Miscellany

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[stpGetStats]	@Username	varchar(50),	@Channel	varchar(50)ASBEGIN	SET NOCOUNT ON;    SELECT	COUNT(LineText) AS 'lines_said'	FROM	UserTalk INNER JOIN			ircUsers ON UserTalk.UserID = ircUsers.UserID	WHERE	ircUsers.UserName = @username AND			UserTalk.Channel = @ChannelEND