Do you know what are the ways available in sql server to execute sql statements?
No Answer is Posted For this Question
Be the First to Post Answer
Explain syntax for dropping triggers?
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is user-defined scalar function?
what is denormalization and when would you go for it? : Sql server database administration
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
When multiple after triggers are attached to sql table, how to control the order of execution?
Is foreign key unique?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
What is pivot and unpivot?
What is temporal table?