http://blog.csdn.net/lidanx/zh-CNWed, 07 May 2008 16:19:00 GMT60月亮晶石http://blog.csdn.net/lidanx/archive/2008/05/07/2410634.aspxWed, 07 May 2008 16:17:00 GMThttp://blog.csdn.net/lidanx/archive/2008/05/07/2410634.aspxhttp://blog.csdn.net/lidanx/comments/2410634.aspxhttp://blog.csdn.net/lidanx/archive/2008/05/07/2410634.aspx#Feedback0http://blog.csdn.net/lidanx/comments/commentRss/2410634.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2410634&lt;p&gt;&lt;br /&gt;create proc page&lt;br /&gt;@Tablename varchar(200),&lt;br /&gt;@OutPut int output&lt;br /&gt;as&lt;br /&gt;declare @SQL varchar(200)&lt;br /&gt;declare @R int &lt;/p&gt;&lt;p&gt;SET&amp;nbsp;&amp;nbsp; @SQL=&amp;nbsp; N'select @R=count(*) from&amp;nbsp; &lt;a href="mailto:'+@tablename"&gt;'+@Tablename&lt;/a&gt;&lt;/p&gt;&lt;p&gt;EXEC&amp;nbsp; SP_EXECUTESQL&amp;nbsp;&amp;nbsp; @SQL,&amp;nbsp; N' @R int OUTPUT',&amp;nbsp; @R OUTPUT&lt;br /&gt;SET&amp;nbsp;&amp;nbsp; @OutPut=<img src ="http://blog.csdn.net/lidanx/aggbug/2410634.aspx" width = "1" height = "1" />