Hi,

You have half understtod my problem.

my requirement is select all record from candidates table and and only those records from qualification table who are graduate and if any candidate is...

Hi,

Thanks a lot.

It has also help me clear my concept.

Hi,

Thanks a lot for advice.

Like you mention,that you would add transaction and error handler,how will you go about it ?I just need a proper structure of it.

Thanks

Hi,

Listen, I am not passing value to empid which is identity(1,1).

Fname and Lname are not null,but when null value pass,it accept it and do not throw any error.

Try to understand...

Hi,

It should not accept null values.Now it does and do not return any value and record get save.

It should not accept null values at all.

Hi,

You can assume anything.Though structure of my table is

CREATE TABLE [emp] (

[empid] [int] IDENTITY (1, 1) NOT NULL ,

[Fname] [varchar] (100) NOT NULL ,

[Lname] [varchar] (100) NOT NULL...