| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| What is a stored procedure? | | 3 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L | | 4 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| How to tune a stored procedure? | | 5 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
