sql server 7

[Marcelo Velasquez]

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

[JHausmann]

see post:
http://www.vb-world.net/ubb/Forum3/HTML/002794.html

[Clunietp]

Trigger examples:
http://www.vb-world.net/ubb/Forum3/HTML/002723.html

Stored procedure example from SQL 7 Northwind DB:

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