아미(아름다운미소)

[MS-SQL] 트리거 확인

SELECT * FROM sysobjects WHERE type = 'TR' sp_helptext 트리거명
데이타베이스/MSSQL 2021. 8. 11. 11:36
테이블에 걸려있는 트리거 확인

SELECT 'sp_helptext ' + T.name FROM sys.sysobjects AS T INNER JOIN sys.sysobjects AS O ON T.parent_obj = O.id WHERE T.xtype ='TR' AND O.name like '테이블명'
데이타베이스/MSSQL 2021. 8. 6. 18:01
MSSQL 테이블 목록 조회

MSSQL 테이블 목록 조회 오라클 테이블 조회는 SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE '%테이블명%' MSSQL 테이블 조회는 SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%테이블명%'
데이타베이스/MSSQL 2021. 8. 4. 12:23
asp) MSXML2.DOMDocument 버전확인

Function ProgIDInstalled(progID) On Error Resume Next Dim o : Set o = CreateObject(progID) ProgIDInstalled = Err.Number = 0 End Function If ProgIDInstalled("MSXML2.DOMDocument.3.0") Then ' MSXML3 is present ' End If If ProgIDInstalled("MSXML2.DOMDocument.4.0") Then ' MSXML4 is present ' End If If ProgIDInstalled("MSXML2.DOMDocument.5.0") Then ' MSXML5 is present ' End If If ProgIDInstalled("MSXM..
랭귀지/ASP 2021. 8. 3. 09:56
Javascript : JQuery radio checked value 값 알아내기

[Javascript] document.querySelector('input[name="radioName"]:checked').value; [JQuery] $("input[name='radioName']:checked").val();
랭귀지/JAVASCRIPT 2021. 8. 2. 17:12
MSSQL TOP 에 변수 사용하기

괄호만 추가 하면 됩니다. Select TOP (@nTemp) From @table;
데이타베이스/MSSQL 2021. 7. 22. 14:34
MSSQL SPLIT

DECLARE @valueList varchar(8000) DECLARE @pos INT DECLARE @len INT DECLARE @value varchar(8000) SET @valueList = '20030,20031,20033,20034,20065,20045,20044,' SET @pos = 0 SET @len = 0 WHILE CHARINDEX(',', @valueList, @pos+1)>0 BEGIN SET @len = CHARINDEX(',', @valueList, @pos+1) - @pos SET @value = SUBSTRING(@valueList, @pos, @len) SELECT @value SET @pos = CHARINDEX(',', @valueList, @pos+@len) +1..
데이타베이스/MSSQL 2021. 7. 19. 17:54
NullSafety 미지원 패키지 확인방법

>flutter pub outdated --mode=null-safety
랭귀지/Flutter(플러터) 2021. 7. 17. 23:49
[MSSQL] 시간, 날짜 분리 (요일)

SELECT DATEPART(YEAR, GETDATE()) AS 년, DATEPART(MONTH, GETDATE()) AS 월, DATEPART(DAY, GETDATE()) AS 일, DATEPART(HOUR, GETDATE()) AS 시간, DATEPART(MINUTE, GETDATE()) AS 분, DATEPART(SECOND, GETDATE()) AS 초, DATEPART(DW, GETDATE()) AS [요일(숫자)]
데이타베이스/MSSQL 2021. 7. 12. 16:32
[ASP] 저장프로시저 사용시 parameters

MSSQL데이터형식 PARAMTER데이터형식 bigint adBigint binary adBinary bit adBoolean char adChar datetime adDate decimal adDecimal float adSingle int adInteger money adCurrency nchar adChar ntext adLongVarChar numeric adNumeric nvarchar adVarChar real adSingle smalldatetime adDate smallint adSmallInt smallmoney adCurrency sql_variant adVariant text adLongVarChar timestamp adDBTimeStamp tinyint adTinyInt varbi..
랭귀지/ASP 2021. 7. 7. 17:32
Prev 1 ··· 15 16 17 18 19 20 21 ··· 99 Next