Set Identity From Zero for Existing Table

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

Comments

Post a Comment

Popular posts from this blog

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 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