SQl常用语句总结（持续更新……）
时间：2021-07-01 10:21:17
帮助过：21人阅读
master;
GO
IF DB_ID (N
‘mytest‘)
IS NOT NULL
DROP DATABASE mytest;
GO
CREATE DATABASE mytest;
GO
USE mytest;
GO
IF OBJECT_ID(N
‘dbo.Orders‘)
IS NOT NULL
DROP TABLE dbo.Orders;
GO
CREATE TABLE dbo.Orders
(
ProductID INT NOT NULL,
MadeFrom CHAR(
20),
Sales MONEY NOT NULL
);
SQl常用语句总结（持续更新……）
标签：table creat obj data class 总结 tab bsp test
