Is it possible for a stored procedure to call itself or recursive stored procedure?
How to create a new table in a given schema?
what is nonclustered index
what r steps to we need to fallow b4 kill the process?
What is dirty page?
What is the full meaning of dml?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
wat is the main diff between sql server 2000and sql server 2005
What is primary key, unique key, and foreign key?
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2
What is exclusive locks?
Distinguish between nested subquery and correlated subquery?