Monthly Archives: November 2013

Stuff VS Replace function in SQL Server

Stuff VS Replace function Stuff Function This function is used to replace string from the given start position, passed as 2nd argument with string passed as last argument. In Stuff function, 3rd argument defines the number of characters which are … Continue reading

Posted in SQL Basic Concepts, SQL Server | Tagged | 6 Comments

Case Statement/ Expression in SQL Server

Case Statement/ Expression in SQL server  Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression. This expression can be a simple case expression which compares an expression with a set … Continue reading

Posted in Most Imp SQL Concepts, SQL Basic Concepts, SQL Server | Tagged , | 1 Comment