SQL_Server自定义函数问题－求助(100分)

jybestride · 2008-02-22

create function Fn_getDate(@testvar varchar(100)) returns table as begin     .select * from test where @testvar  end 函数体大约这样现在的问题是： 我如何把＠testvar 作为查询条件？希望各位赐教

Corinth · 2008-02-22

把前面的部分变成字符串,在连接后面的,最后用exec调用

jybestride · 2008-02-22

SQL_Server自定义函数不可以这样的如果能如此早就ＯＫ　了

dyb_23 · 2008-02-22

create function Fn_getDate(@testvar varchar(100)) returns table as begin   execute('select * from test where '+ @testvar) end

jybestride · 2008-02-22

我去试试看如果ＯＫ最迟明天放分

jybestride · 2008-02-22

问题没解决

redflyfox · 2008-02-23

用存储过程不行吗？在存储过程中执行execute('select * from test where '+ @testvar) 应该没问题的.

jybestride · 2008-02-24

由于种种原因不能用存储过程

qiuyan81 · 2008-08-10

create function Fn_getDate(@testvar varchar(100)) returns table(A varchar(20)) as begin     .select A into table from test where @testvar  end

枝上柳绵 · 2008-10-20

exec('select * from '+@tablename+@wherestr)

迷途的羔羊 · 2008-11-17

declare @sqlstring nvarchar(4000) set @sqlstring=... execute sp_executesql @sqlstring

SQL_Server自定义函数问题－求助(100分)

jybestride

Unregistered / Unconfirmed

Corinth

Unregistered / Unconfirmed

jybestride

Unregistered / Unconfirmed

dyb_23

Unregistered / Unconfirmed

jybestride

Unregistered / Unconfirmed

jybestride

Unregistered / Unconfirmed

redflyfox

Unregistered / Unconfirmed

jybestride

Unregistered / Unconfirmed

qiuyan81

Unregistered / Unconfirmed

枝上柳绵

Unregistered / Unconfirmed

迷途的羔羊

Unregistered / Unconfirmed

Similar threads