test.sql

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

-- Execute the scalar user-defined function and stored procedure, 
PRINT dbo.cfs_OrderCountByCustomerID('ALFKI');
EXEC dbo.csp_OrdersByCustomerID 'ALFKI';

-- Create a PointUDT
DECLARE @pt PointUDT
SET @pt = CONVERT(PointUDT, '2.5,3.6');
PRINT @pt.X;
PRINT @pt.Y;
PRINT @pt.ToString();

-- Execute the user-define aggregate
SELECT dbo.CSVStringUDA(CompanyName) AS CSVString FROM Customers;

--Fire the ctr_Products trigger
UPDATE Products SET UnitsInStock = UnitsInStock + 1, UnitsOnOrder = UnitsOnOrder + 1, 
ReorderLevel = ReorderLevel + 1
WHERE ProductID = 1;
UPDATE Products SET UnitsInStock = UnitsInStock - 1, UnitsOnOrder = UnitsOnOrder - 1, 
ReorderLevel = ReorderLevel - 1
WHERE ProductID = 1;