1. °³¹ß/½ÇÇà Ç÷§Æû (1) OS : À©µµ¿ì7 (2) °³¹ßÅø : Delphi7 & ASP (3) »ç¿ë Database : SQL SERVER
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
¾È³çÇϼ¼¿ä? µ¨ÆÄÀÌ·Î °³¹ßÁß¿¡ À¥(ASPÆäÀÌÁö)·Î º¸³»¾î ±â·ÏÇÏ´Â ºÎºÐÀÌ Àִµ¥¿ä, SQL SERVER 2000¿¡¼ »ç¿ëÇÏ´ø DB¸¦ SQL SEVER 2012·Î ¸¶À̱׷¹ÀÌ¼Ç Çߴµ¥, ÀÚµ¿Áõ°¡(ID) Çʵ忡¼ °¡²û Á¦¸Ú´ë·Î Áõ°¡ÇÏ´Â Çö»óÀÌ ¹ß»ýÇÕ´Ï´Ù.
ID°¡ 1115, 1116, 1117·Î Àß Áõ°¡ÇÏ´Ù°¡ 2116À¸·Î ¶Ù°í.. 2116,2117,..,2124,2125,2126·Î Àß Áõ°¡ÇÏ´Ù°¡ 3126À¸·Î ¶Ù³×¿ä. (÷ºÎÈÀÏ ºÁÁÖ¼¼¿ä)
SQL 2000¿¡¼´Â Àß µ¹¾Æ°¡´ø °ÍÀÌ ¸¶À̱׷¹ÀÌ¼Ç ÈÄ À§ÀÇ Áõ»óÀÌ ¹ß»ýÇÕ´Ï´Ù. ÀÚü¼¹ö(SQL 2000)¿¡¼ µ¹¸®´Ù°¡ À¥È£½ºÆþ÷ü(SQL 2012)¿¡¼ µ¹¸®°í ÀÖ½À´Ï´Ù. Äڵ嵵 ´Ü¼øÇÑ ASP¾ð¾î¿¹¿ä. ¾Æ¹«¸® ºÁµµ ¹«½¼ ¿øÀÎÀÎÁö ¸ð¸£°Ú¾î¿ä. Á¶±Ý µµ¿ÍÁÖ¼¼¿ä~~
Serial_Key_SQL = " Insert into " Serial_Key_SQL = Serial_Key_SQL & " SerialNo (" Serial_Key_SQL = Serial_Key_SQL & " Serialno, Sw_name, Version, Write_date" Serial_Key_SQL = Serial_Key_SQL & ") " Serial_Key_SQL = Serial_Key_SQL & " values (" Serial_Key_SQL = Serial_Key_SQL & " '" & serial_Key & "' " Serial_Key_SQL = Serial_Key_SQL & ", '" & Sw_name & "' " Serial_Key_SQL = Serial_Key_SQL & ", '" & Version & "' " Serial_Key_SQL = Serial_Key_SQL & ", '" & Now() & "' " Serial_Key_SQL = Serial_Key_SQL & " )"
Dbcon.Begintrans Dbcon.Execute Serial_Key_SQL Dbcon.CommitTrans
|