-
Where can get some tutorial of SQL SERVER 7, with STORE PROCEDURES, TRIGGERS AND examples of VB 5 using store procedures.
If somebody can send me some example, using the database NORTHWIND I thank
------------------
The blessing of God enriches and it doesn't increase pains
-
-
Trigger examples:
http://www.vb-world.net/ubb/Forum3/HTML/002723.html
Stored procedure example from SQL 7 Northwind DB:
Code:
create procedure "Sales by Year"
@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal, DATENAME(yy,ShippedDate) AS Year
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date