IT(112)
-
PB11.5 , POWERBUILDER 11.5 , SQLSTATE ERROR 22005
SQLSTATE=22005 [Microsoft][ODBC SQL Server Dirver]캐스트 사양에 대한 문자값이 올바르지 않습니다. DBParm 부분에 StripParmNames='Yes' and CallEscape='No' 추가하니 해결이 되었습니다. SQLSTATE ERROR 22005 ERROR 해결
2016.08.24 -
[MS-SQL] ROW 값 나열하기, 세로 값을 가로 값으로 나열하기
--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..
2016.08.24 -
MSSQL, LEFT, RIGHT, SUBSTRING, LEN
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
2016.08.16 -
VB.NET Find Last Row in an Excel Sheet / 엑셀 마지막 행 구하기
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..
2016.07.21 -
VB.NET EXCEL Read, Write / VB.NET 엑셀 읽고, 쓰기
참조 - COM - Microsoft Excel 14.0 object Library 사용하면 됩니다!! 없으면 하위버젼도 상관없어요!! Private Sub excel() 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 xworkbook = xls.Workbooks.Open("E:\12345.xls") xworksheet = xworkbook.Sheets(1) xRange = xworksheet.Range("A1") xlotno = xRange.Value 'Read MsgBox(xlotno) '..
2016.07.20 -
[DELL PC 점검표]DELL PC LED PATTERNS. Diagnostic and Status Lights. Diagnostic Beep Codes.
DELL PC는 친절하게도 상태표시를 LED 패턴으로 알려주죠!! Diagnostic Beep Codes 도 첨부하였습니다. DELL PC 사용자들은 조금이라도 도움이 되었으면 합니다. Diagnostic and Status Lights The Precision T3500/T5500/T7500 Workstations are equipped with diagnostic and status lights. There are numbered lights, 1-4, and the power button also serves as a status indicator. Depending on the status of the system, the power button light may be green or amber ..
2016.07.05