| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to generate XML out of QUERY? | McAfee | 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 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What do you mean by COLLATION? | | 4 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| 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 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| How do you load large data to the SQL server database? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
