adspace
How to enter unicode character string literals in ms sql server?
Answer Posted / Pajkaj Kumar
"To enter Unicode character string literals in MS SQL Server, you can use the N prefix. For example:nnSELECT N'Unicode String';"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What kind of problems occurs if we do not implement proper locking strategy?
What is standby servers? Explain types of standby servers.
what is spatial nonclustered index
What are the properties of the transaction?
What is a view in sql?
What are the different SQL Server Versions you have worked on?
How can I check that whether automatic statistic update is enabled or not?
How do I start sql server 2017?
List out the different types of locks available in sql server?
what is the difference between openrowset and openquery?
What are the different subsets of sql?
What is a coalesce function?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How can we solve concurrency problems?