var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: changing case of input parameters
i am using SQL 2005 and executing a SQL script via a sqlcmd cmd file. the input params are as follows
division Month Year
01 08 2009
when i use these params within SQL server the leading 0 is dropped thus making the scripts fail
i am using the following code to set the params
how can i make the @div and @mth = 01 etc and not change to 1?
SET @DIV = $(div)
SET @mth = $(mth)
SET @year = $(year)
I have set the datatype of @div and @mth to be nvarchar(10)
your help would be appreciated.
Can you use function built-in SQLServer, with 'substring', get 2 first characters...