No announcements
Found 21898 threads
-
0 VotesQQ about SQL Server licensing
Hi Heroes, I saw we can publicly download a copy of SQL Server Standard/Enterprise edition, and there has a built-in installation keys for SQL Server Standard/Enterprise editions on ...Answered | 2 Replies | 1908 Views | Created by gao_lei - Monday, August 10, 2020 7:09 AM | Last reply by Olaf Helper - Monday, August 10, 2020 7:59 AM
-
0 Votes
AZURE DATA FACTORY - VALIDATE THE FILES AND TRIGGER
validate the files like three files are of name type ( shoulder.txt , window.txt , bend.txt) should be present in the blob compared with reference ...Unanswered | 2 Replies | 1822 Views | Created by punith213 - Friday, August 7, 2020 7:49 AM | Last reply by Cris Zhan - Monday, August 10, 2020 7:25 AM -
1 Votes
i need to have adventure work for sql server installed on my computer , how can i get one
I am new to sql and i need to install the database on my computer, how can i get or do i have to buy the complete package of sql. and does the database come with the ...Proposed | 3 Replies | 1808 Views | Created by Gbenga Eze - Wednesday, August 5, 2020 8:26 PM | Last reply by Cathy Ji - Monday, August 10, 2020 6:53 AM -
0 Votes
Fetch element at particular position
What is the SQL syntax to find last directory name from a file path. For example I want to fetch the name of the last Directory i.e. CBBVF We need to fetch the whole string ...Proposed | 5 Replies | 2012 Views | Created by cherry11111 - Thursday, August 6, 2020 3:43 AM | Last reply by Cathy Ji - Monday, August 10, 2020 6:51 AM -
1 Votes
SQL Server Installation
Hello Experts, I have recently started learning SQL Server. And had installed SQL Server 2019 and SSMS 2017 on Windows 10. I was told to remove SQL ...Unanswered | 6 Replies | 2039 Views | Created by HoboCop1 - Saturday, August 8, 2020 5:32 PM | Last reply by Amelia Gu - Monday, August 10, 2020 2:37 AM -
2 Votes
I'm getting continues error like database log backup full.
Always getting error as below. The transaction log for database 'dbname' is full due to 'LOG_BACKUP' I have less explore on SQL side, ...Answered | 3 Replies | 2107 Views | Created by Anugrahshah - Saturday, August 8, 2020 1:47 PM | Last reply by Erland Sommarskog - Saturday, August 8, 2020 9:59 PM -
0 Votes
Average ratings table
I have a table which captures the ratings from 100s of products as below Ratings table: Id, ProductID, Rating(decimal) Data would look like ID ...Answered | 2 Replies | 1723 Views | Created by Pure Deal - Friday, August 7, 2020 4:33 PM | Last reply by Pure Deal - Saturday, August 8, 2020 11:33 AM -
0 Votes
SSMS Tabs not responding when re-sizing
Good day, How do i fix Vertical tabs that doesn't want to re-size by dragging middle line left or right. Sometimes it works to minimize SSMS window and the ...Proposed | 2 Replies | 1733 Views | Created by Burda Barnard - Monday, August 3, 2020 12:28 PM | Last reply by Cris Zhan - Friday, August 7, 2020 8:38 AM -
0 Votes
sum function over partition by order by
Hi , I am trying to use sum function over partition by using order by for cummulative summing. but i am getting syntax error.below is my ...Proposed | 7 Replies | 1841 Views | Created by Gunner010100 - Thursday, August 6, 2020 9:50 AM | Last reply by Melissa Ma - Friday, August 7, 2020 3:00 AM -
0 Votes
Question regarding JDBC parameter selectmethod
Hello , I'm not a DBA , but support a application . we had some query performance issues and while debugging , some of our queries were getting executed as ...Answered | 12 Replies | 2802 Views | Created by ullasckm - Tuesday, July 28, 2020 10:45 AM | Last reply by ullasckm - Thursday, August 6, 2020 9:22 AM -
0 Votes
HOW TO PULL DATA FROM TWO TABLES IN SQL SERVER
Hi Everyone, I am relatively new in SQL Programming. We have a training at the office for simple query like Select * from and found this skill useful for my ...Proposed | 3 Replies | 1606 Views | Created by AG.DEE - Tuesday, August 4, 2020 6:15 AM | Last reply by MIAOYUXI - Thursday, August 6, 2020 1:22 AM -
1 Votes
I'm having a bit of a problem with my SQL server
I'm a student and we have actually been using Oracle for most SQL developer purposes, but in my naivety I decided to test the waters with SQLServer and I have run into a few problems. My SQL server is ...Unanswered | 5 Replies | 1797 Views | Created by NewbieWan1 - Tuesday, August 4, 2020 1:08 PM | Last reply by Cathy Ji - Wednesday, August 5, 2020 2:15 AM -
0 Votes
[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!
This SQL Server related Forum will be migrated to a new home on Microsoft Q&A! We’ve listened to your ... -
0 Votes
Capture Store Procedure Calls Using Extended Events
Hi , I need to capture particular stored procedures calls and parameters and stored them inside sql tables . 1 . Can i stored inside sql table ...Unanswered | 3 Replies | 1749 Views | Created by Sivaprakas - Thursday, July 30, 2020 8:34 AM | Last reply by Cris Zhan - Monday, August 3, 2020 1:11 AM -
0 Votes
error installing sql server 2012
SQL Server 2012 Setup has encountered an error. Problem signature: Problem Event Name: SQL110Exception P1: SQL Server 2012@RTM@ P2: 0x649CBB8FUnanswered | 2 Replies | 1502 Views | Created by Alvaro Gil Fernandez - Wednesday, July 29, 2020 11:53 PM | Last reply by Cathy Ji - Friday, July 31, 2020 6:05 AM -
1 Votes
Changing the value of a binary field.
I need to have something like : UPDATE Mytable Set MybinaryField= not(MybinaryField) I cant get it to work as not is used only in the where clause. Is there a simple way to do this ...Answered | 7 Replies | 2022 Views | Created by vblover29 - Tuesday, July 28, 2020 8:24 PM | Last reply by Erland Sommarskog - Wednesday, July 29, 2020 10:06 PM -
0 Votes
new girl needs help creating weekly totals report
hi guys, ive started trying to get back into SQL and really need some help (you will no doubt see me on here a lot) I am trying to produce a ...Unanswered | 5 Replies | 2187 Views | Created by lovely lucy x - Monday, July 27, 2020 12:03 PM | Last reply by Cathy Ji - Wednesday, July 29, 2020 3:29 AM -
0 Votes
List of countries
I see this everywhere on websites and apps, a list of countries in the first dropdownList and the towns/states associated with those countries in a second dropdownList. How could i ...Unanswered | 13 Replies | 2651 Views | Created by Pure Deal - Thursday, July 23, 2020 8:12 AM | Last reply by MIAOYUXI - Tuesday, July 28, 2020 2:03 AM -
0 Votes
Excel Data Mining Add in
Hi, I have installed Microsoft SQL Server 2012 DM Add-Ins (Data Mining) for Excel 2013. While trying to configure the server the following error ...Answered | 6 Replies | 3023 Views | Created by Murad Sawalha - Sunday, July 19, 2020 10:08 PM | Last reply by Murad Sawalha - Monday, July 27, 2020 7:36 PM -
1 Votes
Extra blank lines when modifying a view in SSMS
Alter To -> New Query Editor Window. I'm wondering if there's a solution. Blank lines are added every time you open up a view or function for modification. If you don't take them out, it ...Answered | 2 Replies | 2167 Views | Created by keithrh - Tuesday, February 27, 2018 2:39 PM | Last reply by laffo16 - Monday, July 27, 2020 12:38 PM
No announcements
