Hey Steve. This is not really about streaming data back to the application; it is really about streaming the results of a TVF back to the calling query, which...

FZelle (6/10/2009)

---

Most people don't know that for every command send ADO.NET needs an open Transaction.

If there is none, it will open one and Commit or Rollback depending on the result.

So...

I think that the CLR is great for doing things not natively available in T-SQL, such as RegEx, File System, and Internet related functions (just to name a few). ...

noeld (11/9/2006)

---

exec (' USE dba_data

SELECT object_name(i.id)table_name, rows, rowmodctr,''Index Name'' = i.name, ''Statistics Date'' = STATS_DATE(i.id, i.indid)

...

Hey there, Bill. I guess you ultimately want someone else to...

Personally, I am a huge fan of the DbFit tool (hence: http://www.sqlservercentral.com/articles/Testing/64636/). I like it because it not only provides repeatable, automated testing (both from GUI and from command-line),...

Sweet! Danke for sharing :-).

Zai Gezundt.

Glad you found it helpful. 🙂

Hi Sam. Yes, in...

john hill (5/29/2009)

---

I enjoyed reading your article. Thanks for sharing it and providing the material.

I downloaded your code and tried adding an option to do an import via SQLXML...

LP:

Correct: I had not thought of the XML solution and so that would be an incorrect statement that I made about single inserts being the “only” way to load data....

Hello "dm_unseen" and thanks for that suggestion.

Matt Whitfield (5/28/2009)

---

I don't really see the major benefit over using the SqlBulkCopy class here, which is also backwards compatible 2000 up.

A minor benefit...

Hello Sanjay and thanks. However, the author of this article is Ryan Cooper so he...

Excellent article! Thanks 🙂

Thanks for this list. Very handy info 🙂

Another free tool is SQL# (SQLsharp). SQL# is a CLR-based suite of over 120 Stored Procedures, User-Defined Functions, User-Defined Types, and...