디버깅하는 남자

1. 우선 데이터가 있어야 하니 테이블 하나 생성하고 데이터를 내맘대로 채우겠습니다. ex) Table 및 Data 테이블 생성은 따로 적지 않았습니다. (4개 컬럼으로 이루어져 있고 전부 nvarchar(50) 입니다. ) select * from Table_Test01 insert INTO Table_Test01 (SQE, NAME, ITEM, ETC) values('1','AAA','1AAA','KOREA') insert INTO Table_Test01 (SQE, NAME, ITEM, ETC) values('2','BBB','1BBB','KOREA') insert INTO Table_Test01 (SQE, NAME, ITEM, ETC) values('3','CCC','1CCC','JAPAN') in..

Dim xls As New Excel.Application Dim xWorkbook As Excel.Workbook Dim xWorksheet As Excel.Worksheet Dim xRange As Excel.Range Dim xlotno As String Dim lColumn As Long = 0 xWorkbook = xls.Workbooks.Open("E:\1234512345.xls") 'File Location xWorksheet = xWorkbook.Sheets(1) With xWorksheet If xls.WorksheetFunction.CountA(.Columns) 0 Then lColumn = .Columns.Find(What:="*", _ After:=.Range("A1"), _ Loo..

SQLSTATE=22005 [Microsoft][ODBC SQL Server Dirver]캐스트 사양에 대한 문자값이 올바르지 않습니다. DBParm 부분에 StripParmNames='Yes' and CallEscape='No' 추가하니 해결이 되었습니다. SQLSTATE ERROR 22005 ERROR 해결

--SEARCH TABLE select TEST01, TEST02 from TEST_001 --INSERT VALUES insert into TEST_001 values ('A','A') insert into TEST_001 values ('B','B') insert into TEST_001 values ('C','C') insert into TEST_001 values ('D','D') insert into TEST_001 values ('E','E') insert into TEST_001 values ('C','F') insert into TEST_001 values ('C','G') --QUERY declare @TEST_VAL varchar(50) declare @VAL varchar(50) de..

declare @test_data varchar(50) set @test_data = 'ABCDE12345' SELECT left(@test_data, 2) --value : AB SELECT SUBSTRING(@test_data, 1, 2) --value : AB SELECT right(@test_data,2) --value : 45 SELECT SUBSTRING(@test_data, len(@test_data)-1, len(@test_data)) --value : 45

Dim xls As New Excel.Application Dim xWorkbook As Excel.Workbook Dim xWorksheet As Excel.Worksheet Dim xRange As Excel.Range Dim xlotno As String Dim lRow As Long = 0 xWorkbook = xls.Workbooks.Open("E:\1234512345.xls") 'File Location xWorksheet = xWorkbook.Sheets(1) With xWorksheet If xls.WorksheetFunction.CountA(.Cells) 0 Then lRow = .Cells.Find(What:="*", _ After:=.Range("A1"), _ LookAt:=Excel..