查询数据库没有主键的表名，并增加主键

declare @tablename sysnamedeclare @strsql nchar(500)declare tableNameCursor cursor forselect b.name from sysobjects b where xtype='U' and  b.name not in (select object_name(a.parent_obj)  from sysobjects a where xtype='PK' )open tableNameCursor  fetch next from tableNameCursor into @tablenamewhile @@FETCH_STATUS = 0beginprint @tablenameset @strsql= 'alter table ' + @tablename + ' add primary key (id) 'print @strsqlexec (@strsql)fetch next from tableNameCursor into @tablenameendclose tableNameCursordeallocate  tableNameCursor

游标的使用

sysobjects对象的使用