SQL statement complete works

xiaoxiao2021-03-06  107

IF exists (SELECT TABLE_NAME from Information_Schema.Tables

Where Table_name = 'T1')

Drop Table T1

Go

INSERT T1 VALUES (1, 'ROW # 1') // Simple Insert

INSERT T1 (Column_2, Column_1) Values ​​('ROW # 1', 1) // Different data different from column order

INSERT INTO T1 (Column_4) VALUES ('Explicit Value') // Data of less insertion value than column number

转载请注明原文地址:https://www.9cbs.com/read-103286.html

New Post(0)