use hbposev9
go
delete from pbcatcol where pbc_tnam = 't_bd_item_info2'
go
delete from pbcatcol where pbc_tnam = 't_pc_branch_price2'
go
--将货号中存在小写的字母修改成大写
declare @ls_tablename varchar(50),@ls_sql varchar(500)
declare test_cur cursor for
SELECT pbc_tnam
FROM pbcatcol
WHERE pbc_cnam = 'item_no'
ORDER BY pbc_tnam
for read only
open test_cur
fetch test_cur into @ls_tablename;
while @@fetch_Status = 0
begin
set @ls_sql='update' +' ' +@ls_tablename+' set item_no=upper(item_no)'
exec( @ls_sql)
fetch test_cur into @ls_tablename;
end
close test_cur
deallocate test_cur
go
--将机构号中存在小写的字母修改成大写
declare @ls_tablename
go
delete from pbcatcol where pbc_tnam = 't_bd_item_info2'
go
delete from pbcatcol where pbc_tnam = 't_pc_branch_price2'
go
--将货号中存在小写的字母修改成大写
declare @ls_tablename varchar(50),@ls_sql varchar(500)
declare test_cur cursor for
SELECT pbc_tnam
FROM pbcatcol
WHERE pbc_cnam = 'item_no'
ORDER BY pbc_tnam
for read only
open test_cur
fetch test_cur into @ls_tablename;
while @@fetch_Status = 0
begin
set @ls_sql='update' +' ' +@ls_tablename+' set item_no=upper(item_no)'
exec( @ls_sql)
fetch test_cur into @ls_tablename;
end
close test_cur
deallocate test_cur
go
--将机构号中存在小写的字母修改成大写
declare @ls_tablename