惯用sql查询语句

常用sql查询语句
查询数据库所有表

DECLARE TableCursor SCROLL CURSOR FORselect table_name from information_schema.columns order by table_nameOPEN TableCursorDECLARE @TmpTableName Nvarchar(100);WHILE 1 = 1BEGINFETCH NEXT FROM TableCursor INTO @TmpTableNameIf @@FETCH_STATUS != 0BEGINbreakEndELSE--print @TmpTableName BEGIN TRYexec('select * from ' + @TmpTableName );END TRYBEGIN CATCHexec('select * from ' + @TmpTableName);END CATCHENDCLOSE TableCursorDEALLOCATE TableCursor