触发器 如何截取字段中的字符串

来源：百度知道 编辑：UC知道 时间：2024/05/14 17:48:57
我想吧YX_user中的YX_UserPassWD截取中间16位数字 存储到user_id里
比方说10ADC3949BA59ABBE56E057F20F883E 存储到user_id的pass里变为
9BA59ABBE56E057

下面这个代码怎么改

use newskin
go
create trigger tr_YX_UserInfo on YX_UserInfo
for insert
as
set identity_insert [DB_9eat].[dbo].[user_id] on ;
insert [DB_9eat].[dbo].[user_id] ([id],[userid],[pass],[email])
select
[YX_UserID],[YX_User],YX_UserPassWD,YX_UserEmail
from
inserted
set identity_insert [DB_9eat].[dbo].[user_id] off ;

use newskin
go
create trigger tr_YX_UserInfo on YX_UserInfo
for insert
as
set identity_insert [DB_9eat].[dbo].[user_id] on ;
insert [DB_9eat].[dbo].[user_id] ([id],[userid],[pass],[email])
select
[YX_UserID],[YX_User],substring(YX_UserPassWD,len(YX_UserPassWD)-13,15),YX_UserEmail
from
inserted
set identity_insert [DB_9eat].[dbo].[user_id] off ;