Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
758 reads
Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-03
1,617 reads
Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-02
1,865 reads
Say you have a simple data transfer class that looks like this:
Public Class Employee
Public Property Name As String
Public...
2013-02-02
1,160 reads
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,007 reads
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING...
2013-02-01
638 reads
It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots...
2013-02-01
1,233 reads
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,143 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
917 reads
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,214 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers