服务器Erorr [英] Server Erorr

问题描述

嗨我有一个代码运行到我的本地计算机当我上传到服务器它给我一个错误询问参数@datecreated但我没有在@datecretaed参数中使用该更新存储过程请帮我这里是我的代码：

Hi i have a code runing into my local computer when i uplode to the server it is giving me an error asking parameter @datecreated but i am not using in the @datecretaed parameter in that update store procedure please help me with this here is my code:

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

如果服务器抱怨不通过您的代码在update / insert语句中缺少参数，请确保在数据库表的 datecreated 列中设置了默认值。您可以将其默认为getdate（）。否则，你必须从代码中提供它的值。

Without going much through your code, if the server complains about a missing parameter in the update/insert statement, make sure you have default value set on the datecreated column in the database table. You can probably default it to getdate(). Otherwise, you have to supply it''s value from the code.

你好我不需要@datecreated参数在那里我没有使用datecreated但我收到错误像这样

@datecreated不是程序up_updateEmployeeNominations的参数。

和商店程序是这样的

Hi i don''t need a @datecreated paramenter in there i am not using datecreated but i am getting the error like this
@datecreated is not a parameter for procedure up_updateEmployeeNominations.
and store procedure is like this

展开 | 选择 | Wrap | 行号

你好我不需要@datecreated参数在那里我没有使用datecreated但是我得到这样的错误

@datecreated不是程序up_updateEmployeeNominations的参数。

和商店程序是这样的

Hi i don''t need a @datecreated paramenter in there i am not using datecreated but i am getting the error like this
@datecreated is not a parameter for procedure up_updateEmployeeNominations.
and store procedure is like this

展开 | 选择 | Wrap | 行号

这篇关于服务器Erorr的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！