Loading

Print in mssql

Print in mssql

Rahul Prajapat

Rahul Prajapat

11y1.4k

I write the query in mssql like

PRINT N'Rahul'
PRINT ' And '
PRINT N'Sandeep'

When i execute the query result is display like:

Rahul

And

Sandeep

So i want the result is displayed in single line like:

Rahul And Sandeep

And what is the mean of N before the string.

Thanks in advance...

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Kumar11y ago
Accepted answer
Here N is used for nvarchar type else by default it is varchar type.
To print your result in one line you should write it in one line like print('sandeeo and rahul');
for more you can check on this link:-
http://stackoverflow.com/questions/10025032/what-is-the-meaning-of-the-prefix-n-in-t-sql-statements
Upendra Pratap Shahi11y ago
Here N stands for nvarchar.
and print statement always print as you want to print. here in this case this is on print one by one because you use three time so this print this type.

PRINT N'Rahul And Sandeep'

use this or use this in a varriable and print that varriable.

Kindly accept the answer.
Rajeesh Menoth11y ago
Hi,

Ref this example : http://www.c-sharpcorner.com/UploadFile/cda5ba/difference-between-char-nchar-varchar-and-nvarchar-data-ty/
Rajeesh Menoth11y ago
Hi,

It's declaring the string as nvarchar data type, rather than varchar

Ref : http://stackoverflow.com/questions/10025032/what-is-the-meaning-of-the-prefix-n-in-t-sql-statements
Rahul Prajapat11y ago
Thanks for answer.
@sandeep in many case we need to use many print statement .
Please give an example of query..
Manas Mohapatra11y ago
1. Print() -> It prints characters in a new line. If you want to display in one line then use single print method to display.

2. N stands for Unicode character. It means you can print other characters like Chinese, French and other languages.