Set Identity From Zero for Existing Table

-
DELETE FROM ProjectMaster;
DBCC CHECKIDENT (ProjectMaster, RESEED, 0)

Comments

Post a Comment

Popular posts from this blog

GridView Design Using CSS

-
Image
 Create Css File in your Project...And Add Reference to Grid View page * {     padding: 0;     margin: 0; } body {     font: 11px Tahoma;     background-color: #F7F7E9; } h1 {     font: bold 32px Times;     color: #666;     text-align: center;     padding: 20px 0;    } #container {     width: 700px;     margin: 10px auto; } .mGrid  {     width: 100%;     background-color: #fff;     margin: 5px 0 10px 0;     border: solid 1px #525252;     border-collapse:collapse; } .mGrid td {    padding: 2px;    border: solid 1px #c1c1c1;    color: #717171; } .mGrid th {     padding: 4px 2px;     color: #fff;     background: #424242 url(grd_head....
Read more

Linq Query Using Left Joins With AsEnumerable()

-
var qu = (from tt in table1.AsEnumerable()  join ss in table2.AsEnumerable()                      on tt.Field<int>("UniqID")    equals ss.Field<int>(" UniqID ")                                                   into tt_ss                      from ss in tt_ss.DefaultIfEmpty()                      select new                  ...
Read more