Temporary tables in SQL Server are prefixed with “#” and table variables with “@,” thus they can have the same name as permanent tables and
Category: SQL Server
SQL Server Administration, Development and Maintenance
DIFFERENCE function in SQL Server
The DIFFERENCE() function returns an integer after comparing two SOUNDEX values. The integer number, ranging from 0 to 4, indicates the match between the two
DATEFROMPARTS in SQL Server
It may be necessary to integrate the several elements of the date into one. In such cases, SQL Server’s DATEFROMPARTS function will come in handy.
DATALENGTH Functions in SQL Server
DATALENGTH is a function that returns the number of bytes used to represent any expression. This looks similar to LEN function that helps in identifying
SQL Server Identity Functions
Identity values are handled by a number of functions in Microsoft SQL Server. The functions assist in establishing the automatic sequential value for table rows,
Grouping and Subtotals the rows in SQL Server
During data analysis, data analysts must categorize data into categories so that different aspects of the information may be displayed in a more understandable manner.
Big Data & SQL 