SQL Server Generate Script

Опубликовано: 24 Январь 2019
на канале: HOUR SEREYVONG

For Trigger when generate, trigger script not generate with you must to modify by your self and paste it under script that already generate. But don't forget use SQL statement "Use [DBName] GO ..."

►My Script

CREATE DATABASE [FanDemo]
GO

USE [FanDemo]
GO
/****** Object: Table [dbo].[Score] Script Date: Tue 22 January 2019 9:39:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Score](
[ScoreID] [int] IDENTITY(1,1) NOT NULL,
[StudentID] [int] NULL,
[Subject1] [int] NULL,
[Subject2] [int] NULL,
[Subject3] [int] NULL,
[Subject4] [int] NULL,
[Subject5] [int] NULL,
PRIMARY KEY CLUSTERED
(
[ScoreID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Student] Script Date: Tue 22 January 2019 9:39:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student](
[StudentID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](200) NULL,
[LastName] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED
(
[StudentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Score] WITH CHECK ADD FOREIGN KEY([StudentID])
REFERENCES [dbo].[Student] ([StudentID])
GO
USE [master]
GO
ALTER DATABASE [FanDemo] SET READ_WRITE
GO

►

Thank for your watching and very thankful for subscribe my channel.

►Visit My Channel / @hoursereyvong2864

🎬🎼Song 💔💔

Subscribe to our Youtube Channel to stay up to date on all new entertainment from HOUR SEREYVONG and follow us on:

Follow on facebook:
Me:https://www.facebook.com/profile.php?...

✔Ok Subscribe
►Subscribe / @hoursereyvong2864

SQL Server Generate Script
SEREYVONG DEMO

На этой странице сайта вы можете посмотреть видео онлайн SQL Server Generate Script длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь HOUR SEREYVONG 24 Январь 2019, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 48 раз и оно понравилось 5 зрителям. Приятного просмотра!

113