Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by sonaliak
-
datatype change from text to varchar
i am trying to change the datatype from text to varchar for 1 column and I found that there is no Alter table command to do this so I used following steps to do it: EXEC sp_rename 'mwebattribmulti.Atmul_comment', 'holdcomm' , 'COLUMN' go alter table mwebattribmulti add Atmul_comment...- sonaliak
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
using TRANSLATE, REPLACE, DECODE with UPDATE
You can try sometthing like this Update mwebwork set Work_Description = REPLACE(work_description,'1','phase n') where Work_ID >500 and work_id <650 GO- sonaliak
- Post #2
- Forum: Microsoft SQL Server: Programming
