April 5, 2012 at 11:25 pm
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?
April 6, 2012 at 12:18 am
How about we start with what you think the answers are for these questions?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2012 at 3:05 am
The answer to most of those can be found in Books Online. The rest with a google search.
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 6, 2012 at 3:58 am
Seriously, that sounds like interview questions. Sorry, I'm with the others. I'm not helping there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2012 at 4:53 am
I'll throw you a bone on the first question:
why a table can have one primerykey
Think about it a primary key ensures a row is unique...
Aside from that google away! 😀
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply