T-SQL语句(建库,建表,事务,存储过程,触发器等...)（国外英文资料）.doc

T-SQL语句(建库,建表,事务,存储过程,触发器等...) T-SQL statements (library building, table building, transaction, stored procedures, triggers, etc.) drop, database, bankDB Use master Exec, sp_attach_db, @dbname=bankDB, @filename1=f:\bank\bankDB_data.mdf -- additional database, parameter 1:, physical name (database name), parameter 2:, file path name Exec, sp_detach_db,bankDB, null -- separating database parameters, 1: database names, and parameter 2: type values.?? Go Use master Go If exists (select * from, sysdatabases, where, name =bankDB) - to determine if the system exists, the bankDB database exists and is deleted Drop database bankDB Go Exec, xp_cmdshell,mkdir, F:\bank-- new folder Go Create database bankDB - new database name On primary ( Name = bankDB_data, - logical name Filename =F:\bank\bankDB_data.mdf, - master database name Size = 10MB, - file size Filegrowth = 15% - growth rate ) Log on ( Name = bankDB_log, - logical name Filename =F:\bank\bankDB_log.ldf-- log file Size = 1MB, - file size Maxsize = 20MB -- File maximum capacity Filegrowth = 10% - growth rate ) Go Exec, xp_cmdshell,rmdir, F:\bank-- delete database Use bankDB Go If exists (select *, from, sysobjects, where, name =userInfo) - determines whether the table name exists in the system and exists deletion Drop table userInfo Go Create table userInfo - new table name ( UID, int, not, null, identity (1,1) -- the customer number automatically grows Uname varchar (8) - not null, account name, required PID varchar (18) not - null, ID number, required Telephone varchar (13) - not null, telephone number is required Address varchar (32) - address, optional input ) Alter table userInfo Add, constraint, PK_UID, primary, key (UID) -- primary key constraints Constraint, UQ_PID, unique (PID) -- unique constraints Constraint, CK_PID, check (len (PID), =18, or, len (PID), =15) -- check constraints Constraint CK_telephone check (telephone, like,0[0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9], or, telephone, like,0[0-9][0-9