Up to Discussions in Community

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
1 Replies Last post: Dec 3, 2008 8:31 PM by Dmitry Jemerov  
Mike Fourier Newbie
Mike Fourier
20 posts since
May 23, 2008
Currently Being Moderated

Dec 3, 2008 8:18 PM

Any thoughts on when T-SQL might appear?

Just wondering if anyone from JB could comment on when we might get a Sybase/MS-SQL/T-SQL dialect?

 

As a somewhat related question: do you think it would ever be possible to get IntelliJ to recognize "scope" (that's probably the wrong word) for the following type of code:

 

OPEN cur_fooIDs
FETCH cur_fooIDs INTO @currentUserID

WHILE @@sqlstatus = 0 BEGIN
    EXEC sp_UpdateNewPassword @currentUserID , @newPassword
    FETCH cur_fooIDs INTO @currentUserID
END

I would love, love, love to have IntelliJ be able to tell me, when I put my cursor next to 'END', where the matching 'BEGIN' is.  So maybe I don't mean "scope" so much as "bracket matching" ?

Dmitry Jemerov JetBrains
Dmitry Jemerov
8,543 posts since
Aug 19, 2002
Currently Being Moderated
Dec 3, 2008 8:58 PM in response to: Mike Fourier
Re: Any thoughts on when T-SQL might appear?

Hello Mike,

 

Just wondering if anyone from JB could comment on when we might get a

Sybase/MS-SQL/T-SQL dialect?

 

We haven't started any work on it yet.

 

As a somewhat related question: do you think it would ever be possible

to get IntelliJ to recognize "scope" (that's probably the wrong word)

for the following type of code:

 

OPEN cur_fooIDs\\ FETCH cur_fooIDs INTO @currentUserID\\ \\
> WHILE @@sqlstatus = 0 BEGIN\\     EXEC sp_UpdateNewPassword
> @currentUserID , @newPassword\\     FETCH cur_fooIDs INTO
> @currentUserID\\ END

 

I would love, love, love to have IntelliJ be able to tell me, when I

put my cursor next to 'END', where the matching 'BEGIN' is.  So maybe

I don't mean "scope" so much as "bracket matching" ?

 

If we implement full support for Transact-SQL, this functionality will of

course be provided.

 

--

Dmitry Jemerov

Development Lead

JetBrains, Inc.

http://www.jetbrains.com/

"Develop with Pleasure!"

 

 

 

Report Abuse

More Like This

  • Retrieving data ...