Viewing 15 posts - 2,221 through 2,235 (of 2,645 total)
August 31, 2018 at 10:02 am
August 31, 2018 at 9:15 am
August 31, 2018 at 5:24 am
August 30, 2018 at 10:03 am
August 30, 2018 at 5:40 am
August 29, 2018 at 5:25 pm
August 29, 2018 at 12:32 pm
Mauricio_ - Wednesday, August 29, 2018 7:24 AMIt's something I have to develop and I'm asking for another points of view.
Have...
August 29, 2018 at 7:35 am
August 29, 2018 at 4:17 am
August 29, 2018 at 3:41 am
August 29, 2018 at 2:46 am
August 28, 2018 at 4:23 pm
August 28, 2018 at 12:29 pm
I'm thinking this might be some setting in SSMS. How are you running the insert?
Does this work?DROP TABLE dbo.TestText;
GO
CREATE TABLE dbo.TestText(myText text NOT NULL);
August 28, 2018 at 10:34 am
One quick thing to try is to add at the end of the SQL statement " OPTION (OPTIMIZE FOR UNKNOWN)"
So the last lines of your SP would look like:
August 28, 2018 at 10:18 am
Viewing 15 posts - 2,221 through 2,235 (of 2,645 total)