随笔分类 -  SQLServer

摘要：来自：http://www.cnblogs.com/williambirkin/archive/2007/06/29/800114.aspx CREATE PROCEDURE [dbo].[pro_CURSOR] AS BEGIN --声明一个游标 DECLARE MyCURSOR CURSOR FOR SELECT userid,depid FROM users --打开游标 open M... 阅读全文