The most detailed informations you'll get with the -1 parameter, as mentioned in the link above, but again no table names.

Figuring out yourself what the columns mean, will be...

Please avoid cross post in different categories

Piggy-backing on Nigel this might be on some help

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12279

Frank

http://www.insidesql.de

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12279 might help you

Frank

http://www.insidesql.de

quote:

---

Cursors never.

DTS - only when needed and never to control.

---

...

Hey Nigel, where is the third...

Sorry, just saw something that shouldn't be done.

What have we learned from other threads?

Never prefix your sprocs with sp_...

Must be some kind of legacy procedure. I...

This might be of any help

http://www.sqlservercentral.com/columnists/bknight/randomvalues.asp

Frank

http://www.insidesql.de

Oh, I forgot!

Dynamic SQL can be used with almost every T-SQL command.

This is something I use for administrational purposes

CREATE PROCEDURE sp_createbinarytable @tname nvarchar(50)  AS



DECLARE @stmt...

I am reiterating myself, but be aware that this flexibility comes at a certain cost. Read this http://www.algonet.se/~sommar/dynamic_sql.html and decide then if dynamic SQL is really what you want.

Frank

http://www.insidesql.de

This one might help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16662

Frank

http://www.insidesql.de

Thanks for explanation!

Frank

http://www.insidesql.de

Indeed, Excel is a very nice tool. But on the other hand certainly has its limitations when it comes to 'real-time' DDE communication with Reuters or Bloomberg. Let's you get...

quote:

---

(HP Master ASE-SQL Server)

---

as for acronyms, what does this stand for?

Frank

http://www.insidesql.de

<*grin*>I know!

Excel is bread and butter to my daily work.

No need to do some VBA in Excel. Functionality is already there when you take a look at how you can...

quote:

---

Actually i want to know what is the approach of SQL server.?

---

ex ante you can't...

Sorry !!!!

A momentary lapse of reason.

Frank

http://www.insidesql.de