2011-10-06 (first published: 2009-12-02)
9,378 reads
Raw Materials
2011-10-04 (first published: 2009-11-26)
11,136 reads
2011-09-29 (first published: 2009-11-18)
10,458 reads
2011-09-27 (first published: 2009-10-28)
9,690 reads
2011-09-22 (first published: 2009-10-21)
10,957 reads
2011-09-20 (first published: 2009-10-14)
10,021 reads
2011-09-15 (first published: 2009-10-07)
8,048 reads
2011-09-13 (first published: 2009-09-30)
8,076 reads
2011-09-08 (first published: 2009-09-23)
6,763 reads
Raw Materials - The Low Bid
When a job is too simple to be done in-house, how far down the phylogenetic tree should you go?
2011-09-06 (first published: 2009-09-16)
7,685 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Alamat BCA KCP Abdul Muis Telp/Wa:08218520154
Alamat: Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, RT.2/RW.8,...
Alamat BCA KCP Sabang Telp/Wa:08218520154
Alamat: Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Alamat BCA KCP Kebon Sirih Telp/Wa:08218520154
Alamat: Plaza Pupuk Kaltim, Jl. Kebon Sirih No.6A Gedung B Lantai 1, RT.14/RW.2, Gambir,...
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers