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)
posted @ 2017-09-05 15:36  {Black_Jack}  阅读(222)  评论(0)  编辑  收藏  举报