This is one little stored procedure to get the factorial of a given number. Some of this little things make you very good in programming as you develop your logic building skills across different areas of computing. One important and good thing about programming is that, once you know the logic in accomplishing a task, […]
This is also some cool tool you can use to retrieve the database ids for all databases on your server. I like writing this type of scripts because they come in handy and can help stop someones headache one day. Now, the logic l’m going to use is to find the maximum database id on […]
This is a little post to illustrate how to retrieve all tables in a given schema. This is a handy tool and can be used for various purposes. So lets call this procedure GetSchemaTables, it takes just one variable, the schema name. Remember this procedure has to be defined in the current database to which […]
In this post, l just want to show some cool programming skills and hopefully make it useful for any one interested in learning TSQL and use of variables and some date functions. The main purpose is to write a program that will return the day name such as Monday, Sunday etc of the first day […]