how do you restrict number of rows for a particular value
in a column.For example:there is a table called
fruits,having apples,bananas ,papayas.I dont want to have
more than 100 apples in that table ,so how can u restrict
number of rows for apple to hundred?
Answer Posted / guest
hint:using row level and statement level trigger
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what does the t-sql command ident_incr does? : Transact sql
What is character functions?
How do I create a sql script?
Can we insert delete data in view?
how to convert character strings to numeric values? : Sql dba
What is sql and explain its components?
Can %notfound return null after a fetch?
What is the difference between partition and index?
Explain what is a subquery ?
What is cascade in sql?
Is it possible to update views?
What is data control language (dcl)?
what is a view? : Sql dba
Why is a primary key important?
Why is nosql good?