SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [sql]

SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

It is particularly useful in handling structured data where there are relations between different entities/variables of the data. SQL offers two main advantages over older read/write APIs like ISAM or VSAM: first, it introduced the concept of accessing many records with one single command; and second, it eliminates the need to specify how to reach a record, e.g. with or without an index.

You can read more about Microsoft SQL, here.

254 questions
2
votes
2 answers

Add entries to AllUserData from SQL

I have been tasked with having our application make entries into our customer's Sharepoint database. I have found the table where I think these entries are stored ("AllUserData"), but there are almost a dozen columns where I have no idea what they…
TruthOf42
  • 121
  • 3
1
vote
0 answers

Migrate documents from SQL Server to SharePoint document library with the meta data?

I'm new in SharePoint and I have a requirement to migrate millions of documents stored as BLOB's in SQL Server to a new SharePoint Document library. Can you suggest the best approaches for the same?
Ashish
  • 11
  • 1
1
vote
1 answer

How to link two tables from SQL Server Database to a SharePoint List?

How can I link two tables from an External SQL server database to a SharePoint list and also send emails from it.
neo269
  • 3,175
  • 15
  • 68
  • 106
0
votes
2 answers

Converting SharePoint list into SQL

I am wondering is it possible to convert a SharePoint list into a SQL query to be used on a different platform. Or even a way to query the data that exists in the list?
Cian Murphy
  • 1
  • 1
0
votes
0 answers

In Sharepoint 2013 AllUserData has been change

Now is written as XML file. Like they told in this article: http://joelblogs.co.uk/2013/02/15/sharepoint-2013-content-databases-and-the-alluserdata-table/ How to use them in SQL ? This field and find out wchich field is for good table ?
Grzegorz Z
  • 1,709
  • 7
  • 42
  • 73
0
votes
1 answer

Change sharepoint database in the same machine

I installed sql server 2012 on windows server 2008 R2 and sharepoint server 2013 stand alone, but there was sql server 2008 r2 on the server and it seems that my sharepoint database installed on that by default! how can I move that to sql 2012 in…
Melika
  • 375
  • 1
  • 5
  • 16