SQL Server char and varchar Data Types
CHAR is a fixed-length, non-Unicode string data. n defines the string length and must be a non-fractional value […]
sql
SQL Server right() function with cast()
The right() function returns the right part of a character string with the specified number of characters. It […]
SQL Server UNION and UNION ALL
The UNION, EXCEPT and INTERSECT operators are relational operators that combine rows from the results sets of two […]
SQL Server Date Conversion Function
Here we have a couple of code examples that work with dates. The first one gets today’s date […]
SQL Server Finding Bad Characters
In SQL Server you can run a SELECT query that shows you all of the records that have […]
SQL Server T-SQL Statements
As mentioned earlier, the Transact-SQL statements have three categories: DDL statements, DCL statements, and DML statements. Each of […]
SQL Server User-Defined Functions
In SQL Server, user-defined functions (UDFs) are similar to stored procedures, except that they do not support OUTPUT […]
SQL Automatically Date and Time Stamp New Rows
You may to date and time stamp every row/record that you add to your table. You may want […]
SQL Finding Duplicates in a Table
Suppose you have one table where you need to show all of the rows that have duplicate (more […]
SQL Finding Duplicates across Two Tables Two Columns
This blog post is a continuation from the previous blog post called SQL Finding Duplicates across Two Tables […]
SQL Finding Duplicates across Two Tables One Column
This post discusses the query needed to check if there are any duplicate values in a certain column […]
T-SQL Bulk Insert-Output Part 5
This post continues from our second post called T-SQL Bulk Insert-Output Part 4. All we are going to […]