Execute File *.sql

Fungsi untuk eksekusi beberapa table di dalam database.

sqlcmd -s MSSQLSERVER\DESKTOP-PNHNPC9 -i E:\data\spasi\SIMFOSIA_part3.sql

contoh isi file

USE [nama_db]

GO
/****** Object:  Table [dbo].[nama_table]    Script Date: 04/02/2019 13.39.52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[nama_table](
    [ID] [numeric](38, 0) NULL,
    [TGL_AKTIF] [date] NULL,
    [TGL_END] [date] NULL,
    [JNS_KANTOR] [numeric](38, 0) NULL,
    [KET_KANTOR] [varchar](100) NULL,
    [CMP_ID] [varchar](10) NULL,
    [KETERANGAN] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]