EXEC sp_executesql and Params

madrianr

Hello,

SQLRefactor formats my SP very well until the last EXEC sp_executesql statement - there are 1 long line - sould'nt be every parameter in a new line?

EXEC sp_executesql @sql, @params, @User_ID, @Mitglied_ID, @Kammer_ID, @Marktplatzgemeinschaft_ID, @Firmensitz_ID, @Firmenbezeichnung, @Vorname, @Name, @Titel, @Strasse, @Postleitzahl, @Ort, @Telefon, @Fax, @Mobil, @Email, @Homepage, @Beschreibung, @Branche_AusbildungBerufWissenschaft, @Branche_BauenWohnen, @Branche_ComputerTelekomIT, @Branche_ConsultingPersonal, @Branche_Dienstleistungen, @Branche_FilmVideoFoto, @Branche_FinanzenVersicherungen, @Branche_FreizeitUnterhaltung, @Branche_Gastronomie, @Branche_GesundheitKosmetik, @Branche_GrafikDesign, @Branche_Handel, @Branche_LebensmittelGetränke, @Branche_ReiseErholung, @Branche_TechnikHandwerk, @Branche_WerbungKommunikationDesign, @Branche_Sonstiges, @angelegt, @geändert, @gelöscht, @Benutzer

JonathanWatts

Hi madrianr,

Sorry about this problem you are having. This is a known issue with SQL Refactor, one that we address in a futures version.

Regards,

Jonathan

madrianr

When?

JonathanWatts

We don't have a confirmed date for the next version, there will be a Katmai-compatible release next year. Due to the popularity of this request it is likely that this fix will be in that release.

Regards,

Jonathan