首页 > 代码库 > SQl常用语句总结(持续更新……)

SQl常用语句总结(持续更新……)

创建示例数据库

USE master;GOIF DB_ID (Nmytest) IS NOT NULLDROP DATABASE mytest;GOCREATE DATABASE mytest;GOUSE mytest;GOIF OBJECT_ID(Ndbo.Orders) IS NOT NULLDROP TABLE dbo.Orders;GOCREATE TABLE dbo.Orders(ProductID INT NOT NULL,MadeFrom CHAR(20),Sales MONEY NOT NULL);

 

SQl常用语句总结(持续更新……)