Viewing 15 posts - 1 through 15 (of 57 total)
Same here 🙁
May 9, 2021 at 10:37 pm
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...
May 19, 2020 at 11:22 pm
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...
May 19, 2020 at 9:49 pm
March 8, 2020 at 12:46 pm
Welcome (hopefully) to the UK!
This is a nice area to come to.
February 29, 2020 at 8:37 pm
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...
February 9, 2020 at 1:47 pm
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...
February 2, 2020 at 3:11 am
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...
January 18, 2020 at 12:07 pm
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...
December 25, 2019 at 12:37 pm
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...
October 29, 2019 at 11:53 pm
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...
October 27, 2019 at 7:37 pm
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...
October 27, 2019 at 7:15 pm
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...
August 11, 2019 at 11:04 pm
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...
August 11, 2019 at 10:51 pm
I pass the name of the server and database to the stored procedure and then use the exec command to execute this as a string then in Visual Studio I...
August 11, 2019 at 11:34 am