This is another thread discussing the same topic:

http://www.sqlservercentral.com/Forums/Topic771488-361-1.aspx

I hope you find it useful.

Regards

Gianluca

It is possibile. It isn't simpler with SQL2005, mainly because it couldn't be any simpler.

Here's an example with SQL2005:

USE testDB

CREATE TABLE testtable (

test INT

)

INSERT INTO testtable VALUES(1)

INSERT INTO testtable VALUES(2)

INSERT...

First Google entry for "exponential notation":

http://en.wikipedia.org/wiki/Scientific_notation

Regards

Gianluca

It would be easier to start tracing the data inserted from now on.

The only thing that comes to my mind is the default trace, that is reset every time the...

C++ CGI on Firebird SQL? 😀

This thread is 5 months old, I hope the OP solved the issue long time ago.

OPENQUERY must determine the result set to return. With a IF / ELSE statement the result set columns cannot be predetermined.

Regards

Gianluca

Are you using a command object or opening the recordset with connection.execute?

If you are using a command object, check the connection timeout property there.

It's ConnectionTimeout, in the connection object.

See this page for reference:

http://www.devguru.com/technologies/ado/8534.asp

One single Italian was able to do the same thing all alone....

...every 3 or 4 words!:-D

...to make a new post...

...you just have...

This is easy...

There's a great article by Lynn Pettis that covers the topic very well.

I suggest that you take a look:

http://www.sqlservercentral.com/articles/T-SQL/67898/