Explain stored procedure?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How to disable stored procedure sql server?
Difference between primary key and clustered index?
Why is normalisation important?
What is the difference between having clause and where clause in sql server?
What are user defined functions in ms sql server?
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
What is log ldf?
What are some examples of schemas?
Explain the phases a transaction has to undergo?
Why does sql studio use a single registered database repository? : sql server management studio
How to throw custom exception in Stored Procedure?