Questions tagged [sql-query]

A database query can be either a select query or an action query.

Filter by
Sorted by
Tagged with
1
vote
1answer
25 views

Save data from SharePoint Online to SQL Table [closed]

I have created one html "User Detail" Form. Using content editor web part, add this form into SharePoint page(web part page / wiki page). "User Detail" form contain Button(Save/Submit) for store ...
1
vote
1answer
22 views

SP 2016 performance: spucworkerprocessproxy excessive SQL queries

A recent run of performance counters on our SP 2016 on prem installation showed a very high value for sharepoint foundation(spucworkerprocessproxy)\executing sql queries -- think millions! Subsequent ...
0
votes
0answers
26 views

VBA query 2010 SharePoint list using multiple cell value conditions

I'd like to begin by stating that I am able to successfully query my sharepoint list and import data based on a single condition. My issue: In excel, I have a list of unique ID's in column A and ...
1
vote
1answer
30 views

Need SQL statement to get contentdbid

Looking for the SQL statement to retrieve the content db id of WSS_Content (only available at the SQL level). In what table is this id stored? when I ran cmdlet Get-SPContentDatabase for a list of ...
0
votes
1answer
62 views

Copy Sharepoint list into Sql table

I am having the task to copy the data of a Sharepoint list into the three different sql tables. Sql table details are: cLetterSection SectionID(Identity column) SectionLanguage(depends on image ...
1
vote
0answers
13 views

Sharepoint - InfoPath URL to database SQL query

We have old Sharepoint (2010) website. The sharepoint form can be accessed with URL in the below format /_layouts/FormServer.aspx?XmlLocation=/abc/def/20150401t092014.xml For some reason it just ...
1
vote
0answers
46 views

K2 Getting values from SQL Server table using store procedure for the filtered items [closed]

new to K2 using store procedure I have four drop down controls in the smartform and i have a button called search. In the drop down controls i am going to select values in the each dropdowns and ...
1
vote
1answer
109 views

SQL Max Degree of parallelism value

Recently we had to reconfigure entire SQL(SharePoint) server due to catastrophic failure in out storage components. While we have done that successfully, we have forgot to turn on the MAX Degree of ...
0
votes
1answer
71 views

can i access to builtin alert me definitions(to user defined alerts )by web service or database query

I don't want to customize alert me in SharePoint like this link But i want to get alerts properties like: I want to know that Alerts defined on which list or Doc-Lib? When they want (email or SMS?) (...
4
votes
1answer
88 views

How to retrieve all list/library which uses custom content type in a site collection?

How to retrieve all list/library which uses custom content type or a custom column in a site collection? It would be really helpful if you post your answers in C# code or SQL query. Please let me ...
1
vote
2answers
824 views

How to retrieve all list/library which uses InfoPath forms in a site collection

How to retrieve all list/library which uses InfoPath forms in a site collection? It would be helpful if you post your answers in C# code or SQL query. Thanks
-1
votes
3answers
148 views

How to know that “EnableVersioning” is enabled in any SharePoint 2013 List/Library using SQL Query

I want to know if below proprieties are enabled or disabled for any SharePoint 2013 List/Library. How we can get using SQL Query from ContentDB (AllLists Table), which column I have to use in my query?...
0
votes
2answers
761 views

how to connect infoPath form with SQL server in SharePoint 2013?

i have an BCS/external content type in SPD connected to my InfoPath form. I want to insert the data to the SQL table. Therefore, I just the following rules: R1) Query using a data connection: Main ...
0
votes
1answer
1k views

InfoPath form has connection to SQL server, but form data is not being submitted and stored in db table?

I am created one submit rule which it has the action 1) query using a data connection: Main connection 2) set a field's value @fullname = 1. I need help creating a second rule inserting all the field ...
0
votes
1answer
2k views

Show the Results of a SQL Query in SharePoint 2013

I need to display the results of a SQL query within SharePoint 2013. I have written the query, which is saved as a view within SSMS however can't see an obvious way to simply display the results, ...
0
votes
1answer
2k views

User permission from Content database

I am having copy of content database from client. Now i need to find permission level for particular user using SQL query. Is it possible?
0
votes
2answers
5k views

Infopath querying secondary datasource based on fields in main data connection

So based on a field in my form, i want to execute a sql query when that field changes. Ive set up the data connection, but as far as i can see, the connection is static and there is no way to ...
0
votes
1answer
64 views

MOSS 2007 SqlDataSource

could you please help, where can I find information, how can I set ODBC SqlDataSource on an aspx page, if I cannot edit the Web.Config file probably due to security reasons? Is there any inline-code ...
0
votes
2answers
1k views

Calendar data's storage in SQL

Hi I would like to know in which db and table the datas for sharepoint calendar ? I need to have a reading access to these datas with another application write in php.
0
votes
1answer
496 views

Will this query return ALL files modified today?

I'm running SharePoint 2010 and SQL Server 2008 R2. It's hugely important that I create a list of every file within a given content database that has been modified today, 10/31. Will this query do ...
0
votes
1answer
3k views

Datasheet View and Slow Query StackTrace-Managed

I have a list with 20000 items when I'm trying to open it in Datasheet View it shows me 100 records and then alert on the screen. Cannot connect to the server at this time. You can continue working ...
0
votes
2answers
376 views

Where does sharePoint store Web application information so we can report full site collection URLs in a SQL report?

I know MS does not support SQL commands against SharePoint Databases. But we are just reading data using SQL and SSRS so no harm to be done. I have SQL Syntax that querys every content DB WEBS table ...
0
votes
3answers
2k views

How do I use a SQL query to check-in a document?

Yesterday I started looking at the tables in my SharePoint 2010's Content databases for the first time and I noticed something a little unnerving: There were files that were checked out and the web ...
2
votes
3answers
225 views

Custom TimerJob SQL Access?

Im trying to access an SQL database from a custom TimerJob, but it fails. Without hitting the Exception, it just stops. I got the exact line where it get stuck: SqlDataReader sqlReader = sqlQuery....
2
votes
1answer
2k views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
1
vote
4answers
10k views

SharePoint 2010 - Database Schema

I´m searching for informations about the SharePoint 2010 Database. Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn ...
2
votes
1answer
2k views

Creating an external list from SQL query using BCS

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...