Viewing 15 posts - 226 through 240 (of 2,568 total)
you don't change the system generated SP - what you do is setup a custom SP and register it to be used instead of the default one that is generated...
December 15, 2023 at 11:43 pm
one option is to use Translate
see https://portosql.wordpress.com/2020/01/13/retirando-acentuacao-translate/ - option 2.4
December 14, 2023 at 5:51 pm
tell your IT that you need to have a technical answer from the vendor - or that they need to block their IP (or do it yourself if you can)...
December 14, 2023 at 5:26 pm
also have a look at this in case Docker is being used - or if it is related to encryption protocols.
https://github.com/microsoft/mssql-docker/issues/478
and you really should go to...
December 14, 2023 at 4:58 pm
and fix your data - these 2 look like they should be different db's
A DB2 1143 12/1/2023
A DB2 10110 6/1/2023
and make it clear if this are daily entries or monthly...
December 13, 2023 at 2:28 pm
Thank you I get 11-12-2023 format, I need 11/12/2023
look at the convert link given about and use the format you need.
and why do you need that particular format on...
December 7, 2023 at 11:39 pm
did you install it on the SERVER? or just your local PC?
and did you install the same "bit" version of the drivers as your SQL instance? if server is 64...
December 7, 2023 at 5:57 pm
have you ensured to see if TCP is enabled as a protocol on the SQL Server Configuration Manager
and are you sure there are no firewall rules preventing you from accessing...
December 7, 2023 at 3:28 pm
you have already been given an answer on your original thread https://www.sqlservercentral.com/forums/topic/txt-file-pipe
December 6, 2023 at 8:42 pm
very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!
December 4, 2023 at 3:26 pm
nothing you can do really within sql other than cleaning up after loading.
you may be able to get the data cleaned in excel itself (ask the owner of it to...
November 29, 2023 at 1:57 pm
and on long run having a key-value table end up being better for this type of things as you always end up requiring more entries added, so better to just...
November 27, 2023 at 12:02 pm
as you have been advised before we need you to post create table DDL, insert statements into the tables required, and what you tried - while a image is good...
November 26, 2023 at 6:47 pm
duplicated of https://www.sqlservercentral.com/forums/topic/sequentially-update-a-column-with-a-decrementing-value
November 24, 2023 at 6:58 pm
Viewing 15 posts - 226 through 240 (of 2,568 total)