sql server 2005 - Insert procedure does not work, however a row can be seen in the table after only running insert statement in the same procedure -


after run procedure shown below, return value 0 , message shown "query executed successfully", no row inserted in table after open table. if run insert statement inside procedure, works fine , new row inserted in can see when open table. kind new sql server, here using sql server 2005 , sql server management studio express. guess may permission issue or maybe sql server management studio express not support features while sql server management studio does. when connect sql server database engine, use windows authorization. mean not have admin permission. appreciate reply or clue. thanks


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -