Native C# in Stored Procedures

Question

Post reply

Native C# in Stored Procedures

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
March 31, 2014 at 8:46 pm

#100885

Comments posted to this topic are about the item Native C# in Stored Procedures

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Rob Bowser Grasshopper Points: 14 More actions · Answer 1

Rob Bowser

Grasshopper

Points: 14

March 31, 2014 at 10:44 pm

#1701877

:hehe: good1!

natalirozin SSC Enthusiast Points: 126 More actions · Answer 2

natalirozin

SSC Enthusiast

Points: 126

March 31, 2014 at 11:04 pm

#1701879

:crying:

Cody Konior SSCarpal Tunnel Points: 4827 More actions · Answer 3

Frankly, the date aside, I think it should have done this. SQLCLR is a massive pain in the butt to write, compile, then distribute the DLLs, then load onto a busy production system.

Though I do completely understand why they wouldn't want to.

vikram.visingh SSC Veteran Points: 224 More actions · Answer 4

That whats I thought.

Who would use Visual Studio then.

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

Umer Akram

SSC-Insane

Points: 22209

April 1, 2014 at 4:52 am

#1701963

Crackinnng :hehe:

greg.rowan Valued Member Points: 59 More actions · Answer 6

greg.rowan

Valued Member

Points: 59

April 1, 2014 at 5:30 am

#1701975

Well played sir, well played.

Nestor Jarquin SSC Veteran Points: 295 More actions · Answer 7

Ok, I'll admit it... I fell for it 🙁

But then I was like, this sounds too good to be true... And it was...

Emito Mr or Mrs. 500 Points: 556 More actions · Answer 8

Emito

Mr or Mrs. 500

Points: 556

April 1, 2014 at 7:05 am

#1702006

jejejeje nice!!!!

Martin_Burton SSCommitted Points: 1932 More actions · Answer 9

Probably best not to even read most things posted today, been drawn into a few for the time it took me to read to the end.

😀

davoscollective SSCertifiable Points: 6405 More actions · Answer 10

Funny!

Sad really though that they can't at least let you script in .net languages.

I suppose there are some trusted/untrusted code issues to resolve.

Postgres has had extensions for other languages for ages. http://www.postgresql.org/docs/current/interactive/external-pl.html

Perl, Python, Tcl are built in as well as the pl/pgsql language, and others have added support for other languages, all done via a C interface. I'd love to see a bit of Iron Python in SSDT personally. In fact more love from the core visual studio team for database & BI projects generally. Sometimes it just feels like we're the poor cousins. The MDX calculations screen for example, is primitive compared to the level of debugging available to "real" .net projects.

Maybe in SQL Server 2017?

Anders Pedersen SSChampion Points: 11410 More actions · Answer 11

Good one!

And demonstrates well why articles should be read in their entirety!

curran.davis SSC Rookie Points: 44 More actions · Answer 12

curran.davis

SSC Rookie

Points: 44

April 1, 2014 at 9:02 am

#1702089

*Grumble*

Jim_K SSCrazy Points: 2418 More actions · Answer 13

Heh,

And for half a second I was thinking, hmm, I might get easier access to regex functions. 😀

samalex SSCertifiable Points: 5429 More actions · Answer 14

I was half way into an email to my other DBA and our Dev's with a link to the article when I double-checked to see if this was an April Fools post, which it was. Glad I saw that before I hit Send.