if exixts in sql

Dec 4 2012 1:40 AM

if exists ( select vAdmissNo,vRegNo FROM tblAdmission where vAdmissNo = '"+11+"' AND vLateral='"+Yes+"' ) error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ')'.

Answers (2)

how to add filter on table in sqlserver 2000...

how to use(or) create int identity in stored procedure