The question sounds like you want to create an audit table. Like J Livingston pointed out, this is a SQL Server forum.

MotivateMan1394 (3/11/2016)

---

Thank you all

And dear Lynn Pettis :

The big question here, is this something your employer is tasking you to accomplish or are you just trying to find a way...

cory.bullard76 (3/11/2016)

---

Curious on how to go about writing a multiple argument is null. For example....

If Field A is null then field B if field B is null then field C...

This is an important question to be answered. Without the scan type, I...

Eirikur Eiriksson (3/11/2016)

---

Very quick on Azure, only caveat is that...

J Livingston SQL (3/12/2016)

---

suggest you try it 🙂

UPDATE #yourtable

SET c4...

Like Grant said, this isn't much to go on. I've never virtualized SQL before, so I don't consider myself qualified to address that part. I'm going to start...

Easter Egg

Alan, I stand corrected. I've never seen it done this way. I learned something new, so thank you.

I hope you're planning on doing some serious index maintenance after all this shrinking. Shrinking data files tends to fragment indexes to 99%, so it will be necessary.

You may already know this, but having that leading wildcard in the search will prevent SQL Server from using an index on that column, so your query is going to...

You need one check constraint for each column.

Ski

TomThomson (3/11/2016)

---

I think we're in an impossible situation here. Anything we do is either wrong from a short term language design point of view or just not feasible except...

TomThomson (3/11/2016)

---

Ed Wagner (3/11/2016)

---

Jeff Moden (3/11/2016)

---

TomThomson (3/11/2016)

---

Certainly we want to get the numbering added to this splitter in SQL 2016, but we ought to find way of avoiding treating...