-- DEMO WHILE Loop and CAST
DECLARE @ip1 varchar(15), @ip1start int
SET @ip1 = '10.3.21.'
SET @ip1start = 131
WHILE (@ip1start<255)
BEGIN
--PRINT 'test'
PRINT @ip1 + CAST(@ip1start as varchar(3))
SET @ip1start = @ip1start + 1
END
GO
Brad Chen's Developer Blog Azure Database Data science Machine Learning Cloud
訂閱:
張貼留言 (Atom)
資料治理實施
資料治理實施
-
SQL Server Enterprise 與 Standard 基本差異比較如下 : SQL Server Enterprise Edition SQL Server Standard Edition ...
-
Oracle version support matrix Oracle Release 19 Oracle Database Client Software Requirements https://docs.oracle.com/en/database/oracle/orac...
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
沒有留言:
張貼留言