-- 改变列定义
ALTER TABLE [table_name] ALTER COLUMN [column_name] varchar(150)
-- 重置IdentitySeed
DBCC CHECKIDENT ('dbo.ClaimProperty'); --查看当前Identity
DBCC CHECKIDENT ('dbo.ClaimProperty', RESEED, 1); --重置Identity
DBCC CHECKIDENT ('dbo.ClaimProperty', NORESEED); --查看当前Identity
-- 检查表是否存在,如果存在drop
If(OBJECT_ID('tempdb..#temp') Is Not Null)
Begin
Drop Table #Temp
End
-- 删除换行符
SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')