Identity column in SQL Server

This is only for identity coloum
Create Table tblPerson
(
PersonId int Identity(1,1) Primary Key,
Name nvarchar(20)
)


Insert into tblPerson values ('Sam')
Insert into tblPerson values ('Sara')

Insert into tblPerson values ('Todd') where personid=2
select * from tblperson
Insert into tblPerson(PersonId, Name) values(2, 'John')

delete tblPerson where personid=2
SET Identity_Insert tblPerson ON --suppose we have deleted any in between the table and we try to insert the row but it can be inserted by this querry we inserted the row
SET Identity_Insert tblPerson OFF --after modification we need to again resert the identity insert..

DBCC CHECKIDENT(tblPerson, RESEED, 0)-- if we want to completely delete our table and start is agiin from the person id =1 the we should use this querry

Comments

Post a Comment

Popular posts from this blog

Prime Number Program in C#

Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime numbers can't be divided by other numbers than itself or 1. For example 2, 3, 5, 7, 11, 13, 17, 19, 23.... are the prime numbers. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int number, i, m = 0, flag = 0;             Console.WriteLine("PLEASE ENTER THE NUMBER TO CHECK PRIME NUMBER");             number = int.Parse(Console.ReadLine());             m = number / 2;             for(i=2;i<=m;i++)             {           ...
Read more

Fibonacci Series in C#

In the case of Fibonacci series, the next number is the sum of the previous two numbers for example 0, 1, 1, 2, 3, 5, 8, 13, 21 etc. The first two numbers of Fibonacci series are 0 and 1. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int val1 = 0, val2 = 1, val3, i, number;             Console.WriteLine("Please Enter any number");             number = int.Parse(Console.ReadLine());             Console.WriteLine(val1 + " " + val2);             for (i=2;i<=number;i++)             {                 val3 =...
Read more

view in sql server

Image
A view is nothing more than a  saved SQL query . A view can also be considered as a virtual table .   A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table. SQL CREATE VIEW Syntax CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE coHEndition SQL Script to create tblEmployee table: CREATE TABLE  tblEmployee (  Id  int Primary Key ,  Name  nvarchar (30),  Salary  int ,  Gender  nvarchar (10),  DepartmentId  int ) When this query is executed , the database engine actually retrieves the data from the underlying base tables,  tblEmployees and tblDepartments . The View itself, doesnot store any data by default. When to Use a Vi...
Read more