목록2021/07 (5)

아미(아름다운미소)

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 Next