sql server - drop and create a synonym while using select * sys.synonyms with a case statement -


i using following code drop , create synonyms in database. 

select * sys.synonyms  drop synonym database1.btxaddr; drop synonym database1.btxsupb; create synonym database1.btxaddr   database2.da2.btxaddr;   create synonym database1.btxsupb  datebase2.da3.btxsupb;  truncate table database2.da2.btxaddr; truncate table database2.da3.btxsupb; insert database2.da3.btxsupb select * database2.da2.btxsupb;

the problem having have differnt folders want synonym point to. folders da1, da2, da3. synonym da pointing @ da1. want have if statement looks pointing change pointer da2 , da3 , da1 when need change them.

i have read lot of posts on here , can change synonyms myself. save me time in long run need change it.

this need , makes easeier. 

declare @synname varchar(100), @syntarget varchar(150)  declare syns cursor select  base_object_name   sys.synonyms    name in ('btxaddr', 'btxsupb')  open syns fetch next syns @synname, @syntarget while @@fetch_status <> -1 begin  print 'drop synonym ' + @synname  set @syntarget = case                     when @syntarget '%[da2]%' replace(@syntarget,'[da2]','[da3]')                    when @syntarget '%[da3]%' replace(@syntarget,'[da3]','[da1]')                    when @syntarget '%[da1]%' replace(@syntarget,'[da1]','[da2]')               end  print 'create synonym ' + @synname + ' ' +@syntarget  fetch next syns @synname, @syntarget end close syns deallocate syns

i'm posting came incase else has same issue wont have go through trouble have gone through.


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more