Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SELECT N'...'

Author  Topic 

Kbalz
Yak Posting Veteran

94 Posts

Posted - 2007-09-26 : 09:06:28
I was running SQL Profiler today on an app, and I noticed this:

SELECT N'sometext'

When I ran the above in management studio, it wasn't any different visually than running

SELECT 'sometext'

So what does the N character do?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-26 : 09:12:16
Converting the string to UNICODE (NVARCHAR/NCHAR)



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-26 : 09:32:37
http://sqljunkies.com/Forums/ShowPost.aspx?PostID=13373

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-09-26 : 09:42:52
Holy Sheet!!! Graz allows you to post links to sqljunkies? I would have figured he would have this site filter those links out by now.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-26 : 09:50:02
quote:
Originally posted by Van

Holy Sheet!!! Graz allows you to post links to sqljunkies? I would have figured he would have this site filter those links out by now.


Who told you that links from non-SQLTeam are not allowed?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-09-26 : 09:51:12
I think Madhi is posting faster than Graz can stick pins in his Voodoo doll ...
Go to Top of Page

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-09-26 : 09:54:57
I was jk. I used to work with Graz (for about 3.5 years...man was that an awful 3.5 years...I taught him everything he knows...then he turned on me...started doing his own speeches and stuff...lol,jk) and we used to bug him about other SQL sites.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-26 : 10:00:37
quote:
Originally posted by Van

I was jk. I used to work with Graz (for about 3.5 years...man was that an awful 3.5 years...I taught him everything he knows...then he turned on me...started doing his own speaches and stuff...lol,jk) and we used to bug him about other SQL sites.


Well.

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kbalz
Yak Posting Veteran

94 Posts

Posted - 2007-09-26 : 11:06:39
Ah Gotcha, thanks for link!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-28 : 02:23:07
quote:
Originally posted by Van

I was jk. I used to work with Graz (for about 3.5 years...man was that an awful 3.5 years...I taught him everything he knows...then he turned on me...started doing his own speeches and stuff...lol,jk) and we used to bug him about other SQL sites.


Can you highlight the change you made?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-09-28 : 09:33:29
Changed "speaches" to "speeches"...typo/misspelling.
Go to Top of Page
   

- Advertisement -