Viewing 15 posts - 4,621 through 4,635 (of 9,399 total)
If you want to store the procedure in master and be able to execute it from other databases without having to specify the database, then you're doing it right. ...
November 24, 2015 at 5:50 am
If I'm reading it correctly, I thin you're saying that your procedure contains the SET NOCOUNT ON and you're saying that you don't want the attachment (generated by a different...
November 24, 2015 at 5:36 am
Unless I'm missing something, you won't need any IF statements. Instead, you want to run your query and filter on the contacts.organization_name column.
To generate the DDL for a table,...
November 24, 2015 at 5:26 am
I think one of the major problems is that when a company is hacked, they act like they're doing everyone a favor by "issuing a press release disclosing the incident"...
November 24, 2015 at 5:21 am
crookj (11/23/2015)
DonlSimpson (11/23/2015)
Ed Wagner (11/23/2015)
djj (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
anthony.green (11/23/2015)
djj (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
TeachGym
Exercise
lethargic
Sleep
Just Can't Get Enough
Food
Hunger
Games
Strategy
Tactics
Tractics (1975)
Combat
November 24, 2015 at 4:54 am
I have to agree with Tom. It may be valid, but is certainly not recommended and it would never survive a review.
November 24, 2015 at 4:53 am
MMartin1 (11/23/2015)
"export_File_IMG_'
I dont work with this a whole lot so I was wondering if the single quote closing the double quote is valid, or if it is just covering...
November 23, 2015 at 12:07 pm
Steve Jones - SSC Editor (11/23/2015)
pietlinden (11/22/2015)
The spam this weekend is insane... is the filter taking the weekend off?
So, the filter is learning, though it misses some I don't understand.
However...
November 23, 2015 at 10:01 am
djj (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
anthony.green (11/23/2015)
djj (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
TeachGym
Exercise
lethargic
Sleep
Just Can't Get Enough
Food
Hunger
Games
Strategy
November 23, 2015 at 10:00 am
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to drop the login...
November 23, 2015 at 9:23 am
Steve Jones - SSC Editor (11/23/2015)
November 23, 2015 at 9:20 am
anthony.green (11/23/2015)
djj (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
TeachGym
Exercise
lethargic
Sleep
Just Can't Get Enough
Food
November 23, 2015 at 7:11 am
anthony.green (11/23/2015)
Ed Wagner (11/23/2015)
TeachGym
Exercise
November 23, 2015 at 6:04 am
Stewart "Arturius" Campbell (11/22/2015)
Really interesting question, thanks Steve.Heven't used extended events yet, so learned something new.
I haven't used them in production either. I played with them once, but found...
November 23, 2015 at 5:44 am
DonlSimpson (11/20/2015)
whereisSQL? (11/20/2015)
crookj (11/20/2015)
Ed Wagner (11/20/2015)
ZZartin (11/20/2015)
anthony.green (11/20/2015)
Luis Cazares (11/20/2015)
anthony.green (11/20/2015)
Ed Wagner (11/20/2015)
anthony.green (11/20/2015)
djj (11/20/2015)
anthony.green (11/20/2015)
djj (11/20/2015)
ShootingRange
Rover
curiosity
Learning
Improvement
Home
Depot
Require
Want
Need
Help
Assistance
Teach
November 23, 2015 at 5:37 am
Viewing 15 posts - 4,621 through 4,635 (of 9,399 total)