I have some sql script(complex), which will take too much time because of the data. It has to run on a daily basis. I have scheduled this for every morning,at the same time some other sql scripts are also execute in the same server. So my sql script timed out mostly. It will run some days...
I have a question on the scope of @@ROWCOUNT. I have a Select statement used in my Stored Procedure, which is given below. I would like to know whether it will return the desired results all the time or any possibility of showing wrong result on multi user environment.
About my requirement...
Hi all,
I would like to know, how to connect to DB2 from SQL 2000 through the linked server Concept. which data source should i use (ODBC/OLEDB)? which one will be better?
Plz help me with an example.
Thanx
I am new to VB and facing a problem in Data Report. I have a table for sales header and a detailed table for for storing corresponding item details. There are seperate header and detailed tables for each financial year data.
I have created a data environment, connection, a parent command...
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.