Question of the Week – 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record […]
Question of the Week – 11/1/2014 Read Post »
Answer – Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server? 1) User database (where temporary table are defined)
Answer -Question of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation
Answer -Question of the Week – 2/1/2014 – Question 1 Read Post »
Answer – Objective Question (Which table is called Heap table in SQL Server)
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 of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation
Question of the Week – 2/1/2014 – Question 1 Read Post »
Answer – Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)
Question :- How many non clustered indexes are possible in a table in SQL Server 2008R2 1) 1 2) 249
Answer – Question of the Week – 28/12/2013 – Question 2
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
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code
While loop in SQL server Read Post »
Deleting Duplicate rows using CTE
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is
Deleting Duplicate rows using CTE Read Post »
Answer -Question of the Week – 25/12/2013- Question 1
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 »
Interview Questions
Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5
Question of the Week – 28/12/2013 – Question 2 Read Post »
Question of the Week -25/12/2013- Question1
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))
Question of the Week -25/12/2013- Question1 Read Post »
Ranking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition.
Ranking Functions in SQL Server Read Post »
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
Stuff VS Replace function in SQL Server Read Post »