June 19, 2008 at 11:03 am
Hi,
I need to write a SP which is used to find the old email id which we pass and replace with the new email id which we will give.
Tbl_data is table name and here the col name is email_id,
for eg: if i pass the old mail id as anja@test.com it should find this email id and replace with john@test.com
Pls can anyone give the stored procedure to do this,i am also trying.
Its my humble request.pls
Waiting for ur kind reply
June 19, 2008 at 11:27 am
Can you show an attempt. We are seeing more and more test or interview questions and we don't want to give you the answer, we want to help you learn.
show some work, we'll help point out issues.
June 19, 2008 at 11:31 am
Hi steve,
Actually i am a dba,i have adminstration,but i dont know development so only i am asking u.Pls help
June 19, 2008 at 11:38 am
This was a cross-post. Answers there too:
http://www.sqlservercentral.com/Forums/Topic520048-338-1.aspx
Please don't cross-post.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply