hi!

you shouldn't create a connection for each recordset as each connection consumes resources on your db server (don't forget to think of your webapp serving multiple requests of such a...

hi!

voting for bad idea as well! don't know but, some guys around seem to use sql server for anything else but its initial purpose (to be a *database* server).

skip starting...

hi

pinhead is right. without creating an IIS app it won't execute ASP scripts ...

if you're using IIS6 be aware that scripting itself is deactivated per default!

best regards,

chris.

hi!

and don't forget to check the windows *System* event log for reported hardware timeouts, driver errors or similar (eg. on most SCSI adapters you get something like "timeout exceeded accessing...

quote:

---

... but not select top @Reccount ...

---

... unless you use dynamic SQL and sp_executesql (to...

trying to hack an unkown source? 😉

could do it like that: cursor for "select name from sysdatabases"

dynamic cursor for: "select name from <db>.dbo.sysobjects where xtype = 'U'"

dynamic select for your...

check "CREATE PROCEDURE" statement in BOL

SQL*Net or Net8 provides the basic libraries enabling applications (whatsoever) to access oracle databases on da data stream level.

* You won't be able to talk to Oracle without those libraries...

check out "CASE" in BOL

hi!

concerning the example: don't forget to use "tools/references" to add the ADO interfaces to your project (MDAC - available from microsoft as "MDAC_TYP.exe" in thousands of variants and installed by...

hi!

try to avoid empty strings, if you're up to creating "clean" code on whatever client side you're using. stumbling over a NULL from time to time will make your developers...

hi!

in general, you should break up updates *that* big into poritions of a considerable size, say 1 million rows each. do this by setting rowcount before your update statement:

set rowcount...

hi!

sorry, hadn't time to think it all over, but two things struck me:

1. don't use "for to recordcount" to iterate through recordsets! use "while not eof", thats more secure!

2. if...

hi!

other suggestion: why do you want to mess around with generating/modifying your html code in your dbms? its just not built for it, and t-sql is somehow a little "stoneage"...

hi!

you want to know which indexes are used for your queries (regardless if "normal" selects or views): turn on "show execution plan" in query analyzer and examine the result.

best regards,

chris.

...