Tell me what is use of except clause? How it differs from not in clause?
No Answer is Posted For this Question
Be the First to Post Answer
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
What is ms sql server triggers?
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
What are the advantages of user defined function?
What are the methods used to protect against sql injection attack?
How to swap the data of two columns in a table. both the columns containing varchar values.
How can you know if the row fetched from cursor is still valid in underlying table?
List the different index configurations possible for a table?
What is index in an assignment?
Explain the database you used in your final year project?