Which of the following statements is wrong?
Correct Answer: Truncate retains the identity of the table
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
The table Comments has an auto incremented column called 'Commentid' and a 'UserComments' column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?
Consider the following table: Order - - - - - Orderid Customerid Orderdate Comments Select ISNULL (Comments, 'No comments') AS comments From Order What will be the output of the above query?
What is the maximum storage capacity of XML data type in SQL SERVER 2005?
Columns are called _____________ of a table in a relational model.
Which is the best method to handle errors and deadlocks?
What is the name of the service that provides ETL capabilities for SQL Server for data import, data integration and data warehousing needs?
When creating indexes in SQL, what two main factors must be considered?
What is a 'CROSS APPLY' used for?
Which sql function finds the length of a string field?
What is the default port of Microsoft SQL Server (for TCP)?