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











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










C# Crop white space from around the image









madeinstein



,














Image







This code will crop the image based on all white and transparent pixels from around the image     public  static  Bitmap CropWhiteSpace(Bitmap bmp) {   int  w = bmp.Width;   int  h = bmp.Height;   int  white = 0xffffff;     Func< int , bool > allWhiteRow = r =>   {     for  ( int  i = 0; i < w; ++i)       if  ((bmp.GetPixel(i, r).ToArgb() & white) != white)         return  false ;     return  true ;   };     Func< int , bool > allWhiteColumn = c =>   {     for  ( int  i = 0; i < h; ++i)       if  ((bmp.GetPixel(c, i).ToArgb() & white) != white)         return  false ;     return  true ;   };     int  topmost = 0;   for  ( int  row = 0; row < h; ++row)   {     if  (!allWhiteRow(row))       break ;     topmost = row;   }     int  bottommost = 0;   for  ( int  row = h - 1; row >= 0; --row)   {     if  (!allWhiteRow(row))       break ;     bottommost = row;   }     int  leftmost = 0, rightmost = 0;   for  ( int  col = 0; col < w; ++col)   {     if  








Read more