BEGIN
SET @_SENDINGGROUP_SCRIPT = ( SELECT A.SENDINGGROUP_SCRIPT
FROM dbo.M_GROUP A
WHERE A.ID = @CampId
) ;
--SET @SENDINGGROUP_SCRIPT = @_SENDINGGROUP_SCRIPT ;
SET @_SENDINGGROUP_SCRIPT = "'CREATE VIEW v_sending_group AS'"+@_SENDINGGROUP_SCRIPT;
EXEC (@_SENDINGGROUP_SCRIPT);
END ;我想根据查询结果(一句SQL)动态的生成一个view。可是拼写语句的时候老是出现问题,请各位帮忙看看。谢谢~~
SET @_SENDINGGROUP_SCRIPT = ( SELECT A.SENDINGGROUP_SCRIPT
FROM dbo.M_GROUP A
WHERE A.ID = @CampId
) ;
--SET @SENDINGGROUP_SCRIPT = @_SENDINGGROUP_SCRIPT ;
SET @_SENDINGGROUP_SCRIPT = "'CREATE VIEW v_sending_group AS'"+@_SENDINGGROUP_SCRIPT;
EXEC (@_SENDINGGROUP_SCRIPT);
END ;我想根据查询结果(一句SQL)动态的生成一个view。可是拼写语句的时候老是出现问题,请各位帮忙看看。谢谢~~
SELECT @_SENDINGGROUP_SCRIPT=A.SENDINGGROUP_SCRIPT
FROM dbo.M_GROUP A
WHERE A.ID = @CampId
SET @_SENDINGGROUP_SCRIPT = 'CREATE VIEW v_sending_group AS '+@_SENDINGGROUP_SCRIPT;
EXEC (@_SENDINGGROUP_SCRIPT);
END ;
SET @_SENDINGGROUP_SCRIPT = (SELECT A.SENDINGGROUP_SCRIPT FROM dbo.M_GROUP A WHERE A.ID = @CampId);
SET @_SENDINGGROUP_SCRIPT = 'CREATE VIEW v_sending_group AS ' + @_SENDINGGROUP_SCRIPT; EXEC (@_SENDINGGROUP_SCRIPT);
END ;
BEGIN
SET @_SENDINGGROUP_SCRIPT ='SELECT A.SENDINGGROUP_SCRIPT
FROM dbo.M_GROUP A
WHERE A.ID = '+ltrim(CampId)
SET @_SENDINGGROUP_SCRIPT = 'CREATE VIEW v_sending_group
AS'+@_SENDINGGROUP_SCRIPT;
EXEC (@_SENDINGGROUP_SCRIPT);
END