Viewing 15 posts - 3,436 through 3,450 (of 7,429 total)
In this situation what does @query represent (actual example please) and what are you hoping for @Result to return?
February 4, 2003 at 3:38 am
Can you provide an example of the value of
date_doc
and
date_entered
so we can understand what is going on there?
Also, what do those values represent? (Ex. number of sec. since 1/1/1900 12:00 AM)
...
February 4, 2003 at 3:35 am
You cannot, unfortunately, lock the SP from running in limited fashion. That is the reason for transactions and locking to prevent access until freed.
February 4, 2003 at 3:32 am
Actually I have never heard of a variable referenced like so. A variable is a logically defined struture that lives only in the current context. If you made a column...
February 4, 2003 at 3:30 am
Open the table in EM with return all rows. Find the record you want, place the cursor in the proper column for that row and press CTRL+0 which will update...
February 4, 2003 at 3:27 am
xtype = 'v' returns viws only. You are seeing table names too?
Now it will show INFORMATION_SCHEMA views as well and to prevent those just do
where xtype = 'v' and status...
February 4, 2003 at 3:25 am
The only problem I have with not blaming MS is it is their code. Sure the Admins, DBAs and networking folks could have taken proper steps to prevent/limit the issue....
February 3, 2003 at 8:10 am
Unless I am wrong, I would not personally suggest doing so unless you need the function inline or have special needs for it. However after going thru the documentation in...
February 3, 2003 at 5:37 am
Maybe, maybe not. If you have an unlimited number of where options or extremely high number anyway it may be better to use dynamic SQL. You still have some control...
February 3, 2003 at 3:34 am
Keep in mind that a function is inline processing of every row with it's set of functionality. Depednin on what you are doing and how many rows are processed it...
February 3, 2003 at 3:19 am
Keep in mind that even though the market for Oracle may look good it does have a lot of requirements to work under that are different from SQL so you...
February 3, 2003 at 3:14 am
Usign SELECT...INTO has known issues with locking. You should try to write so temp table is created with CREATE TABLE and use INSERT.
February 1, 2003 at 10:14 am
Speaking of hardware, what is coming in and how are things going to be expanded? I am just curious.
January 31, 2003 at 6:51 pm
Just to clear things up a bit now that my brain is working. The three stages of SQL code during it's life cycle are these
Parse Time -- Syntax validation only.
Compile...
January 31, 2003 at 2:17 pm
Can you post the relavent C++ I just cannot picuture the code as I have not used these options before.
January 31, 2003 at 11:54 am
Viewing 15 posts - 3,436 through 3,450 (of 7,429 total)