请问大家这个Stored Procedure in SQL 应该怎么写

Create a store procedure what record the new film in the database. The procedure work

with a status which is represented that the film is available (0) or not (1).

Create a store procedure what check the users name length that the name is insertable in

the table or not (the string length 10 characters).