thanks for all the help wietzera,i think i will figure out a way to do the same procdure with a try

thanks again for the help

i think i have found the answer but i am not entirely sure what is being asked by DAve, all i am tryin to do is add a column...

hey i think i got it it works when we reverse the order but the update is not performed so we can use a

Begin and an END ?? would...

IF EXISTS(SELECT NULL FROM sys.columns WHERE [name] = 'x' AND OBJECT_NAME([object_id]) = 'b')

UPDATE b

SET X = 'some values'

ELSE

ALTER TABLE x ADD x varchar(2000) NULL

I wanted to do more...

When i used

IF EXISTS(SELECT NULL FROM sys.columns WHERE [name] = 'x' AND OBJECT_NAME([object_id]) = 'b')

ALTER TABLE x ADD x varchar(2000)...

all i need to do is to strip out any html tags from all the colums in the db entered by croos site scripting. i know that there is a...

thanks

i am a newbie to this could u please guide me as to how i would do this, for example i want to check the login table and...

Has anyone using coldfusion has encoountered this situtation before any help would be really appreciated

thanks

I am using coldfusion

thanks

Sorry if i was not descriptive enough but what i want to know is when the password is stored in the login table as of now the DBA can see...

Thanks all works perfectly thaks again

From the results ?? do you mean that after i run the script i take the reults and run the script again ??

thanks

hey so the query shows that it did alter the bit columns to allow nulls but then when i look inside the table itself the bit fields still donot...

hey i do have a question, u have where system_type_id = 104, I am thinking that this ID of 104 specifies bit,what specifies NText, As i think if i...

Thanks that works thank you so much