I need a function that outputs first N number of characters in a dash-delimited input string. Requirements: If N drops in the middle of a word, include the last word in the output even if total gets more than N…
First of all this does not contain my answer. I want to find which firewall rule allows specific port 1433 In my server, Plesk has been installed and "MS SQL over TCP protocol" firewall rule is disabled. Somehow I can…
I would like to connect my SQL Database on Siteground Hosting to Power BI through the SQL Server connection. However, I need to get the following information which I am not sure where to get: Siteground Database Credentials in the…
I am on MS-SQL 2016. I have a scenario that requires to get top 2 paid bonus for each group, RANK and ROW_NUMBER are not allowed, here is the code you can use to generate the table and data: Create…
I'm developing a new app and giving .NET Core a go. All is fine until I deploy the app to servers (for staging/testing). I wrote some custom code where I try/catch and return from WebAPI core endpoints so I am…
I can't create a DBLink from Oracle XE 18c to SQL Server 2017 Express! I have an instance of Oracle XE 18c on my server centos 7.6 and an instance of SQL Server 2017 Express, both working properly. I'd like…
I Have to create two-column different value with the same data, important thing data is from combining two tables with the inner join Statement. Here are the table1 and table 2 (it's like attendance report) Am attaching tables Table 1…
Okay, so I'm working on this Microsoft SQL database table that contains message strings, and I am trying to identify all of the URLs in those strings via starting with 'www.' and ending with either ('.biz','.com','.net','.org'). I found a very…
I want to get all data of current date from my database I'm using phpMyAdmin this is the query which I use but it did not show any data SELECT * FROM tables WHERE time = CURDATE();
This is Users table CREATE TABLE Users ( Id INT PRIMARY KEY IDENTITY(0,1), Name NVARCHAR(20) NOT NULL, Surname NVARCHAR(25) NOT NULL, Email NVARCHAR(30), Facebook NVARCHAR(30), CHECK(Email IS NOT NULL OR Facebook IS NOT NULL) ); This is BULK INSERT BULK…