test.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 22 行

-- 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;