Post reply

Information_Schema.Routines

  • May 4, 2015 at 3:44 pm

    #398409

    This is not working.

    select * from INFORMATION_SCHEMA.ROUTINES

    where routine_type in( 'PROCEDURE' ,'FUNCTION')

    and (routine_name not like '%A_%'

    or routine_name not like '%B_%')

    This is giving me resultset with all proc and functions starting with A_ , B_ along with others.

    I just want others to show in the output.

  • May 4, 2015 at 4:10 pm

    #1795491

    ...

    and routine_name not like '%B_%')

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 2 posts - 1 through 1 (of 1 total)

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