Work Book UserPreferences
 
Help Info Print View Search Diffs Edit
 À妽º   Ã£±â   Freeboard   Subjectless   Images   ÃÖ±Ù±Û 

Version as of 2004-11-03 19:34:31

Clear message


ÀÛ¾÷ ³ëÆ®. ¹®µÎ»ðÀÔ¹æ½ÄÀ¸·Î °»½Å(¸Ç À§ÀÇ ³»¿ëÀÌ °¡Àå ÃÖ±Ù ³»¿ëÀÓ)

¿ÀÈÄ 6:59 2004-11-03
[WWW]ÀÚ¹Ù ¿ÀǼҽº·Î ½Ã½ºÅÛ ÅëÇÕÇϱâ

¿ÀÀü 11:53 2004-10-25
Visual Studio .NET Bootstrapper
http://msdn.microsoft.com/vstudio/downloads/tools/bootstrapper/

Visual Studio .NET 2003 Hosted Experience
http://msdn.microsoft.com/vstudio/tryit/

Visual Basic 2005 Express Edition Beta
http://lab.msdn.microsoft.com/express/vbasic/default.aspx

Introducing the Visual Basic .NET Power Pack
http://msdn.microsoft.com/vbasic/default.aspx?pull=/library/en-us/dv_vstechart/html/vbpowerpack.asp

Visual Basic At The Movies
http://msdn.microsoft.com/vbasic/atthemovies/

Windows Mobile > Tools and Downloads
http://msdn.microsoft.com/mobility/windowsmobile/downloads/

Smart Client Development
http://msdn.microsoft.com/smartclient/

Visual Basic Dev
http://msdn.microsoft.com/vbasic/default.aspx

GotDotNet? User Sample: Cave Man Hank (.net compact framework)
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=aef48b4c-9345-4138-ac75-0248bc5b7691

ASP.NET Web: The Official Microsoft ASP.NET Site
http://www.asp.net/

¿ÀÈÄ 2:43 2004-10-22
M$°è¿­ ¼­¹ö ºÎÇÏ Åë°è ¾Ë¾Æº¸±â
¼º´É¸ð´ÏÅ͸µÀ» È°¿ëÇÏ´Â ¹æ¹ý
http://mudmania.org/reiot/PerformanceMonitoring

Web Application Stress ToolÀÇ ÀÌ¿ë
http://support.microsoft.com/default.aspx?scid=kb;KO;231282
http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062a-439e-a67d-75a89aa36495&DisplayLang=en

mrtg
http://mrtg.co.kr/
http://snmpboy.msft.net/default.aspx

log ºÐ¼®
http://awstats.sourceforge.net

http://gotdotnet.com ´å³Ý °ü·Ã
http://www.debuglab.com/ µð¹ö±×·¦

.NET: Visual Basic .NET
Getting Started with Visual Basic .NET
http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vbasic.asp
Printed pages 19

Getting Started with Visual C# .NET
http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcsharp.asp
Printed pages 20
.NET: Visual C++.NET

Getting Started with Visual C++ .NET
http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcppn.asp
Printed pages 20
Other

Getting Started with Visual C++
http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcpp.asp
Printed pages 20

¿ÀÈÄ 12:54 2004-10-13
[WWW]´å³Ý ÇÁ·ÎÁ§Æ®¸¦ Á¤º¹Ç϶ó - ¨ç ÀÌ·¡¼­ ¾ÈµÇ´Â°Å±º!

[WWW]Serial Communication with VB.Net
[WWW]GotDotNet User Samples - serial
[WWW]GotDotNet User Sample: RS232-Serial comunication class (update)
[WWW]The Moth - Serial (RS232) communications in .NET

¿ÀÈÄ 10:25 2004-09-08
http://www.microsoft.com/korea/windowsserversystem/virtualserver/evaluation/rceval.asp
Microsoft Virtual Server 2005, Enterprise Edition RC ¹öÀü ÆäÀÌÁö.

Virtual pc°¡ windows 2003À¸·Î ³Ñ¾î°¡¸é¼­, À̸§±îÁö ¹Ù²ãÄ¡·Á´Â ¸ð¾ç.
¼­¹ö Çϳª ¸¶·ÃÇؼ­ ¹º°¡ Á» Çغ¼±î...

¿ÀÈÄ 9:56 2004-09-03
bstr to char
#include <comdef.h> 
 
... 
 
CString strLine; 
_bstr_t bstrText( strText ); 
strLine.Format( "%s", LPCSTR( bstrText ) ); 

¿ÀÀü 9:50 2004-08-20
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133
How to dynamically number rows in a SELECT Statement ; °£´ÜÈ÷, oracleÀÇ rownum °°Àº °ÍÀ» ¾²±â À§ÇÑ ²Ç¼ö

¿ÀÈÄ 6:00 2004-08-19
atl¿¡¼­ objectsafety¸¦ ±¸ÇöÇÏ´Â°Ç ´Ü¼øÈ÷ ´ÙÀ½ÀÇ ÀÎÅÍÆäÀ̽º¸¦ »ó¼Ó¹Þ¾ÆÁÖ¸é ³¡ :
public IObjectSafetyImpl<CKioPhotoPaymentCtrl, INTERFACESAFE_FOR_UNTRUSTED_CALLER | INTERFACESAFE_FOR_UNTRUSTED_DATA> 
¿ÀÈÄ 2:22 2004-08-17
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/html/msdn_abcsmfc.asp
The ABCs of MFC ActiveX Controls (ActiveX Controls Technical Articles)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/html/msdn_signmark.asp
Signing and Marking ActiveX Controls

[Upload]helpers.zip

ObjectSafety °ü·Ã ·¹Áö½ºÆ®¸® ÀÚ°¡ µî·Ï µµ¿ÍÁÖ´Â ÄÚµå 
Âü°í·Î ·¹Áö½ºÆ®¸® µî·Ï ÄÚµå´Â DllRegisterServer()¿¡¼­ Çصµ µÇÁö¸¸, 
clsid¸¦ °¡Á®´Ù ¾´´Ù´ø°¡ÀÇ ¹®Á¦°¡ ÀÖÀ¸¹Ç·Î.. 
ÄÁÆ®·Ñ::CKioPhotoCtrlFactory::UpdateRegistry ÇÔ¼ö¿¡¼­ µî·ÏÇϵµ·Ï ÇÏÀÚ. 

¿ÀÀü 11:53 2004-08-17
http://www.codeproject.com/system/serial.asp ½Ã¸®¾ó Åë½Å¿ë Wrapper Class.

¿ÀÀü 11:39 2004-08-16
ºê¶ó¿ìÀú¿¡¼­ ¸¶¿ì½º Å°º¸µå ¸·±â (ie ±âÁØ)
// Å°º¸µå ¸·±â 
document.onkeydown=KeyEventHandle;  
document.onkeyup=KeyEventHandle;  
 
function KeyEventHandle() { 
        if ( (event.ctrlKey == true && (event.keyCode == 78 || event.keyCode == 82)) || (event.keyCode >= 117 && event.keyCode <= 123) ) {  
                event.keyCode = 0;  
                event.cancelBubble = true;  
                event.returnValue = false;  
        }  
}  
 
// ¸¶¿ì½º ¸·±â 
document.onmousedown = mouseright; 
function mouseright(e) { 
        if (navigator.appName == 'Netscape' && (e.which == 3 || e.which == 2)) { 
                return false; 
        } else if (navigator.appName == 'Microsoft Internet Explorer' && (event.button == 2 || event.button == 3)) { 
                return false; 
        } 
 
        return true; 
} 
¿ÀÀü 11:08 2004-08-16
vb¿¡¼­ ocx ¸¸µé ¶§ IObjectSafety
? ÀÎÅÍÆäÀ̽º ±¸Çö
' ¸ÞÀÎ ¸ðµâ¿¡ »ðÀÔÇÏ´Â ºÎºÐ 
 
Global gPortOpen As Boolean 
Global gVIewMode As Integer 
Option Explicit 
 
      Public Const IID_IDispatch = "{00020400-0000-0000-C000-000000000046}" 
      Public Const IID_IPersistStorage = _ 
        "{0000010A-0000-0000-C000-000000000046}" 
      Public Const IID_IPersistStream = _ 
        "{00000109-0000-0000-C000-000000000046}" 
      Public Const IID_IPersistPropertyBag = _ 
        "{37D84F60-42CB-11CE-8135-00AA004BB851}" 
 
      Public Const INTERFACESAFE_FOR_UNTRUSTED_CALLER = &H1 
      Public Const INTERFACESAFE_FOR_UNTRUSTED_DATA = &H2 
      Public Const E_NOINTERFACE = &H80004002 
      Public Const E_FAIL = &H80004005 
      Public Const MAX_GUIDLEN = 40 
 
      Public Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" _ 
         (pDest As Any, pSource As Any, ByVal ByteLen As Long) 
      Public Declare Function StringFromGUID2 Lib "ole32.dll" (rguid As _ 
         Any, ByVal lpstrClsId As Long, ByVal cbMax As Integer) As Long 
 
      Public Type udtGUID 
          Data1 As Long 
          Data2 As Integer 
          Data3 As Integer 
          Data4(7) As Byte 
      End Type 
 
      Public m_fSafeForScripting As Boolean 
      Public m_fSafeForInitializing As Boolean 
 
      Sub Main() 
          m_fSafeForScripting = True 
          m_fSafeForInitializing = True 
      End Sub 
 
 
' ÄÁÆ®·Ñ Äڵ忡 »ðÀÔÇÏ´Â ºÎºÐ 
 
Private Sub IObjectSafety_GetInterfaceSafetyOptions(ByVal riid As _ 
      Long, pdwSupportedOptions As Long, pdwEnabledOptions As Long) 
 
          Dim Rc      As Long 
          Dim rClsId  As udtGUID 
          Dim IID     As String 
          Dim bIID()  As Byte 
 
          pdwSupportedOptions = INTERFACESAFE_FOR_UNTRUSTED_CALLER Or _ 
                                INTERFACESAFE_FOR_UNTRUSTED_DATA 
 
          If (riid <> 0) Then 
              CopyMemory rClsId, ByVal riid, Len(rClsId) 
 
              bIID = String$(MAX_GUIDLEN, 0) 
              Rc = StringFromGUID2(rClsId, VarPtr(bIID(0)), MAX_GUIDLEN) 
              Rc = InStr(1, bIID, vbNullChar) - 1 
              IID = Left$(UCase(bIID), Rc) 
 
              Select Case IID 
                  Case IID_IDispatch 
                      pdwEnabledOptions = IIf(m_fSafeForScripting, _ 
                    INTERFACESAFE_FOR_UNTRUSTED_CALLER, 0) 
                      Exit Sub 
                  Case IID_IPersistStorage, IID_IPersistStream, _ 
                     IID_IPersistPropertyBag 
                      pdwEnabledOptions = IIf(m_fSafeForInitializing, _ 
                    INTERFACESAFE_FOR_UNTRUSTED_DATA, 0) 
                      Exit Sub 
                  Case Else 
                      Err.Raise E_NOINTERFACE 
                      Exit Sub 
              End Select 
          End If 
      End Sub 
 
      Private Sub IObjectSafety_SetInterfaceSafetyOptions(ByVal riid As _ 
      Long, ByVal dwOptionsSetMask As Long, ByVal dwEnabledOptions As Long) 
          Dim Rc          As Long 
          Dim rClsId      As udtGUID 
          Dim IID         As String 
          Dim bIID()      As Byte 
 
          If (riid <> 0) Then 
              CopyMemory rClsId, ByVal riid, Len(rClsId) 
 
              bIID = String$(MAX_GUIDLEN, 0) 
              Rc = StringFromGUID2(rClsId, VarPtr(bIID(0)), MAX_GUIDLEN) 
              Rc = InStr(1, bIID, vbNullChar) - 1 
              IID = Left$(UCase(bIID), Rc) 
 
              Select Case IID 
                  Case IID_IDispatch 
                      If ((dwEnabledOptions And dwOptionsSetMask) <> _ 
                   INTERFACESAFE_FOR_UNTRUSTED_CALLER) Then 
                          Err.Raise E_FAIL 
                          Exit Sub 
                      Else 
                          If Not m_fSafeForScripting Then 
                              Err.Raise E_FAIL 
                          End If 
                          Exit Sub 
                      End If 
 
                  Case IID_IPersistStorage, IID_IPersistStream, _ 
                IID_IPersistPropertyBag 
                      If ((dwEnabledOptions And dwOptionsSetMask) <> _ 
                    INTERFACESAFE_FOR_UNTRUSTED_DATA) Then 
                          Err.Raise E_FAIL 
                          Exit Sub 
                      Else 
                          If Not m_fSafeForInitializing Then 
                              Err.Raise E_FAIL 
                          End If 
                          Exit Sub 
                      End If 
 
                  Case Else 
                      Err.Raise E_NOINTERFACE 
                      Exit Sub 
              End Select 
          End If 
      End Sub 

¿ÀÀü 12:48 2004-08-16
atl¿¡ ÅåÅåÈ÷ ´çÇÏ°í ÀÖ´Â Áß.

HWND hWnd; 
((IOleInPlaceObjectWindowlessImpl<Ctestatlctrl>*)this)->GetWindow(&hWnd); 
::PostMessage(hWnd, WM_PAINT, 0, 0); 
ÀÏ´Ü m_rcPos °´Ã¼·Î À̳༮ÀÌ ¾îµð ¹ÚÇôÀÖ´ÂÁö´Â ¾Ë¾Æ ³¾ ¼ö Àִµ¥,
invalidate, invalidaterect µûÀ§ÀÇ ÇÔ¼ö¸¦ ½áµµ...
ºê¶ó¿ìÀú»Ó¸¸ÀÌ ¾Æ´Ï¶ó, È­¸é Àüü°¡ °»½ÅµÇ¾î ¹ö¸°´Ù.

::InvalidateRect(m_hWnd, &m_rcPos, false); 
È£ÃâµÉ¶§¸¶´Ù È­¸é Àüü°¡ ²­¹÷²­¹÷... -_-

±×³É mfc·Î Â¥¾ß°Ú´Ù...

¿ÀÈÄ 8:20 2004-08-12
ÃÖ±Ù com ÄÁÆ®·ÑÀ» ¸¸µé°í Àִµ¥, ¾öÇÏ°Ô BSTR ¹®ÀÚ¿­À» ÀÏ¹Ý ¾Æ½ºÅ°·Î º¯È¯ÇÏ´À¶ó »ðÁú.
sprintf, wsprintf ÇÔ¼ö·Î char, wchar_t Çü½Ä º¯È¯Àº °¡´ÉÇѵ¥,

¹®Á¦´Â.. BSTRÀº multibyte°¡ ¾Æ´Ï¶ó unicode¶ó´Â °Í -_-
MultibyteToWidechar
?Àΰ¡... ±× ÇÔ¼ö·Î º¯È¯Çß´Ù --;

¿ÀÀü 11:24 2004-08-05
Microsoft Win32 to Microsoft .NET Framework API Map
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/win32map.asp

¿ÀÈÄ 3:38 2004-07-21
Startup Phases for x86-based Systems
http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/Windows/XP/all/reskit/en-us/prmc_str_reii.asp

¿ÀÈÄ 2:33 2004-07-19
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q145/6/79.asp&NoWebContent=1
vb ¿¡¼­ ·¹Áö½ºÆ®¸® ½Ø¿ì±â

¿ÀÀü 11:22 2004-07-07
Accessibility °ü·Ã ¸µÅ©
¿ÀÀü 11:26 2004-06-04
ÀÚµ¿ ·Î±×¿Â ½Ø¿ì±â
HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion
?\Winlogon
¿ÀÈÄ 3:54 2004-05-26
RegressionAnalyzingGrapher °³¹ß°ü·Ã 1Â÷ ¹ÌÆÃ

¿ÀÀü 10:38 2004-05-11
CDO 1.2.1 for Winnt ´º½º Æ÷½ºÆÿë asp ÇÔ¼ö
Win2k Server (sp2)¿¡¼­ Á¤»ó ÀÛµ¿ÇÔ.
news.microsoft.comÀÇ °æ¿ì Æ÷½ºÆÿ¡ 20~30¿©ÃÊ°¡ ¼Ò¿äµÊ.
iframeÀ̳ª Æ˾÷µîÀ» ÀÌ¿ë, ¹é±×¶ó¿îµå¿¡¼­ Æ÷½ºÆõǵµ·Ï ÇÏ´Â °ÍÀÌ ÁÁÀ» µí.

'Configuration¿ë Á¢µÎ¾î-Namespace 
const CONFURL = "http://schemas.microsoft.com/cdo/configuration/" 
 
function PostNewsThread(host, newsgroup, subject, contenttext, username, useremail) 
        Set msg = Server.CreateObject("CDO.Message") 
        Set Flds = msg.Configuration.Fields             'Flds´Â ADODB.Fields °´Ã¼ÀÓ 
         
        Flds(CONFURL+"postusing")               = 2 'cdoPostUsingPort 
        Flds(CONFURL+"protocolauthentication")               = 0 'cdoAnonymous  
        Flds(CONFURL+"nntpserver")               = host 
        Flds(CONFURL+"nntpserverport")               = 119 
        Flds(CONFURL+"nntpauthenticate")                  = 0 'cdoAnonymous  
        Flds(CONFURL+"postusername")               = username 
        Flds(CONFURL+"postnntpaccountname")               = username 
        Flds(CONFURL+"postpassword")               = "" 
        Flds(CONFURL+"postemailaddress")               = username + " <"+useremail+">" 
        Flds(CONFURL+"postuserreplyemailaddress")               = username + " <"+useremail+">" 
        Flds.Update 
 
        msg.Subject = subject 
        msg.TextBody = contenttext 
        msg.Newsgroups = newsgroup 
        msg.From = username + " <"+useremail+">" 
        msg.Post 
end function 
¿ÀÈÄ 1:30 2004-05-06
[WWW]182598 HOWTO: Implement IObjectSafety in Visual Basic Controls

¿ÀÀü 10:36 2004-04-23
wscript¸¦ ÀÌ¿ëÇÑ ·¹Áö½ºÆ®¸® ¾×¼¼½º.txt
[VBScript]  
Dim WshShell, bKey 
Set WshShell = WScript.CreateObject("WScript.Shell") 
 
WshShell.RegWrite "HKCU\Software\ACME\FortuneTeller\", 1, "REG_BINARY" 
WshShell.RegWrite "HKCU\Software\ACME\FortuneTeller\MindReader", "Goocher!", "REG_SZ" 
 
bKey = WshShell.RegRead("HKCU\Software\ACME\FortuneTeller\") 
WScript.Echo WshShell.RegRead("HKCU\Software\ACME\FortuneTeller\MindReader") 
 
WshShell.RegDelete "HKCU\Software\ACME\FortuneTeller\MindReader" 
WshShell.RegDelete "HKCU\Software\ACME\FortuneTeller\" 
WshShell.RegDelete "HKCU\Software\ACME\" 
 
[JScript]  
var WshShell = WScript.CreateObject ("WScript.Shell"); 
 
WshShell.RegWrite ("HKCU\\Software\\ACME\\FortuneTeller\\", 1, "REG_BINARY"); 
WshShell.RegWrite ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader", "Goocher!", "REG_SZ"); 
 
var bKey =    WshShell.RegRead ("HKCU\\Software\\ACME\\FortuneTeller\\"); 
WScript.Echo (WshShell.RegRead ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader")); 
 
WshShell.RegDelete ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader"); 
WshShell.RegDelete ("HKCU\\Software\\ACME\\FortuneTeller\\"); 
WshShell.RegDelete ("HKCU\\Software\\ACME\\"); 

¿ÀÈÄ 4:00 2004-04-22
msde ¶óÀ̼¾½º °ü·Ã url.
http://www.microsoft.com/sql/msde/howtobuy/msderights.asp
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
http://www.microsoft.com/sql/msde/productinfo/features.asp

¿ÀÈÄ 12:18 2004-04-21
<script> 
function openNewWin(tmpImg) 
{ 
    var newWin; 
    newWin = window.open(tmpImg.src, '', 'width='+tmpImg.width+',height='+tmpImg.height); 
    newWin.focus(); 
} 
 
function onloadfile(fname) 
{ 
        alert(fname); 
        var tmpImg = new Image; 
        tmpImg.src = fname; 
        tmpImg.onload = openNewWin(tmpImg); 
} 
</script> 
 
<BODY> 
<INPUT TYPE="file" name="file1" onChange="onloadfile(this.value);"> 
</body> 

¿ÀÈÄ 11:43 2004-04-09
/* Å×ÀÌºí »ý¼º SQL */ 
CREATE TABLE [dbo].[tb1] ( 
        [ID] [varchar] (10)  NOT NULL , 
        [description] [varchar] (50) NOT NULL  
) ON [PRIMARY] 
GO 
 
CREATE TABLE [dbo].[tb2] ( 
        [idx] [int] IDENTITY (1, 1) NOT NULL , 
        [ID1] [varchar] (10) NULL , 
        [ID2] [varchar] (10) NULL , 
        [ID3] [varchar] (10) NULL , 
        [ID4] [varchar] (10) NULL , 
        [ID5] [varchar] (10) NULL , 
        [ID6] [varchar] (10) NULL , 
        [ID7] [varchar] (10) NULL , 
        [ID8] [varchar] (10) NULL , 
        [ID9] [varchar] (10) NULL , 
        [ID10] [varchar] (10) NULL  
) ON [PRIMARY] 
GO 
/* Å×ÀÌºí »ý¼º SQLÀÇ ³¡ */ 
 
 
 
/* ½ÇÁ¦ ÇÊ¿äÇÑ ½ºÅ©¸³Æ®ÀÇ ½ÃÀÛ */ 
/* ÀÏ´Ü ÇʵåÀÇ °¹¼ö´Â 10°³·Î °¡Á¤ */ 
Declare @d1 varchar(10), @d2 varchar(10), @d3 varchar(10),@d4 varchar(10),@d5 varchar(10),@d6 varchar(10),@d7 varchar(10),@d8 varchar(10),@d9 varchar(10),@d10 varchar(10) 
 
CREATE TABLE #temp(tempfield varchar(10) NULL)  
 
/* °¢ ÇʵåÀÇ ID °ª¿¡ µû¶ó ¼³¸í¿¡ ÇØ´çÇÏ´Â description Çʵ带 °¡Á®¿È 
    ÇʵåÀÇ ID °ªÀÌ NULLÀ̸é ÇØ´ç description Çʵ忡µµ NULL °ªÀÌ µé¾î°£´Ù */ 
Declare rCursor CURSOR FOR   
      SELECT   tb1_1.description AS description1, tb1_2.description AS description2,  
                tb1_3.description AS description3, tb1_4.description AS description4,  
                tb1_5.description AS description5, tb1_6.description AS description6,  
                tb1_7.description AS Expr6description7, tb1_8.description AS description8,  
                tb1_9.description AS description9, tb1_10.description AS description10 
        FROM      dbo.tb2 
          LEFT OUTER JOIN dbo.tb1 tb1_1 ON dbo.tb2.ID1 = tb1_1.ID 
          LEFT OUTER JOIN dbo.tb1 tb1_2 ON dbo.tb2.ID2 = tb1_2.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_3 ON dbo.tb2.ID3 = tb1_3.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_4 ON dbo.tb2.ID4 = tb1_4.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_5 ON dbo.tb2.ID5 = tb1_5.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_6 ON dbo.tb2.ID6 = tb1_6.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_7 ON dbo.tb2.ID7 = tb1_7.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_8 ON dbo.tb2.ID8 = tb1_8.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_9 ON dbo.tb2.ID9 = tb1_9.ID 
                LEFT OUTER JOIN dbo.tb1 tb1_10 ON dbo.tb2.ID10 = tb1_10.ID 
OPEN rCursor  
FETCH NEXT From rCursor  
        INTO @d1, @d2,  @d3,  @d4,  @d5,  @d6,  @d7,  @d8,  @d9,  @d10   
 
/* ·çÇÁ¸¦ µ¹¸é¼­  NULL ÀÌ ¾Æ´Ñ °ªÀ» Àӽà Å×ÀÌºí¿¡ Áý¾î³Ö´Â´Ù */  
WHILE (@@FETCH_STATUS <> -1)   
BEGIN   
        IF(@d1 IS not null)  
        INSERT   #temp 
                Select @d1 
        IF(@d2 IS not null)  
        INSERT   #temp 
                Select @d2 
        IF(@d3 IS not null)  
        INSERT   #temp 
                Select @d3 
        IF(@d4 IS not null)  
        INSERT   #temp 
                Select @d4 
        IF(@d5 IS not null)  
        INSERT   #temp 
                Select @d5 
        IF(@d6 IS not null)  
        INSERT   #temp 
                Select @d6 
        IF(@d7 IS not null)  
        INSERT   #temp 
                Select @d7 
        IF(@d8 IS not null)  
        INSERT   #temp 
                Select @d8 
        IF(@d9 IS not null)  
        INSERT   #temp 
                Select @d9 
        IF(@d10 IS not null)  
        INSERT   #temp 
                Select @d10 
        FETCH NEXT From rCursor  
                INTO @d1, @d2,  @d3,  @d4,  @d5,  @d6,  @d7,  @d8,  @d9,  @d10   
END   
CLOSE rCursor   
DEALLOCATE rCursor  
 
/* °á°ú°ª °¡Á®¿À±â */ 
SELECT   * 
FROM      #temp; 
 
/* Àӽà Å×ÀÌºí »èÁ¦ */ 
DROP TABLE #temp; 

¿ÀÈÄ 5:25 2004-04-08
»ðÁúÀº °è¼ÓµÇ°í...
aspÀÇ ÆĶó¸ÞÅÍ °´Ã¼¿Í´Â ¶Ç ´Þ¶óÁø ado.net.
´öºÐ¿¡ ¶Ç »ðÁú... -_-;

ÀÌÁ¨ ÇູÇÏ°Ô ÀúÀå ÇÁ·Î½ÃÀú¸¦ Á» ½áº¸ÀÚ... ;¤²;

SqlCommand comm = new SqlCommand(); 
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["DSNConnectionString"]); 
comm.Connection = conn; 
comm.CommandType = CommandType.StoredProcedure; 
comm.CommandText = "sp_uGetKeyCode"; 
SqlParameter param = new SqlParameter("RETURN_VALUE",SqlDbType.Int); 
param.Direction = ParameterDirection.ReturnValue; 
comm.Parameters.Add(param); 
conn.Open(); 
comm.ExecuteNonQuery(); 
int nRet = (int)comm.Parameters["RETURN_VALUE"].Value; 
conn.Close(); 
¿ÀÈÄ 4:44 2004-03-29
T-SQL¿¡ ´«À» ¶á Kenial.
Declare @count int 
Declare rCursor CURSOR FOR 
        SELECT * From Cont_TB Order by Colorcode 
Set @count = 0 
OPEN rCursor 
FETCH NEXT FROM rCursor 
WHILE (@@FETCH_STATUS <> -1) 
        BEGIN 
                Set @count = @count + 1 
                UPDATE Cont_TB SET Key_Code = @count WHERE CURRENT OF rCursor 
                FETCH NEXT FROM rCursor 
        END 
CLOSE rCursor 
DEALLOCATE rCursor 
GO 

CREATE PROCEDURE [dbo].[sp_uGetKeyCode] AS 
Declare @count int, @rKeyCode int, @row_status int 
 
Set @count = 0  
Declare rCursor CURSOR FOR  
        SELECT Key_Code From Cont_TB Order by Key_Code 
OPEN rCursor 
FETCH NEXT From rCursor 
        INTO @rKeyCode 
 
WHILE (@@FETCH_STATUS <> -1)  
BEGIN  
        Set @count = @count + 1 
        Set @row_status = @@FETCH_STATUS 
        IF(@count <> @rKeyCode) 
        BEGIN 
                Set @count = @count - 1 
                Break 
        END 
        FETCH NEXT From rCursor 
                INTO @rKeyCode 
END  
CLOSE rCursor  
DEALLOCATE rCursor 
RETURN(@count+1) 
GO 

http://support.microsoft.com/default.aspx?scid=kb;en-us;257405&Product=win2000 ·¥µð½ºÅ© °ü·Ã

¿ÀÈÄ 3:36 2004-03-26
¾û¾û ´ëü ¹¹°¡ ¾î¶»°Ô µÈ°Å¾ß ÀÌ°Ç.
ÀÏ´Ü µ¿ÀüÀνıâ´Â Á¦¾î°¡ µÇ´Âµ¥.. VB·Î ¾Ë¾Æº¼ ¼ö ¾ø°Ô § Äڵ嵢¾î¸®.
mscomm °´Ã¼ µûÀ§¸¦ ½á¼­ ÀÌ·¸°Ô ¸¸µé¾î³õ´Ù´Ï..

ÀÏ´Ü ±â°è Á¦Àۻ翡¼­ ¸¸µç Äڵ带 ¾²´Â°Å´Ï±î ÀÌ»óÀº ¾ø°ÚÁö¸¸.
rs-232 Åë½Å.. ¾îÈæÀÌ´Ù ÁøÂ¥ ;

ºñº£¿¡¼­ ocx ¸¸µé·Á¸é ÀÌ·¸°Ô ÇÏ´Â ¼ö¹Û¿¡ ¾ø´Â°Ç°¡...?
ÁøÂ¥ º¹ÀâÇÏ°í ³­ÀâÇϱⰡ ±Í¼º±æÀÇ ¼­¿ï¿ª¿¡ ±×Áö¾ø±¸³ª ;

¿ÀÈÄ 6:33 2004-03-24
À¥¼­ºñ½º ½ÃÀÛ!

uddi, wsdl, soap, http.

¿ÀÀü 9:46 2004-01-26
http://www.madchick.com/Default.asp?Page=2&SubPage=2 activex °ü·Ã
http://www.component.pe.kr/Lecture/ActiveX/ActiveX.html .net¿¡¼­ activex ¹èÆ÷ÁúÇϱâ

¿ÀÈÄ 1:55 2004-01-19
jscript·Î ÇÁ·Î±×·¥ ·±ÄªÇϱâ (·ÎÄÿ¡¼­¸¸ ÀÛµ¿)
<script> 
function fnShellExecuteJ() 
{ 
        var objShell = new ActiveXObject("Shell.Application"); 
        objShell.ShellExecute("notepad.exe", "", "", "open", 1); // normal window 
} 
</script> 

ÃÊ°£´Ü ado.net ¿¹Á¦ (in C#)

// ³×ÀÓ½ºÆäÀ̽º Ãß°¡ 
 
Using System.Data; 
Using System.Data.SqlClient; 
 
... 
  
SqlConnection sCon = new SqlConnection("DB¿¬°á¹®ÀÚ¿­"); 
SqlCommand sCom = new SqlCommand(); 
sCom.Connection = sCon; 
sCom.CommandType = CommandType.StoredProcedure;  // ÀúÀå ÇÁ·Î½ÃÀú¸¦ »ç¿ë ¾ÈÇϸé À̺κÐÀº »ý·« 
 
try 
{ 
    if(sCon.State == ConnectionState.Open) // ÀÌ¹Ì ¿­¸° SqlConnection °³Ã¼¸¦ ¶Ç ¿­¶§ ¹ß»ýÇÏ´Â ¿¡·¯ ¹æÁö 
        sCon.Close(); 
    sCom.Transaction = sCon.BeginTransaction(IsolationLevel.ReadCommitted,"Æ®·£Àè¼Ç¸í"); // Æ®·£Àè¼Ç ½ÃÀÛ 
 
    ... 
    sCom.CommandText = "ÇØ´ç ÇÁ·Î½ÃÀú¸í"; // ÀúÀå ÇÁ·Î½ÃÀú¸¦ »ç¿ë ¾ÈÇÒ °æ¿ì ÀζóÀÎ Äõ¸®¹® 
    sCom.ExcuteNonQuery(); // ±âŸ ½ÇÇà¹æ½Äµµ °¡´É 
    sCom.CommandText = "ÇØ´ç ÇÁ·Î½ÃÀú¸í"; 
    sCom.ExcuteNonQuery(); 
    ...// ÀÌ·± ½ÄÀ¸·Î Äõ¸®¹® ½ÇÇà °è¼Ó.. ·çÇÁµµ ÀÌ ºÎºÐ¿¡¼­ µ¹¸³´Ï´Ù.  
 
       // SqlParameter°¡ ÇÊ¿äÇϸé ÇØ´çÄõ¸® ½ÇÇà Àü¿¡ Add ¶Ç´Â Clear  ¶Ç´Â RemoveAt ¸Þ¼Òµå »ç¿ëÇØ ÁÖ±¸¿ä.. 
 
    // ¿©±â±îÁö ¿¡·¯°¡ ¾øÀ¸¸é Commit ÇØÁÜ 
    sCom.Transaction.Commit(); 
} 
catch(SqlException ex) 
{ 
    // ¿¡·¯°¡ ¹ß»ýÇϸé Rollback ÇØÁÜ 
    sCom.Transaction.Rollback(); 
} 
finally 
{ 
    sCon.Close(); 
} 

ÇÁ·Î±×·¡¹ÖºÐ·ù


PythonPowered EditText of this page (last modified 2004-11-03 19:34:31)
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile