如何在SQL存储蓄过程里执行一条组合的SQL语句(也就是执行一个字符串)。 同题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如SET @sqlstring = N'set @a = GZSW_SK.dbo.datetimetostr((SELECT ' +LTRIM(RTRIM( @字段名)) + N' from '+ LTRIM(RTRIM(@TableName)) + N' WHERE ' + LTRIM(RTRIM(@KEYNAME))+ N'='''+LTRIM(RTRIM(@KEYVALUE))+N''' ))'EXECUTE sp_executesql @sqlstring 如SET @sqlstring = 'select * from table1'EXECUTE sp_executesql @sqlstring //仅供参考CREATE PROCEDURE sp_load_modules( @id int = 0, @p_id int = 0, @need_child_count bit = 0, @need_memo bit = 0)ASdeclare @sql varchar(8000)set @sql = 'select t1.id, t1.name, t1.project_id, t1.table_prefix ' --for list, no memoif (@need_memo <> 0) set @sql = @sql + ', memo'if (@need_child_count <> 0) set @sql = @sql + ', (select count([id]) from t_object where module_id = t1.[id]) as child_count 'set @sql = @sql + ' from t_module t1 where 'if (@id <> 0) set @sql = @sql + ' id = ' + convert(varchar(20), @id)else set @sql = @sql + ' project_id = ' + convert(varchar(20), @p_id)set @sql = @sql + ' order by id 'exec (@sql)GO SET @sqlstring = 'select * from table1'Exec(@SqlString)也行 急需Delphi串口手机短信收发程序 恭喜老冯初升星星,特此庆祝 十六进制高低位转换为十进制数!高分求助! 求过滤网页正文内容的正则表达式,急用 求AI算法(请大家帮忙想想思路)!! 如何取得oracle下某个用户下的存储过程列表,以及如何导出某个存储过程,并存为plaql脚本? 再线等2000系统下怎样让红色警戒联机谢谢! 在word中怎么调用word的“段落”,“字体”等的设置窗口 在delphi里怎么获取一个数据库的所有的表 急求用delphi+SQL做一个程序 调用Outlook Express来发送邮件,多个附件 怎樣在程序中調用outlook.application
CREATE PROCEDURE sp_load_modules
(
@id int = 0,
@p_id int = 0,
@need_child_count bit = 0,
@need_memo bit = 0
)
ASdeclare @sql varchar(8000)set @sql = 'select t1.id, t1.name, t1.project_id, t1.table_prefix ' --for list, no memo
if (@need_memo <> 0)
set @sql = @sql + ', memo'if (@need_child_count <> 0)
set @sql = @sql + ',
(select count([id])
from t_object
where module_id = t1.[id]) as child_count 'set @sql = @sql + '
from t_module t1
where 'if (@id <> 0)
set @sql = @sql + ' id = ' + convert(varchar(20), @id)
else
set @sql = @sql + ' project_id = ' + convert(varchar(20), @p_id)set @sql = @sql + '
order by id 'exec (@sql)
GO
Exec(@SqlString)也行