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

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

python - Terminate a gnome-terminal opened with subprocess -

-
using subprocess , command ' gnome-terminal -e bash ' can open gnome-terminal desired (and have stick around). done either p=subprocess.popen(['gnome-terminal', '-e', 'bash']) or p=subprocess.popen(['gnome-terminal -e bash'], shell=true) but cannot close terminal using p.terminate() or p.kill() . understand, little trickier when using shell=true did not expect run problems otherwise. to terminate terminal , children (in same process group): #!/usr/bin/env python import os import signal import subprocess p = subprocess.popen(['gnome-terminal', '--disable-factory', '-e', 'bash'], preexec_fn=os.setpgrp) # here... os.killpg(p.pid, signal.sigint) --disable-factory used avoid re-using active terminal can kill newly created terminal via subprocess handle os.setpgrp puts gnome-terminal in own process group os.killpg() used send signal group
Read more

c++ - convert unicodestring to string in xrad studio -

-
i have problem in "rad studio 10 seattle" trying text input tedit object , errormessage saying e2034 cannot convert 'unicodestring' 'string' my code follows: this->shopvar->adddog(edname->text, strtoint(edage->text), "male", "dogspecial"); this function adddog takes (string, int, string, string) when try send text tedit object edname->text errormessage mentioned earlier. my question follows, can make convertion on edname unicodestring string or have change datatype of parameterlist? if so, how do it? have been searching issue have not found similar problem. you need convert unicodestring data ansi first, pass instead. easiest way assign unicodestring ansistring (or derivative) first, , use c_str() method char* pointer, std::string accept: this->shopvar->adddog(ansistring(edname->text).c_str(), ...); if possible , maybe consider rewriting shopvar class use std::wstrin...
Read more