i need to insert values into 3tables using storedprocedure and each tables should allows only 5rows. if one table filled with 5 rows remaining rows should be move to another table

please be more explicit... maybe, u need create and stored procedure with functions (any rowCount or making an select count(id) from table1) if this value is 5, then make an change insert this...
be more especific please

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.