MSSQL 常用操作

0.GUID去除横线和变换为小写

SELECT  LOWER(REPLACE(LTRIM(NEWID()),'-',''))

1.IDENTITY 函数说明

IDENTITY ( data_type [ , seed , increment ] ) AS column_name
IDENTITY(numric,1,1)

2.将数据库的日志文件压缩

ALTER DATABASE [DBName] SET RECOVERY SIMPLE  
ALTER DATABASE [DBName] SET RECOVERY FULL  
DBCC SHRINKDATABASE([DBName], 0)