CREATE TABLE #TT
(
ID uniqueidentifier NOT NULL
DEFAULT newID(),
name varchar(20),
AreaCode INT
)
INSERT INTO #TT
(
Name,
AreaCode
)
OUTPUT INSERTED.ID,
INSERTED.Name,
INSERTED.AreaCode
SELECT 'SS',
1
UNION ALL
SELECT 'SS1',
2
DROP TABLE #TT
(
ID uniqueidentifier NOT NULL
DEFAULT newID(),
name varchar(20),
AreaCode INT
)
INSERT INTO #TT
(
Name,
AreaCode
)
OUTPUT INSERTED.ID,
INSERTED.Name,
INSERTED.AreaCode
SELECT 'SS',
1
UNION ALL
SELECT 'SS1',
2
DROP TABLE #TT
No comments:
Post a Comment