Viewing 15 posts - 16 through 30 (of 110 total)
Simply "wrap" your LEFT stuff inside a CASE similar to this:
CASE
April 18, 2017 at 8:40 am
Might want to start with changing how you are incrementing (decrementing) your loop, since currently you start at 1 and then subtract 1 each time, meaning you have an infinite loop....
April 17, 2017 at 5:30 pm
Drew,
Thanks for feedback. I realized my solution was not ideal for performance, but was unsure of the final use (small one time data load or frequent use).
April 17, 2017 at 3:07 pm
Found my problem. I misunderstood the purpose of the Visual Studio generated script. I assumed the CREATE ASSEMBLY was to establish a "placeholder" and that the subsequent ALTER ASSEMBLY contained...
April 17, 2017 at 1:58 pm
How about wrapping the ALTER LOGIN in a TRY...CATCH? That would at least allow your policy update to continue on with the rest of the users.
April 17, 2017 at 11:55 am
Not sure why you need XML and STUFF use, but this alternative will at least get you what you asked for:
April 17, 2017 at 11:32 am
If the assembly does not exist, I create it. The I use ALTER ASSEMBLY to "upgrade" the existing assembly with the latest code. Is this not how it is done?
April 17, 2017 at 10:56 am
Most likely you were not trying to run the stored procedures from a DAC connection. Lookup DAC in SQL Server Books On Line for more information.
December 29, 2016 at 2:41 pm
I wonder if any change is needed to STRING_SPLIT for getting the order of values that are split. The following is an example of how I use the ROW_NUMBER...
August 31, 2016 at 2:04 pm
I adapted the following from this link (https://social.msdn.microsoft.com/Forums/en-US/20e92e10-a0ab-4a53-a766-76f84bfd4e8c/converting-hex-values-to-int?forum=transactsql).
It makes use of a "dummy" XML CAST so as to be able to use ".value".
I CAST the resulting hex from...
April 21, 2016 at 3:04 pm
See response to issue here: http://stackoverflow.com/questions/34770688/vs-sqlclr-function-x-has-unresolved-reference-to-schema-y
Essentially you add a CREATE SCHEMA object to your project, even if you know the target system will already have the schema.
February 16, 2016 at 9:22 am
Running into same problem, was there ever a workaround/fix for this?
February 11, 2016 at 9:48 am
Let me see if I have this straight...
It is safer to have each individual authenticate via AD (totally agree) and then be authorized via database access groups?
So instead of an...
December 22, 2015 at 5:33 pm
Currently verifying, but we believe that we've traced the issue to a particular version of the Oracle OLEDB software. WireShark revealed that data content of a packet appeared to...
May 3, 2012 at 2:02 pm
Viewing 15 posts - 16 through 30 (of 110 total)