Another thing that is strange is that in SSMS 18 (17 was the same from memory) if you want to import Excel files you need to save the file into...

Same here 🙁

It's ok I have solved it now.

I needed to create a wrapper stored procedure where I define the Result Set and then can remove this from the view and call...

I have been using OPENQUERY and WITH RESULTS SETS which has been working well but now I have hit an 8,000 character limit with the column definition and am not...

I find using stored procedures with my web-based C#/JavaScript projects to be really helpful as when debugging I will create a C# page with parameters that calls the stored procedure...

Welcome (hopefully) to the UK!

This is a nice area to come to.

I think sometimes with these companies, they get a lot of income from paid support too so it may not be in their interests to make things easy to use...

I have had to work on a popular college MI system (still in use today) in a few places where the tables and fields all have very unclear names based...

This is interesting as I found exactly the same thing. I kept going back to trying GIT again, each time with a different graphical tool and I always ended up...

I've kept trying ADS but each time I do after a few hours of using it, it starts messing up and when I execute a query it sometimes shows me...

Hello Steve

Thanks for confirming and explaining the key differences.

I will stick with the where clause in that case as do have an index covering the field/s in question and performance...

I just turned off a system I developed in 1999 where I re-write the application in 2010 but kept the same database (although amended some columns). This year the owner...

Thanks I had forgotten about this command.

For pagination is it better to use limit and offset or a condition in the where clause. I would normally go for the where...

To answer the other part of your question as to how exec is used, as I am passing the database name to the query I need to make the SQL...

Hello Jeff

I store the live and training connection strings in the .NET Core system appsettings.json file and use a switch on the end of the URL (?system=Training) but don't actually...