I’ve been writing sometime now on Transact Sequel (TSQL) which is the microsoft version of SQL and I hope those posts help clarify some major tasks in SQL server programming. In this new tutorial which l’m starting today because of the numerous request that I’ve been getting to provide this lecture free online and due to my basic concept […]
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 […]
