April 2015 ~ SQL Server Tricks

Popular Posts

Basics of SQL Commands

SQL commands are a set of instructions that are used to interact with the database like Sql Server, MySql, Oracle etc. SQL commands are re...
SET NOCOUNT

Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned a...
Different Types of SQL Joins

S ql joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is...
Built-in Functions (Transact-SQL)

CHARINDEX - Searches an expression for another expression and returns its starting position if found. DECLARE @FullName VARCHAR ( 100 )...
Delete duplicate rows in SQL Server

Introduction Some time some duplicate data may inserted in the SQL table. But its harmful for you and your application too. So how to re...
Schema in SQL Server 2012

Introduction In this article I describe schemas in SQL Server 2012. A schema is like a container that contains database objects like tables...
UDF For Splitting Comma Seperated Values

CREATE FUNCTION [dbo] . [fnSplit] ( @sInputList VARCHAR ( 8000 ) -- List of delimited items , @sDelimiter VARCHAR ( 8...