Update Null Value in Integer (Forign Key)

[nomi2000]

How can i update Null Value in an Integer(Forigen Key) through stored proc
i can do this if the field is varchar by Convert() but how in intger field?
help
nouman

 

[Psychpt]

alter table [tablename]
alter column [columnname] [new data type or keep the same] [NULL]

HTH

 

[nomi2000]

Dear Psycht
i want to update the value to null(in a Forign Key) not update the column data type
Regards
Nouman

 

[foxdev]

[tt]Update MyTable
set MyColumn = NULL
where MyKeyColumn = MyKeyValue[/tt]
Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org