Summary on 20081111: system method in sql server2005

最新推荐文章于 2020-07-29 14:06:01 发布

原创最新推荐文章于 2020-07-29 14:06:01 发布 · 432 阅读

CC 4.0 BY-SA版权

文章标签：

8 篇文章

订阅专栏

1 篇文章

订阅专栏

本文介绍了 SQL Server 2005 中的一些实用技巧，包括如何处理 NULL 值、使用 CHARINDEX 函数查找字符串首次出现的位置、利用 SUBSTRING 函数截取字符串以及类型转换的方法。

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))