遍历每个表进行指定操作

usewebsitedb

declare@tablenamevarchar(50)
declare@sqlstrvarchar(300)
declaretable_cursorcursorfor
selecto.name
fromsyscolumnscinnerjoinsysobjectsoono.id=c.id
whereo.xtype='u'andc.name='userid'
orderbyo.name
opentable_cursor
fetchnextfromtable_cursorinto@tablename
while(@@fetch_status=0)
begin
set@sqlstr='select'''+@tablename+'''astablename,*from'+@tablename+'whereuserid=''qifei'''
exec(@sqlstr)
fetchnextfromtable_cursorinto@tablename
end
closetable_cursor
deallocatetable_cursor