How to execute multiple statements in SQL Server and return a temporary table after a select query

Set ANSI_NULLS on
go  
SET quoted_identifier in
go  
-=============================================  
CREATE FUNCTION CSJ_CSJ (@id as int)  
RETURNS @temp Table                    --here returns a table of its own creation, where the fields are set according to their needs  
(  
  [id] int,    
  [ZD] varchar (m),   
  [XL] varchar ( As
BEGIN
          
    insert INTO @temp select ID,ZD,XL from Deb-   -Inserts the SQL statement from the query into a temporary table, noting that the field is consistent  
          
    Return    --don't forget to return here, or not to inquire!  
End
Go

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/