Monthly Archives: October 2009

How to make database offline or online

Posted on October 13, 2009 by vivekjohari

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 … Continue reading →

Posted in SQL Basic Concepts, SQL Server | Tagged , | 2 Comments

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

Posted on October 12, 2009 by vivekjohari

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 … Continue reading →

Posted in SQL Basic Concepts, SQL Server | Tagged , , | 1 Comment

Difference between Primary key and Unique key

Posted on October 5, 2009 by vivekjohari

var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src=’” + gaJsHost + “google-analytics.com/ga.js’ 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 … Continue reading →

Posted in Imp SQL Difference, Interview Questions, SQL Primary Key Constraint, SQL Server | Tagged | 30 Comments