How we Resize table,temp table, database and log file size
in SQL Server 2005
Answer / amrish kumar
WHERE database_id = DB_ID('DataBaseName');
|Is This Answer Correct ?||0 Yes||6 No|
Mention the different authentication modes in sql server.
what is sql server? : Sql server database administration
How to determine the service pack currently installed on SQL Server?
What is the distinction amongst delete and truncate?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
why SQL server is more used to store database rather than Access
How can you know if the row fetched from cursor is still valid in underlying table?
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
Explain nested join?
How to find the version of sql server? : sql server database administration
What is partition, how will you implement it? : sql server analysis services, ssas
How to update muliple row in single query?