Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hameed
Starting Member
40 Posts |
 Posted - 2001-05-30 : 07:15:25
|
| I want to set up a stored procedure in SQL Server 7 that goes through all the records in a table (7000 records and growing), checks the first leftmost seven characters in a particular column and if the string made up of those seven characters is not http:// then update that record (specifically that field so that http:// is appended to the left of the field value). I want to run this only once on the new data, after that I will handle this from an input form for any new records that are added to the table. This is the initial data load that I uploaded from a access table and I want to clean up the data. |
|
|
|
|
|
updating all records in table