Guest
Private paste!

Untitled

By: a guest | Apr 21st, 2010 | Syntax: VB.NET | Size: 0.51 KB | Hits: 163 | Expires: Never
Copy text to clipboard
  1. USE [Test]
  2. GO
  3. /****** Object:  StoredProcedure [dbo].[sps_rssfeeds_getbyid]    Script Date: 04/21/2010 19:53:19 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. -- =============================================
  9. -- Author:              Matthew Raymer, Developer
  10. -- Create date: April 16, 2010
  11. -- Description: Select all records
  12. -- =============================================
  13. CREATE PROCEDURE [dbo].[sps_rssfeeds_delete]
  14.         @p_rssid int
  15. AS
  16. BEGIN
  17.  
  18. SET NOCOUNT ON;  
  19.  
  20. DELETE
  21. RSSFEEDS
  22. where
  23. RSSID = @p_rssid
  24. END