Anthony Wilko

Anthony Wilko is a full-time webmaster and owner of Infuseweb LLC, an affordable full-featured web hosting company based out of San Antonio, Texas.

He has over 7 years of web design and development experience including data-driven site design with ASP, ColdFusion, MS SQL Server, Access. He is also a Macromedia Dreamweaver MX 2004 Certified Professional.

SQLServerCentral Article

Review: MyLittleAdmin

SQL Server has great client side tools, Query Analyzer, Enterprise Manager, for working with your server and managing it. But how many times have you wished for a web interface because you didn't have VPN or didn't want to give rights to a developer. Or maybe you host clients' databases on your server and don't want one person to see another's databases. Read this review by someone who actually uses this product.

You rated this post out of 5. Change rating

2004-08-13

9,015 reads

Blogs

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

By

How I used AI for this postChatGPT to generate images based on info specifically...

T-SQL Tuesday #202: The Two Outages I Won't Ever Forget

By

My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....

Measuring RAG Solutions: Are We Retrieving the Right Information?

By

A RAG pipeline that answers questions in the demo is not the same thing...

Read the latest Blogs

Forums

Performance Regression After Upgrading from SQL Server 2016 to 2022

By abdalah.mehdoini

Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...

Adding new column with DEFAULT

By Thomas Franz

Comments posted to this topic are about the item Adding new column with DEFAULT

How do I connect to a SQL Server database on my ISP?

By Doctor Who 2

I've got a web application for my side business. I've added a SQL Server...

Visit the forum

Question of the Day

Adding new column with DEFAULT

Which number will the COUNT() return after executing the following statements:

DROP TABLE IF EXISTS #test;
CREATE TABLE #test (id INT)
INSERT INTO #test (id)
SELECT *
  FROM GENERATE_SERIES(1, 3) AS gs
;

ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0;
go
UPDATE #test SET flag = 0 WHERE id = 1
UPDATE #test SET flag = 1 WHERE id = 2

INSERT INTO #test (id) VALUES (4)

SELECT COUNT(*)
  FROM #test AS t
 WHERE flag = 0
 

See possible answers