Error: Can not find data type long

Navigation
2

I'm trying to create a procedure in SQL Server 2012, but it's giving the following error in signing it. 

Mensagem 2715, Nível 16, Estado 3, Procedimento MINHAPROCEDURE, Linha 6
Column, parameter, or variable #1: Cannot find data type long.
Parameter or variable '@IDCatOrigem' has an invalid data type.
Mensagem 2715, Nível 16, Estado 3, Procedimento MINHAPROCEDURE, Linha 6
Column, parameter, or variable #2: Cannot find data type long.
Parameter or variable '@IDCatDestino' has an invalid data type.

CREATE PROCEDURE MINHAPROCEDURE
    (@IDCatOrigem [long], 
    @IDCatDestino [long])
AS
BEGIN

I have tried without the parentheses, without the brackets and nothing ... How do I create a procedure with input parameters?

    
asked by anonymous 27.09.2015 / 17:24

2 answers

3

The long type does not exist in SQL Server. Use bigint .

    
27.09.2015 / 17:30
2

See what the error says

  

Column, parameter, or variable # 1: Can not find data type long.
  Parameter or variable '@IDCatOrigem' has an invalid data type.

The long data type does not exist in SQL Server, the equivalent is the type bigint .

    
27.09.2015 / 17:30
My code from my jquery cycle 2 slide does not work. I wonder where the error is? 1px Unwanted Space in Internet Explorer