CREATE TABLE #temp(name char(3))
INSERT INTO #temp VALUES ('CD')
,('AB')
,('LM')
,('BC')
,('GH')
,('KJ')
,('AB')
DECLARE @cols AS NVARCHAR(MAX);
SELECT @COLS = substring(list, 1, len(list) - 1)
FROM (SELECT list =
(SELECT DISTINCT...
2015-02-10 (first published: 2015-02-02)
10,416 reads
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
19 reads
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,588 reads
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
298 reads
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....
2015-02-09 (first published: 2015-02-01)
7,686 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
21 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,166 reads
By Steve Bolton
…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we...
2015-01-30
2,555 reads
Reading Time: 3 minutesBeing on the edge of a cliff is a common feeling when running a small business
Stepping Back
I...
2015-01-30
1,257 reads
Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus...
2015-01-30
19 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