How to truncate a table first before running a package?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Distinguish between nested subquery and correlated subquery?
How to create and drop temp table in sql server?
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
what is normalization? Explain different levels of normalization? : Sql server database administration
Explain the microsoft sql server delete command? : SQL Server Architecture
Define DML and DCL statements?
What is sql server transaction log file?
how do we find every fifth record in a table
What is 1nf normalization form?
What is data source object?
What is the difference between implicit and explicit transaction?