Applied SQL: LIKE ‘whatever’
Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches...
2014-01-27
750 reads
Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches...
2014-01-27
750 reads
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...
2014-01-31 (first published: 2014-01-27)
2,672 reads
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,187 reads
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
824 reads
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,258 reads
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here: http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/), then you can...
2014-01-30 (first published: 2014-01-27)
1,751 reads
This one is a bit off for me. I've had to make SSIS exports kick out in specific ways such...
2014-01-29 (first published: 2014-01-27)
1,535 reads
As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks...
2014-01-26
565 reads
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,333 reads
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,621 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers