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.
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