No announcements
Found 1377 threads
-
0 Votes
I cant able pass customized dates
0 BEGIN IF ... -
0 Votes
Azure SQL Server Logs
Hi, I was after a way to obtain logs (historical and going forward) to see who has connected to a database and if ... -
0 Votes
Syntax to query LDAP over SSL
Hello everyone, I was able to query LDAP over port 636 with the below. How do I modify it so I can query the below AD ...Answered | 2 Replies | 3049 Views | Created by phathuynh27 - Friday, July 24, 2020 1:45 PM | Last reply by phathuynh27 - Sunday, July 26, 2020 5:53 PM -
0 Votes
Fulltext search word with * suffix not found, without suffix found (code example included)
Hi, when we search for the word koetswerk* we found no hits, when we search for koetswerk the record is found for lcid 1043. If we change the language to 1036 the ... -
0 Votes
Searching for Data in SQL XML Field
Hi All, I am using sql server 2016. Looking to find away to extract information in where clause on XML field. It is a very large database that I am currently working on. I am using ... -
1 Votes
Basic SQL Query Retrieve the Month name, days Between two given dates
The Below Details are my Input data:- NAME---WORK-START DATE--------WORK-END ...Unanswered | 4 Replies | 3678 Views | Created by SuganyaRobin - Wednesday, July 1, 2020 2:09 PM | Last reply by Laxmidhar sahoo - Thursday, July 2, 2020 5:25 PM -
3 Votes
Azure SQL Full text indexes constantly generating queries
Hello, We have been using Azure sql databases for quite a while now. All of them have full text indexes. Lately i have noticed that in the list of ...Unanswered | 1 Replies | 4110 Views | Created by TogaRudy - Thursday, March 26, 2020 7:55 AM | Last reply by bychkoff - Friday, June 5, 2020 9:03 PM -
0 Votes
MySQL ODBC does not connect on win server 2016
i have windows 2016 machine with sql 2016 insatlled. I installed MYSQL ODBC connector in the machine, when added the server details ...Unanswered | 1 Replies | 3773 Views | Created by RANJITH K - Wednesday, June 3, 2020 7:11 PM | Last reply by Olaf Helper - Thursday, June 4, 2020 6:17 AM -
0 Votes
Does SQL server require SSL 3.0
One of our customer had requirement to disable TLS1.0 , TLS1.1 and enable only TLS1.2. They have now disabled SSL3.0 with TLS1.2 enabled and they are ...Unanswered | 3 Replies | 3410 Views | Created by Prakruthi.K - Wednesday, May 20, 2020 5:55 AM | Last reply by Olaf Helper - Wednesday, May 20, 2020 9:10 AM -
0 Votes
SQL Server FullText Search not returning expected rows (complete code to reproduce)
I am practicing using FullText Search on SQL Server 2016. Below is a complete code of the steps to reproduce my problem. I don't understand why none of my queries return any ... -
0 Votes
FTI Query over Joined tables is slow
Hi I have a table with a full text index. I have a query which uses CONTAINS to search the table. This works well. I now need to expand the query to also search ...Unanswered | 1 Replies | 3561 Views | Created by oz909 - Monday, May 4, 2020 2:29 AM | Last reply by RamJaddu - Thursday, May 7, 2020 3:15 PM -
0 Votes
WHILE loop to replace data in temp table columns
Hello, I have 2 temp tables DECLARE @Jresults TABLE (guest_title varchar(10) null, ...Answered | 3 Replies | 4145 Views | Created by G-Oker - Tuesday, April 28, 2020 5:11 PM | Last reply by G-Oker - Tuesday, April 28, 2020 5:53 PM -
0 Votes
SQL Search question
I am running SQL server 2014 I need to query and see all the information in the following: WEB.dbo.filedef What query syntax do I ...Answered | 1 Replies | 3933 Views | Created by Jedi_Administrator - Saturday, April 18, 2020 5:57 PM | Last reply by Olaf Helper - Monday, April 20, 2020 7:42 AM -
0 Votes
CTE to INSERT seperate line for each day between two dates, with the same info, but only that day in the arrival/departure columns
HI, I am trying to collate data from multiple table into on temporary table (which i have done) , but I am not being asked for a separate line for each date in between the arrival ...Unanswered | 1 Replies | 4890 Views | Created by G-Oker - Wednesday, March 25, 2020 4:42 PM | Last reply by G-Oker - Friday, March 27, 2020 9:10 AM -
0 Votes
Eliminating brackets in a search
This is strange. Does anyone have an idea on how to remove strings from a search where the string contains a bracket? In the case below, search needs to show only the last two ...Answered | 2 Replies | 4174 Views | Created by Crakdkorn - Sunday, January 26, 2020 8:28 PM | Last reply by Dedmon Dai - Monday, January 27, 2020 8:21 AM -
0 Votes
How to get value After "A"
My database Cust Id Start Like "A1.....A10....A100...." How to I get max value and increment value EX.. Max id = ...Unanswered | 4 Replies | 4791 Views | Created by K.VelRaj - Sunday, December 22, 2019 11:14 AM | Last reply by George Kosmidis - Monday, December 23, 2019 9:00 AM -
0 Votes
How to implement Search in SQL Server for Matrimonial Website
I have a database built on SQL Server 2017 for a matrimonial website. It has few hundreds of tables where user profile properties, partner preferences etc. are ...Unanswered | 0 Replies | 3885 Views | Created by Bhanu Prakash T - Wednesday, December 18, 2019 9:17 AM -
0 Votes
need to have ordered results in one shot query instead of 3 queries
Hello, I have the following query where i do 3 searches and then make union between them so that the results are ordered, is there a way i can do this in one shot without losing the ...Unanswered | 3 Replies | 5556 Views | Created by Mahaghsql - Wednesday, November 27, 2019 10:30 AM | Last reply by Soumen Barua - Wednesday, November 27, 2019 6:14 PM -
0 Votes
Full Text Search in Azure - Population Issue
I'm running a Azure SQL Server (Single Instance, General Purpose, Serverless, Gen5, 4 vCores, auto-pause disabled). I've setup a Full Text index on a table but the Population process ...Unanswered | 1 Replies | 4801 Views | Created by oz909 - Thursday, November 14, 2019 3:19 AM | Last reply by oz909 - Friday, November 15, 2019 2:02 AM -
0 Votes
What is OSQL?
what is osql ? how can use it? what is commands?!Proposed | 2 Replies | 6220 Views | Created by AhhI1075 - Saturday, October 5, 2019 7:30 PM | Last reply by Olaf Helper - Monday, October 7, 2019 7:01 AM - Items 1 to 20 of 1377 Next ›
No announcements