I got it....

thank you.....

here you added the new column and added the identity for that column. BUT my question is i already having the table with all the fields. i need to change...

HI,

I am using the database thru java. I need to insert the rows in to the tables that time i need to use the identity. i can get the max...

please let me know how to automate this process.

When table having the primary key and constraints we cant use the alter table

alter column [column] statement.

i have 150 table. when i delete the relation and can create...

Thanks folks...... it has helped me...

Hi All... thanks for your reply....

finally i got it.... i did not do any changes... i removed some columns and added once again in the query... its working fine.....

now i...

i set the QUOTED_IDENTIFIER OFF and i tried... but no use...

i removed the recurrence_type and recurrence_interval from the above query then it is executing. but i need these two columns....

Hi all.... thanks for your reply...

i am executing this quey in the stored procedure...

i have taken like DECLARE @v_sql VARCHAR(8000);

when i am trying to set the string as...

Hi Chirag!!!

thanks for your reply.....

here find my comments....

SET @v_sql = 'SELECT a.[appointmentslot_id], a.[slot_type], u.[display_name] as slot_type_desc, '+

'a.[start_time], a.[location_id],...