create procedure sp_me
as
declare @v
select @v=(select somevalue from tb where id=1)
select * from tb2 where v=@v
as
declare @v
select @v=(select somevalue from tb where id=1)
select * from tb2 where v=@v
解决方案 »
- getdate函数显示的时间值 多行显示
- 关于字符串不足位补0的问题
- 再用100分求存储过程嵌套返回记录生成视图,一句SQL实现(zjcxc(邹建) 也参与了)
- 急!!!!!错误21002:[SQL-DMO]用户“wl_user”已经存在????
- 刚才图片没传上哈,,再来问一次..
- 访问内网的服务器有时候会出现超时的情况
- 怎样写这条查询语句?
- 请问怎样用一个查询将数据导到EXCEL文件中,而且每天导出到用当天时间命名的EXCEL文件中,用SQL语句怎样写
- 马可,进来帮忙~看看
- 一个SQL SERVER连接问题
- 如何获得字符串的字元数
- 關於同步“OLE DB provider 'MSDASQL' reported an error. ”??
as
declare @address varchar(200)
select @address = address from t1 where ...
select * from t2 where address = @address
go
as
select * from(select * from 表) where 1-a
go
create proc p_test
as
select * from(select * from 表) a where 1-a
go
as
declare @v varchar(2000),@comm varchar
set @comm=select @a.*,b.* from myTable as a inner join ('+
@v+') as b on a.key=b.key'
exec(@comm)
decalre @comm varchar
set @comm=select @a.*,b.* from myTable as a inner join ('+
@v+') as b on a.key=b.key'
exec(@comm)