filmov
tv
SQL-Tips : create table with script | #sqlserver_2020

Показать описание
Hi everyone,
In this video , you can create a table in sql server by many ways.
---------------------------------------------------------------
Script:
/*
Many ways create table in SQL server
*/
--1. Create table physic
CREATE TABLE tbl_1
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
-- 2. create temp table
CREATE TABLE #tbl_1
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
-- 3. create variable table
DECLARE @table AS TABLE
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
--4. create table from another table
In this video , you can create a table in sql server by many ways.
---------------------------------------------------------------
Script:
/*
Many ways create table in SQL server
*/
--1. Create table physic
CREATE TABLE tbl_1
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
-- 2. create temp table
CREATE TABLE #tbl_1
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
-- 3. create variable table
DECLARE @table AS TABLE
(
ID BIGINT IDENTITY(1,1),
code VARCHAR(10),
Name NVARCHAR(100)
)
--4. create table from another table