Monthly Archives: October 2009

How to make database offline or online

By | October 13, 2009

Database is made offline to move its physical files. There can be many ways to make a database offline. But there are three main methods which are used frequently to make the database offline. These methods are given below:- CodeProject 1)With the help of Alter database Command:- We can make the database offline or online… Read More »

Different ways to create a table and insert data into the table

By | October 12, 2009

Introduction Tables can be defined as the structure which contains the data in the database. This article discuss about the different ways to create a table and insert data into the table. Some of the ways to create a table is given below:- 1)Creation of a table with the help of a create statement For… Read More »

Difference between Primary key and Unique key

By | October 5, 2009

var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src=’” + gaJsHost + “’ type=’text/javascript’%3E%3C/script%3E”)); try { var pageTracker = _gat._getTracker(“UA-11608194-1”); pageTracker._trackPageview(); } catch(err) {} Both Primary key and Unique key enforce uniqueness of the column on which they are defined but still there are some differences between them. The differences are defined… Read More »