Explain the difference between delete,drop and truncate in SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is normalization? What number of normalization shapes are there?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
what is blocking? : Sql server database administration
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
What is the stuff?
What is the default value of an integer data type in sql server 2005?
What will happen if a column containing char type data is changed to the nchar data type?
What is the difference between resultset and resultsetmetadata?
Can Somebody tell me the difference between Clustered & Non- Clustered Index??
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What happens if null values are involved in bitwise operations?