Free for PREMIUM members
Go Premium for a chance to win a PS4. Enter to Win
insert into INSERT INTO dbo.Table(
Select CASE WHEN Row1 is null then 0 else Row1 end as Row1,
Open in new window
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
ISNULL(Row1, 0) as Row1
COALESCE (Row1, 0)
COALESCE (Row1, '')
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.