SQL Server 2008 on 1and1 server

I entered this in as below. The error code was:

CREATE PROCEDURE CollapseToSUMs AS

DECLARE @col1 BIGINT, @col2 BIGINT, @col3 BIGINT;

SELECT

@col1 = SUM(col1)

,@col2 = SUM(col2)

,@col3 =...

Thank you very much!

I am using Microsoft SQL Server 2008 R2.

How do you get a USER ID and PASSWORD in your connection string.