例如:
select Deptname from Dept where DeptNo=@DeptNoCREATE FUNCTION dbo.Dep(@DeptNo,@SQL)
as......return @deptname???@deptNo='12345';
@SQL='select Deptname from Dept where DeptNo=@DeptNo'
select dbo.dep('12345',@SQL).
请问如何写该自定义函数数返回'select Deptname from Dept where DeptNo=‘12345’的值。(因为我传递的@SQL是字符串形式,不能在自定义函数中执行,请高手指点,谢谢)
select Deptname from Dept where DeptNo=@DeptNoCREATE FUNCTION dbo.Dep(@DeptNo,@SQL)
as......return @deptname???@deptNo='12345';
@SQL='select Deptname from Dept where DeptNo=@DeptNo'
select dbo.dep('12345',@SQL).
请问如何写该自定义函数数返回'select Deptname from Dept where DeptNo=‘12345’的值。(因为我传递的@SQL是字符串形式,不能在自定义函数中执行,请高手指点,谢谢)
select @v=dbo.dep('12345',@SQL)
returns varchar(500)
as
begin
set @deptname=(select Deptname from Dept where DeptNo=@DeptNo)
return @deptname
end
--楼主,你的具体的要求是什么呢?
除非 你使用储存过程...
例如:
select Deptname from Dept where DeptNo=@DeptNoCREATE FUNCTION dbo.Dep(@DeptNo,@SQL)
as......return @deptname???@deptNo='12345';
@SQL='select Deptname from Dept where DeptNo=@DeptNo'
select dbo.dep('12345',@SQL).
请问如何写该自定义函数数返回'select Deptname from Dept where DeptNo=‘12345’的值。(因为我传递的@SQL是字符串形式,不能在自定义函数中执行,请高手指点,谢谢)
returns varchar(100)
as
begin
declare @var varchar(100)
set @var='select Deptname from Dept where DeptNo='''+cast(@i as varchar)+''''
return (@var)
end
select dbo.f_getsql('123','1')
------------------------------------------
select Deptname from Dept where DeptNo='123'
returns varchar(1000)
as
begin
declare @var varchar(100)
set @var='select Deptname from Dept where DeptNo='''+cast(@i as varchar)+''''
return (@var)
end