alter a table column and set identity from max existing in that column in sql server 2008 -

-

i have column maxcode name, in mytable filled before,now want alter column , set type identity start max number existing in column maxcode

use below code reset seed value identity column

declare @newseed numeric(10) select @newseed = max(maxcode) mytable dbcc checkident (mytable, reseed, @newseed)

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

c# - Can I intercept a SOAP response in .NET before a content type binding mismatch ProtocolException? -

-
i trying debug c# code wrote consume web service. i'm hitting error when receiving response because content type of response doesn't match binding. exception snippet: an exception of type 'system.servicemodel.protocolexception' occurred in mscorlib.dll not handled in user code additional information: content type text/xml of response message not match content type of binding (application/soap+xml; charset=utf-8) the web service external can't change on end. know there lot of troubleshooting steps can take besides (and have tried many, it's not simple changing binding), there way view response message, or more info response, before hit exception? have custom message inspector written afterreceivereply method in it, exception occurs before method hit.
Read more

css - Can I use the :after pseudo-element on an input field? -

-
i trying use :after css pseudo-element on input field, not work. if use span , works ok. <style type="text/css"> .mystyle:after {content:url(smiley.gif);} .mystyle {color:red;} </style> this works (puts smiley after "buu!" , before "some more") <span class="mystyle">buuu!</span>a more this not work - colors somevalue in red, there no smiley. <input class="mystyle" type="text" value="somevalue"> what doing wrong? should use pseudo-selector? note: cannot add span around input , because being generated third-party control. :after , :before not supported in internet explorer 7 , under, on elements. it's not meant used on replaced elements such form elements (inputs) , image elements . in other words it's impossible pure css. however if using jquery can use $(".mystyle").after("add smiley here"); api docs on .after to ...
Read more