Disable identity insert in SQL Server Get link Facebook Twitter Pinterest Email Other Apps madeinstein , February 02, 2009 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 Telx Computers29 January 2021 at 06:07Very 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 MiamiReplyDeleteRepliesReplyAdd commentLoad more... Post a Comment
Parse XML to dynamic object in C# madeinstein , July 24, 2012 <? 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
Multiple TeamCity Build Agents on one Server madeinstein , February 16, 2018 multiple-teamcity-build-agents-on-one-server Read more
Parse XML to object model in C# using XSD utility madeinstein , July 24, 2012 * Run xsd Visual Studio command line utility to generate object from xsd file (from Visual Studio Command Prompt) * Then add the cs file to your project (same place as your xsd file) < xsd : schema xmlns : xsd = "http://www.w3.org/2001/XMLSchema" targetNamespace = "urn:contacts" xmlns : bks = "urn:contacts" > < xsd : element name = "contacts" type = "bks:Contacts" /> < xsd : complexType name = "Contacts" > < xsd : sequence > < xsd : element name = "contact" type = "bks:Contact" minOccurs = "0" maxOccurs = "unbounded" /> </ xsd : sequence > </ xsd : complexType > < xsd : complexType name = "Contact" > < xsd : sequence > < xsd : element name = "firstName" type = "xsd:string" /> < xsd : element name Read more
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