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

learn more… | top users | synonyms

0
votes
2answers
48 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
95 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
0answers
47 views

InfoPath - SQL as Secondary Datasource - Limit Results

I have limited InfoPath experience, mostly using as SQL table UI. I am now trying to create a SharePoint form that will capture data from a SQL table. In dev environment I have been able to add the ...
0
votes
1answer
278 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
649 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
3k 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
61 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
622 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
385 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
2k 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 ...
0
votes
1answer
263 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
1k 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
210 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 = ...
1
vote
1answer
1k 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. ...
0
votes
3answers
7k 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 ...