摘要:
格式:CONVERT(data_type,expression[,style])说明:此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar)相互转换的时候才用到.例子:SELECTCONVERT(varchar(30... 阅读全文
摘要:
WITH INDEX_TABLE AS(SELECT 2 as DatabaseID, o.name AS TableName, c.name AS ColumnName,ic.index_id,i.type_desc AS IndexTypeFROM SYS.OBJECTS OJOIN SYS.i... 阅读全文