SharePoint 2016 Removed Features

Reading Time: < 1 minute SharePoint 2016 Removed or deprecated Features SharePoint Foundation is no longer available in the SharePoint Server 2016 release. no more free SharePoint Foundation Removed Standalone Installation – SharePoint Server 2016 doesn’t support the standalone install option, so it is no longer available in the setup program. SQL Server Express is not …

Insert to identity columns SQL Server

Reading Time: < 1 minute Inserting data from other source to identity column and need to retain the indentity values. Use below Code set IDENTITY_INSERT dbo.<tablename> ON insert Statement ex: insert into PROD_DISP_CATG_SUBCATG(PROD_DISP_CATG_SUBCATG_ID,DISP_CATG_ID, DISP_SUBCATG_ID,PROD_ID,CREATE_TMSP,LAST_UPDATE_TMSP,LAST_DB_USER_NM) values(’20008′,’1003′,NULL,’1162′,’2007-03-20 13:41:00.000′,NULL,’dbo’) set IDENTITY_INSERT dbo.<tableName> OFF insert statement must specify the columns to insert Communities Tagged : Technology Tagged: Identity Column …