| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| How to find the date and time of last updated table?
| | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| What's the maximum size of a row? | | 4 |
| Can you have a nested transaction? | HCL | 3 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| what are the problems in logshipping? | | 2 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| Wht is Stuff in sql ser | | 1 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| Which virtual table does a trigger use? | | 3 |
| What is a materialized view? | | 2 |
| Questions on identity? | Infosys | 1 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| how to know Who Is Blocking Your SQL Server? | | 2 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| what are batch in sql server?
| Satyam | 2 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |