摘要： select to_char(sum(decode(currency, 'USD', amount * 1.0000, 'THB', amount * 0.029403, 'HKD', amount * 0.129017, 'PHP', amount * 0.020661, 'IDR', amount * 0.0001, 'VND', amount * 0.000056, 'KRW', amou... 阅读全文

摘要： set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[SP_CreateData_Demo]ASdeclare @a intset @a=1beginwhile @a<45000begininsert into Person_User_Info(PersonID,UserCode,UserPassword,Depa... 阅读全文