Viewing 15 posts - 511 through 525 (of 2,894 total)
Bhuvnesh (3/21/2013)
Kwisatz78 (3/21/2013)
March 21, 2013 at 5:11 am
shohelr2003 (3/21/2013)
@Eugene Elutin,
Can you please tell me the basic difference between FOR INSERT and INSTEAD OF INSERT Trigger.
I know there are lots of resources on it. But please tell me...
March 21, 2013 at 3:45 am
Wait types?
March 20, 2013 at 12:32 pm
Well, this SP should be pulling the job tables every 5 min or so and seeing if any are running longer than defined SLA for that job, so, if the...
March 20, 2013 at 12:31 pm
SQLCrazyCertified (3/20/2013)
Eugene Elutin (3/20/2013)
Not really good idea to do so, but if you really need it, use xp_cmdshell.
xp_cmdshell 'c:\MyBatch.bat'
Thanks Eugene, what you mean by not really good idea?....what are the...
March 20, 2013 at 11:41 am
Not really good idea to do so, but if you really need it, use xp_cmdshell.
xp_cmdshell 'c:\MyBatch.bat'
March 20, 2013 at 11:20 am
It depends! Which exact waits types you are having problem with?
Are you sure that they are CPU dependent ones?
March 20, 2013 at 11:17 am
tafountain (3/20/2013)
As far as the NEWSEQUENTIALID goes, SSCrazy hit most of the points I didn't elaborate on. ...
Who are you calling SSCrazy, SSC Journeyman? 😉
GUID's are evil! B-r-r-r-r-r! :hehe:
March 20, 2013 at 10:33 am
SQL_NuB (3/20/2013)
if Active is true in DB2 and now coming in as FALSE in DB1, I need that.
as for NULL values, I...
March 20, 2013 at 6:42 am
... I want the values from both databases, return true
What do you mean by this? Which values?
Also, when you compare your data in the WHERE clause the way...
March 20, 2013 at 6:26 am
shohelr2003 (3/20/2013)
CREATE TRIGGER [dbo].[Discount]
ON [dbo].[Product]
INSTEAD OF INSERT
AS
Declare @disc int;
Declare @line int;
Declare @pdid as varchar(10);
BEGIN
select @disc = i.DiscPercentage from inserted i
select @line = i.LineNumber from inserted i
select @pdid = i.ProdId from...
March 20, 2013 at 4:04 am
akberali67 (3/20/2013)
I am trying to join the table to itself many times on a condition. Is there a way to automate number of joins based on count of something from...
March 20, 2013 at 3:53 am
Vedran Kesegic (3/20/2013)
Moderator, please close this thread as nonconstructive.I tried with mad goat method, but it turns out it did not work 🙂
More than that! It not only didn't work,...
March 20, 2013 at 3:50 am
datwungai (3/19/2013)
What exactly are you afraid of?
It's a former DBA that hates me because unlike him, I take my job seriously and won't give him sa permissions. He thinks...
March 20, 2013 at 3:35 am
...
I coded but it always checks LineNo1. Please help me to code whether I can check data that is greater than 18 in Discount Column against all the LineNo .
...
Could...
March 20, 2013 at 3:17 am
Viewing 15 posts - 511 through 525 (of 2,894 total)