17.sql

机械工业出版社《SQL Server应用开发实例教程》源代码

select lower('i LOVE you') as 小写字母
select upper('please reading') as 大写字母
select replicate('go',10) as 复制函数
select reverse('uoy') as 倒序函数
select len('adifwe dfa') as 求字符串长度函数
select substring('adsfkagdgs',4,3) as 求子串函数
select stuff('i love you',3,4,'hate') as 填充函数
select charindex('asdfgsdk','df') as 子串位置函数
select char('21') as 字符函数
select ascii('t') as 标准代码函数