Syntax error near keyword check

[Sid244]

I am tyring to find the correct syntax for a check inside my stored procedure.

@ID as check

Any thoughts, please.

 

[SQLDenis]

What are you trying to check
errors? use @@error, check is a keyword and can not be used like that

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Sid244]

I have a check box that I am trying to update in an Mdi form. In my stored procedure I am linking the information from the new form with the parent program. In the new window there are some check boxes and I want to relay that information back to the DB as whether it is checked or not.

@Name as nvarchar(50),
@HasID as check,
@Date as datetime,

[what is the correct keyword in a stored procedure for a check?]

 

[Sid244]

It is supposed to be

@whatever as bit

not

@whatever as check

Sorry for the confusion.

 

[SQLDenis]

Aha, you would use a bit data type, 2 possible values 1 or 0 (and NULL of course)


@Name nvarchar(50),
@HasID bit,
@Date datetime,

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Sid244]

Yep, thanks for the help though.