Activity overview
Latest activity by heck4
A few other things that may help:
SQL Compare 10 does not exhibit this bug, and treats the two different syntaxes as interchangeable.
I've read that CAST is implemented internally within SQL as an alias to CONVERT.
Using SSMS 17.7, when I use the above script to create the table, and then re-script it out using SSMS it uses CONVERT, getting rid of my original CAST syntax.
Thanks. Feel free to close this ticket.
/ comments
A few other things that may help:
SQL Compare 10 does not exhibit this bug, and treats the two different syntaxes as interchangeable.
I've read that CAST is implemented internally within SQL as an...
Yes you are correct Mark. Scripts folder to database. We treat our source control as the system of record. / comments
Yes you are correct Mark. Scripts folder to database. We treat our source control as the system of record.
Done. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/17334229-similar-to-other-ideas-any-project-option-to-igno Close the ticket please.
/ comments
Done.https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/17334229-similar-to-other-ideas-any-project-option-to-ignoClose the ticket please.
Scripts with CAST are treated like they should be CONVERT
As an example, I have this script:CREATE TABLE [dbo].[tblCastConvertTest]After I execute it on the database and run a comparison, its showing a false positive difference:Any ideas on why this is ha...