Exforsys

Free Training

TSQL Statement

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

Go Back   Exforsys > Articles and Tutorials > SQL Server 2005 Tutorials

Exforsys.com


SQL Server 2005 Tutorials SQL Server 2005 Tutorials and Articles discussions

Reply

 

LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 04-23-2008, 11:45 AM
Junior Member
 
Join Date: Apr 2008
Posts: 2
trevorc1653 is on a distinguished road
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-02-2009, 08:39 PM
Junior Member
 
Join Date: Feb 2009
Location: Dallas, TX
Posts: 2
ssbp2we is on a distinguished road
looks like its if the string after N is a unicode string. refer msdn.microsoft . com/en-us/library/ms182673 . aspx (Transact-SQL)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Output of the Statement Adrian Oracle Database 2 04-26-2008 03:40 AM
tutorials on vb scrpiting in qtp anandcyril Testing Tutorials 1 11-30-2007 03:59 AM
SELECT Statement - Help nickole SQL Server 7 04-11-2007 01:46 PM
DB2 - SELECT - INTO Statement James Allen DB2 2 02-17-2006 12:19 PM
Difference between Statement and Callable Stmt. banuchithrak Java Tutorials 5 08-24-2004 06:32 PM


All times are GMT -4. The time now is 12:17 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Copyright 2004 - 2009 Exforsys Inc. All rights reserved.