MSSQL存储过程中定义表变量 

 1 USE hisproc
 2 GO
 3 IF EXISTS(SELECT * FROM SYSOBJECTS WHERE name = 'xxxx')
 4     DROP PROC xxxx
 5 GO
 6 
 7 CREATE PROC xxxx
 8 (
 9     @Test    VARCHAR(10)
10 )
11 AS
12     --定义表变量
13     DECLARE @indexTable TABLE
14     (
15         IndexID    INT    IDENTITY(1,1),
16         Name VARCHAR(30)
17     )
18     INSERT INTO @indexTable(Name)VALUES('AQ')
19     INSERT INTO @indexTable(Name)VALUES('CE')
20     INSERT INTO @indexTable(Name)VALUES('表变量')
21     SELECT * FROM @indexTable
22 GO
23 
24 
25 EXEC hisproc..xxxx '333'

 

posted @ 2014-02-08 10:13  Net-Spider  阅读(915)  评论(0)    收藏  举报