TRUNCATE TABLE statement in SQL Server
IT Tricks

TRUNCATE TABLE statement in SQL Server

The TRUNCATE TABLE command is used to delete all records from a table in SQL Server. This command works similar to the DELETE statement but without the WHERE clause. Syntax of the TRUNCATE TABLE statement in SQL Server TRUNCATE TABLE [ten_CSDL.] [ten_schema.] ten_bang[ WITH (PARTITIONS (so_phanvung | so _phanvung TO so _phanvung ) ] ; […]

The CREATE TABLE statement in SQL Server
IT Tricks

The CREATE TABLE statement in SQL Server

In SQL Server (Transact-SQL), the CREATE TABLE statement is used to create and define tables. Syntax of CREATE TABLE statement in SQL Server CREATE TABLE ten_bang(cot1 kieu_du_lieu [ NULL | NOT NULL ],cot2 kieu_du_lieu [ NULL | NOT NULL ],…); Variable name or variable value ten_bang The name of the table you want to create. […]

ALTER TABLE statement in SQL Server
IT Tricks

ALTER TABLE statement in SQL Server

In SQL Server, the ALTER TABLE statement is used to add columns, edit columns, delete columns, rename columns, or rename tables. Add columns to tables in SQL Server Syntax ALTER TABLE ten_bang ADD ten_cot dinh_nghia_cot; For example ALTER TABLE nhanvien ADD ho VARCHAR(50); The above ALTER TABLE statement will add the cough column to the […]

DROP TABLE statement in SQL Server
IT Tricks

DROP TABLE statement in SQL Server

In SQL Server, the DROP TABLE statement is used to delete a table from the database. DROP TABLE command syntax DROP TABLE ten_bang; Variable name or variable value ten_bang The name of the table to delete the SQL Server database key. For example DROP TABLE nhan_vien; The command in the example above will delete the […]

GLOBAL TEMPORARY TABLE in SQL Server
IT Tricks

GLOBAL TEMPORARY TABLE in SQL Server

The Global Temporary Table global SQL tables (Transact-SQL) are tables created separately in SQL Server sessions, Syntax CREATE TABLE ##ten_bang( cot1 kieudulieu [ NULL | NOT NULL ], cot2 kieudulieu [ NULL | NOT NULL ], …); Variable name or variable value ten_bang The name of the global clipboard you want to create. The name […]

LOCAL TEMPORARY TABLE in SQL Server
IT Tricks

LOCAL TEMPORARY TABLE in SQL Server

The article shows how to use LOCAL TEMPORARY TABLE in SQL Server with syntax and examples. Local clipboard LOCAL TEMPORARY TABLE is stored in tempdb and SQL Server will automatically delete the table when it is no longer in use. Syntax CREATE TABLE #ten_bang( cot1 kieudulieu [ NULL | NOT NULL ], cot2 kieudulieu [ […]

Cars & Motobikes Random

The appearance of TOYOTA GR Supra has been changed again and again! “Battle index” big burst table!

1,696 In addition to the powerful TOYOTA title of “Bull Demon King”, it also has BMW power technology that has not been in history. Even if GR Supra still exudes a strong new car smell, it has a high business opportunity to conquer many Japanese modified brands. Let many European strengthened brands convinced! Although GR […]

World News

20:09 “Wuhan Pneumonia”, the new wholesale market, controls nearly 90% of the dishes on the Beijing table

The pneumonia epidemic in Wuhan was reported from the Beijing Xinfadi agricultural products wholesale market. The entrance gate was locked and the police stood guard. (Reuters) 2020-06-15 20:09:54 [Central News Agency]Beijing’s new wholesale market for the outbreak of pneumonia in Wuhan recently is a super-large market for farm animals, livestock and fisheries that has developed […]

Use Index in Access 2016
IT Tricks

Create a Table in Access 2016

When creating a database, you will store your data in Table objects. The objects in the database depend heavily on the table, you should always start to design the database by creating all the tables, then new objects. Before creating the table, carefully review your requirements and identify all the tables you need. Create the […]