Disable identity insert in SQL Server

madeinstein , 
SET IDENTITY_INSERT dbo.table_name OFF

INSERT INTO table_name( [Id] , [Name])

SELECT 1 , 'Name1'

SET IDENTITY_INSERT dbo.table_name ON

GO
  
































Comments









  1. Telx Computers29 January 2021 at 06:07
    Very Good information, the information which you have provided is very good and necessary for everyone. Always keep sharing this kind of information. Thank you. IT support Miami
    ReplyDelete











Post a Comment



















Popular posts from this blog










Parse XML to dynamic object in C#









madeinstein



,















<? xml version="1.0" encoding="utf-8" ?>  < contacts >    < contact  id = '1' >      < firstName > Michael </ firstName >      < lastName > Jordan </ lastName >      < age > 40 </ age >      < dob > 1965 </ dob >      < salary > 100.35 </ salary >    </ contact >    < contact  id = '2' >      < firstName > Scottie </ firstName >      < lastName > Pippen </ lastName >      < age > 38 </ age >      < dob > 1967 </ dob >      < salary > 55.28 </ salary >    </ contact >  </ contacts >   public  class  XmlToDynamic {   public  static  void  Parse(dynamic parent, XElement node)   {     if  (node.HasElements)     {       if  (node.Elements(node.Elements().First().Name.LocalName).Count() > 1)       {         //list          var item = new  ExpandoObject();         var list = new  List<dynamic...








Read more










How to enable Kerberos Delegation in Google Chrome









madeinstein



,















* Using Registry Key   Set/Add this string registry key   [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Chrome] Name: AuthNegotiateDelegateWhitelist Value: *   * Using Command Line param   --auth-negotiate-delegate-whitelist=*   Delegation can be restricted to servers in the specific domain   *.mydomain.com   I’ve tested it with IIS + SQL Server and double hop delegation works fine.   You can read more about Google Chrome command line params here .   








Read more