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 - 2006-03-30 : 09:22:17
|
| Suzanne writes "I have a database where people will be able to enroll in classes and I would like to limit the number of enrollees per class (or records with specific column values), how can this be done? SQL Server 2000Windows Server 2003Thank you!" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-30 : 09:25:21
|
| Something likeIf (select count(*) from table)>somevalue--Dont insert dataelse--Insert dataOtherwise give more detailsMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Limiting records