Question:- Which table is called Heap table in SQL Server. 1) Table without any indexes 2) Table without any […]
Answer – Objective Question (Which table is called Heap table in SQL Server) Read Post »
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation
Question :- How many non clustered indexes are possible in a table in SQL Server 2008R2 1) 1 2) 249
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
The Perfect Mix of Technology & Knowledge