C# Tutorial - Introduction


Comments

Post a Comment

Popular posts from this blog

Identity column in SQL Server

Image
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
Read more

Sql related query

Image
Delete duplicate rows in sql SQL Script to create  Employees  table Create   table  Employees (      ID  int ,      FirstName  nvarchar ( 50 ),      LastName  nvarchar ( 50 ),      Gender  nvarchar ( 50 ),      Salary  int ) GO Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lambeth' ,   'Female' ,  30000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lamb...
Read more

Data base normalization

Image
Database normalization  is the process of organizing the  fields  and  tables  of a  relational database  to minimize  redundancy . Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships. Normalization i s the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table  ) and ensuring  data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. First Normal Form Eliminate repeating gro...
Read more