It forces the string to Unicode.
|--------------------+----------------------------------------------------|
|Eric A. Laney |You can't kiss a girl unexpectedly - only sooner |
|Systems Architect |than she thought you would. |
|Verizon Security | |
|Voice: 813.987.1416 | |
|Pager: 888.551.3718 | |
|--------------------+----------------------------------------------------|
"Correa, Orlando
(ITSC)" To: SQL <[EMAIL PROTECTED]>
<Orlando.Correa@ma cc:
il.ihs.gov> Subject: RE: Column description
property of MSSQL 2K?
03/13/2002 02:32
PM
Please respond to
sql
Sorry to ask... but...
What does the N' in N'user', N'dbo' etc., etc. stand for?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 7:06 AM
To: SQL
Subject: Re: Column description property of MSSQL 2K?
They are handled through the extended properties. You have to use stored
procedures to manipulate them, and a SQL function to view them. Here is
the script that Query Analyzer generated after I added a description to the
DEPLOYED column of a table named NOC:
exec sp_addextendedproperty N'MS_Description', N'This is a description.',
N'user', N'dbo', N'table', N'NOC', N'column', N'DEPLOYED'
BOL has all the details, you might want to start with "Creating and
Maintaining Databases" / "User-Defined Functions" / "Using Extended
Properties on Database Objects".
|------------------+------------------------------------------------------|
|Eric A. Laney |"You know how Einstein got bad grades as a kid? Well, |
|Systems Architect |MINE are even WORSE!" |
|Verizon Security | |
|Voice: | |
|813.987.1416 | Calvin|
|Pager: | |
|888.551.3718 | |
|------------------+------------------------------------------------------|
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
