T-SQL Decommenter Part II
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
2018-11-15
989 reads
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
2018-11-15
989 reads
2018-11-08
1,883 reads
2018-11-07
969 reads
2018-10-19
1,060 reads
2018-10-11
778 reads
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
679 reads
2018-09-13
5,107 reads
Didn't find anything, so hope this will help someone with similar need.
Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well
2018-09-19 (first published: 2018-09-12)
620 reads
2018-09-06
1,003 reads
Producing hierarchies from SQL tables can necessitate joining a table to itself. This article will explain how you can do this.
2020-03-06 (first published: 2018-08-30)
24,938 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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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