Error converting data type varchar to smallint.

Posted on 2005-05-06
Last Modified: 2008-01-09

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?

Question by:Westside2004
    LVL 9

    Accepted Solution

    Show the rest of your proc, in particular youre insert statement.  It's kind of hard to tell with just the parameter information.

    LVL 1

    Author Comment

    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now