Home
Welcome to SQL-Articles
This website is totally dedicated to SQL SERVER, a specific implementation of a relational database server from MICROSOFT.SQL server has been in the industry for the past three decades and has come a long way from SQL 1.0, SQL 7.0 through to SQL SERVER 2012 aka SQL Server Denali. Number of voluntary and involuntary DBAs , developers working on SQL databases keep ticking every day and the main intent of this website is to help and educate each of those out in the field and new database professionals starting their venture with the SQL server.
SQL-ARTICLES host’s number of good articles related to various SQL server features and helpful T-SQL scripts. Apart from this, the readers and users can ask us anything about SQL server in our FORUMS column. We would like to maintain this website as a SQL server knowledge base and a technical information exchange point. Come in, have a look and drench yourself in the rain of SQL SERVER.
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.