CREATE TRIGGER tr_person_setPersonID ON person AFTER INSERT AS DECLARE @newid int SET @newid = (select max(P.person_id) + 1 FROM person P JOIN inserted i ON i.study_id = P.study_id WHERE p.study_id = ...

I'm trying to re-order a bunch of rows based upon user preference. For example I have 10 row. There is a column called order_id that gives each row an id from 1-10. I want to be able to do things like ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...