C#

create PROCEDURE [dbo].[Ins_Products] 
	-- Add the parameters for the stored procedure here
	@ProductName nvarchar(max),
	@ProductModel nvarchar(max),
	@ProductColor nvarchar(50),
	@ProductDescription nvarchar(max),
	@ProductPrice bigint,
	@ProductQuantity int


AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
declare @ProductID  bigint;
--set @ProductID=-1

	if Not Exists ( Select @ProductID = ProductID From Products 
					Where ProductModel=@ProductModel)
	Begin
		Insert Into Products (ProductName,ProductModel,ProductColor,ProductDescription,ProductPrice,ProductQuantity)
		Values(@ProductName,@ProductModel,@ProductColor,@ProductDescription,@ProductPrice,@ProductQuantity)
	    select @ProductID=@@Identity
	End
	else
	
	Begin
		Update Products 
			Set ProductName=@ProductName ,ProductModel=@ProductModel ,
				ProductColor=@ProductColor,
				ProductDescription=@ProductDescription,
				ProductPrice=@ProductPrice,ProductQuantity=@ProductQuantity
			where (ProductID=@ProductID)
	End
return @ProductID
END

Msg 102, Level 15, State 1, Procedure Ins_Products, Line 26
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Procedure Ins_Products, Line 33
Incorrect syntax near the keyword 'else'.

using System;<br />
using System.Collections;<br />
<br />
<br />
namespace Zombie_Zombie_Zombie<br />
{<br />
    partial class Form1<br />
    {<br />
        protected override void Dispose(bool disposing)<br />
        {<br />
            if (disposing && (components != null))<br />
            {<br />
                components.Dispose();<br />
            }<br />
            base.Dispose(disposing);<br />
        }<br />
<br />
        #region Windows Form Designer generated code<br />
<br />
        private void InitializeComponent()<br />
        {<br />
            this.tabControl1 = new System.Windows.Forms.TabControl();<br />
            ...<br />
        private System.Windows.Forms.RichTextBox outputRichText;<br />
        private System.Windows.Forms.LinkLabel linkLabel14;<br />
<br />
        class character<br />
        {<br />
            protected Hashtable charSheet = new Hashtable();<br />
            protected Hashtable calcSheet = new Hashtable();<br />
            protected Hashtable mutantStats = new Hashtable();<br />
            protected Hashtable mutantPowers = new Hashtable();<br />
            // charSheet is the base character sheet with user modifiable values<br />
            // calcSheet are the values after calculations... Strength plus Melee plus Sword<br />
            // non user modifiable<br />
            // mutantStats are the mutant powers that directly affect the base stats, and are added<br />
            // into calcSheet<br />
            charSheet.Add("Name","")<br />
            ...<br />
            charSheet.Add("Money", "");<br />
        }<br />
<br />
    }<br />
}<br />
<br />

<br />
Error	1	Invalid token '(' in class, struct, or interface member declaration	C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\Zombie Zombie Zombie\Zombie Zombie Zombie\Form1.Designer.cs	499	26	Zombie Zombie Zombie<br />
...<br />
Error	39	Invalid token '(' in class, struct, or interface member declaration	C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\Zombie Zombie Zombie\Zombie Zombie Zombie\Form1.Designer.cs	537	26	Zombie Zombie Zombie<br />