if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition
1 3617How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
5 10938How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
8 32852Difference between sql server 2000 and sql server 2005?
Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
11 53155
Give me any three differences between Truncate and Delete.
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can primary key be a foreign key?
How to find the login name linked to a given user name?
How do you delete a trigger?
What is scheduled job and how to create it?
What is history table in sql server?
what changed between the previous version of sql server and the current version? : Sql server database administration
what are the critical issues you have resloved in your company
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the types of joins in sql?
What is scalar user-defined function?
What are the different types of locks in the database?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are the disadvantages of indexes?