Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows […]
Answer – Question of the Week – 28/12/2013 – Question 2 Read Post »
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname
Answer -Question of the Week – 25/12/2013- Question 1 Read Post »
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5
Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition.
Stuff VS Replace function Stuff Function This function is used to replace string from the given start position, passed as
Case Statement/ Expression in SQL server Sometimes we need to get one result output from multiple possible outcomes based on
Replication in SQL Server Introduction Replication in SQL Server is a way of distribution of database and their objects from one
Log Shipping in SQL Server Log Shipping Log Shipping in SQL Server is a process of keeping the latest copy
Rebuild and Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in
Happy New Year 2013 May this new year bring lots of Happiness in all of your life. Let welcome 2013