Anonymous

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[GetBugDetails](@Category VarChar)ASDECLARE @BugDetails TABLE(BugsID BIGINT,Category VarChar,Severity VarChar,Priority VarChar,Owner VarChar,State VarChar,Result VarChar,Summary VarChar,Votes Char)INSERT INTO @BugDetailsSELECT BugsID, Category, Severity, Priority, Owner, State, Result, Summary, VotesFROM bugsWHERE Category = @Category