ÇósqlÓï¾ä

Êý¾Ý¿âÖР   en_url
http://www.shuangyongjulebu.com/yikatongBulletin.aspx?bl_Id=118
¸ÄΪ

http://www.shuangyongjulebu.com/yikatong/Bulletin.aspx?bl_Id=118


SQL code:
CREATE TABLE [info_É̼Ò] (
[en_Id] [int] IDENTITY (1, 1) NOT NULL ,
[en_Pic] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[en_Name] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[en_Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[en_Url] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[cabg_Id] [int] NULL ,
CONSTRAINT [PK_info_É̼Ò] PRIMARY KEY CLUSTERED
(
[en_Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO

---

SQL code:
select substring(en_url,len('http://www.shuangyongjulebu.com/yikatongBulletin.aspx?bl_Id=')
,10)
from info_É̼Ò
where en_url like '%shuangyongjulebu.com/yika%'




d=5205
d=5205
d=96
d=5203
d=5205
=5189
=5203
=5317
=118
=5188
=5205

---

update info_ÉÌ¼Ò set en_url = 'http://www.shuangyongjulebu.com/yikatong/Bulletin.aspx?bl_Id=118 '
where en_url = 'http://www.shuangyongjulebu.com/yikatongBulletin.aspx?bl_Id=118'

---

SQL code

---

Code highlighting prod