you didn't mention it, maybe it's there but not in the snippet you posted, but where is the connection for the dataadapter?

I know the ADODBRecordSet As object is the 4th...

can't you connect with your default linked server to oracle, and then simply switch to 4 part naming conventions, same as SQL?

That's absolutely true in my case whenever i connect...

SQL Server is deny by default, so as long as the user is not tied to a sysadmin, you would add the user to the database, and then add that...

SQL Server Compact Edition databases are supposed to a good idea for mobile phones and other portable devices;There's no service like SQLServer...

Syed Jahanzaib Bin hassan (4/23/2011)

---

lets try with recent updates of this release like service packs and CUs

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

here is an example that works to 99999.99; from there it's trivial to expand it to higher numbers:

--1,23,45,67,890

ALTER function lakFormatting(@value money)

returns table

as

return

SELECT

CASE

...

Isn't this handled by the GUI/app you are using to display the data? Typically separators are handled by the regional settings in windows for me; all numbers in SQL server...

the SSMS has an option to script data as wll as the table definitions; i've used it before

but it's weird when i went to Tools>>Options ...SQL Server Object Explorer>>Scripting i...

don't deploy a script ;give the end user a complete backup with all tables and default data already in place; it's faster, easier and not prone to script errors

it's...

I had to lookup Sneakernet on Wiki , already anticipating installing something ultra fast on my network;

That one made my day.

it is much easier to write a file within your application than it is to do it on the SQL Server.

You run into a lot of permissions issues where the...

what is the name of the identity column in the table [stocktb]?

are you trying to force stocktb.[identitycolumn?] to be exactly the same as the productid from the other table, or...

ok, with a lot of rows in the source table,isn't the CURRENT_TIMESTAMP variable still being evaluated on a per-row basis?

can you try this instead?

declare @Last7Days int

SELECT...

really need a bit more of the table definition to give you some solid code examples.

basically, what you want is to use a tally table to help generate all possible...

I'm guessing there's not an index on the[table-name-removed] column yet;

that should speed things up considerably i bet.