论坛 › SQL Server › 自动处理SQL Server 2005表格数据

liuxiaoyun111 发表于 2018-10-16 06:46:24

自动处理SQL Server 2005表格数据

　　Update Contact SET>　　Update Contact SET FirstName =Ltrim(RTrim( FirstName))
　　Update Contact SET MiddleName =Ltrim(RTrim( MiddleName))
　　Update Contact SET LastName =Ltrim(RTrim( LastName))
　　Update Contact SET Suffix =Ltrim(RTrim( Suffix))
　　Update Contact SET EmailAddress =Ltrim(RTrim( EmailAddress))
　　Update Contact SET Phone =Ltrim(RTrim( Phone))
　　Update Contact SET PasswordHash =Ltrim(RTrim( PasswordHash))
　　Update Contact SET PasswordSalt =Ltrim(RTrim( PasswordSalt))

查看完整版本: 自动处理SQL Server 2005表格数据