why different syntaxes in Commnad lines?

[phil]

Hi,

I saw three different syntaxes in command lines:
UpdateCommand="UPDATE [mytable] SET [name] = @name ...
UpdateCommand="Update `mytable` set `name`=? ...
UpdateCommand="UPDATE [mytable] SET [name] = ? ...

Does the three do the same?
Why those differences?
Thanks
Phil

 

[Mary Chipman [MSFT]]

It depends on which data provider and data source you are using. See
http://msdn2.microsoft.com/en-us/library/bbw6zyha.aspx for more
information.

--Mary

 

[phil]

Thanks

It depends on which data provider and data source you are using. See
http://msdn2.microsoft.com/en-us/library/bbw6zyha.aspx for more
information.

--Mary

Hi,

I saw three different syntaxes in command lines:
UpdateCommand="UPDATE [mytable] SET [name] = @name ...
UpdateCommand="Update `mytable` set `name`=? ...
UpdateCommand="UPDATE [mytable] SET [name] = ? ...

Does the three do the same?
Why those differences?
Thanks
Phil