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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gummadi
  • Order by date
  1. gummadi

    How to make all stmnts. in a TRIGGER execute regardless of an error

    Hi bobyjose,<br><br>I think your problem will be solved if you you use join statement to eliminate the rows that voilating referential<br>integrity.<br><br>If insert is into same table which is having trigger,then <br>join statement will not useful.but if if you are inserting into another we can...
  2. gummadi

    cascade delete

    Hi,<br>yes,you are right Jerm, we are having&nbsp;&nbsp;cascade delete option in <br>SQL SERVER 2000. <br><br>gummadi<br><br>
  3. gummadi

    cascade delete

    Hi,<br>There is no cascade delete option in sqlserver . we have to handle it with triggers. Even the foriegnkey relation has to maintained using trigger rather than using foriegn constraint because when i had written a trigger for cascade delete i found that forien key is getting fired...
  4. gummadi

    Can I do an IF inside a SELECT, or else how do I do this query? help!

    Hi,<br><br>&nbsp;Take out the total ---<br>... WHERE (dbo.tblItemNumber.itemnumberlistID = @pItemNumberListID OR<br>dbo.tblItemNumber.itemnumberlistID IS NULL)<br>--- condition from your selct statement ,because you want select row&nbsp;&nbsp;irrespective of whether it is null,matching or not...
  5. gummadi

    Using VBScript with SQL

    Hi,<br><br>SQL= &quot;SELECT LNK_NM, LNK_DSPL FROM EPIC_LINK WHERE LNK_USER = '&quot;&UserID&&quot;'AND LNK_NM = '&quot; & name&&quot;'&quot;<br><br>gummadi
  6. gummadi

    SQL 6.5 ??? How to Modifying colunm properties???

    alter table a alter COLUMN a VARCHAR(3)
  7. gummadi

    How do you refer a field which is a part of a composite primary key

    Hi,<br>I tried to apply<br>2)create table referinteger(a int references integer(a, b))<br>after creating <br>1)create table integer(a int,b int,primary key(a,b)) <br>i am getting an below error<br><br>Server: Msg 8140, Level 16, State 1, Line 1<br>More than one key specified in column level...
  8. gummadi

    Problem editing or updating database from client machine

    Hi<br><br>Check if your are upadating primary key column referenced in other tables<br><br><br>Gummadi
  9. gummadi

    How do you refer a field which is a part of a composite primary key

    Hi,<br><br>It is not possible to reference a part of composite primary key.because a foreign key can created only if referenced column is unique or a primary key.<br>so if you want to reference a part of composite key ,you should have unique constraint on it or you have to reference whole part...

Part and Inventory Search

Back
Top