This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - SQL SERVER - UDF - Get the Day of the Week Function - Part 4

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function Part 4

June 1, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

In Day of the Week Function Part 4, I answer why I write a UDF when DATENAME exists (I just like it) and show the one line DATENAME version.

Read More
An oak supply tray has an empty compartment beside its standard fitting, while existing filled compartments remain untouched.

SQL SERVER – Create Default Constraint Over Table Column

May 31, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

A DEFAULT constraint supplies a value when an INSERT omits the column. I test omitted values separately from explicit NULL.

Read More
SQL Server Unpivot Table.

SQL SERVER – UNPIVOT Table Example

May 29, 2008
Pinal Dave
SQL Tips and Tricks
PIVOT and UNPIVOT, SQL Function, SQL Scripts

UNPIVOT Table is the reverse of PIVOT. This AdventureWorks example turns state columns back into rows, and shows why the detail rows do not return.

Read More
SQL SERVER - SQL SERVER - UDF - Get the Day of the Week Function - Part 3

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3

May 27, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Nanda Kumar improved the UDF to get the day of the week: it now uses the date you pass in instead of GETDATE() and handles Saturday correctly.

Read More
A SQL Server message window.

SQL SERVER – T-SQL Script to Devide One Column into Two Column

May 25, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

A quick script to split one column into two with LEFT, RIGHT and CHARINDEX, plus what to check when a value has no comma or has extra spaces.

Read More
SQL SERVER - SQL SERVER - UDF - Get the Day of the Week Function - Part 2

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2

May 23, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Mihir Popat improved my Day of the Week Function with @@DATEFIRST, so Sunday does not have to be the first day of the week. Here is his UDF.

Read More
PIVOT table example.

SQL SERVER – PIVOT Table Example

May 22, 2008
Pinal Dave
SQL Tips and Tricks
PIVOT and UNPIVOT, SQL Scripts, SQL Server

A PIVOT Table example on AdventureWorks that counts addresses by state, plus why UNPIVOT cannot always give you back the original rows.

Read More
Previous 1 … 311 312 313 314 315 316 317 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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