How to make SQL Server 2005 database empty using cursor & sys.objects (Delete All Tables, stored procedures, views & UDF’s)

Understanding sys.objects: Sys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself. Using Sys.objects returns list of all database objects and its types, type can be either of given below: DB OBJECT TYPES F     FOREIGN_KEY_CONSTRAINT IT    INTERNAL_TABLE PK    PRIMARY_KEY_CONSTRAINT S     SYSTEM_TABLE SQ    SERVICE_QUEUE [...]

Read Full Post »

Quick oops concept reference: Definitions of object oriented programming terms

Encapsulation: is an ability of hiding data or methods from the rest of the world. Inheritance: is a concept of passing and using attributes of base class into derived class. Polymorphism: single name – multiple use, it can be achieved via Function overloading & operator overloading. Class & object: a class is a definition which [...]

Read Full Post »

Quick DBMS reference: Single line definitions of important SQL Server terms

Normalization: is a process of organizing data and minimizing redundancy De-normalization: is a technique to move from higher to lower normal forms of database modeling in order to speed up database access. Stored Procedure: is a named group of T-SQL statements which can be created and stored in Database as an object. Primary Key: is [...]

Read Full Post »