Nishant kumar

Software Developer

About Me

gfhgf
View my complete profile

Monday, 24 August 2015

how to check store procedure exist or not

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME="procedure name" AND ROUTINE_SCHEMA="dbname";

Posted by gfhgf at 02:37
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Nishant Kumar Rai

Nishant Kumar Rai

Blog Archive

  • ►  2013 (1)
    • ►  November (1)
  • ►  2014 (4)
    • ►  January (1)
    • ►  June (3)
  • ▼  2015 (22)
    • ►  April (5)
    • ►  May (1)
    • ►  July (4)
    • ▼  August (11)
      • Email Validation check from regex code in vb.net
      • Validate Email in Vb.net
      • Email Send Class in Vb.net
      • sort string as alphabetical in vb.net
      • String Abribiation in vb.net
      • How create setup file in vb.net
      • MySQL Stored Procedure
      • How To Convert database to UTF8 in my sql
      • How to Set background color of Combobox item in vb...
      • store processior in my sql
      • how to check store procedure exist or not
    • ►  November (1)
  • ►  2016 (4)
    • ►  April (1)
    • ►  July (1)
    • ►  December (2)
  • ►  2018 (1)
    • ►  March (1)
  • ►  2020 (1)
    • ►  August (1)

Total Pageviews

Nishant kumar rai. Picture Window theme. Powered by Blogger.