October 2009 - Technology with Vivek Johari

How to make database offline or online

October 13, 2009April 27, 2018 vivekjohari2 Comments

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 […]

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

October 12, 2009October 28, 2018 vivekjohari1 Comment

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 […]

Difference between Primary key and Unique key

October 5, 2009February 1, 2019 vivekjohari30 Comments

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 they are defined but still there are some differences between them. The differences are defined […]