April 10, 2012 at 10:04 am
1)why a table can have one primerykey?
2)what is derivedtable in sql server?
3)what is subquery in sql server?
4)what is insteadof trigger in tsql?
April 10, 2012 at 10:14 am
5) Why should I do my own homework?
April 10, 2012 at 10:24 am
Books Online and Google are wonderful resources.
April 10, 2012 at 10:36 am
Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or interview questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 10, 2012 at 10:40 am
Sean Lange (4/10/2012)
Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or interview questions.
Actually, they aren't the same (well, except the one about the instead of trigger). This time it is about tables.
But I do agree that these are very basic questions, and you really should try answering them yourself.
April 10, 2012 at 10:47 am
Lynn Pettis (4/10/2012)
Sean Lange (4/10/2012)
Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or interview questions.Actually, they aren't the same (well, except the one about the instead of trigger). This time it is about tables.
But I do agree that these are very basic questions, and you really should try answering them yourself.
But they have all been posted by this person several times before and all withing the last few days...
http://www.sqlservercentral.com/Forums/FindPost1280916.aspx
1)why a table can have one primerykey?
2)what is derivedtable in sql server?
3)what is subquery in sql server?
4)what is insteadof trigger in tsql?
http://www.sqlservercentral.com/Forums/FindPost1280599.aspx
1)can we call sp into another sp if yes plz give small example?if no plz tell me reason?
2)can we call functionn into another function if yes plz give small example?if no plz tell me reason?
3)can we call sp in function?if yes plz give small exmp?if no plz tell me reason?
4)can we call function in sp?if yes plz give small examp?if no plz tell me reason?
http://www.sqlservercentral.com/Forums/FindPost1280598.aspx
what is insteadof trigger in tsql?
http://www.sqlservercentral.com/Forums/FindPost1279322.aspx
Hi friends,
i have small doubts in sql server.plz tell me the answers
1)why a table can have one primerykey?
2)what is derivedtable in sql server?
3)can we call sp into another sp if yes plz give small example?if no plz tell me reason?
4)can we call functionn into another function if yes plz give small example?if no plz tell mereason?
5)can we call sp in function?if yes plz give small exmp?if no plz tell me reason?
6)can we call function in sp?if yes plz give small examp?if no plz tell me reason?
7)what is subquery in sql server?
8)what is insteadof trigger in tsql?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 10, 2012 at 10:51 am
Sean Lange (4/10/2012)
Lynn Pettis (4/10/2012)
Sean Lange (4/10/2012)
Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or interview questions.Actually, they aren't the same (well, except the one about the instead of trigger). This time it is about tables.
But I do agree that these are very basic questions, and you really should try answering them yourself.
But they have all been posted by this person several times before and all withing the last few days...
http://www.sqlservercentral.com/Forums/FindPost1280916.aspx
1)why a table can have one primerykey?
2)what is derivedtable in sql server?
3)what is subquery in sql server?
4)what is insteadof trigger in tsql?
http://www.sqlservercentral.com/Forums/FindPost1280599.aspx
1)can we call sp into another sp if yes plz give small example?if no plz tell me reason?
2)can we call functionn into another function if yes plz give small example?if no plz tell me reason?
3)can we call sp in function?if yes plz give small exmp?if no plz tell me reason?
4)can we call function in sp?if yes plz give small examp?if no plz tell me reason?
http://www.sqlservercentral.com/Forums/FindPost1280598.aspx
what is insteadof trigger in tsql?
http://www.sqlservercentral.com/Forums/FindPost1279322.aspx
Hi friends,
i have small doubts in sql server.plz tell me the answers
1)why a table can have one primerykey?
2)what is derivedtable in sql server?
3)can we call sp into another sp if yes plz give small example?if no plz tell me reason?
4)can we call functionn into another function if yes plz give small example?if no plz tell mereason?
5)can we call sp in function?if yes plz give small exmp?if no plz tell me reason?
6)can we call function in sp?if yes plz give small examp?if no plz tell me reason?
7)what is subquery in sql server?
8)what is insteadof trigger in tsql?
AH! I missed the last one which looks to have all the questions in one place.
April 10, 2012 at 11:00 am
Of course I have no issue with asking basic questions.
I just tend to get annoyed at the same question over and over. Each time people all saying the same thing. Use BOL it explains these basic concepts. The nothing from the OP but new posts asking the same thing. /Rinse /Repeat
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 10, 2012 at 9:49 pm
if u know answers plz tell me
April 10, 2012 at 11:26 pm
asranantha (4/10/2012)
if u know answers plz tell me
Why don't you do your own research and try to answer your questions yourself? As you do the research if you have specific questions, come ask those.
April 10, 2012 at 11:52 pm
asranantha (4/10/2012)
if u know answers plz tell me
I hope with all my heart you'll never land a DBA job. At least not with that attitude.
I fear for the company's data...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2012 at 4:17 am
asranantha (4/10/2012)
if u know answers plz tell me
By the way, it's considered rude to use L33T or text speak on the forums. SQL Server is confusing enough with all its acronyms and technobabble jargon. You're only making it more difficult for yourself (and anyone trying to help you) by adding in abbreviations and short speak in your posts.
In future posts, please spell out your words as best you can so people don't have to spend long periods of time trying to figure out what you're saying.
April 11, 2012 at 5:00 am
asranantha (4/10/2012)
if u know answers plz tell me
All pirates should find their own treasure 😀
or just maybe research a little more 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply