Hello there,I am having a table named as example:Columns are: ID, Name, qs1, qs2, qs3Now I want run a T-Sql which will delete data from from qs1, qs2, qs3; not from ID, Name.E.g.:----------------------------ID | Name | qs1 | qs2 | qs3---------------------------- 1 | John | 1 | 3 | 5 2 | Dave | 1 | 3 | 5----------------------------
After running the T-Sql, the result should be shown as:--------------------------------ID | Name | qs1 | qs2 | qs3-------------------------------- 1 | John |<Null>|<Null>|<Null> 2 | Dave |<Null>|<Null>|<Null>--------------------------------
Hope I can make you understand my problem.Regards,DaipayanSoftware Programmer
Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F
Delete Particular Column in a Row
Posted - 2010-12-29 : 01:31:49
