set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[RtnTableFunc]()
RETURNS TABLE
AS
RETURN ( SELECT 'cqs' as a,'2007-04-03' as b,'okok' as c )
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[getTable]
AS
BEGIN
--create table @table(a varchar(20),b varchar(20),c varchar(20))
--set @table=dbo.RtnTableFunc()
--select * from @table
select * from dbo.RtnTableFunc()
SET NOCOUNT ON;
END
/*
exec cqsdb.dbo.getTable
a b c
cqs 2007-04-03 comtent
*/