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










Tibco Rendezvous (tibrv) C# .Net example









madeinstein



,















This is an example of broadcast messaging using TIBCO Rendezvous .   You can find more information about queue, dispatcher, transport and other rendezvous concepts in the TIBCO Rendezvous® Concepts  pdf documentation.   Command Line:   Receiving messages   tibrvlisten –service <port> -network "<ip-address>" –daemon <port> "<subject>"    tibrvlisten –service <port> -network ";<multicast-ip-address>" –daemon <port> "<subject>"         tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST"     tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.>"   Publishing messages   tibrvsend –service <port> -network "<ip-address>" –daemon <port> "<subject>" "<your-message>"   tibrvsend -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST" "He...








Read more










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