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 runningSELECT '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" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-26 : 09:32:37
|
http://sqljunkies.com/Forums/ShowPost.aspx?PostID=13373MadhivananFailing to plan is Planning to fail |
|
|
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. |
|
|
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?MadhivananFailing to plan is Planning to fail |
|
|
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 ... |
|
|
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. |
|
|
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. MadhivananFailing to plan is Planning to fail |
|
|
Kbalz
Yak Posting Veteran
94 Posts |
Posted - 2007-09-26 : 11:06:39
|
Ah Gotcha, thanks for link! |
|
|
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?MadhivananFailing to plan is Planning to fail |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-09-28 : 09:33:29
|
Changed "speaches" to "speeches"...typo/misspelling. |
|
|
|