易语言吧 关注:266,097贴子:1,663,431
  • 4回复贴,共1

【求租】易语言怎么运行这段SQL语句

只看楼主收藏回复

如题:在易语言里怎么运行这段SQL语句
declare @str varchar(100)
set @str='系统'
declare @s varchar(8000)
declare tb cursor local for
select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
print ''所在的表及字段: ['+b.name+'].['+a.name+']'''
from syscolumns a join sysobjects b on a.id=b.id
where b.xtype='U' and a.status>=0
and a.xusertype in(175,239,231,167)
open tb
fetch next from tb into @s
while @@fetch_status=0
begin
exec(@s)
fetch next from tb into @s
end
close tb
deallocate tb


IP属地:山西1楼2016-09-02 01:06回复
    执行asp代码就用过,你可以上网找找sql易语言模块


    来自Android客户端5楼2016-09-02 09:43
    回复
      一个在数据库执行的存储过程。
      你自己拆开就是了。


      IP属地:北京8楼2016-09-02 12:36
      回复