Stuff

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[stpAddLine]	@Username	varchar(50),	@Channel	varchar(50),	@Message	varchar(512)ASBEGIN	SET NOCOUNT ON;	DECLARE	@UserID int	SET	@UserID = (	SELECT	UserID					FROM	ircUsers					WHERE	UserName = @Username )	if @UserID = NULL		begin			INSERT INTO ircUsers			VALUES ( @Username )			SET	@UserID = ( SELECT @@IDENTITY )		end	INSERT INTO UserTalk	VALUES	( @Message, @UserID, @Channel )ENDGO