Viewing 15 posts - 1,261 through 1,275 (of 1,390 total)
I haven't played with net core, do you have any info on the type conversion differences? I can't find anything, weak google fu I guess.
In C# since 5 years...
October 30, 2019 at 4:14 pm
You're connecting Sql Server to Sql Server? Why not use a linked server?
October 30, 2019 at 2:51 pm
With .NET Core there's finally a way for Sql programmers to get out from under the yoke of C#'s type conversions.
October 30, 2019 at 1:22 pm
You have 2 types of GL Accounts: 5 series, and 6 series. For each type you have a matrix which defines the offset positions of data columns which include: location,...
October 29, 2019 at 9:28 pm
I couldn't assume such a thing for possible frequency. We work with documents and we go through 50,000 documents per day. The table size never changes because incoming is...
October 28, 2019 at 1:09 pm
How often do you add documents/nodes to this hierarchy?
According to the OP there are approximately 25k rows in the table. If this represents 5 years of activity, then...
October 27, 2019 at 1:09 pm
At one point I looked into this because we got called into one of those "we want to slap a UI on our database" jobs. Thankfully it didn't go anywhere. ...
October 25, 2019 at 1:12 pm
The alternate solutions don't factor in all of the constraints. Also, both assume the apparent ordinality of dates/ranges will be valid while the OP has offered no assurances that's the...
October 23, 2019 at 5:19 pm
By 'base64' column you must mean varbinary(max)? I've never done it with a pdf file before but if it is possible in t-Sql then OPENROWSET would be my guess as...
October 23, 2019 at 4:04 pm
I can't test it (don't have the table) and all of your column names are reserved words so here's a swag at it:
with range_cte(ID) as (
select
...
October 22, 2019 at 8:54 pm
Why not just create a primary key in table A?
October 22, 2019 at 8:25 pm
If 'jsonpayload' is valid JSON it could be updated in place. Using Sql 2016+ something like this (copy, paste, run) could work:
/* create a test table with...
October 19, 2019 at 1:29 pm
Is there a business definition that defines an "error" or is the error table only supposed to contain errors generated by sql? Please post the definition of the student table...
October 16, 2019 at 2:03 pm
I wasn't taking into consideration the Convert.To/FromBase64 calls that are used with the decryption method, so I wasnt converting to or from Base64 when i was performing the substring,...
October 16, 2019 at 3:46 am
..., then store the decrypted value(s) into a MySQL database. My task is now to get said Data onto our Reporting SQL Server and store as decrypted.
The MySQL is...
October 15, 2019 at 10:52 pm
Viewing 15 posts - 1,261 through 1,275 (of 1,390 total)