Every change is logged in the transaction logged. That allows point-in-time restores and rollbacks.

CREATE TABLE rollbacktest( id int);

INSERT INTO rollbacktest

SELECT database_id FROM sys.databases;

BEGIN TRAN;

TRUNCATE TABLE rollbacktest;

DROP TABLE rollbacktest;

ROLLBACK TRAN;

SELECT...

sqlfriends@sql.com (1/28/2016)

---

Hi Team,

I have the below requirement my table has the below data

TABLENAME - SOURCE

EMPID ENAME DEPARMENT

1 XXX ...

This might be overkill, but storing a table with valid date formats could work. You can simplify the list or increase it as needed. You could even store lengths and...

That should be done in the front end, otherwise you risk the possibility of reordering the rows and losing any way of defining which job relates to which invoice.

Here's the...

You should try to search for articles about the problems defined as "gaps and islands". There are plenty of them on the internet which might help you to understand the...

mjakachira (1/27/2016)

---

Tried that and it didn't like the syntax. Going to keep trying I think i get it but any ideas?

Also when I just use UNION it does the same...

ScottPletcher (1/26/2016)

---

Luis Cazares (1/26/2016)

---

Manic Star (1/26/2016)

---

So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached...

Manic Star (1/26/2016)

---

So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached the plans at...

Eric M Russell (1/26/2016)

---

Luis Cazares (1/26/2016)

---

Eric M Russell (1/25/2016)

---

Luis Cazares (1/6/2016)

---

Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this:...

Eric M Russell (1/25/2016)

---

Luis Cazares (1/6/2016)

---

Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this: http://i.imgur.com/shDmF0L.jpg

I hope I don't offend...

Brandie Tarvin (1/26/2016)

---

TomThomson (1/25/2016)

---

I see the same. Plus in the EU it's probably illegal to host the...

Ed Wagner (1/25/2016)

---

Hugo Kornelis (1/25/2016)

---

Ed Wagner (1/24/2016)

---

jonathan.crawford (1/23/2016)

---

Uh, how does one go Hand-To-Hand, exactly? Were you cramming pellets down someone's throat? I can also envision you sneaking around with...

prosciutto

Would something like this work for you? I'm removing the loop and using a different method to concatenate as explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET NOCOUNT ON

declare@command...

Eirikur Eiriksson (1/25/2016)

---

JustMarie (1/25/2016)

---

The ONLY business reason I can think of for this situation is a legal requirement that there be no gaps in the numbering. There's a vague...