Saturday, June 13, 2015

sqlserver Cannot specify a column width on data type int

error:
Msg 2716, Level 16, State 1, Procedure dummy_ins, Line 2
Column, parameter, or variable #1: Cannot specify a column width on data type int.

Problem :
i have created a stored procedure in sqlserver and accidently i have define size of int

create procedure dummy_ins
(
@vid int(30),





Solution:
Remove the size of int datatype or use nvarchar type.
Error of the Level 16 are caused by the user and can be fixed by the SQL Server user.

No comments:

Post a Comment

web stats