title: How do I cast Scope_Identity() to Int?
body: <p>So <a href="http://msdn.microsoft.com/en-us/library/aa258832(SQL.80).aspx" rel="noreferrer">Scope_Identity()</a> returns an ?-Byte Numeric Type in SQL Server.  </p>
  
  <p>That is not awesome. </p>
  
  <p>Is there a safe way to cast it to an int in a select query so we don't have to manage every whim of SQL Server in our ODBC Wrapper?</p>