Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

"[" and "]" in MS SQL

Anonymous
2011-09-02
2013-05-21

  • Anonymous
    2011-09-02

    Transact Sql allows to use  around names, so that a Create Procedure line could be

        create procedure schema.proc_name
    

    as well as

        create procedure [schema].[proc_name]
    

    I edited the SQL regexefunc this way:

        regexfunc="[\w_]+[\.\w_]*"
    

    and it works :-)

     

  • Anonymous
    2011-09-02

    Sorry, this was the original regexfunc, here is my new one:

        \[*[\w_]+\]*\.*\[*[\w_]*\]*
    

    I am no regex expert, so there is probably a better way to say this