MERGE Statement – SQL Server 2008
In earlier versions of SQL Server in order to perform INSERT, UPDATE or DELETE we have to have separate T-SQL statements. With the introduction of SQL Server 2008 we have MERGE statement which helps in simplifying this. It allows us to perform DML operations based on certain JOIN conditions in single statement.
VidhyaSagar
| #
Do you want a batch file to script out all the tables in the database using bcp?
Ramesh
| #
VidhyaSagar, Could you please provide the batch scripts to extract table data using bcp out into multiple files dynamically from a database
VidhyaSagar
| #
@Andres – Sybase date format is not matched with SQL Server date format. If you are using ODBC driver then update in ODBC entry for AFTER connecting.
set temporary option date_order=’MDY’
If this isnt working then check SQL Server default date format and then change accordingly
Andres Gutierrez
| #
Hello, I am trying to make this procedure but when I test the connection, right after I give the information on the Login window, appears the following error:
[Sybase][ODBC Driver][Adaptive Server Enterprise]SQL Anywhere Error -157: Cannot convert ’08/10/09′ to a timestamp
Do you have any idea or suggestion to fix this problem? I dont know where that date comes from. Regards. Andres.
Engin Ardıç
| #
Thank you for nice article! That’s so helpful for me.