Skip to content

No Column Name

My learnings and thoughts on SQL Server and PowerShell

  • About Me:
    • Twitter:
    • DBA.stackexchange
  • Community Scripts
  • T-SQL Tuesday
  • SQL Server
  • PowerShell
  • Twitter

Tag: CHECKSUM

Another Difference between N” and ” in SQL Server.

If it walks like a ‘duck’, talks like a ‘duck’, and looks like a ‘duck’…careful! It could be a N’duck’

Another Difference between N” and ” in SQL Server.

Words: 270

Time to read: around 2 minutes.

Continue reading “Another Difference between N” and ” in SQL Server.”

Author Shane O'NeillPosted on October 24, 2018October 24, 2018Categories GeneralTags CHECKSUM, cross apply, hashbytes, implicit conversion, nvarchar, sql-server, varcharLeave a comment on Another Difference between N” and ” in SQL Server.

How Can I Replace “No column name” With A Word In SQL Server?

An ode to a knowledge seeker

How Can I Replace “No column name” With A Word In SQL Server?

Words: 398
Time to read: ~ 2 minutes
tl;dr : Give it an alias! ( select ‘0’ AS [Zero]; )

Continue reading “How Can I Replace “No column name” With A Word In SQL Server?”

Author Shane O'NeillPosted on September 6, 2017September 20, 2017Categories SQL New BloggerTags ABS, Alias, CHECKSUM, Modulo, NEWID, sql-server, SQLNewBloggerLeave a comment on How Can I Replace “No column name” With A Word In SQL Server?

Recent Posts

  • Ordering and Choices in PowerShell
  • How SQL Server’s Compute Scalar Will Impede You
  • Getting SQL Server Version using dbatools
  • T-SQL Tuesday 183 – Tracking Permissions
  • T-SQL Tuesday #182 – Integrity

Recent Comments

Ordering Collections… on Ordering and Choices in PowerS…
webdesigner on Updating the Account Password…
Anonymous on When Stored Procedures say the…
Performing a Quick F… on How SQL Server’s Compute…
Get the SQL Server V… on Getting SQL Server Version usi…

Archives

  • July 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • February 2024
  • October 2023
  • July 2023
  • April 2023
  • December 2022
  • October 2022
  • August 2022
  • July 2022
  • May 2022
  • April 2022
  • January 2022
  • November 2021
  • October 2021
  • July 2021
  • June 2021
  • May 2021
  • February 2021
  • January 2021
  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016

Categories

  • Advent of Code
  • DBA Fundamentals
  • dbachecks
  • dbatools
  • General
  • Golang
  • maintenance plan
  • Pester
  • Powershell
  • SQL Family
  • SQL New Blogger
  • sql-server
  • STATISTICS IO
  • T-SQL Tuesday
  • Uncategorized

Recent Posts

  • Ordering and Choices in PowerShell
  • How SQL Server’s Compute Scalar Will Impede You
  • Getting SQL Server Version using dbatools
  • T-SQL Tuesday 183 – Tracking Permissions
  • T-SQL Tuesday #182 – Integrity
  • About Me:
    • Twitter:
    • DBA.stackexchange
  • Community Scripts
  • T-SQL Tuesday
  • SQL Server
  • PowerShell
  • Twitter
No Column Name Powered by WordPress.com.

Loading Comments...