Viewing 15 posts - 826 through 840 (of 5,111 total)
I want to separate money values in my tables with (/) character Also separate decimal by (") Character. Example: 2/498/489"25 help me please
I'll make you a deal......
July 17, 2019 at 1:34 pm
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...
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...
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...
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...
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...
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...
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...
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...
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....
July 12, 2019 at 10:43 am
Have you considered using a Calendar or Tally Table?
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...
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]'
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:
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...
July 10, 2019 at 3:52 pm
Viewing 15 posts - 826 through 840 (of 5,111 total)