摘要: （一）USE NorthwindselectOrderID,count(case when Quantity between 20 and 30 then ProductID end) as '20-30',count(case when Quantity between 30 and 40 then ProductID end) as '30-40',count(case when Quanti...阅读全文

摘要: USE Northwinddeclare Order_cursor cursor forSELECT OrderID from Ordersopen Order_cursordeclare @OrderID as INTfetch next from Order_cursor into @OrderIDwhile(@@fetch_status =0)beginPRINT 'OrderID' + S...阅读全文

摘要: 如果你经常关注SQL Server的NewsGroups，你会发现人们经常会问为什么我不能运行这样的SQL语句：SELECT * FROM @tablenameSELECT @colname FROM tblSELECT * FROM tbl WHERE x IN (@list)In many cases someone says "use dynamic SQL" and with a simp...阅读全文

摘要: 选择从10到15的记录select top 5 * from (select top 15 * from table order by id asc) table_别名 order by id desc　　随机选择数据库记录的方法（使用Randomize函数，通过SQL语句实现）　　对存储在数据库中的数据来说，随机数特性能给出上面的效果，但它们可能太慢了些。你不能要求ASP“找个随机数...阅读全文

摘要: 查询系统表INFORMATION_SCHEMA.TABLES得到所有用户表结构：SELECT T.TABLE_SCHEMA as [TableOwner],T.TABLE_NAME as [TableName],C.COLUMN_NAME as [ColumnName],C.DATA_TYPE as [DataType],C.CHARACTER_MAXIMUM_LENGTH as [Size],C...阅读全文