| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 5 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 6 |
| how do we find every fifth record in a table | | 11 |
| How to count the number of duplicate items in a table? | | 1 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| is there more the two primary key in a single table? | Systematix | 22 |
| What are the different types of joins and what does each do? | | 2 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
