usewebsitedbdeclare@tablenamevarchar(50)declare@sqlstrvarchar(300)declaretable_cursorcursorforselecto.namefromsyscolumnscinnerjoinsysobjectsoono.id=c.idwhereo.xtype='u'andc.name='userid'orderbyo.nameopentable_cursorfetchnextfromtable_cursorinto@tablenamewhile(@@fetch_status=0)beginset@sqlstr='select'''+@tablename+'''astablename,*from'+@tablename+'whereuserid=''qifei'''exec(@sqlstr)fetchnextfromtable_cursorinto@tablenameendclosetable_cursordeallocatetable_cursor