Viewing 15 posts - 211 through 225 (of 1,079 total)
Location
19
SELECT CHARINDEX('A2,R1,T3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]
Location
0
Why A2,R1,T3,D1 return 0? A2,R1,T3,D1 is Exists...
January 18, 2017 at 8:00 am
January 18, 2017 at 6:54 am
Back to basics, thanks for the question.
January 16, 2017 at 6:03 am
thanks for the question, trusty old gem used countless times.
November 30, 2016 at 6:48 am
Nice question, technically both:
1. INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)
and
2. INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'
are invalid, option 1 contains an invalid sub-query SELECT. Remove...
November 2, 2016 at 12:58 am
Sounds like a bug, are you on the latest Service Pack for 2012?
October 11, 2016 at 11:55 pm
I'll admit, this one got me. :hehe:
Thanks for the question.
October 10, 2016 at 10:25 pm
Best to speak to your license partner, if Standard, you'll need to review the rules of licensing the host and additional vCores, or just the vCores of the VM by...
October 5, 2016 at 7:32 am
You license SQL per server, not database.
So yes, you can add more databases to an existing licensed instance.
....you say virtual...is this also Web, or STD or ENT?
It...
October 4, 2016 at 2:05 am
Thank you for the suggestion, although I've tried all variants, including yours, and it appears that it doesn't accept anything beyond a standalone name.
September 29, 2016 at 9:06 am
Dammit - wonder if there's any replacement tool for BPA.
July 13, 2016 at 11:33 am
Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.
July 13, 2016 at 11:12 am
Viewing 15 posts - 211 through 225 (of 1,079 total)