Create procedure Test @a varchar(100)
As
...
执行:
declare @str varchar(100)
set @str = 'jfdsaf'
Exec Test @str
As
...
执行:
declare @str varchar(100)
set @str = 'jfdsaf'
Exec Test @str
解决方案 »
- [疑难问题]我不会说,举个例子,您一看就明白了?
- sql2005 Varchar(300) 里面保存的是二进制数据,我该如何取呢
- 帮我看看我写的触发器
- 时间比较问题???
- 新手求一SQL存储过程(在线等...)
- 如何追加字段,求sql语句?
- 请大虾们帮我写个表的转换
- sql server 2000不能在sp2安装?
- 菜鸟问题:学数据库学什么?
- 关于SQL问题
- select ledid, (case when lendsplitid is null then ledid when '' then ledid else ledid + '-' + lendsplitid end) as lendida from t
- 为什么用SQLDMO.BulkCopy导出的数据集为empty?
@a int ,
@b int
as
insert a select @a,@b
as
exec('select * from 表' + @参数)
as
declare @sql varchar(2048)
set @sql = --你的sql语句
set @sql = @sql + @sqlcause
exec (@sql)
go
As
exec('select * from sysobjects where 1=1 and ' + @sql)
执行:
declare @str varchar(100)
set @str = 'xtype = ''U'''
Exec Test @str