摘要：if object_id('T') is not null drop table Tgocreate table T(id varchar(10) primary key ,name varchar(10))go--用触发器完成create trigger tr_T_insert on Tinstead of insertasbegin declare @i int select * into # from inserted select @i=isnull(max(id),1000000) from T update # set id=right(10000... 阅读全文

摘要：一个计算外汇汇率的web服务！ 分类： 已试验成功的Web Service的具体做法！2005-08-11 08:312246人阅读评论(2)收藏举报http://www.webservicex.net/CurrencyConvertor.asmx?WSDL从当前两种流通货币中得到外汇汇率ConversionRate(FromCurrency As Currency, ToCurrency As Currency) As doubleCurrency类型为函数的一个枚举类型，其中记录了各种流通货币的代表简写，如下：AFA-Afghanistan Afghani ALL-Alban... 阅读全文