How to add an address record into adventureworkslt?
what is the order of execution of where,having,group by in select stement
6 Answers IBM, Tanla Solutions,
Explain the collation?
How to update values in a table with update statements in ms sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is Trace flag?
How to write a query with a full outer join in ms sql server?
What is row by row processing ?
What are the options which must be set to allow the usage of optimistic models?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is executereader?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
What are Row versions of DataRow?