sp_help 'Tablename' should do the work.

Is there just one column DATA? Or do you mean 3 columns (or more) which may contain NULL values?

I don't have experience with that many tables, and I think it should just be tested in your environment. Also, the number of tables is limited by the server capacity,...

I would make the column NOT NULL and would try to improve your input. Of course you could do this also with a trigger or something, but I avoid myself...

I've seen the same issue when on using sql scripts on different machines. Tab settings often differ locally and that's why I would rather use spaces instead of tabs. I...

Both of these works, just figure out for yourself if the value fits better as an integer or a float/decimal.

declare @Datetime1 as datetime = getdate(),

@Datetime2 as datetime = dateadd(mi,-20,getdate())

select...

tom.weber (9/9/2011)

---

situation, I've got two tables

table 1 named team with columns teamID, name (and some other fields)

table 2 named game with columns gameID, homeTeamID, awayTeamID, date (and some other fields)

I...

It's often a good thing if you put your tembdb on a dedicated disk, for such reasons and general performance. Though, I don't know what you expect to what size...

Do you get an error when you type

SELECT * FROM fn_name (1,'20110101')?

Hmm, the table doesn't have an unique id and or primary key? Or else just right click on the table, select top 1000 rows, delete the top 1000, copy all...

Love uh? That's a bit more appreciation than I expected 😉

My solution would probably go along these lines:

SELECT TOP 2

*

FROM

(

SELECT TOP 4

ID, name

FROM #A

ORDER BY ID ASC

) A

ORDER BY ID DESC

I once had a colleague used Excel who only knew how to use basic arithmetic functions (add, substract, etc) and passed by about any function Excel has and he still...

Not sure who you replied to, but it seems like the problem issued here is purely an own constructed identifier. I only suggested two options, while I stay neutral to...

It is very likely that the situation you described caused the problem. What you should consider is changing the column ID from what seems INT into IDENTITY(1,1) or UNIQUEIDENTIFIER. I...