Linux中国  设为主页
 收藏本站
 
当前位置: > 首页 ->数据库应用 ->SQL Server ->使用T-SQL操作面试SQL Server开发人员
  相关分类： 
Access
DB2
Mysql
Oracle
PostgreSQL
SQL Server
Sybase
其他数据库
  站内搜索： 
热门文章排行
热门文章排行 SQLServer2005的一般部署步骤 (04-23)
SQL server 2005安装问题汇总(06-03)
[SQL Server]2005 Express Edition概(04-23)
用MS SQL Reporting Services生成报(04-17)
50种方法巧妙优化你的SQL Server数据(04-17)
精采文章排行
精采文章排行 教你如何在SQL Server计算机列和平均(06-29)
SQL Server数据库搭建农村信息化的方(06-29)
让VB实现SQL Server 2000存储过程调(06-29)
SQL Server数据库搭建农村信息化的方(06-29)
SQL Server 2005分析服务 统一整合视(06-29)
  ·如何在SQL Server中构建并利用UDF表格 ·使用T-SQL操作面试SQL Server开发人员 ·课程讲解 如何使用SQL Server校勘功能 ·SQL Server从安装到建库为新手寻找捷径 ·如何使用SQL Server数据库嵌套子查询 ·问题解决:SQL Server 2005无法重新安装 ·精细分析 SQL server服务器的内存配置 ·如何获取SQL Server数据库元数据的方法 ·用实例分析如何整理SQL Server输入数据

使用T-SQL操作面试SQL Server开发人员

作者:Webmaster   来源:   点击:   日期:2007-06-29 [收藏] [投稿]

  IE是否经常中毒？推荐您

















预备考试脚本

在开始考试之前，我需要一个模式和一些数据来运行所要考核的查询，列表A创建了所需的这些数据：

列表A： 

IF OBJECT_ID('Sales') > 0
       DROP TABLE Sales
 GO
 IF OBJECT_ID('Customers') > 0
       DROP TABLE Customers
 GO
 IF OBJECT_ID('Products') > 0
       DROP TABLE Products
 GO
 CREATE TABLE Customers
 (
 CustomerID INT IDENTITY PRIMARY KEY,
 FirstName VARCHAR(50),
 LastName VARCHAR(50),
 City VARCHAR(50),
 State CHAR(2),
 Zip VARCHAR(10)
 )
 GO
 CREATE TABLE Products
 (ProductID TINYINT IDENTITY PRIMARY KEY,
ProductName VARCHAR(20),RecommendedPrice 
MONEY,Category VARCHAR(10)
 )GO CREATE TABLE Sales(SaleID INT IDENTITY 
PRIMARY KEY,ProductID TINYINT NOT NULL 
REFERENCES Products(ProductID),CustomerID INT 
NOT NULL REFERENCES Customers(CustomerID),SalePrice 
MONEY NOT NULL,SaleDate SMALLDATETIME NOT NULL)GO
 INSERT INTO Products(ProductName, RecommendedPrice, Category)
VALUES('DVD',105,'LivingRoom')INSERT INTO 
Products(ProductName, RecommendedPrice, Category) 
VALUES('Microwave',98,'Kitchen')INSERT 
INTO Products(ProductName, RecommendedPrice, 
Category)VALUES('Monitor',200,'Office')INSERT 
INTO Products(ProductName, RecommendedPrice, Category)
VALUES('Speakers',85,'Office')INSERT INTO 
Products(ProductName, RecommendedPrice, Category) 
VALUES('Refrigerator',900,'Kitchen')INSERT INTO 
Products(ProductName, RecommendedPrice, Category)
VALUES('VCR',165,'LivingRoom')
 INSERT INTO Products(ProductName, RecommendedPrice, Category)
 VALUES('CoffeePot',35,'Kitchen')GO
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('John','Miller','Asbury','NY','23433') INSERT INTO 
Customers(FirstName, LastName, City, State, Zip) 
VALUES('Fred','Hammill','Basham','AK','85675')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Stan','Mellish','Callahan','WY','38556')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Adrian','Caparzo','Denver','CO','12377')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Mike','Horvath','Easton','IN','47130')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Irwin','Wade','Frankfurt','KY','45902')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('George','Marshall','Gallipoli','ND','34908')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Frank','Costello','Honolulu','HI','23905')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Billy','Costigan','Immice','SC','75389')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Shelly','Sipes','Lights','AZ','35263')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Chirsty','Melton','Spade','CA','97505')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Amanda','Owens','Flask','CN','50386')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Brittany','Smits','Bourbon','KY','24207')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Kristy','Bryant','Tarp','FL','58960')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Kelly','Street','TableTop','ID','57732')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Tricia','Hill','Camera','ME','46738')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Holly','Raines','Compact','MS','35735')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Natalie','Woods','Woods','IN','87219')
 INSERT INTO Customers(FirstName, LastName, City, State, Zip) 
VALUES('Wendy','Hilton','Action','KY','47093')
 GO
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,1,130,'2/6/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,2,97,'1/7/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,3,200,'8/8/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(4,4,80,'4/9/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(5,5,899,'10/10/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(6,6,150,'10/11/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,7,209,'12/12/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(4,8,90,'5/13/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(6,9,130,'6/14/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,14,85,'6/19/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,15,240,'9/20/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,16,99,'7/21/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,17,87,'3/22/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,18,99,'1/23/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(6,19,150,'3/24/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(5,5,900,'3/10/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(4,6,86,'8/11/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,7,88,'8/12/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,8,198,'12/13/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,9,150,'5/14/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(6,14,99,'7/19/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(6,15,104,'9/20/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,16,270,'2/21/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(4,17,90,'7/22/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,1,130,'3/6/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,2,102,'4/7/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(1,3,114,'11/8/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(5,4,1000,'5/9/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(5,5,1100,'10/10/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,6,285,'6/11/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(2,7,87,'10/12/2005')
 INSERT INTO Sales(ProductID, CustomerID, SalePrice, SaleDate) 
VALUES(3,8,300,'7/13/2005')
 GO

一旦我载入了这些数据，我就可以开始测试了（提示：我会让应聘者将他们编写的SELECT/UPDATE/INSERT/DELETE 语句存储在一个文本文件中，这样我以后可以随时阅览）。

1 2 下一页>>



 如果您对本文有任何疑问或者建议，请到讨论区发表您的意见: >> 论坛入口 <<

上一页12 下一页

上一篇：课程讲解 如何使用SQL Server校勘功能   下一篇：如何在SQL Server中构建并利用UDF表格
【文章评论】 【收藏本文】 【推荐好友】 【打印本文】 【我要投稿】 【论坛讨论】

   相关文章:
·精细讲述SQL Server数据库备份多种方法

   文章评论:(1条)
  
 请留名： 匿名评论   点击查看所有评论 论坛讨论
 

 声明：刊登此文章是为了传递更多信息,文章内容仅供参考,转载请注明出处。