ȨÀ¸·Î
| ¹«·áȸ¿ø°¡ÀÔ | ¾ÆÀ̵ð/ºñ¹øÃ£±â
ÃßõÀ½¾Ç¹æ¼Û
ms sql ÀúÀå ÇÁ·Î½ÃÀú
11³â Àü
¾Æ·¡ select @idx= scope_identity(), return @idx´Â ÃÖÁ¾ »ý¼ºµÈ idx °ªÀ» ¹ÝȯÇϱâ À§ÇÔ..

==== ÀúÀå ÇÁ·Î½ÃÀú
CREATE PROC mailWrite
    @nName varchar(20),
    @email varchar(50),
    @mailFlag bit,
    @mailDate smalldatetime,
    @mailFile varchar(50),
    @idx int output
AS
    set nocount on
    insert into mailList ( name, email, mailFlag, mailDate, mailfile) values( @nName, @email, @mailFlag, @mailDate, @mailFile )
    select @idx=scope_identity()
    return @idx
GO

==== »ç¿ë ¿¹
with dbConn
    .beginTrans



    Set cmd = Server.CreateObject("ADODB.Command")
    with cmd        'ÀúÀå ÇÁ·Î½ÃÀú¸¦ ÀÌ¿ëÇÑ µ¥ÀÌÅÍ ÀúÀå
       .activeConnection = dbConn
       .prepared = true
       .CommandType = 4
       .CommandText = "mailWrite"
       .Parameters("@nName").Value = nName
       .Parameters("@email").Value = email
       .Parameters("@mailFlag").Value = mailFlag
       .Parameters("@mailDate").Value = mailDate
       .Parameters("@mailFile").Value = mailFile
       .Execute
       idx = .Parameters("@idx")
    end with
    
    if .errors.count > 0 then
        .rollbackTrans
    else
        .commitTrans
        set rs = server.createObject("adodb.recordset")
        with rs
            qul="select * from mailList where idx="& idx
            .open qul, dbConn, 3, 3
            dbIdx = .fields("idx")
            dbName = .fields("name")
            dbEmail = .fields("email")
            if .fields("mailFlag")=true then
                dbMailFlag = "checked"
            else
                dbMailFlag = ""
            end if
            dbMailDate = .fields("mailDate")
            dbMailFile = .fields("mailFile")
        end with
        
        response.write dbIdx &"<br>"& dbName &"<br>"&_
                                    dbEmail &"<br>"& dbMailFlag &"<br>"& dbMailDate &"<br>"& dbMailFile
    end if
end with
ÃßõÃßõ : 517 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
3,046
 Vimeo (ºñ¸Þ¿À) API ¸¦ »ç¿ëÇÏ¿© Ç÷¹À̾î ÄÁÆ®·ÑÇϱâ
3,045
 iframe »ç¿ë½Ã ÇÏ´Ü¿¡ ¹ß»ýÇÏ´Â °ø¹é Á¦°Å¹æ¹ý
3,044
 ¾ÆÀÌÇÁ·¹ÀÓ(iframe) Àüüȭ¸é °¡´ÉÇÏ°Ô Çϱâ
3,043
 ºÎÆ®½ºÆ®·¦(bootstrapk)¿¡¼­ »ç¿ëÇÏ´Â class¸í Á¤¸®
3,042
 ºÎÆ®½ºÆ®·¦ CSS
3,041
 Å©·Ò¿¡¼­ ¸¶Áø Á¶Àý
3,040
 PHP ÇöÀç ÆäÀÌÁöÀÇ µµ¸ÞÀθíÀ̳ª urlµîÀÇ Á¤º¸ ¾Ë¾Æ¿À±â
3,039
 PHP preg match all()
3,038
 PHP ·Î À¥ÆäÀÌÁö ±Ü¾î¿À±â ¸ðµç ¹æ¹ý ÃÑÁ¤¸®!
3,037
 [PHP] ¿ø°ÝÁö ÆÄÀÏ ÁÖ¼Ò ³ëÃâ ¾ÈÇϰí curl·Î ´Ù¿î·Îµå ¹Þ±â
3,036
 PHP ÇÔ¼ö Á¤¸®
3,035
 ¾ÆÀÌÇÁ·¹ÀÓ(iframe) ºñÀ² À¯ÁöÇϸ鼭 Å©±â Á¶ÀýÇÏ´Â ¹æ¹ý
3,034
 PHP ¹è¿­¿¡¼­ ¹«ÀÛÀ§·Î Çϳª »Ì¾ÆÁÖ´Â array rand() ÇÔ¼ö
3,033
 PHP Á¤±Ô½Ä Á¤¸®
3,032
 PHP Á¤±Ô½ÄÀ» Ȱ¿ëÇÑ ÅÂ±× ¹× ƯÁ¤ ¹®ÀÚ¿­ Á¦°Å ¹× ÃßÃâ ¹æ¹ý
3,031
 php Å©·Ñ¸µ ¶Ç´Â ÆÄ½Ì ÇÔ¼ö, Á¤±Ô½Ä ¸ðÀ½
3,030
 Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
3,029
 À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
3,028
 ¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
3,027
 [HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
3,026
 HTML <Audio> »ç¿ë¹ý
3,025
 À©µµ¿ì10 ½Ã½ºÅÛÆÄÀÏ ¼Õ»ó (Ãʰ£´Ü ¿À·ù º¹±¸¹æ¹ý!!)
3,024
 PHP ÆÄÀÏ Á¸Àç ¿©ºÎ ÆÄ¾ÇÇϱâ(·ÎÄà ÆÄÀÏ Á¸Àç ¹× ¿ø°ÝÁö ÆÄÀÏ Á¸Àç)
3,023
 [CSS] ¹Ú½º ¼¼·Î °¡¿îµ¥ Áß¾Ó Á¤·Ä 6°¡Áö
3,022
 CSS Layout ¼öÆò & ¼öÁ÷ Á¤·Ä
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
Copyright (C) musictrot All rights reserved.