SQLserver语句

1. 创建数据库文件：

USE master

GO

CREAT DATABASE E_market

ON PRIMARY

( name="E_market_data",

filename="E:\aaa\E_market_data.mdf",

size=5mb,

maxsize=100mb,

filegrowth=10%

), Filegroup F1

(name="E_market_data_1",

filename="E:\aaa\E_market_data_1.mdf",

size=5mb

)

LOG ON

( name = "   ",

filename="e:\aaa\...ldf",

size=5mb

)

2. 修改文件组：

use marster

Alter database E_market add Filegroup FG

GO

Alter database E_market add file

(name = "   ",

filename="e:\aaa\...ldf",

size=5mb
) to filegroup FG

GO

3.删除数据库：

USE master

IF exists(select * from sysdatabases where name = 'E_market')

DROP database E_market

GO

4. select 3+4 as add result

GO

DECLARE @age int

SET @age=18

SELECT @age

GO

DECLARE @x int, @y int

SET @x=8

SET @y =10

if @x>=@y

     Select '@x>=@y'

else

　　select "@y大"

GO

INSERT INTO CommoditySort VALUES('手机数码')

INSERT UserInfo VALUES('Yoyo','123‘,'晓凤',1,'aa@123.com','北京','1230003')

INSERT INTO CommodityInfo (sortID, commodityName, Info) VALUES (1, XX,XX)

INSERT INTO OrderInfo (UserID, commodiytID, Amoutn, PayMoney, Payway) values(xx,xx,DEFAULT,xx,xx)

INSERT INTO UserAddress(UID,Uname, Uaddress, Uphone)

SELECT UserID, UserName, UserAddress, Phone FROM UserInfo