Viewing 15 posts - 106 through 120 (of 2,903 total)
Personally I'd use an IF statement:
IF @LoanNumber IS NULL AND @DealershipName IS NULL
BEGIN
PRINT 'Both @LoanNumber and @DealershipName cannot be Null, a value...
August 31, 2015 at 3:40 pm
Trick question isn't it?
UNIQUE constraint: used to "...make sure that no duplicate values are entered..." So you can't have duplicates.
-SQLBill
August 31, 2015 at 3:34 pm
I'm planning on upgrading one of my Win7 laptops to Win10 in the next few months...I'm trying to let Win10 'settle down' as much as possible without going past the...
August 31, 2015 at 3:29 pm
mufadalhaiderster (8/21/2015)
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
I know this might sound...
August 21, 2015 at 10:24 am
When I was in the military (US Air Force), we had to do an annual security refresher. A 'several page' document was passed around with a 'sign to acknowledge...
August 21, 2015 at 10:10 am
SQLRNNR (8/7/2015)
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
August 7, 2015 at 4:30 pm
It sounds/looks like a command to update the subscriber failed at some point (network connectivity???) and left the second column blank on the subscriber.
That means the rows are no longer...
August 7, 2015 at 4:25 pm
mister.magoo (8/7/2015)
Sqlbill, how do they restrict the network people that can grant access to the account/group so that they don't work in cahoots with the villain?
We have a legal document...
August 7, 2015 at 4:12 pm
Real world experience....
We are not a 24-hour on duty DBA shop....after hours all production issues are handled by the on call DBA.
We have to abide by the client's security requirements...
August 7, 2015 at 2:40 pm
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congrats!!!!
-SQLBill
July 13, 2015 at 9:26 am
TomThomson (7/7/2015)
SQLBill (7/6/2015)
Unless it is pressing and can't wait for the next day....I stay to get it done...otherwise....my day is done.-SQLBill
I suspect you didn't mean that.
Or maybe Alvin's question...
July 7, 2015 at 8:59 am
Koen Verbeeck (7/7/2015)
SQLBill (7/6/2015)
July 7, 2015 at 8:57 am
Koen Verbeeck (7/3/2015)
GilaMonster (7/3/2015)
TomThomson (7/3/2015)
But don't make the mistake of thinking that all-nighters are always a sign of problems, or long hours (how can long hours be "heroic"?).
No, I'm...
July 6, 2015 at 1:35 pm
Lynn Pettis (7/2/2015)
Sean Lange (7/2/2015)
Lynn Pettis (7/2/2015)
July 2, 2015 at 1:43 pm
Brandie Tarvin (6/30/2015)
June 30, 2015 at 9:43 am
Viewing 15 posts - 106 through 120 (of 2,903 total)