Set Identity From Zero for Existing Table

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

Comments

Post a Comment

Popular posts from this blog

AngularJS

-
Image
What is AngularJS? AngularJS is an open source web application framework. It was originally developed in 2009 by Misko Hevery and Adam Abrons. It is now maintained by Google. Its latest version is 1.4.3. Definition of AngularJS as put by its  official documentation  is as follows − AngularJS is a structural framework for dynamic web apps. It lets you use HTML as your template language and lets you extend HTML's syntax to express your application's components clearly and succinctly. Angular's data binding and dependency injection eliminate much of the code you currently have to write. And it all happens within the browser, making it an ideal partner with any server technology. Features AngularJS is a powerful JavaScript based development framework to create RICH Internet Application(RIA). AngularJS provides developers options to write client side application (using JavaScript) in a clean MVC(Model View Controller) way. Application written in AngularJS is c...
Read more

C# - Difference between String and Stringbuilder in C#, Asp.net

-
String String is immutable. Immutable means once we create string object we cannot modify. Any operation like insert, replace or append happened to change string simply it will discard the old value and it will create new instance in memory to hold the new value. Example string  str =  "hi" ; // create a new string instance instead of changing the old one str +=  "test" ; str +=  "help" ; String Builder String builder is mutable it means once we create string builder object we can perform any operation like insert, replace or append without creating new instance for every time. Example StringBuilder  sb =  new   StringBuilder ( "" ); sb.Append( "hi" ); sb.Append( "test " ); string  str = sb.ToString(); Differences String It’s an immutable Performance wise string is slow  because every time it will  create new instance In string we don’t have append keyword String belongs to  ...
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