摘要:
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 阅读全文