Which version of SQL Server and Which version of Management Studio is best for new Advance Steel?

[SanjoyNath]

Dear Experts?

Which version of SQL Server and Which version of Management Studio is best for new Advance Steel?

I am having SQL Server management Studio 2014

Which server to chose?

[Dias_Antonio]

Dear @SanjoyNath  The version suported by Advance Steel after 2018 is SQL Management Studio 2014. This is teh version that I use here im my PC running without problems.

The second screenshot you showed is a Import process wizard where you can import data to a Microsoft Excel sheet...the server name is the server with the name of your PC. Try to update in order to show in the dropdown menu.

[SanjoyNath]

Dear Experts,

We have exported all data from the Adtorbase.mdf with data exporter of sql server management tool

Then we have added the data in the excel as per our needs

Then when we are trying to import the data to the sql server back , we are facing driver errors or right errors

Please give a single sample of properly running of this query and how to insert 60000 ro

USE [D:\FROM_C\MANAGEMENT_TOOLS\DATABASES_MDF_FILES\\AstorBase.mdf]
GO

INSERT INTO [dbo].[AnchorsName]
           ([ID]
           ,[Standard]
           ,[ClassID]
           ,[MaterialKey]
           ,[Explodable]
           ,[Source]
           ,[Diameter]
           ,[SetName]
           ,[OwnerText]
           ,[NumItems]
           ,[DIN1]
           ,[Diameter1]
           ,[Material1]
           ,[Position1]
           ,[DIN2]
           ,[Diameter2]
           ,[Material2]
           ,[Position2]
           ,[DIN3]
           ,[Diameter3]
           ,[Material3]
           ,[Position3]
           ,[DIN4]
           ,[Diameter4]
           ,[Material4]
           ,[Position4]
           ,[DIN5]
           ,[Diameter5]
           ,[Material5]
           ,[Position5]
           ,[DIN6]
           ,[Diameter6]
           ,[Material6]
           ,[Position6])
     VALUES
           (<ID, int,>
           ,<Standard, nvarchar(64),>
           ,<ClassID, int,>
           ,<MaterialKey, nvarchar(64),>
           ,<Explodable, bit,>
           ,<Source, nvarchar(15),>
           ,<Diameter, float,>
           ,<SetName, nvarchar(64),>
           ,<OwnerText, nvarchar(15),>
           ,<NumItems, int,>
           ,<DIN1, nvarchar(32),>
           ,<Diameter1, float,>
           ,<Material1, nvarchar(16),>
           ,<Position1, int,>
           ,<DIN2, nvarchar(32),>
           ,<Diameter2, float,>
           ,<Material2, nvarchar(16),>
           ,<Position2, int,>
           ,<DIN3, nvarchar(32),>
           ,<Diameter3, float,>
           ,<Material3, nvarchar(16),>
           ,<Position3, int,>
           ,<DIN4, nvarchar(32),>
           ,<Diameter4, float,>
           ,<Material4, nvarchar(16),>
           ,<Position4, int,>
           ,<DIN5, nvarchar(32),>
           ,<Diameter5, float,>
           ,<Material5, nvarchar(16),>
           ,<Position5, int,>
           ,<DIN6, nvarchar(32),>
           ,<Diameter6, float,>
           ,<Material6, nvarchar(16),>
           ,<Position6, int,>)
GO

ws in the built with these?