Which of the following is used to comment a portion of an SQL Server 2008 script?
Correct Answer: Double dash (--)
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
Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?
FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.
A local temporary stored procedure name can contain a maximum of __________ characters
Analyze the following permissions: 1.ALTER permission on the database. 2.CONTROL permission in the database. 3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database. Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?
Analyze the following code snippet for creating a stored procedure in SQL Server 2008: CREATE PROCEDURE Person.GetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) AS SET NOCOUNT ON SELECT FirstName, LastName, JobTitle, Department FROM Person.EmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName GO Which of the following is a valid code to execute the GetEmployees stored procedure?
Which of the following is not a valid data type in SQL Server 2012?
What would be the output of following statement: Select * from tbl_Employee where Emp_Name=NULL
Which of the following is not a valid string constant or hexadecimal constant?
Can a unique key with not null constraint make it a primary key?
Which of the following standard reports will show you the fragmentation of the physical indexes?