Viewing 15 posts - 1 through 15 (of 57 total)
March 14, 2018 at 8:55 am
RoNoS - Wednesday, December 6, 2017 12:39 AMIsn't that giving a syntax error about a missing bracket?
Would think so too
colnames(
December 6, 2017 at 7:17 am
After seeing the question in the newsletter I was expecting to see something like
select format(@date, 'MMMM dd')
Had to do some digging...
October 24, 2017 at 4:51 am
As I read it...
Ceiling appropriate for the coffee card tracking
You actually spent $6.91 but are recording it as $8.00 ($1.09 "saved" via obfuscation -- but its...
August 25, 2017 at 6:40 am
April 3, 2017 at 5:06 am
A little confused again...
Looking at
https://msdn.microsoft.com/en-us/powershell/reference/5.1/microsoft.powershell.core/get-module
-ListAvailable
Indicates that this cmdlet gets all installed modules. Get-Module gets modules in paths listed in the PSModulePath environment variable. Without this parameter, Get-Module gets only the...
December 5, 2016 at 7:15 am
Interesting...
This article https://msdn.microsoft.com/en-us/library/hh231286.aspx
updated 8/1/16 does not indicate the deprecation and states
Use the Import-Module cmdlet to import the sqlps module. Specify the DisableNameChecking parameter if you want to suppress...
November 28, 2016 at 5:22 am
Jeff Moden (11/16/2016)
IMHO, cleaner code if you take the shortcut.
SELECT mychar FROM mydata WHERE mychar LIKE '[[]%'
That's how I went about doing it and then had to take a closer...
November 17, 2016 at 6:36 am
As noted, both 1 & 2 appear to be invalid
INSERT dbo.TimeZoneOffsetTest (mytime) SELECT CAST('20161015 08:15 -4:25' as DATETIMEOFFSET)
go
INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 +2:00'
go
will work
November 2, 2016 at 6:02 am
We start each table at a different starting point (for us usually 1,000 apart) so then when we have only a handful of rows during DEV there is no chance...
September 29, 2015 at 6:14 am
Bill Talada (9/28/2015)
September 29, 2015 at 6:03 am
TomThomson (9/28/2015)
September 29, 2015 at 5:47 am
Bill Talada (9/28/2015)
September 29, 2015 at 5:34 am
Bill Talada (9/28/2015)
September 28, 2015 at 3:19 pm
Viewing 15 posts - 1 through 15 (of 57 total)