CREATE PROCEDURE proname
AS
SET NOCOUNT ON
declare @s2 varchar(100)
IF OBJECTID('_TMP') IS NOT NULL
EXEC('DROP TABLE _TMP')
set @s2 ='select * into _tmp from tablename'
exec (@s2)
select * from _tmp
AS
SET NOCOUNT ON
declare @s2 varchar(100)
IF OBJECTID('_TMP') IS NOT NULL
EXEC('DROP TABLE _TMP')
set @s2 ='select * into _tmp from tablename'
exec (@s2)
select * from _tmp
set nocount on
declare @s2 varchar(8000)
----------------------------------------------------------------------
如果varchar后面不指明长度,则默认长度为1.
declare @s2 varchar(8000)
请zjcxc(邹建)大侠到这里接分
http://community.csdn.net/Expert/topic/5020/5020480.xml?temp=.3796656不用改存储过程,在程序中,在open前,先执行set nocount on
就OK了。