-- 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)
-
a bicycle manufacturer - Adventure Works Cycles Scenarios include Manufacturing , Sales , Purchasing , Product Management , Contact Manageme...
-
Guideline for SQL Server configuration, installation and database creation
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
沒有留言:
張貼留言