Any way to cause SQL Server to parse query in multiple lines so error reporting is more accurate? -
i might overlooking more robust error reporting, error reporting sql server gives me line number (which 1 line) non-syntactical errors. today client had ',' in price value, dealing 72 or fields took me quite awhile find given cannot cast float message. i thinking maybe force sql run code in multiple lines line number more useful bit of info. i tried line break, putting in new lines, , adding new line characters non of worked. does know way this, or have method tracking down these errors? i think try try_convert in fields not set varchar; mean can apply function dates, numbers, , other not character data. you can take @ example: http://msdn.microsoft.com/en-us/library/hh230993.aspx hope helps!