Enable SQLCMD Mode on SSMS
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,560 reads
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,560 reads
It’s time for another T-SQL Tuesday. The brainchild of Adam Machanic (b|l|t), and designed to strengthen the SQL Server blogging...
2018-08-07
361 reads
2018-08-07
69 reads
Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...
2018-08-24 (first published: 2018-08-07)
8,239 reads
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of...
2018-08-07
39 reads
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like...
2018-08-07
1,206 reads
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
57 reads
Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...
2018-08-07
392 reads
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
33 reads
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
22 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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