How do I rename a column?
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
481 reads
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
481 reads
I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016...
2016-04-18
565 reads
Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...
2016-04-16
630 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
474 reads
Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations
Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...
2016-04-16
174 reads
I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...
2016-04-16
161 reads
?????
(“MARR-hah-bah”, Arabic: Hello)
This year takes me to yet another part of the world:
I have been invited to speak at THE...
2016-04-15
556 reads
2016-04-15
461 reads
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
87 reads
By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...
2016-04-25 (first published: 2016-04-15)
1,696 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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