Blog

SQL String Functions

SQL Server provides built-in functions to handle strings. Each function performs an operation on a string and returns a string or numeric value.

By Admin

SQL Configuration Functions

SQL Server provides many built-in functions and also lets you create user-defined functions. Configuration Functions are one of the built-in functions that help the user access information about the current configuration.

By Admin

SQL Mathematical Functions

SQL mathematical functions are used to perform a mathematical operation and to return the result set of the operation. All math functions are deterministic except the RAND function.

By Admin

SQL Bulk Insert

The Bulk Insert can be used to insert data from a text file or a flat file into a SQL Server Table. When creating SQL Server 2000 ETL solutions, such as importing of text files, it is common for developers to employ DTS packages to achieve results quickly.

By Admin

T-SQL Programmability Features in SQL server 2008 - Part 3

In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based on certain conditions. Now using the MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it, and when unmatched then insert it. One of the most important advantages of MERGE statement is all the data is read and processed only once.

By Admin