title: I can not declare bigint variable
body: <p>In Sql server I can't declare a variable with <em>bigint</em> data type. My <em>Mobile</em> column has <em>bigint</em> data type. it's give me error <em>varchar</em> not convert to <em>bigint</em> when i use procedure. </p>
  
  <p>When i write <code>Mobile=cast(@Mobile as varchar)</code> it works fine</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[Get_Suggestion]
          @FirstName varchar(255),
          @MiddleName varchar(255),
          @LastName varchar(255),
          @Mobile Bigint
  
  AS
  BEGIN
   SELECT
      *
       FROM dbo.Contacts
       WHERE
       (
         Mobile =@Mobile 
       )
  END
  </code></pre>
  
  <p><strong>Table Structure</strong> </p>
  
  <pre><code>DROP TABLE [dbo].[Contacts]
  GO
  CREATE TABLE [dbo].[Contacts] (
  [ContactId] int NOT NULL IDENTITY(1,1) ,
  [Name] varchar(100) NOT NULL ,
  [FamilyHeadId] int NULL ,
  [Addressold] ntext NULL ,
  [Mobile] bigint NULL ,
  </code></pre>
  
  <p><em>Calling</em></p>
  
  <pre><code>Get_Suggestion 'John','Doe','Patel',999999999
  </code></pre>