Solved

sharepoint List

Posted on 2014-10-16
3
135 Views
Last Modified: 2014-10-30
I create List from sharepoint 2010, I need to know after add to List data which database and which table to go my adding data

for example i checked the using following command but its not there
USe [WSS_Content]

            SELECT
                *
            FROM
                AllLists
            WHERE
                tp_Title = 'Holiday Requests'


for example if i add to Holiday request new records i need to know where is keeeping
0
Comment
Question by:ukerandi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
Montoya earned 333 total points
ID: 40384035
0
 
LVL 32

Assisted Solution

by:Jamie McAllister MVP
Jamie McAllister MVP earned 167 total points
ID: 40384038
OK I have to point out that this absolutely should not be done!

You're not meant to read the content database directly as you can introduce locks.

Please find another way to achieve your objectives via the remote interfaces such as web services, CSOM or the API.

Doing this will leave your installation unsupportable by Microsoft.
0
 
LVL 19

Assisted Solution

by:Montoya
Montoya earned 333 total points
ID: 40384047
I agree w/ Jamie, btw
The beauty of SharePoint is the XML framework, using it can be very easy.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question