You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
11 lines
396 B
11 lines
396 B
--更改使用者帳號登入資料
|
|
--Select * From OTB_SYS_Members;
|
|
update OTB_SYS_Members Set Password ='2DGZp2Lo0F2YF13i/sp6VA=='
|
|
|
|
--更改客戶資料
|
|
--Select * From OTB_CRM_Customers
|
|
--Select * From OTB_CRM_Contacters
|
|
Update OTB_CRM_Customers Set Memo = '' , Address = '*****' + Right(Address, 8)
|
|
Update OTB_CRM_Contacters Set Email = 'brucekai@gmail.com', Memo = '', Password ='2DGZp2Lo0F2YF13i/sp6VA=='
|
|
|
|
|