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

InterviewPreparation

-
 https://raghu-dotnet.blogspot.com/p/dotnet-core-web-api-interview-question.html https://raghu-dotnet.blogspot.com/p/c-interview-q.html https://raghu-dotnet.blogspot.com/p/top-10-linq-language-integrated-query.html https://raghu-dotnet.blogspot.com/p/aspnet-web-api-interview-q-with-examples.html https://raghu-dotnet.blogspot.com/p/ms-sql-interview-questions.html https://raghu-dotnet.blogspot.com/p/top-10-javascript-interview-questions.html
Read more

Linq Query Using 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 ")                                        select new             {               FirstName = tt.Field<string>("ColumnsFName"),               LastName = ss.Field<string>("ColumnsLName"),             }).ToList(); Note:- Using Left join we should check   null rows in the second table. If have null row it`s throw error without ...
Read more