01.
USE [mydatabase]
02.
GO
03.
/****** Object: StoredProcedure [dbo].[myStoredProcedure] Script
Date
: 11-Sep-15 3:29:52 PM ******/
04.
SET
ANSI_NULLS
ON
05.
GO
06.
07.
SET
QUOTED_IDENTIFIER
ON
08.
GO
09.
10.
CREATE
PROCEDURE
[dbo].[myStoredProcedure]
11.
@pCountry
VARCHAR
(10)
12.
AS
13.
BEGIN
14.
15.
16.
DECLARE
@
temp
TABLE
17.
(
18.
RowID
INT
IDENTITY (1,1),
19.
Name
VARCHAR
(50),
20.
LastName
VARCHAR
(50),
21.
Country
VARCHAR
(50)
22.
)
23.
24.
25.
INSERT
INTO
@
temp
(
Name
,LastName,Country)
VALUES
(
'Weerachai'
,
'Nukitram'
,@pCountry)
26.
INSERT
INTO
@
temp
(
Name
,LastName,Country)
VALUES
(
'Surachai'
,
'Sirisart'
,@pCountry)
27.
INSERT
INTO
@
temp
(
Name
,LastName,Country)
VALUES
(
'Adisorn'
,
'Boonsong'
,@pCountry)
28.
29.
30.
SELECT
*
FROM
@
temp
31.
32.
END
33.
34.
GO