Matthew Cushing (5/21/2013)

---

Sean Lange (5/21/2013)

---

If you track only the "old" value you have the complete history. The value it was changed to is either in the next audit row or...

tknecht 32495 (5/21/2013)

---

Insert was actually the first thing I tried. This is my insert statement using the actual table and column names:

insert into Component (CmpnentID) values (8001090000) where KitID...

You can find Jeff's tally table article here.

http://www.sqlservercentral.com/articles/62867/%5B/url%5D

tknecht 32495 (5/21/2013)

---

The searching I've done for doing what I need suggests using an update statement to add information to an existing table. I was lead to believe that...

Matthew Cushing (5/21/2013)

---

Thanks for replying. CDC was our first thought, but it doesn't have the data that was changed. This is a system that keeps track of who...

Then you need to...

I looked and looked at your original...

Hi and welcome to the forums. It sounds like you need some help with an update (or maybe an insert). From what you posted you are not likely to get...

And be VERY VERY careful if you use the dynamic sql approach to protect yourself from sql injection. NEVER run a dynamic string that has user entered content as part...

The next thing you should do is to stop storing SSN in clear text. Get that stuff encrypted!!!!

Matthew Cushing (5/21/2013)

---

I'm curious if there is a built in way or a best practice that allows for recording changes in tables without having to create a history table for...

I would fight back hard on that one. It is irresponsible to store SSNs in clear text. Would you store credit...

Take a look at this article.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

Hi and welcome to SSC. Can you turn this into readily consumable ddl (create table statements) and sample data (insert statements)? This can absolutely be done without a cursor but...

softwareeng2010 (5/20/2013)

---

hi all,

i want to convert database diagram to script in sql server 2012,how?someone told me to check Definition field in sysdiagrams, but couldn't find anything

hope u can...