Sistaxis Question
-
For what is used the modifier N' sometimes before the variable in Store Procedures.
For Example:
EXEC msdb.dbo.sp_add_log_shipping_database N'pubs'
EXEC msdb.dbo.sp_add_log_shipping_plan
@plan_name=N'Pubs database backup'
@description= N'Log shipping the pubs database',
@source_server= N'my_source',
@source_dir= N'\\my_source\pubs_logshipping',
@destination_dir= N'c:\logshipping\pubs',
@history_retention_period= 60, -- 1 hour
@file_retention_period= 1440, -- 1 day
@copy_frequency= 10, -- copy files every 10 minutes
@restore_frequency= 30 -- load files every 30 minutes
Thanks
-
The Capital "N" Before a string indicates the string is "Double Byte" Nvarchar, NChar, NText
-
To specify that the string is in unicode format ie. nvarchar or nchar
Cheers,
* Noel -
hehe... I got in a bit late
* Noel -
Thank you all for clarify me this question.
Thank yoy very much...
-
Are you back from PASS already??
-
No really I think.
Really, I do not undertand what PASS is
-
Sorry, was talking to Noeld
. Maybe this is what PM are for 
. -
I am back from London!! PASS is at the end of september. Now
WHAT inthe world rgR'us means??
* Noel -
I knew you were early
. -
noeld - don't even ask!
by the way i did the right thing and sent you a pm with a "welcome back" msg...for all that remi knows i'm shocked that he doesn't know when PASS is....or that you were in London!
comme d'habitude...late again...RATS!!!!!
**ASCII stupid question, get a stupid ANSI !!!** -
I know it's in septembre. That's all I need to know since I ain't going
. -
Looks very funny but is very difficult to pronounce
* Noel -
We'll cross that bridge when we don't meet at PASS this year
. -
noeld - repeat after me - aar - gee - are - us...see how easy it is now ?!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply