I think i know how to perform the spaces now i tried it on an insert into can we perfrom this on an insert Into statement

So for a statement...

First of all thanks for the scripr and i ran it this way as shown below but the company name and confidential are diaplyed together can i insert a break...

how can i accomplish that can we declare without creating a procedure in sQL. I hae somefamiliarilt with PL/SQl procedures but not SQL server which is partly why i am...

Thanks for the script but my problem is that i have to check if column A exists than add BCD if B exists add ACd and so on, and there...

Thanks the Merge was really helpful, will use it

thanks again

no there are no fancy columns, and i do get the inserted message, May be i should show the table info after the insert to show me the insert results....

I think i got it the problem was that

on the else statement where the insert is specified i had to have [] specified for every column instead of simply...

I get an error with the begin end as well

Msg 156 level 15 state 1 line 7

Incorrect syntax near the keyword Else

Msg 102 level...

does anyone have any idea about this or can point me somewhere

oh by the way i now know a way to create update statements for all the tables...

now i know that i can combine the two procedurs but yet to come up witha way to update all the XXXID's in the datbase with the new XXXID's...

i didnot have the where clause in select which is why it was not working

If exists

(Select * from departments where XXID = 106 and XXID = 20)

Update Departments...

Is there a way we can create a procedure and call it in a script that would be a neat thing to learn please let me know if anyone...

Also i used the trycatch on alter table as shown below and got an error as

Msg 2705, Level 16, State 4, Line 240

Column names in each table must be...

Thanks that works with the try and catch, I am creating a bunch of tables and wonder if i have to define a try catch for every create statement, is...

just trying to add a column ( for eg title to table person and update its values ), sorry for the confusion I think i found the way for try...