Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   how to create triggers with tables having no common coloumns (http://www.go4expert.com/forums/create-triggers-tables-common-coloumns-t10073/)

jitupatil_2007 16Apr2008 18:08

how to create triggers with tables having no common coloumns
 
hi friends i am new to this forum and i want to create a trigger which would read one record from the 1st table match that appropriate digits from the 2nd table and on matching it would save those records in new table and these records will be deleted from second table so that when i search with the new record i won't get the redudant data but the problem i am facing is i am having the tables with no common coloumn in either of the tables and no primary key in any of the table so can any one help me please....


All times are GMT +5.5. The time now is 22:19.