Home All Groups Group Topic Archive Search About

What the N is going on?

Author
15 Jul 2005 3:18 AM
Mator DeSchenna
What the heck is with these Ns that SQL script generator sticks in here
everywhere.
It is enough to make me quit my  SQL Farm Managerial position.

Why do I have to deal with Ns everywhere??


EXECUTE sp_rename N'dbo.Tmp_Table1, N'Table1', 'OBJECT'

Author
15 Jul 2005 4:28 AM
David Gugick
Mator DeSchenna wrote:
> What the heck is with these Ns that SQL script generator sticks in
> here everywhere.
> It is enough to make me quit my  SQL Farm Managerial position.
>
> Why do I have to deal with Ns everywhere??
>
>
> EXECUTE sp_rename N'dbo.Tmp_Table1, N'Table1', 'OBJECT'

The N prefix denotes a UNICODE character string. It's an ugly
implementation.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com
Author
15 Jul 2005 7:25 AM
Mator DeSchenna
How do I get rid of it ???

It's yucky !


EWWWWwwwwwWWWWWwww
Author
15 Jul 2005 7:39 AM
Tibor Karaszi
> How do I get rid of it ???

? Not using Unicode, I guess...


> It's yucky !

But it adheres to the ANSI SQL standard.
Show quote
"Mator DeSchenna" <ddsdd*sdadf.com> wrote in message news:Fa2dndjiyKV5-UrfRVn-qA@comcast.com...
> How do I get rid of it ???
>
> It's yucky !
>
>
> EWWWWwwwwwWWWWWwww
>
>

AddThis Social Bookmark Button