I encountered a problem with using the stored procedure today. I used it for the first time. I used the Enterprise Manager to create a stored procedure. I just gave a name and didn't want to write anything in it. I saved it, later I used it, so I opened it for modification. I changed the process name to the parameter to the return value. The syntax passed. Make sure that the error message is displayed:
"Error 21037: [SQL-DMO] The name specified in the" Create... "statement of the text property must match the name property, and must be followed by a valid tsql statement. "
Obviously it has little to do with the syntax. It seems that no one has explained it on the Internet, but someone mentioned the process name in a post, so I tried it, I completely deleted the failed stored procedure, created a new stored procedure, and pasted the code just now. OK!