| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| how to rename the table | | 3 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| Which virtual table does a trigger use? | TCS | 6 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| How many types of cursors are there in SQL Server? | 247Customer | 3 |
| plz send every query in sql server2000 | Infosys | 1 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| What's the maximum size of a row? | | 4 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 6 |
| Can you explain the role of each service? | | 1 |
| What is ACID Property of Transaction? | | 4 |
| How can I know what query is executing by by a particural
user? (using sp id or any othe way.) | | 2 |
| write the query for taking database restore in sql? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
