April 10, 2012 at 10:28 pm
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?
plz tell me answers
April 11, 2012 at 1:08 am
Have you tried google and Books Online? The answer to the first will be found with google, the other 3 are definitely in Books Online
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 11, 2012 at 7:53 am
PLEASE stop posting these same questions over and over.
_______________________________________________________________
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 11, 2012 at 9:50 am
if u know answers plz tell me .other wise donot reply.
iam waiting for answrers.donot write any othere messages.if u know tell me properly other wise stop write any other messages.plzzzzzzzzzzzzzz
April 11, 2012 at 9:53 am
Seriously, go and do some basic research and look the stuff up. It's not hard, there is a huge amount of documentation available for SQL and some really good search engines will help you find it.
People are not going to spoon-feed you basics, especially when it looks like homework or interview questions. The DBA job requires the ability to research, investigate and find info out on your own.
If you'd done a little work on your own, you'd have had the answers to these questions days ago.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 11, 2012 at 9:54 am
asranantha (4/11/2012)
if u know answers plz tell me .other wise donot reply.iam waiting for answrers.donot write any othere messages.if u know tell me properly other wise stop write any other messages.plzzzzzzzzzzzzzz
And you are going to be waiting a long time. Yes, many of us could answer your questions but we'd prefer that you do your own research and come back and ask more specific questions to help you understand each topic. Plus, if you take the time to do the research you will find that you will learn one of the most important skills any IT professional needs to succeed in this career field.
April 11, 2012 at 9:57 am
Here's a hint to get you started:
http://www.google.com/search?q=why+a+table+can+have+one+primerykey
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 11, 2012 at 9:57 am
Actually you are not waiting for answers. You keep asking the same things over and over.
The following link will provide you an answer to your first question.
_______________________________________________________________
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 11, 2012 at 10:06 am
everything is avilable in google.at this time why maintaing this site.if any ;body know .simply sameif u know anserr tell why give this type of discussion.if u give answers clearly. definately its help .othere wise i donot like this type of discussion.someday say search google .i know that one.
i try to search anserrs in google.but iam not getting ansers clearly thats why i post here
April 11, 2012 at 10:10 am
asranantha (4/11/2012)
everything is avilable in google.at this time why maintaing this site.if any ;body know .simply sameif u know anserr tell why give this type of discussion.if u give answers clearly. definately its help .othere wise i donot like this type of discussion.someday say search google .i know that one.i try to search anserrs in google.but iam not getting ansers clearly thats why i post here
demonstrate to us that you have researched your questions. Your questions are so broad, the only other suggestion I have for you is to go to school. We don't have the time to give you full answers to your questions, that's why we are telling you to research on your own. Use Google, read Books Online. There are plenty of resources out there to help you get started. Get started.
When you can ask more specific, detailed questions about a topic that you don't understand, come back and ask that question.
April 11, 2012 at 10:17 am
asranantha (4/11/2012)
i try to search anserrs in google.but iam not getting ansers clearly thats why i post here
Really? Strange, the link I posted (which was your exact question typed into google) produced a full page of links to sites that explain why tables can only have one primary key.
This site is not a substitution for the documentation (which is very good). We're happy to discuss things, or explain something if you don't understand it, but do the basic investigation first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 11, 2012 at 10:17 am
asranantha (4/11/2012)
everything is avilable in google.at this time why maintaing this site.if any ;body know .simply sameif u know anserr tell why give this type of discussion.if u give answers clearly. definately its help .othere wise i donot like this type of discussion.someday say search google .i know that one.i try to search anserrs in google.but iam not getting ansers clearly thats why i post here
Did you actually look at any of the results when using google? How about the link I posted above? The very first link, you know the one at the top, could not possibly be any more clear in the definition.
Here is the link in case you are unable to find it.
http://www.quora.com/Why-can-a-database-table-have-only-one-primary-key
As I said in at least one of your other posts, I have no problem with basic questions. The questions you are posting are so basic and it is painfully obvious that you are not willing to spend a couple minutes looking for the answer. Are you sitting in your interview typing this on your phone hoping that we will help you come up with a brilliant answer so you get the job that you are clearly not qualified for?
There are lots of people around here willing to have discussions and help learn but you have to demonstrate some effort on your own.
_______________________________________________________________
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 11, 2012 at 10:18 am
i have what i do .i donot liku ur suggestions.better u go schhol.donot wast my time and ur time.who knows that persion will tell.
April 11, 2012 at 10:22 am
asranantha (4/10/2012)
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?
plz tell me answers
i've linked answers to your questions below, they were not all that hard to dig up.
what is derivedtable in sql server?
what is subquery in sql server?
what is insteadof trigger in tsql?
Lowell
April 11, 2012 at 10:22 am
asranantha (4/11/2012)
i donot liku ur suggestions.
That's fine, I don't like these kind of questions.
better u go schhol.
I've done a number of years at schools, university and in various training courses and I'll probably do many more in years to come. Wish I could go study full time.
donot wast my time and ur time.who knows that persion will tell.
If you were so concerned about your time and ours, you'd have done some searching yourself, then it wouldn't have been two or more days without you getting an answer.
http://sqlskills.com/BLOGS/PAUL/post/RTFM-No-seriously-RTFM-Then-ask-your-question.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply