Archives: March 2012
SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL
Introduction
Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is -
Where, EmployeeID id the UniqueID alloted to every new employee record inserted into the… Read more
0 comments, 500 reads
Posted in Juggling With SQL on 28 March 2012
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question.
Actually speaking, without explicit logging or tracing, it is not possible to get this… Read more
1 comments, 737 reads
Posted in Juggling With SQL on 12 March 2012



Subscribe to this blog