动态sql插入表

建表：
/****** Object:  Table [dbo].[TBL_BILLINFO_0805]    Script Date: 2008-5-26 15:41:17 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_BILLINFO_0805]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_BILLINFO_0805]
GO

/****** Object:  Table [dbo].[TBL_BILLINFO_0805]    Script Date: 2008-5-26 15:41:19 ******/
CREATE TABLE [dbo].[TBL_BILLINFO_0805] (
    [fRelTaskID] [int] NOT NULL ,
    [fCaller] [varchar] (24) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [fCallee] [varchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
    [fSetupTime] [datetime] NULL ,
    [fConnTime] [datetime] NULL ,
    [TimeLen] [int] NULL ,
    [fFlag] [int] NULL
) ON [PRIMARY]
GO
存储过程：
create procedure dbo.Bill_InsertToTable
@sTableName varchar(24),
@iRelTaskID int,
@sCaller varchar(24),
@sCallee varchar(24),
@sDate varchar(24),
@sSetupTime varchar(24),
@sConnTime varchar(24),
@iTimeLen int,
@iFlag int


As
Begin
    declare @sSetup varchar(50)
    declare @sConn    varchar(50)
    declare @table varchar(50)
    set @sSetup=convert(datetime,(@sDate+' '+@sSetupTime),120)
    set @sConn=convert(datetime,(@sDate++' '+@sConnTime),120)
    set @iFlag=0
    set @table=@sTableName
    Declare       @sql       varchar(4000)
    set @sql= 'Insert Into  ' + @sTableName + ' (fRelTaskID,fCaller,fCallee,fSetupTime,fConnTime,TimeLen,fFlag) Values(' +
                 ''''+ cast( @iRelTaskID as varchar(24)) +'''' + ',' +
                 '''' + @sCaller + '''' + ',' +
                 '''' + @sCallee + '''' + ',' +
                 '''' + @sSetup  + ''''+ ',' +
                 '''' + @sConn + '''' + ',' +
                 ''''+ cast(@iTimeLen as varchar(24)) +''''+ ',' +
                 ''''+ cast(@iFlag as varchar(24)) +''''  + ')'
   
    --print @sql
    exec (@sql)
   
    select @@rowcount
   
end
Go

错误：一开始没有把@iRelTaskID 之类的参数转换为varchar类型的，所以总是提示连接时从varchar转换到 nt是出现错误。
修改后可以了。