Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Native C# in Stored Procedures Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 7:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 19, 2016 8:30 AM
Points: 552, Visits: 964
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?
Post #1556974
Posted Tuesday, April 1, 2014 8:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 20, 2016 3:29 PM
Points: 1,395, Visits: 855
Good one!

And demonstrates well why articles should be read in their entirety!
Post #1557030
Posted Tuesday, April 1, 2014 9:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 17, Visits: 126
*Grumble*
Post #1557049
Posted Tuesday, April 1, 2014 9:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, May 21, 2016 9:29 AM
Points: 117, Visits: 1,663
Heh,

And for half a second I was thinking, hmm, I might get easier access to regex functions.
Post #1557064
Posted Tuesday, April 1, 2014 10:20 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 4, 2015 9:45 AM
Points: 216, Visits: 1,050
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.
Post #1557096
Posted Tuesday, April 1, 2014 11:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 31, Visits: 64
Low blow sir!
Post #1557139
Posted Tuesday, April 1, 2014 12:15 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 20, 2016 9:51 AM
Points: 3,963, Visits: 2,253
I almost fell for this one because it actually seems reasonable to allow this.
Post #1557154
Posted Tuesday, April 1, 2014 1:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 30, 2015 9:19 AM
Points: 2, Visits: 37
Tisk..tisk..twas not funny!!
Post #1557173
Posted Tuesday, April 1, 2014 1:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 1:27 PM
Points: 1, Visits: 4
LOL on the no errors or warnings from compiler :) This was definitely a developer's prank! Thanks for making the day a bit better.
Post #1557183
Posted Tuesday, April 1, 2014 2:20 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:34 PM
Points: 3,479, Visits: 8,068
I was reading it, thinking what a terrible idea it was, feeling confused about how I had missed rumors of it's potential existence, hoping that it was turned off by default and would require a database or server level option to enable, and then was totally relieved at final reveal.



"If you break a few eggs, then make an omelet."
Post #1557196
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse