Questions tagged [sql]
SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
252
questions
0
votes
1
answer
149
views
Does the Power Apps with SQL Connector will use Connection Reference while connecting to SQL Database/Table in Canvas App?
I have a canvas app using SQL as data source connector, currently I am using connection.
But while moving from one environment to another as a managed solution I am unable to change the SQL connection ...
0
votes
0
answers
47
views
How to migrate InfoPath XML Data to SQL Server?
The project is to create .net website forms using razor C# to replace Infopath.
Migrate the xml data on the sharepoint 2013 server to an SQL Server. My lead says to write a script; I think there are ...
0
votes
1
answer
777
views
Is it possible to use environment variable in canvas Power Apps for SQL data source
Is it possible to use environment variable in canvas Power Apps for SQL server data source?
If not, any work around so that we can update the SQL server name and database name in a managed solution?
I ...
0
votes
0
answers
192
views
SharePoint 2019/Subscription Edition -- SQL Authentication
I have been working with SharePoint for the better part of 15 years. During that time, I almost always installed SharePoint in a domain environment where the Application Server(s) and Database Server(...
0
votes
2
answers
99
views
Get items from SPO and past them in Azure SQL
I am trying to make a logic app with "Recurrence" triger which get items from SPO list (from view) with condition:
if have null values, then pass them some string or boolean (if column is ...
0
votes
1
answer
43
views
How to join multiple lists in SharePoint 2013 on-premises?
sorry if my question is for old versions. the system I have access is sharepoint 2013, InfoPath , sharepoint designer. I need a list for report that I have to joint multiple list for retrieving the ...
0
votes
1
answer
122
views
Error on Central Admin's 'Check Database Status'
The default instance was upgraded to SQL 2019 for the server on which our SPinstance for SP2013 Enterprise resides. Our SP lives on a named instance.
ULS logs:
System.NullReferenceException: Object ...
0
votes
1
answer
1k
views
Cannot Connect to Database Master at SQL Server - SharePoint 2019
I have a following setup:
subnet is the same, two separate VMs
First server has SQL Server 2017 RTM
Second server has SharePoint 2019 Enterprise
After installing SharePoint, I get the following error:
...
0
votes
1
answer
98
views
How to show output of an SQL query in Sharepoint 2013 web part?
Is it possible to use the SQL query that I have written and outputted to a web part through JS and display it as a table in a SharePoint 2013 web part?
0
votes
2
answers
392
views
New SharePoint 2010 install Error - Failed on SQL 2008 Native Client
I'm undertaking a new installed to replicates and excising infrastructure to test updating to new SharePoint server e.g. 2016, etc. When I try and install SharePoint 2010 Foundation on a windows ...
0
votes
0
answers
1k
views
Data table doesn't refresh
I have a canvas app where on one screen I have a data table connected to a SQL server table, which pulls a list of values. When I select a value in that list, it's supposed to take me to another ...
0
votes
1
answer
280
views
How to save binary file to SQL by power automate
I have got a problem with database. Is there a solution or connector to save a Binary field to SQL database?
0
votes
1
answer
543
views
Stuck at SharePoint2016 config Wizard
I already followed the tutorial and instructions but still cannot create database from SharePoint Config wizard.
Even I used SharePoint 2016 Management Shell, but still :
"Cannot connect to ...
0
votes
1
answer
25
views
T-SQL to CAML - I wonder what's missing in the CAML (T-SQL works)
I have this SQL query and it works perfectly. However, when I try to create a similar CAML it doesn't work. Is there a tool that can convert SQL to CAML. or can someone please help. Here is the ...
1
vote
1
answer
13
views
create report from external big data at sql database at sharepoint 2016
I need to create a report from an external SQL database and run the report at SharePoint 2016.
The SQL database size was big around 5 GB, How can I do it?
I think to create a procedure at SQL database ...