cmartel 20772 (3/5/2014)

---

Using EXEC works well in a standard script but calling it from within a function gives the error "Invalid use of a side-effecting operator 'INSERT EXEC' within a...

Just encapsulate the SELECT for the INSERT in an EXEC so that it is not a parse-time issue. For example:

DECLARE @Table TABLE (IntVal INT NOT NULL)

IF (1 = 0)

BEGIN

INSERT...

sgmunson (2/27/2014)

---

That's quite detailed, and I'm sure it could be pursued, but the effort level at this point is somewhat high, and given that I'm already up against a deadline,...

sgmunson (2/26/2014)

---

Hi all,

I have an existing Pervasive ETL process that uses a Java method, and I would like to create a user-defined function in SQL Server 2008 R2 that references...

As far as I know, this is the only CLR forum here; there isn't one per each version of SQL Server.

I believe they changed the terminology as well in terms...

dlevin (2/14/2014)

---

Spring Town -

Thanks for this great explanation. I have a question...

You write "You're on the right track as far as the memory clerks go. Watch them over time....

I was going to suggest getting the latest SSDT so I am curious if that fixed it.

I did find a few links of others having this same problem, not directly...

ericjorg (2/20/2014)

---

I thought as much, but I had to give it a try here before...

Hi there. I just wanted to mention that while OPENROWSET...

ishaan99 (12/8/2008)

---

Has anyone tried calling a stored procedure from a user defined function. I have a procedure as Proc_XXX with 7 parameters if i do exec Proc_XXX(null,null,null,null,null,'1/1/1998','1/1/2007') i am getting...

SQLRNNR (2/19/2014)

---

Solomon Rutzky (2/19/2014)

---

...regarding getting the "bytes" / VARBINARY / hex code of the Assembly prior to it going into SQL Server, that is jumping a little bit ahead as...

• This reply was modified 5 years, 8 months ago by  Solomon Rutzky.
• This reply was modified 5 years, 2 months ago by  Solomon Rutzky. Reason: fix link

SQLRNNR (2/19/2014)

---

Alan.B (2/19/2014)

---

SQLRNNR (2/19/2014)

---

Great article. Very useful information.

One question I think could be answered and would be very useful to those noobs to CLR.

How do you get the varbinary representation...

• This reply was modified 5 years, 8 months ago by  Solomon Rutzky.
• This reply was modified 5 years, 2 months ago by  Solomon Rutzky. Reason: fix link

Alan.B (2/19/2014)

---

SQLRNNR (2/19/2014)

---

Great article. Very useful information.

One question I think could be answered and would be very useful to those noobs to CLR.

How do you get the varbinary representation...

Alan.B (2/19/2014)

---

5 stars! I just finished this and really enjoyed it. This is turning into a very excellent stairway Solomon and I can't wait to read the rest of the...

Sean Lange (2/6/2014)

---

Alex Grinberg-230981 (2/6/2014)

---

To send a table from .NET, you need to use DataTable. I wrote number of applications using this technique, now issues were found. If I have...