Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,054 reads
SQL – Split delimited columns using XML Or UDF function
The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...
2015-01-09
1,355 reads
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
782 reads
I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
695 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
703 reads
Friday Followup For January 9, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-09
410 reads
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files.
DECLARE @filename NVARCHAR(1000);
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn...
2015-01-09
1,548 reads
T-SQL script to find the highly populated tables in database
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we...
2015-01-09
1,406 reads
How to resolve connection errors when loading data in SSAS Tabular project
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...
2015-01-09
592 reads
Building Connection Strings
I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite...
2015-01-08
1,047 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCP Tumpang (08218200205) WhatsApp
ALAMAT : Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur...
BCA KCP Kepanjen (08218200205) WhatsApp
ALAMAT : Jl. Jend. Yani Jl.Pahlawan No.99, Ardirejo, Kepanjen, Kec. Kepanjen, Kabupaten Malang, Jawa...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
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 = 0See possible answers