When would you use sql joins?
Can two tables share a primary key?
What does it mean if @@cursor_row returns a negative number?
What are transactions in sql?
Explain the properties of subqueries in sql server?
What is factless fact table? : sql server analysis services, ssas
Where do you find the default Index fill factor and how to change it?
How do I delete a sql server database?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
Tell me what is log shipping?
Where is localdb stored?
find 2nd highest salary of person using cursor concept?
What are the disadvantages of using the stored procedures?