UPDATE [EU_PackageDevelopment].[dbo].[SSCUnitholderTable]
   SET [SSB_Fund_Num] = 'SSB_Fund_Num, nvarchar(8)',
      [Fund_Name] = 'Fund_Name, nvarchar(255)',
      [Date_From] = 'Date_From, date',
      [Date_To] = 'Date_To, date',
      [Basis_Ind] = 'Basis_Ind, nvarchar(8)',
      [Share_Class_Name] = 'Share_Class_Name, nvarchar(255)',
      [Beg_Bal] = 'Beg_Bal, numeric(31,11)',
      [Beg_Bal_Units] = 'Beg_Bal_Units, numeric(22,10)',
      [Apps] = 'Apps, numeric(22,10)',
      [Apps_Units] = 'Apps_Units, numeric(22,10)',
      [Redem] = 'Redem, numeric(22,10)',
      [Redem_Units] = 'Redem_Units, numeric(22,10)',
      [Dist_Redem] = 'Dist_Redem, numeric(22,10)',
      [Dist_Redem_Units] = 'Dist_Redem_Units, numeric(22,10)',
      [End] = 'End, numeric(31,11)',
     [End_Units] = 'End_Units, numeric(22,10)'
 WHERE <'Search Conditions,,'>
GO

quote:

---

Originally posted by visakh16

update the columns names in the table
sounds like what you need is
sp_rename

http://msdn.microsoft.com/en-us/library/ms188351.aspx

make sure you find all reference of the column nad reflect changes once you do the name change otherwise dependent objects like view, procedure etc will break

---

quote:

---

Originally posted by bandi

quote:

---

Originally posted by visakh16

update the columns names in the table
sounds like what you need is
sp_rename

http://msdn.microsoft.com/en-us/library/ms188351.aspx

make sure you find all reference of the column nad reflect changes once you do the name change otherwise dependent objects like view, procedure etc will break

---

Hi Visakh,
I guess he wants to update column values...
By looking at UPDATE posted by OP, he chosen UPDATE statement from SSMS....

--
Chandu

---