MSSQL parameters binding

[expired user #9277]'s profile image [expired user #9277] posted 9 years ago in General Permalink
Parameters for MSSQL server have a different syntax from MySQL:
instead of :param they use @param

This leads to unrecognizable parameters if using MS SQL DB's

One could just find/replace '@' with ':' but it's not always the case

I am trying to get rid of stupid MSSQL Management Studio and this is an issue for me...
Thanks
ansgar's profile image ansgar posted 9 years ago Permalink
Parameter binding is done in HeidiSQL itself, without sending or retrieving something from the server. So, this is independent of the server version or the server system. Just use the ":p" syntax in HeidiSQL and you're done, anyway if you're on MSSQL, MySQL or PostgreSQL.
[expired user #9277]'s profile image [expired user #9277] posted 9 years ago Permalink
I understand and this is a great feature, but I have a large collection of scripts that have the standard notation with '@'

This could be considered an improvement - maybe?

Regards

Please login to leave a reply, or register at first.