Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mitrab22
-
Is there an easier way to handle this Replace method?
Why can't u use the substring function?- mitrab22
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Constraint / primary key question
What DBMS are you using? You can use something like this: This works for Oracle It should work on SQL Server too, but never tested it. ALTER TABLE ChildTable ADD ( CONSTRAINT R_123 FOREIGN KEY (Key_Name) REFERENCES ParentTable) ;- mitrab22
- Post #2
- Forum: Microsoft SQL Server: Programming
