Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2012-01-09 : 00:46:20
|
| I had an interview few days back where I faced some curious questions. Even I'm still struggling for the answers for those questions. At last I’m here, can someone help me:Q 1: Can we have different collection for database and table in sql server 2005? My Ans: "Yes" ???Q 2: write a query that uses all date functions in sql server 2005???????Pushkar |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-09 : 07:07:57
|
| Q1: I guess you meant COLLATION? Yes.Q2: Heh! |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-01-09 : 07:19:03
|
| Q2 - in bol 2008 there are 19 of them. I would have got maybe 8 or 9 if asked this question (and wouldn't have taken the job).==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-09 : 07:30:37
|
| But just getting 8 or 9 is not good enough, you have to write a single query using all of them.That question sounds almost like the alleged Google interview questions such as "A man pushed his car to a hotel and lost his fortune. What happened?"Welcome back Nigel! That was a long vacation!! |
|
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-01-09 : 08:01:18
|
Now I'm satisfied if experts feel that these were alleged question. I'll go back to that organization and will search who was selected and what he answered actually......  |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-01-09 : 09:11:40
|
quote:
Originally posted by sunitabeck
But just getting 8 or 9 is not good enough, you have to write a single query using all of them.That question sounds almost like the alleged Google interview questions such as "A man pushed his car to a hotel and lost his fortune. What happened?"Welcome back Nigel! That was a long vacation!!
It would have been a select with a column for each function.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Interview Question