hi how to set query while inserting to sql table for stored procedure for perticular column if register no reaches to 32 room no value should shange.

You need to check the value in the stored procedure before insert.

When you have the required input then you can get the count.

DECLARE @CheckCount INT

SELECT  @CheckCount  = COUNT(RegisterNo) FROM RegistrationTable WHERE condition comes here...

IF (@ CheckCount > 32)
BEGIN
        RETURN 'Exceeded'
END
ELSE
BEGIN
        INSERT INTO RegistrationTab...
        RETURN 'Success'
END

This is good way to approach... Other wise you can write separate stored procedure or query to check before call the SP.