N - curious?

Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!The N represents a Unicode string.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!|||See the Books Online topic 'Server-side Programming with Unicode'
(http://msdn2.microsoft.com/en-us/library/ms191313(SQL.90).aspx).
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Looking at an if exists statement created by SQL Enterprise Manager such
> as: if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure')
> = 1), what does the N do? I've seen cases where it is and isn't necessary,
> but I cannot find documentation telling what it does. "N" is a very
> ineffective search!!!
>

MySQL vs SQL Server?

Hey there,

I'm curious about MySQL. Could anyone quickly summarize the
differences between MySQL and SQL Server and outline why someone might
pick SQL Server over MySQL?

(Please post replies here, email address is fake)
Cheers,
Geoff Glave
Vancouver, Canadagglave@.softtracks.com wrote:
> Hey there,
> I'm curious about MySQL. Could anyone quickly summarize the
> differences between MySQL and SQL Server and outline why someone might
> pick SQL Server over MySQL?
> (Please post replies here, email address is fake)
> Cheers,
> Geoff Glave
> Vancouver, Canada

While MS SQL isn't perfect, take a look at this list of MySQL gotchas:
http://sql-info.de/mysql/gotchas.html

Zach|||Zach, pretty good list of things you have to know if you work in mySQL
especially if you work in a different rdbms such as SQL Server or
Oracle also.

IMHO -- Mark D Powell --