-- ±âº» °Ô½ÃÆÇ(Basic)¿ë Å×ÀÌºí ¼³°è Create Table dbo.Basic ( 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() Not Null, --ÀÛ¼ºÀÏ PostIP VarChar(15) Not Null, --ÀÛ¼ºIP Content Text Not Null, --³»¿ë Password VarChar(20) Not Null, --ºñ¹Ð¹øÈ£ ReadCount Int Default 0, --Á¶È¸¼ö Encoding VarChar(10) Not Null, --ÀÎÄÚµù(HTML/Text) Homepage VarChar(100) Null, --ȨÆäÀÌÁö ModifyDate DateTime Null, --¼öÁ¤ÀÏ ModifyIP VarChar(15) Null --¼öÁ¤IP ) Go --±âº» SQL¹® 4°¡Áö ÀÛ¼º Select * From Basic Go -- ±âº» °Ô½ÃÆÇ(Basic)¿¡ ±ÛÀ» ÀÛ¼ºÇÏ´Â ÀúÀå ÇÁ·Î½ÃÀú : procWriteBasic Create Proc dbo.procWriteBasic @Name VarChar(25), @Email VarChar(100), @Title VarChar(150), @PostIP VarChar(15), @Content Text, @Password VarChar(20), @Encoding VarChar(10), @Homepage VarChar(100) As --With Encryption Insert Basic (Name, Email, Title, PostIP, Content, Password, Encoding, Homepage) Values (@Name, @Email, @Title, @PostIP, @Content, @Password, @Encoding, @Homepage) Go -- ±âº» °Ô½ÃÆÇ(Basic)¿¡¼­ µ¥ÀÌÅ͸¦ Àоî¿À´Â ÀúÀå ÇÁ·Î½ÃÀú : procListBasic Create Procedure dbo.procListBasic As Select * From Basic Order By Num Desc Go -- Á¶È¸¼ö Áõ°¡½ÃÄÑÁÖ´Â ÀúÀå ÇÁ·Î½ÃÀú : procUpdateReadCount Create Proc dbo.procUpdateReadCountBasic @Num Int As Update Basic Set ReadCount = ReadCount + 1 Where Num = @Num Go -- ÇØ´ç ±ÛÀ» ¼¼ºÎÀûÀ¸·Î Àоî¿À´Â ÀúÀå ÇÁ·Î½ÃÀú : procViewBasic Create Procedure dbo.procViewBasic @Num Int As Select * From Basic Where Num = @Num Go -- ÇØ´ç ±Û¿¡ ´ëÇÑ ºñ¹Ð¹øÈ£ Àоî¿À´Â ÀúÀå ÇÁ·Î½ÃÀú : procReadPasswordBasic Create Proc dbo.procReadPasswordBasic @Num Int As Select Password From Basic Where Num = @Num Go -- ÇØ´ç ±Û Áö¿ì´Â ÀúÀå ÇÁ·Î½ÃÀú : procDeleteBasic Create Proc dbo.procDeleteBasic @Num Int As Delete Basic Where Num = @Num Go -- ÇØ´ç ±ÛÀ» ¼öÁ¤ÇÏ´Â ÀúÀå ÇÁ·Î½ÃÀú : procUpdateBasic Create Proc dbo.procUpdateBasic @Name VarChar(25), @Email VarChar(100), @Title VarChar(150), @ModifyIP VarChar(15), @ModifyDate DateTime, @Content Text, @Encoding VarChar(10), @Homepage VarChar(100), @Num Int As Update Basic Set Name = @Name, Email = @Email, Title = @Title, ModifyIP = @ModifyIP, ModifyDate = @ModifyDate, Content = @Content, Encoding = @Encoding, Homepage = @Homepage Where Num = @Num Go