- In sql server 2005, there is no support for array.
- when you print something using print @dddvalue, when @dddvalue is null, there will be nothing printed
- charindex('search', @src) will get the index that the 'search' first accured in the @src
- substring(@src, @firstIndex, @length)
-
when you want to convert from one type to another tye, consider the function of 'Cast' and 'Convert', the format is like
set @int = cast(@str as int)
set @str = cast (@int as nvarchar(10))