Calling SQL guys, HELP

[Kakateyudu]

Oka table vundhi [b]kakateyudu[/b] ani......  aa table lo oka field vundhi [b]code[/b] ani......

aa [b]code[/b] ki konni constraints vunnai, like oka 4 values vunnai, we can only insert one of those values into that kakateyudu table inthat code field...... 

aa four values ki nen inkoka value add cheyyali.......  sCo_^Y sCo_^Y sCo_^Y sCo_^Y


CITI#H@ CITI#H@ CITI#H@ CITI#H@

nen asale chala eek  &*B@ &*B@ &*B@ &*B@ &*B@

[Kakateyudu]

CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

[ammulu]

[quote author=Kakateyudu© link=topic=212708.msg2606206#msg2606206 date=1310742753]
CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@
[/quote]

CITI#H@ CITI#H@ CITI#H@ CITI#H@ pm choodu

[Hitman]

CHECK Constraint ni modify cheyyalemu anukunta.. Just drop and create a new check.

[Kakateyudu]

[quote author=ammulu link=topic=212708.msg2606219#msg2606219 date=1310742842]
CITI#H@ CITI#H@ CITI#H@ CITI#H@ pm choodu
[/quote] S#d^ S#d^ S#d^ S#d^ S#d^  replied

[satti from attili]

CITI#H@ CITI#H@ CITI#H@

[tharanga]

CITI#H@ CITI#H@ CITI#H@ CITI#H@

[satti from attili]

[quote author=ADHIPATHI link=topic=212708.msg2606227#msg2606227 date=1310742914]
CITI#H@ CITI#H@ CITI#H@ CITI#H@
[/quote] CITI#H@ CITI#H@ CITI#H@ ane badulu cheppochu ga  CITI_c$y CITI_c$y CITI_c$y

[Kakateyudu]

[quote author=Hitman link=topic=212708.msg2606223#msg2606223 date=1310742887]
CHECK Constraint ni modify cheyyalemu anukunta.. Just drop and create a new check.
[/quote]

drop aa evadevadu use cheskuntunnado aa table.....  sFun_duh sFun_duh sFun_duh  danni CHECK constraint antara mama....

no way na add cheyyatam without drop  sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[Kakateyudu]

[quote author=satti from attili link=topic=212708.msg2606233#msg2606233 date=1310742955]
CITI#H@ CITI#H@ CITI#H@ ane badulu cheppochu ga  CITI_c$y CITI_c$y CITI_c$y
[/quote]

*7*^ *7*^ *7*^ *7*^ *7*^  dorli dorli navve badulu nuvvu seppochu ga

[tharanga]

[quote author=satti from attili link=topic=212708.msg2606233#msg2606233 date=1310742955]
CITI#H@ CITI#H@ CITI#H@ ane badulu cheppochu ga  CITI_c$y CITI_c$y CITI_c$y
[/quote]naaku ans teliste nene cheppevaadini [img]http://www.tollywoodinfo.com/discus/clipart2/ntr_style2.gif[/img]

[satti from attili]

[quote author=Kakateyudu© link=topic=212708.msg2606236#msg2606236 date=1310742996]
*7*^ *7*^ *7*^ *7*^ *7*^  dorli dorli navve badulu nuvvu seppochu ga
[/quote]naku vasthe  CITI#H@ CITI#H@ CITI#H@ ani endhuku pedutha  CITI_c$y CITI_c$y CITI_c$y

[Ranga_The_Donga]

INSERT INTO Kakateeyudu (code)
VALUES (6)


ila run chesthe emani error vasthundhi???? sCo_^Y sCo_^Y sCo_^Y

[satti from attili]

[quote author=ADHIPATHI link=topic=212708.msg2606240#msg2606240 date=1310743018]
naaku ans teliste nene cheppevaadini [img]http://www.tollywoodinfo.com/discus/clipart2/ntr_style2.gif[/img]
[/quote] F@!n F@!n F@!n F@!n F@!n F@!n

[JUJUBI_JULABI]

Script out the constraint from SSMS or even script out the create table , u will see the constraint there , then add ur modifications and then drop and re create the constraint.