摘要：RTRIM ---LTRIM ---删除字符左右的空格RIGHT右边取字符LEFT左边取字符MID任意位置取字符DECLARE @string1 char(11),@string2 char(14)set @string1 = ' Example'set @string2 = 'SQLSERVER'select @string2 + @string1 as '字符串简单链接'RTRIM(@string2) + LTRIM(@string1) as '去除空格后的连接'select right(rtrim(customerID),2 阅读全文

摘要：//创建数据库CREATE DATABASE salesON PRIMARY(NAME = sales_data,FILENAME = 'd:\sales_data.mdf',size=10MB,maxsize=500mb,filegrowth=10%)LOG ON(NAME = sales_log,FILENAME = 'd:\sales_log.ldf',size=5MB,maxsize=100mb,filegrowth=2mb)SP_HELPDB SALES//查询数据库ALTER DATABASE salesSET AUTO_SHRINK ON//自动收 阅读全文