Column value insert in limit time

Try this

declare @msg varchar(max)

if(select Count(*) from tablename where columnname like 'Productkeyname' = 3)

begin

set @msg='Your product key already inpsert three time'

select @msg

end

+2

Hi methoun,

Set one flag column and Count column in your table.

Whenever the user enters the increse the count. If the count is more then 3 , set the flag as false.

If again user enters check the flag is true or false. if it true update, other then returnthe error message

0

Hi,

Write record count query to get count of record for the product key.

Select count(*) from table_name where product_id = @id

if you get = 3 then show alert or allow insert.

+2