Viewing 15 posts - 826 through 840 (of 5,109 total)
Which you use is really up to you. Just like an application that provides a service that others do, much of what you choose is down to preferance. Personally, I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 16, 2019 at 9:29 pm
Cross post from Stack Overflow (generally it's not well received by communities to cross post, as information ends up being incomplete on the different sites), but I'll reiterate my...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 16, 2019 at 9:13 am
I don't select, you don't select, but life is diverse and there are deviations. Let's see what the author will say.
This is nothing to do with the diversity...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2019 at 1:31 pm
I saw many times when users used AD accounts without domain and passwords trying to connect to SQL server. So, it can be the similar case.
This isn't the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2019 at 1:14 pm
Please find the attached Screen shots
Those screenshots aren't Windows Authentication logins; they're SQL logins. If you're using SQL logins, who is running the application doesn't matter, as the AD...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2019 at 1:03 pm
If you want to use a single account, you need to have your .net application use impersonation, so that it connects using an impersonated windows account.
Otherwise you could create a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2019 at 11:39 am
When I run the query above I do not see anything about the mail in it's results. But we di us send mail all the time. this is why...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2019 at 3:24 pm
You should really avoid usage of sp_addrolemember; it has been deprecated for some time. sp_addrolemember (Transact-SQL):
Important
This feature is in maintenance mode and may be removed in a future version...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2019 at 2:34 pm
Hi, Can ssis 2005 package directly upgrade to 2016? As there is no enviroment except 2005 and 2016. Please advise. Thanks
I don't believe so, no....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2019 at 10:43 am
Have you considered using a Calendar or Tally Table?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2019 at 8:53 pm
Seems like the easiest would be to use CHARINDEX and STUFF:
SELECT I.ID,
I.AdditionalIDs
FROM (VALUES ('101,102,103,104,105,106,107')) X1(SCHID)
CROSS...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2019 at 2:39 pm
If you specifically want "R-" followed by 6 digits, you could do:
YourColumn LIKE 'R-[0-9][0-9][0-9][0-9][0-9][0-9]'
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2019 at 7:41 pm
I personally prefer a Cross Tab. I can't test this as your sample data is an image, which is impossible to use, but I would personally do something like this:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2019 at 7:30 pm
While SQL Server has relatively few patches for security, you never know.
Ironic then, that this Security Patch (KB4505225) was released only yesterday for SQL Server 2014-2017? I wonder if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2019 at 3:52 pm
Without some sample data, and a way to replicate this, this is really difficult to answer. If you can provide some DDL and DML that we can use and let...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2019 at 3:43 pm
Viewing 15 posts - 826 through 840 (of 5,109 total)