SQL SERVER - MENGGANTI SCHEMA DARI TABEL

ALTER SCHEMA schema_baru TRANSFER schema_lama.table1

ALTER SCHEMA schema_baru TRANSFER schema_lama.table2

SQL SERVER - LOOPING

CONTOH WHILE Loop
DECLARE @bil INT
SET @bil = 1
WHILE (@bil <=5)
BEGIN
PRINT @bil
SET @bil = @bil + 1
END
GO

Hasil:
1
2
3
4
5

CONTOH WHILE Loop dengan BREAK
DECLARE @bil INT
SET @bil = 1
WHILE (@bil <=5)
BEGIN
PRINT @bil
SET @bil = @bil + 1
IF @bil = 4
BREAK;
END
GO

hasil:
1
2
3