0

T-SQL is nice. But I need a more flexible scripting language in Sql Server like javascript.

Can anyone help?

Rob
45.9k24 gold badges126 silver badges155 bronze badges
asked Jul 30, 2010 at 14:47

2 Answers 2

7

You can try looking at CLR in SQL Server.

You can use any .NET language and import assemblies to SQL server, using the public functions in those assemblies.

You may even have success with this using javascript that compiles to CLR (see this SO question on that subject).

answered Jul 30, 2010 at 14:50
Sign up to request clarification or add additional context in comments.

2 Comments

hi thanks for answers. i know about clr. but i want something that do not need compilation.
@ehsan - The native language of SQL Server is SQL. Anything else will require compilation. It does not support javascript out of the box, and probably never will.
0

You could make a thin wrapper for IronJS to expose that functionality to Sql Server. Should be easy to do, but you would be coding in Sql strings, and it would probably become a mess.

EDIT: I was thinking of doing this for fun, that's how I found your question. Here's what I've been doing for the last hour: JSql

answered Mar 8, 2012 at 7:57

1 Comment

@ehsan: Added link to my repo

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.