扫帚是什么做的:select @id=id from [dbo].[table1] where id > -1 order by id ASC
来源:百度文库 编辑:中科新闻网 时间:2024/05/05 21:43:55
其中的表名能不能换成变量?
如果可以,应该怎么用呢?请举例.
如果可以,应该怎么用呢?请举例.
你好:
可以的!~用表名变量效率更高!
select * from buy where id= 261
select * from table1 where id in (select id from table2),
select @id=id from [dbo].[table1] where id > -1 order by id ASC
sql="select * from exam_subject where id="& cint(id(j))是什么意思?
sql="select * from main where id="&id 这句啥意思
sql="select * from main where id="&id 这句啥意思
select distinct id ,num=sum(cast((num) as int) from sy order by id desc
stb="select top 1 id FROM our order by id "
sql="select * from spzs where id="+cstr(id)+" order by id desc" 意思
select * from im_users where Id = '"+id+"' and password = '11' 那里错了?