Correct Answer: LEN
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
What is a 'CROSS APPLY' used for?
When creating indexes in SQL, what two main factors must be considered?
What is the name of the service that provides ETL capabilities for SQL Server for data import, data integration and data warehousing needs?
Which of the following allows you to modify (update or delete) all values of the parent table?
What is the 'WITH RECOMPILE' statement used for?
What is the maximum storage capacity of XML data type in SQL SERVER 2005?
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?
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?
Which of the following statements is wrong?
We have a table named 'Customer' which has a column named 'Customerid' having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?