July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly look at PARSE() function. PARSE() function can convert any string value to Numeric or Date/Time format. If passed string value cannot be converted to Numeric or Date/Time format, it will…
Read More

SQL SERVER – Question to You – When to use Function and When to use Stored Procedure

Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Server, SQL Stored Procedure

This week has been very interesting week. I have asked few questions to users and have received remarkable participation on the subject.
Q1) SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
Q2) SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
Keeping the same spirit up, I am asking the third question over here.
Q3) When to use User Defined Function and when to use Stored Procedure in your development?

Read More

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Stored Procedure, SQL String
I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He…
Read More