I am happy to write this blog post as I am really happy that finally, SQL Server Engineering team has decided to fix the error which we all have been struggling for many years. I will say Since the year 2000, I have been working with SQL Server and it has always bothered me that every time when I try to insert data into my table which is larger than the data type of the column, I got an annoying error String or binary data would be truncated. I recently demonstrated this to my Comprehensive Database Performance Health Check.
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
Question: How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement?
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
Question:Â How to Extract Alphanumeric Only From A String?
PostgreSQL – Storing Unicode Characters is Easy
One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both English and non-English characters.
How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206
Question: How to Sort a Varchar Column Storing Integers with Order By?
How to Trim TIME Part in DATETIME Values? – Interview Question of the Week #200
Question:Â How to Trim TIME Part in DATETIME Values?
SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be several methods to do this. One simple method is to make use of a regular expression. Let us see how we can retrieve rows with the all alphabets from Alphanumeric Data.