利用SQL Server 2005数据库邮件发送电子邮件

IF EXISTS(SELECT name from master..sysdatabases where name = 'SalesDB')
      DROP DATABASE SalesDB



CREATE DATABASE SalesDB;



USE SALESDB;

CREATE TABLE SalesHistory

(
      SaleID INT IDENTITY(1,1),
      Product VARCHAR(30), 
      SaleDate SMALLDATETIME, 
      SalePrice MONEY

)



DECLARE @i SMALLINT



SET @i = 1



WHILE (@i <=100)



BEGIN
      INSERT INTO SalesHistory
      (Product, SaleDate, SalePrice)
      VALUES
      ('Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57) )




      INSERT INTO SalesHistory
      (Product, SaleDate, SalePrice)
      VALUES
      ('BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13) )




      INSERT INTO SalesHistory
      (Product, SaleDate, SalePrice)
      VALUES
      ('PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29) )




      SET @i = @i + 1



END