× 评论会员:sachin10d 时间:2012/02/06
CREATE FUNCTION fn_FunctionName (@NO INT )
RETURNS TABLE
AS
RETURN
(Select No,Name from TAB1 where No=@NO
UNION
Select No,Name,Class from TAB2 where No=@NO
UNION
Select Dept,Place from TAB3 where No=@NO)
Go
使用这种方式
SELECT * FROM fn_FunctionName(10 )
× 评论会员:游客 时间:2012/02/06
Simon_Whale的例子是从这里imgsrc=codepreThisexampleusesthespanclass="code-preprocessor"@@ROWCOUNT/spanspanclass="code-keyword"function/spanspanclass="code-keyword"as/spanpartspanclass="code-keyword"of/spanthespanclass="code-keyword"view/spandefinition.spanclass="code-keyword"USE/spanpubsspanclass="code-keyword"IF/spanspanclass="code-keyword"EXISTS/span(spanclass="code-keyword"SELECT/spanTABLE_NAMEspanclass="code-keyword"FROM/spanINFORMATION_SCHEMA.VIEWSspanclass="code-keyword"WHERE/spanTABLE_NAME=spanclass="code-string"'/spanspanclass="code-string"myview'/span)spanclass="code-keyword"DROP/spanspanclass="code-keyword"VIEW/spanmyviewspanclass="code-keyword"GO/spanspanclass="code-keyword"CREATE/spanspanclass="code-keyword"VIEW/spanmyviewspanclass="code-keyword"AS/spanspanclass="code-keyword"SELECT/spanau_lname,au_fname,spanclass="code-preprocessor"@@ROWCOUNT/spanspanclass="code-keyword"AS/spanbarspanclass="code-keyword"FROM/spanauthorsspanclass="code-keyword"WHERE/spanstate=spanclass="code-string"'/spanspanclass="code-string"UT'/spanspanclass="code-keyword"GO/spanspanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spanmyview/pre/code作为视图创建了一个虚拟的表,你可以做,如下面的简单的例子,认为大多数的SQL操作{体C3}