My plan was to get the text file and do a Bulk insert into a holder table in Sql server 2000 via the bulk insert command inside a stored procedure.

As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write y… ...

Have entry in .env file: "QUERY_BATCH_SIZE = 2098" to overcome SQL Server error: "The incoming request has too many parameters. The server supports a maximum of 2100 parameters.

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...

Hi, I've found that when adding a list of entities that get assigned Identities by the Db the bulk insert assigns the Id's in reverse order. IE, add three entities to a list with Name and Id field, ...