I am trying to use Bulk Insert to import a text file, but I keep getting an error that the data will be truncated. The file is comma delimited, character data is surrounded by double quotes and numeric data is not. When running the bulk insert, sql server is trying to import the double quotes as...
I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server...
I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server...
I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server...
I want to save a MS Word document to an image column in a table. I know saving the path is the perferred way but this is NOT an option. I've read Books Online and still do not understand how to do this.
Table MyImages
( ImageID int identity
Image image
)
How do I store...
I am using SQL Server 2000 to write a store procedure that inserts a record into a table. There is error handling to return an error to Cold Fusion, but when an error is received, Cold Fusion is popping up with an ODBC error from SQL Server and is never getting to the point where it can check...
I am using SQL Server 2000 to write a store procedure that inserts a record into a table. There is error handling to return an error to Cold Fusion, but when an error is received, Cold Fusion is popping up with an ODBC error from SQL Server and is never getting to the point where it can check...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.