Probier mal
CREATE PROCEDURE dbo.sp_updCustomerContactPerson @Nummer int, @Liste int, @Ansprechpartner varchar(40) Collate database_default, @Anmerkung text, @Telefon varchar(25)Collate database_default, @EMail varchar(40) Collate database_default, @FAXNummer varchar (25) Collate database_default AS UPDATE HW_Database.dbo.T_ADRANSP SET Ansprechpartner = @Ansprechpartner, Anmerkung = @Anmerkung, Telefon = @Telefon, EMail = @EMail, FAXNummer = @FAXNummer WHERE ((Nummer = @Nummer) AND (Liste = @Liste)) GO Oder �hnlich. Beachte "Collate database_default". Viele Gr�sse Ivo ----- Original Message ----- From: "Alexander Zeitler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 12:00 PM Subject: AW: [Database.asp] Collation? > > > Gegenfrage: > > Wie ist denn Deine Collation Deiner Datenbank? > wo finde ich das? > > > In der Regel d�rfte das bei Dir 'Latin1_General_CI_AS' sein, oder nicht? > > hier die SP: > > CREATE PROCEDURE dbo.sp_updCustomerContactPerson > @Nummer int, > @Liste int, > @Ansprechpartner varchar(40), > @Anmerkung text, > @Telefon varchar(25), > @EMail varchar(40), > @FAXNummer varchar (25) > > AS > > UPDATE > HW_Database.dbo.T_ADRANSP > SET > Ansprechpartner = @Ansprechpartner, > Anmerkung = @Anmerkung, > Telefon = @Telefon, > EMail = @EMail, > FAXNummer = @FAXNummer > WHERE > ((Nummer = @Nummer) AND (Liste = @Liste)) > GO > > Gruss > > Alex > www.aspintranet.de > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ > Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular > ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com > _______________________________________________ > Database.asp mailing list > [EMAIL PROTECTED] > http://www.glengamoi.com/mailman/listinfo/database.asp > ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
