_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 貎朱Μ蟆郁骸襯殊朱覦る覦覯

Contents



-- ろ 企 
CREATE TABLE dbo.Test001 (seq int IDENTITY(1, 1) NOT NULL);
GO

-- ろ 一危 10覯 j鍵
INSERT dbo.Test001 DEFAULT VALUES;
GO 10

-- 覲襦 螳語る 覦覯
DECLARE @intMaxSeq int, @nvcStmt nvarchar(4000), @nvcTableName sysname;

SET @nvcTableName = N'dbo.Test001';
SET @nvcStmt = N'SELECT @intMaxSeq = MAX(seq) FROM ' + @nvcTableName;

EXEC sp_executesql @nvcStmt, N'@intMaxSeq int OUTPUT', @intMaxSeq OUTPUT;

SELECT @intMaxSeq;
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

覓企 覓殊企 讌碁ゼ 磯 襯企 豺讌 螻 讌襯 螳豢 螳螻 讌企伎 襦 螳 襯 螳豢 螳朱 企 蟾 螻葛 襾碁蟇磯Μ讌 螻 れ願 蠍磯ゼ 螳讌 螳螻 レ覓殊 襷 螳覃 螻 襷讌 豌覈 螳朱 螻褐 蟇一 覃襴 襯伎襷 覓殊企襴 覯 朱 螳讌 螳. 豌讌 願朱 企伎螻 襷覓殊 願朱 伎螳覃 朱 願朱 至 襷 願朱 伎覃 襷覓殊 願朱 覦襯願 蟆企. 願 讌襦 螳 覓殊 譬 伎企. ( <<語>>)