Viewing 15 posts - 346 through 360 (of 595 total)
You can check out the return values of the extended procedures in the master database, or, if you're up to it, write your own extended procedure. There's information in...
June 11, 2003 at 8:33 am
ok, horse is now officially pulp. brian has already stricken the question.
June 11, 2003 at 8:26 am
Is there an error code produced. "It doesn't work" doesn't help me much. If I read your code correctly, you are trying to insert a temp table's records...
June 10, 2003 at 12:41 pm
From Books Online:
quote:
The setting of SET SHOWPLAN_TEXT is set at execute or run time and not at parse time.When SET SHOWPLAN_TEXT is...
June 10, 2003 at 12:15 pm
Try specifying the returned fields in the SELECT * FROM #NEWTEMP. I believe the UNION requires a matching number of fields in each of the joined resultsets.
June 10, 2003 at 12:09 pm
I believe the question was what was causing the deadlock, which was indeed the HOLDLOCK hint. Your comments are indeed accurate, but did not address the question, which specifically...
June 10, 2003 at 6:59 am
quote:
...you'll see it's length is 9 bytes rather than 8....
As I mentioned in my first...
June 10, 2003 at 6:54 am
I agree; bit of a pet peeve with me as well...What about using the BIGINT datatype, it's signed, but should give you the range you need. It's only supported...
June 10, 2003 at 5:52 am
quote:
...Is it possible to get the results I am looking for with a sql statement or must I use a procedure....
June 10, 2003 at 5:34 am
CREATE PROCEDURE dbo.HasPaid
(
@GuyID INT NOT NULL
, @DollID INT NOT NULL
, @GuyPaid BIT NOT NULL OUTPUT
, @DollPaid BIT NOT NULL OUTPUT
)
AS
-- First, guy
SELECT @GuyPaid =...
June 9, 2003 at 1:48 pm
The only difference I can think of between the two data types is that the MONEY datatype will ALWAYS have a precise scale of 4 (meaning, always has 4 digits...
June 9, 2003 at 12:58 pm
quote:
That's correct. I want ALL active courses AND ALL active courses that starts with the number 10. ...
June 9, 2003 at 12:35 pm
I'm sorry, but Wanda wants to limit the query based on BOTH criteria, not just one or the other. AND is the correct expression. The problem is in...
June 9, 2003 at 11:11 am
I'm not quite sure what you are doing with these statemeents, but it almost seems as if you are trying to use the ampersand symbol in place of the AND...
June 9, 2003 at 5:53 am
Viewing 15 posts - 346 through 360 (of 595 total)