Viewing 15 posts - 1,576 through 1,590 (of 2,894 total)
Can be any sort of problem and it's unlikely to be related to SQL.
Can you execute this stored proc from SSMS?
May 14, 2012 at 9:12 am
Now I'm completely scared!
Just image for a second:
- Order, please!
- Accused, there is a clear evidence that you've been googling for MS Certification Exam questions. It's a criminal offence and...
May 14, 2012 at 9:05 am
BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you lie, cheat...
May 14, 2012 at 8:46 am
drew.allen (5/14/2012)
CELKO (5/12/2012)
We do not use BIT flags in SQL; that was assembly language.
T-SQL doesn't have a Boolean data type, so I see no problem with using a BIT to...
May 14, 2012 at 8:15 am
Actually, I can see now what you want...
But then you will need to provide a bit more of data. There is no way that SQL will guarantee that inserting in...
May 14, 2012 at 6:59 am
that's dense_rank.
select *, dense_rank() over (partition by id order by product) dr
from @tbl
If you need for id of 3 get rank 1 for 'e' and rank 2 for...
May 14, 2012 at 6:56 am
...
Is there a better (or more elegant ) way of executing the output of the output of the Stored Proc?
...
I can't think of more elegant way of executing the output...
May 14, 2012 at 5:41 am
vinu512 (5/14/2012)
Phil Parkin (5/14/2012)
vinu512 (5/14/2012)
tbabs25 (5/14/2012)
I get a number in return instead of...
May 14, 2012 at 5:02 am
Perry Whittle (5/10/2012)
hisakimatama (5/10/2012)
The application is certainly a Windows-based application, then.so it's not exposed to the "outside world" then.
Sure, and there is no way to get onto...
May 10, 2012 at 9:23 am
HowardW (5/10/2012)
Eugene Elutin (5/10/2012)
...
Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't help...
May 10, 2012 at 7:47 am
STOP POSTING USELESS CODE!!!
Here is the must have one!
CREATE PROC dbo.p_ShowMeWhenICanGoHome (@TargetTime TIME(0), @TellMeEvery TIME(0))
AS
BEGIN
DECLARE @TimeNow TIME
DECLARE @h INT, @m INT, @s-2 INT
DECLARE @msg NVARCHAR(1000)
DECLARE @WaitFor VARCHAR(8)
SET @WaitFor =CAST(@TellMeEvery...
May 10, 2012 at 7:36 am
...
Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't help at all...
Actually,...
May 10, 2012 at 6:52 am
HowardW (5/10/2012)
Eugene Elutin (5/10/2012)
I wouldn't use "Instead Of" trigger for that. The standard one for "after insert,update,delete" will do as fine with much less coding...
Depends on the reason for it....
May 10, 2012 at 6:43 am
Viewing 15 posts - 1,576 through 1,590 (of 2,894 total)