Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
As part of a new HR project you're creating several stored procedures that will add logging information to the logs table. This logging information is very detailed and should contain carriage returns to make paragraphs more readable. How can you add carriage returns to text when inserting into a table?
Use CASE
Use CHAR
Use TEXTPTR
Use COS
That was the correct answer, well done!
Sorry, that was the wrong answer
You can use CHAR(13) to add carriage returns. The CHAR function converts an int ASCII code to a character.
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2019
All rights reserved