March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
CASE Expression

SQL SERVER – Using CASE Expression in Default Value

July 21, 2021
Pinal Dave
SQL Tips and Tricks
SQL CASE, SQL Scripts, SQL Server, SQL Table Operation

It is not possible to use CASE Expression in Default Values when you add a new column. I hope this answers the question. However, there is a workaround.

Read More
Unsolved CASE Expression

SQL Puzzle – Unsolved CASE Expression

April 20, 2021
Pinal Dave
SQL Puzzle
SQL CASE, SQL Scripts, SQL Server

Lots of people have asked me to share another puzzle. Well, let us see a very simple puzzle of Unsolved CASE Expression in today’s blog post.

Read More
order by a parameter

SQL SERVER – How to Order By a Parameter?

June 8, 2020
Pinal Dave
SQL Tips and Tricks
SQL CASE, SQL Order By, SQL Scripts, SQL Server

We figured out that there was a very poor code written in one of the Stored Procedure’s Order By clause. Let us learn today how to order by a parameter.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version