Exforsys
+ Reply to Thread
Results 1 to 2 of 2

TSQL Statement

This is a discussion on TSQL Statement within the SQL Server forums, part of the Database category; USE master; GO EXEC sp_addlinkedserver 'SEATTLESales', N'SQL Server' -- the line I have a question about GO I got the ...

  1. #1
    trevorc1653 is offline Junior Member Array
    Join Date
    Apr 2008
    Answers
    1

    TSQL Statement

    USE master;
    GO
    EXEC sp_addlinkedserver
    'SEATTLESales',
    N'SQL Server' -- the line I have a question about
    GO

    I got the above SQL statement from SQL Server Booksonline.
    I've seen several statements that have an N before
    a character string. I've been able to execute the
    statements successfully with the inclusion of this N.
    What is the purpose of the N?


  2. #2
    ssbp2we is offline Junior Member Array
    Join Date
    Feb 2009
    Location
    Dallas, TX
    Answers
    2
    looks like its if the string after N is a unicode string. refer msdn.microsoft . com/en-us/library/ms182673 . aspx (Transact-SQL)


Latest Article

Network Security Risk Assessment and Measurement

Read More...