Response to: a problem in sql server

Revision 1
Looking at your stored procedure here are some suggestions.
If you want to execute another stored procedure(SP) inside a stored procedure this is how you would do it

EXEC USP_INS_TEST '123','123'

Having said that there is no necessity of the stored procedure USP_CRE_USP_INS as it is just trying to execute the stored procedure USP_INS_TEST and there is no other SQL commands in that stored procedure. So you can just directly call the SP USP_INS_TEST instead of calling SP USP_CRE_USP_INS.