You want the DENSE_RANK() function:

Select Id, DENSE_RANK() OVER(order by Id) as [Seq_Num]

From MyTable

And how can you tell which one was the first inserted? SQL Server does not necessarily either store them or return them in the same order that you inserted...

OK, this will get the entire length:

select o.name, m.definition

from master.sys.system_sql_modules m

join master.sys.system_objects o

ON o.object_id = m.object_id

Of course, getting the entire definition out of...

"Select [text] from master.sys.syscomments" works but is limited to 4000 characters.

In what context are you trying to do this? A SELECT? A View? An INSERT Trigger? A stored procedure that is writing to the table?

It is...

Define "first". Remember that relational database have no inherent order of their...

Glad I could help.

Not necessarily. The actual security context that SQL Server uses for external...

Execute the following command and post the results:

SELECT * From INFORMATION_SCHEMA.TABLES

#Temp tables are unique per-session, not per procedure.

#Temp tables can span subordinate Batches, but is dropped when the batch that created it exits. EXEC('..') and sp_ExecutSQL() create subordinate batches...

I don't know what account OPENROWSET from SQL Server runs under, but you should make sure that it has the necessary access to that directory and file.

Mind you, I do not know if these numbers are correct. I am just saying that they are reasonably possible. 😀

blandry (9/3/2008)

---

Can these numbers actually be correct? Your editorial states 10,000 lost each week at the 36 largest airports. That means on average 278 laptops per week, or...

ALTER is not an option for the Script Generator. The Script Generator is the thing in SSMS that can script multiple objects at a time.

The facility that creates the...

At this point, the only two things that I am fairly certain would work are:

1. A SQLCLR proc that recieves an XML parameter and writes it to...