I just doit; now 10 minutes I have deployes my link exchange community application; in this moment it will be avaible only for my site visitors, no SEO for this, but you can view and test the process of link exchange; Free, simple, and lovely to use, this application comes instead of paba project that was lost because, probably, the involved number of persons/visitors/editors was to small - it was concepted for a little community; here the community will be contain anyone who wants to get into it. Enjoy it and let my know about functinalities that aren't wrking or you willl like to see there,

Do you need something like this? I need this many times, specially when I need to syncronize two databases or life database with demo database. So..this is simple, you have to write a common insert command and other two lines, for ignoring, on insert time the identity column:

SET IDENTITY_INSERT [table_name] ON

insert into [table_name] (id, name, ...) values (99,'popnadrian')

SET IDENTITY_INSERT [table_name] OFF

And you made a "nice" work, your boss must be proud by you

Usefull and funny resources for SQL

Use delete with join

http://www.sqlservercentral.com/Forums/Topic493913-338-1.aspx

DELETE px
FROM #prodextend px
INNER JOIN #product p ON p.din = px.din
AND p.pkgSize = px.pkgSize
INNER JOIN #manu_clients mc ON mc.clientCode = p.clientCode

How to use in join in Update command

http://www.bennadel.com/blog/938-Using-A-SQL-JOIN-In-A-SQL-UPDATE-Statement-Thanks-John-Eric-.htm

UPDATE
b
SET
b.is_stud = 1
FROM
@boy b
INNER JOIN
@relationship r
ON
b.id = r.boy_id
INNER JOIN
@girl g
ON
(
r.girl_id = g.id
AND
g.name = 'Winona Ryder'
);

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100415