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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-17 : 09:52:03
|
| Dev writes "1. I would like to know why Stored procedures are used in SQL and what are the benifits of the same.2. What r the Different functions in SQL3. What is Having claused used forIt will be great if some one could suggest me link or questions with answers for the SQL related Interview questions along with the answersThanx in Advance" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-17 : 09:57:51
|
Books On line( = SQL server help) explain all that.google is good too.Go with the flow & have fun! Else fight the flow  |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-17 : 10:17:26
|
| No offense, but if you need to come here to find the answers to those questions, then you are probably not qualified for the job. Spend more time researching, playing around with, and learning SQL.also -- that second question is one of the worst interview questions I've ever seen !- Jeff |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-17 : 10:21:01
|
| By the way, improving your spelling and grammar would be a good idea BEFORE you go on an interview. And saying "well, I just type that way on the internet" is NOT a valid excuse. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-17 : 10:34:03
|
quote:
Originally posted by AskSQLTeam
Dev writes "1. I would like to know why Stored procedures are used in SQL and what are the benifits of the same.2. What r the Different functions in SQL3. What is Having claused used forIt will be great if some one could suggest me link or questions with answers for the SQL related Interview questions along with the answersThanx in Advance"
1. No reason. It fact, they just get in Frans Bouma's way, so ignore them.2. Saving data and retrieving data.3. An escape clause used by girlfriends to avoid making decisions. For example "I'll have what you're having".Damian |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-17 : 10:36:08
|
| Cool! So when they ask "does my butt look fat in these jeans?" you can say "hell yeah, you keep eating the same shit I do." |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-17 : 16:20:30
|
quote:
Originally posted by robvolk
Cool! So when they ask "does my butt look fat in these jeans?" you can say "hell yeah, you keep eating the same shit I do."
You can also resort to the DENY clause if this happens.rockmoose |
|
|
|
|
|
|
|
|
SQL Interview 
By the way -- if you really want to "Wow" them on your interview, you should memorize my definition of "triggers" from this thread: