General information
Forum:
Microsoft SQL Server
Dimitry
I personally like to build my own update statements so I can Alltrim() the character fields so varchar() columns really work.
>As far as getting the data from SQL Server, I like using SQL pass through.
>
>But I am not sure what is a better (preferred or recommended) way of sending changes back to the SQL Server. I am aware of two methods:
>
>1. Making cursor updatable and using TABLEUPDATE()
>
>2. Using cursor (without making it updatable) and then building a SQL UPDATE string based on the cursor/table fields and sending it to the SQL Server using SQLEXEC().
>
>Any suggestions?
>
>Thank you
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only