jika terjadi masalah ketika mengaktifkan Apache seperti kasus ini ( Port 80 in use by "Unable to open process" with PID 4! )
ubah port 80 menjadi 8080 di directory C:\xampp\apache\conf
Kamis, 21 Februari 2019
Senin, 04 Februari 2019
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]
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]
Langganan:
Postingan (Atom)