Posted By

qrist0ph on 06/02/10


Tagged


Versions (?)

Stored Procedure mit Table


 / Published in: SQL
 

  1. GO
  2. CREATE PROCEDURE dbo.test
  3. AS
  4. DECLARE @ProductTotals TABLE
  5. (
  6. ProductID int,
  7. Revenue money
  8. )
  9. INSERT INTO @ProductTotals (ProductID, Revenue) VALUES (1,2)
  10. INSERT INTO @ProductTotals (ProductID, Revenue) VALUES (1,3)
  11. SELECT * FROM @ProductTotals
  12. GO
  13. EXEC dbo.test;
  14. GO
  15. DROP PROCEDURE dbo.test;
  16. GO

Report this snippet  

You need to login to post a comment.