Jeff Moden (10/2/2009)

---

There are much more effective methods than using a join to a number source to find gaps in a sequence. I never use a Tally table or...

I would go for an inline table function - especially if dealing with small ranges much higher up the range (for example checking 12 digit account numbers for sequence breaks)....

As Richard says (and I did in a previous post), CommandBehaviour.SchemaOnly does SET FMTONLY ON behind the scenes for you.

Glad it will save you some work - just remember -...

Try this

With Hierarchy (ParentID, AMIID, MenuText, ParentMenuText, RootMenuText, level, DisplayOrder, URL, ToolTip, Display, NewWindow, SortKey)

As (Select ParentID, AMIID, MenuText, MenuText,...

Richard

Have some code. The important bit is the CommandBehaviour.SchemaOnly parameter to the SqlCommand.ExecuteReader call.

Also note that SqlDataReader.GetSchemaTable() will return you a lot more information.

Thirdly - note that, as discussed -...

?? If you're asking did I give enough info to the OP to achieve what was asked for, then yes. If...

Wow, you need to have some pork chops and chill a bit. Breathe deeply, it's only a forum. By the way, empty has a p in it 😀 Sorry couldn't...

I'd have to agree, I must say. CLR is the way to go with this one. 🙂

Apart from SET FMTONLY ON,...

Nice job sir. 😀

Here's a link to the member list

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader_members.aspx

I'm sure all of that is possible.

Check out System.Data.SqlClient.SqlDataReader - have a look at the members FieldCount, GetDataTypeName and GetFieldType, GetName.

They're also pretty much wrapped up into the call GetSchemaTable...

I'm sorry i've looked at it for a few minutes now and I can't work out what it is you're trying to do - probably cos i'm not feeling 100%....

Garadin

If you're using say SqlClient under .NET then that gives you meta-data irrespective of the presence of rows.

You can move from one result set to the next with NextResult().

Sorry for...

Are you opening an XML file, or consuming a web service?

What you want to do is program it in C# or VB.NET as a CLR Stored Procedure.

There's lots of help...