Sometimes, there are situations where we need to find out a particular or list of stored procedures or functions that contain certain objects or SQL text. There are several ways to accomplish this purpose.
Showing posts with label Script. Show all posts
Showing posts with label Script. Show all posts
Create Date and Time SQL Table
Previously I have designed date and time SQL table for one of my database project. This morning, one of my colleague approached me to discuss the options of populating a date table. I tested a few different methods and make some comparison of their performance. Here are a few options,
Subscribe to:
Posts (Atom)