T-SQL Hints

-- 改变列定义

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 #TempEnd

-- 删除换行符

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')