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


Please Help Members By Posting Answers For Below Questions

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1300


What kind of problems occurs if we do not implement proper locking strategy?

1500


What is standby servers? Explain types of standby servers.

1081


what is spatial nonclustered index

1060


What are the properties of the transaction?

1074


What is a view in sql?

1043


What are the different SQL Server Versions you have worked on?

1080


How can I check that whether automatic statistic update is enabled or not?

1113


How do I start sql server 2017?

1016


List out the different types of locks available in sql server?

1051


what is the difference between openrowset and openquery?

1197


What are the different subsets of sql?

1655


What is a coalesce function?

1285


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

2296


How can we solve concurrency problems?

1123