SQl常用语句总结（持续更新……）
标签：table creat obj data class 总结 tab bsp test
SQl常用语句总结（持续更新……）
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
);