I thought you could only have one clutstered key and that one should be the primary key ? Right/Wrong ?

Sorry, my bad vision, now I see in the image it...

I mean I know how to get that by going through the menu and drilling down , right click and select "SCRIPT...."

That's not what I really want. A...

ScottPletcher: Your SQL worked. It happens to be a VIEW.

My Next question: How do I get the definition of a view

Sorry what I meant when I said "DO NOT REPLY" is I had already found the solution. Didn't want to bother anyone.

I ran the script, OK!

But the problem is I need the database name listed as well.

That way I will know what database to look for straight away

use master

select top 100 * from sys.databases order by name

DONE! Do not reply

Works well but here is a related question. How can we search specifically for the the word "referrals_orr"

I know that SQL server thinks of "_" as any common character....

The type of the date_of_birth column is char(8)

Thank you worked perfectly!

Great!

Sorry I meant the value between the <address>....</address> tags

Lets make this simple.

select top 100 message from [surescripts_msg_import]

In this case the column message is of type text.

Can someone please help me write a select query that will retrieve the...

Nice examples but they don't help me in my situation.

I have a table that has a text column. Inside the column is a XML stream.

Select top 1 message from surescripts_msg_import

where

message_type...

Thank you and peace!

By the way, may I ask what a HEAP is ? A hort answer will be appreciated.

Couple of notes here...

Thanks it worked. Took 20 seconds but gave the result set.

1.) I had to modify your syntax slightly ( a little syntax error )

SELECT @ObjectID = OBJECT_ID...

I modified this slightly and tried to run for one table. Went on running... I fonally cancelled. What can be wrong with this ?

All that I did was

1.) Removed references...