1 Kicks

How to find stored procedures in sql server by Different ways(www.codegain.com)

submitted by codegaincodegain(2794) 9 months, 28 days ago

In this codesnippet, i will show, how to find the procedures in sql server using three different ways. such as by name, by content and by parameter names

1 comment |category: |Views: 4

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
codegaincodegain(2794)
Comments:

posted by dpetersondpeterson(4397) 9 months, 27 days ago 0

A word of advice to anyone using sysobject/sys.objects in SQL Server: avoid doing so if you can. The INFORMATION_SCHEMA views are SQL-92 compliant and won't change between SQL Server versions. Not to mention, it makes your code portable to any compliant RDBMS.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?