Colorado SQL Events for April 2014
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-04-08
411 reads
T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard
It is April and April Fools has only just begun. Well, or so Matt Velic (blog | twitter) would have us believe. Matt decided that this month for TSQL...
2014-04-08
16 reads
T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard
It is April and April Fools has only just begun. Well, or so Matt Velic (blog | twitter) would have us...
2014-04-08
981 reads
T-SQL Tuesday #53–Why So Serious?
It’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I...
2014-04-08
819 reads
Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
634 reads
Question of the Week -08/04/2014
Suppose we need to find out the name of all the months in a given year (Year will be given...
2014-04-08
511 reads
Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?
Options:-
a) 1
b) 2
c) More...
2014-04-08
602 reads
[SQL Snacks Video] SQL Server Table Partitioning 101
I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...
2014-04-08
650 reads
T-SQL Tuesday #53 Why So Serious
This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...
2014-04-08
839 reads
Curation and Performance
I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...
2014-04-08
809 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
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