yeah i've used multiples before; i needed both a counter and a partitioning /grouping of the data;

here's a simple but lame example:

select

Row_number()...

the most common way is to have a trigger enter a row in a specific table; the your application can scan the table every minute or so for any...

Google Translator (4/21/2010)

---

Hello

I have an application that contains a cursor when I run the query in SSMS there are mistakes but he made the entire cursor (like on error...

I doubt R2 is much different from SQL 2008; there is a maintenance function to change editions in the SQL Server Installation Center for 2008:

as Lutz posted, both the syntax you used and the error you posted are for Oracle only; SQL server uses the plus + operator to concatenate strings:

Here is the equivilent...

yes that is exactly correct, Joy; you've got it now.

the views from INFORMATION_SCHEMA stuff are missing a lot of info;

to get theidentity or not,i would either use the ColumnProperty() function, or select from sys.columns instead.

select * from sys.columns where...

SQLWB.EXE = SQL Work Bench, otherwise knows as SQL Server Managment Studio; that's the executable you are using to look at and connect to SQL server, running the sqlserver.exe process.

Grant Fritchey (4/22/2010)

---

I had to know for sure, so I just validated it. I started a trace with no stop time, shut down the server, restarted the server, the trace...

jameswhitby (4/22/2010)

---

Lowell,

By doing that I get the following error message:

Msg 7313, Level 16, State 1, Line 1

An invalid schema or catalog was specified for the provider "Ifxoledbc" for linked server...

james it's probably just the dbname.schemaname then;

you said you were running this commnad:

select * from LIVE.live_db.informix.thistable

try

select * from LIVE...thistable instead; that lets the linked server infer the dbname and...

when you concatenate, you cannot alias the CASE statement...right at the end of your case you have this:

end as type||','||

also you have a logic hole: null concated with anything...

yes you can Eric; i did the same thing making a SSMS clone in .NET, for me it was just for fun, but you learn all the pieces you need.

What...

it took me 3 searches for the definition till i found Pointy Haired Boss, which i should have realized right away...

i have a bunch...

well, I've never had to restart the default trace or a c2 trace; i could be wrong, but that's...