Good question, thanks.

Thanks for the question. I fell for the trick and got it wrong, but now I know why.

Thanks again!

- webrunner

Lowell (12/9/2014)

---

i think it's a scope issue.

it looks like technically there are two [myuser] users, in two different databases.

they only get JOINED to be the same person when you use...

Thanks for your reply!

First, some additional info.

1. It is definitely a table, not a view.

2. I did get back the user 'mylogin' with the suser_name() query that you suggested.

3. Curiously,...

ksatpute123 (12/1/2014)

---

You can start with this:

http://blog.sqlauthority.com/2007/12/26/sql-server-truncate-cant-be-rolled-back-using-log-files-after-transaction-session-is-closed/

http://www.sqlservercentral.com/Forums/Topic1488704-391-1.aspx

If you are a beginner then you need to understand how DELETE, DROP and TRUNCATE work instead...

Great question, thanks!

- webrunner

"3114 B.C. is the start of the Mayan calendar."

I wonder whether the Mayans used "May-SQL" 😀

- webrunner

Really cool. Thanks!

- webrunner

ianstirk (11/16/2014)

---

Hi

Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or...

Thanks for this reply!

I'll review your suggestions and come up with a design. I see what you mean about tracking the history/auditing can be treated separately.

The particular problem I have...

Thanks for this! But why select the top 22 only?

- webrunner

Thanks for the question. However, something about the list of radio button options made me think the only option worth picking was that the queries give the same result, which...

I know! I...

Thanks, Steve, for this editorial.

To me it seems that cost is a big factor along with the relevant features of each platform. I think as far as relational database platforms,...

martin-705756 (10/13/2014)

---

I'm ready to be corrected, but I'm pretty sure it's only non-MSSQL servers.

This is because you can't directly query MYSQL (or other SQL flavours) with MSSQL server syntax -...