Answer 4：用动态SQL实现

　　Question5: The Fastest Way to Recompile All Stored Procedures
　　I have a problem with a database running in SQL Server 6.5 (Service Pack 4). We moved the database (object transfer) from one machine to another last night, and an error (specific to a stored procedure) is cropping up. However, I can't tell which procedure is causing it. Permissions are granted in all of our stored procedures; is there a way from the isql utility to force all stored procedures to recompile?

　　Tips: sp_recompile can recomplie a store procedure each time

　　Answer 5：在执行存储过程时,使用 with recompile 选项强制编译新的计划；使用sp_recompile系统存储过程强制在下次运行时进行重新编译

　　Question6: How can I add row numbers to my result set?
In database pubs, have a table titles , now I want the result shown as below,each row have a row number, how can you do that?
Result:

line-no  title_id ----------- -------- 1  BU1032 2  BU1111 3  BU2075 4  BU7832 5  MC2222 6  MC3021 7  MC3026 8  PC1035 9  PC8888 10 PC9999 11 PS1372 12 PS2091 13 PS2106 14 PS3333 15 PS7777 16 TC3218 17 TC4203 18 TC7777

　　Answer 6：
　　--SQL 2005的写法
　　select row_number() as line_no ,title_id from titles
　　--SQL 2000的写法
　　select line_no identity(int,1,1),title_id into #t from titles
　　select * from #t
　　drop table #t