February 1, 2008 at 9:07 am
DepartmentIDDepartmentName
1Human Resources
2Information Technology
3Marketing
4Legal
Table: Department
Table: Employee
EmployeeIDEmployeeNameDepartmentID
1 Paul3
2 John1
3 Mary4
4 JosephNull
5 Leo1
6 Mark3
7 Scott3
6.List all the departments that don’t have any employees. (Without using sub query)
7.List the departments with the number of employees.
9.How will you check the locks on a table?
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 1, 2008 at 9:21 am
Clearly, obviously homework. You even posted the question numbers.
For help of this kind, you have to show what you tried that didn't work rather than have any of us do your homework for you. I mean, you aren't one of my kids, right?
"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
February 1, 2008 at 9:44 am
hi atleast could u jus let me know
How will you check the locks on a table???plz atleast let me know this i did that n i got that
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 1, 2008 at 9:56 am
Dynamic management views related to transactions are what you're looking for. But, just so you know, that's not the final answer. That's where to look in the documentation to get the final answer.
"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
February 1, 2008 at 1:38 pm
Books online is your friend...
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply