<div>
turned out I was missing a parameter.... lol..<br />
<br />
I call the proc from the app and i was not passing in a required param... my bad<br />
<br />
-ws
</div>


turned out I was missing a parameter.... lol..

I call the proc from the app and i was not passing in a required param... my bad

-ws

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have been getting this error for hours, when i try to do a database insert.<br />
<br />
I am not trying to convert varchar to smallint.<br />
<br />
I have a stored procedure with params like this at the top:<br />
<br />
@PasswordQuestion &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(150),<br />
@PasswordAnswer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nvarchar(150),<br />
@WebsiteDiscoveryMethodCod<wbr />e &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;smallint,<br />
@EmployerID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;char(35)<br />
<br />
I do not know why I get this error... soooo frustrating.. can anyone explain why this error would erroneously happen?<br />
<br />
-ws
</div>
</div>


Hi,

I have been getting this error for hours, when i try to do a database insert.

I am not trying to convert varchar to smallint.

I have a stored procedure with params like this at the top:

@PasswordQuestion					varchar(150),
@PasswordAnswer					nvarchar(150),
@WebsiteDiscoveryMethodCode				smallint,
@EmployerID					char(35)

I do not know why I get this error... soooo frustrating.. can anyone explain why this error would erroneously happen?

-ws

Error converting data type varchar to smallint.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.