--ÇÑÁÙ ¸Þ¸ðÀå Å×ÀÌºí ¼³°è --¹øÈ£, À̸§, À̸ÞÀÏ, ¸Þ¸ð, ÀÛ¼ºÀÏ, IPÁÖ¼Ò Create Table dbo.Memo ( Num int identity(1,1) Not Null Primary Key, Name varchar(25) Not Null, Email varchar(100) Null, Title varchar(150) Not Null, PostDate datetime default getdate(), PostIP varchar(15) Not Null ) Select * From Memo Order By Num Desc --MemoÅ×ÀÌºí¿¡¼­ µ¥ÀÌÅ͸¦ °Ë»öÇØ¿À´Â ÀúÀå ÇÁ·Î½ÃÀú Create Proc procSelectMemo As Select * From Memo Order By Num Desc go Insert Memo Values('È«±æµ¿', 'hong@hong.com', 'È«±æµ¿ÀÔ´Ï´Ù.', getdate(), '192.168.0.1') --Memo Å×ÀÌºí¿¡ °ªÀ» ÀÔ·ÂÇÏ´Â ÀúÀå ÇÁ·Î½ÃÀú Create Procedure procInsertMemo @Name VarChar(25), @Email VarChar(100), @Title VarChar(150), @PostDate DateTime, @PostIP VarChar(15) As Insert Memo Values(@Name, @Email, @Title, @PostDate, @PostIP) Go --Drop Proc procInsertMemo