Yes very True...This is good
Type: Posts; User: vcyogi; Keyword(s):
Yes very True...This is good
You can not Call trigger Explicitly....
you can Use Inner Join for the operation of intersection
You can use temporary table for this issue
When we wake up in the Morning, we have two simple Choices.
Go back to sleep and dream,or wake up and chase those dreams..
.........Choice is Yours.........
Just think.. You have big company like microsoft you have many products like vb,vc++,etc.. You want to accumuate all the language codings into a one product for this reason, the microsoft releases...
Well said Sutnatcha..
Yes......
I think some MNCs look the academic percentage as a fresher level only...
If you have a Exp in other companies, you should get the job at any company..
Don't worry...
I am also agree with you
A group of frogs were traveling through the woods, and two of them
fell into a deep pit. When the other frogs saw how deep the pit
was, they told the two frogs that they were as good as dead. The...
Add one more point also
When Delete the Particular row the Corresponding Delete Trigger(if exists) Fire.
In Case of Truncate the Trigger is not fired.
A well-known speaker started off his seminar by holding up a rupee 500 note. In the room of 200, he asked, "who would like this rupee 500 note?" hands started going up. He said, "i am going to give...
Little girl and her father were crossing a bridge.
The father was kind of scared so he asked his little daughter,
"Sweetheart, please hold my hand so that you don't fall into the river."
...
When people talk behind your back, what does it mean??
Simple! It means that you are two steps ahead of them!!!
So, keep moving ahead in life!!
Yes Sutnatcha gave good Suggestion.
Nothing is Impossible without Passion....
Be creative Be innovative. think differently and positively
A blind boy sat on the steps of a building with a hat by his feet. He held up a sign which said: "I am blind, please help." There were...
Hi
I want to copy the structure & all constrains of one table into other table.
There is any Direct query is there without using Sql Scirpt???
Procedure 'B'
Hi
EXIST is fast compare to IN
What is meant by Full Text Searching??
What is the Advantages of that one?
It Executes Like ILRAP
I---Initialize
L---Load
R---Resize
A---Activate
P---Paint
Primary key is Clustered Index and not allows null value.
Unique key is NonClustered Index allows one Null value
Can I Define Unique key + Not Null is Equal to Primary key ????
The Delete command is a DML statement because it deletes data from table
The Truncate command is also Delete the Records from tables.
But how the Truncate command comes under DDL Statement??
I find the Query using WITH TIES keyword in Sql
select top 1 with ties eno from (select top 2 with ties eno
from emp order by eno desc) emp order by eno
Note:With Ties Returns the similar...
Can you retrive more than one 2'nd highest salary?? example emp table ename salary aaaa 1000 bbbb 2000 cccc 3000 dddd 2000 can you retrive two records 'bbbb' & 'dddd' for 2'nd highest salary in a...