摘要: DECLARE @index TABLE(index_name nVARCHAR(max),index_des nVARCHAR(max),index_keys nVARCHAR(max))INSERT INTO @index( index_name, index_des, index_keys)EXEC sp_helpindex 'ycmis.dbo.费用表'--游标模版DECLARE @indexname NVARCHAR(200) DECLARE pcurr CURSOR FOR SELECT index_name FROM @indexOPEN pcurrFETCH N 阅读全文
posted @ 2011-06-25 19:29 qanholas 阅读(442) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示