ane1279263的专栏

USE Accounting; DECLARE @Ident int; INSERT INTO Orders (CustomerNo,OrderDate,EmployeeID) VALUES (1,GETDATE(),1); SELECT @Ident = @@IDENTITY;//系统函数 INSERT INTO OrderDetails (OrderID,PartNo,Descripti

--创建数据库 --CREATE DATABASE test --GO --使用数据库 USE test --删除表 DROP TABLE yt1 --创建表 CREATE TABLE yt1 ( _ID int IDENTITY, --自动增加 _Name varchar(20) NOT NULL, _Yid varchar(30) UNIQUE, _Yid2 varchar(30)

--存储过程，在表sys.objects中 IF(EXISTS (SELECT * FROM sys.objects WHERE name = 'selPro')) DROP PROC selPro GO CREATE PROC selPro( @name varchar(20) ) AS --declare @tablename sysname = @name SELECT * FROM

------------------------------------------- --------------创建数据库------------------- USE master GO IF EXISTS(SELECT * FROM sys.databases WHERE name = 'testDB') DROP DATABASE testDB GO CREATE DATABASE

USE yk_test GO DROP TABLE yt1 CREATE TABLE yt1 ( yID int primary key IDENTITY, yname varchar(20), yaddress varchar(30), ymoney money ) DROP TABLE nameTable CREATE TABLE nameTable ( nId int primar