Guest
Private paste!

Untitled

By: a guest | Apr 21st, 2010 | Syntax: T-SQL | Size: 0.42 KB | Hits: 145 | Expires: Never
Copy text to clipboard
  1. SET ANSI_NULLS ON
  2. GO
  3. SET QUOTED_IDENTIFIER ON
  4. GO
  5. -- =============================================
  6. -- Author:              Matthew Raymer, Developer
  7. -- Create date: April 16, 2010
  8. -- Description: Select all records
  9. -- =============================================
  10. CREATE PROCEDURE sps_rssfeeds_getbyid
  11.         @p_rssid INT
  12. AS
  13. BEGIN
  14.  
  15. SET NOCOUNT ON;  
  16.  
  17. SELECT
  18. RSSID,
  19. URL,
  20. Name
  21. FROM
  22. RSSFEEDS
  23. WHERE
  24. RSSID = @p_rssid
  25. END
  26. GO