1
vote
4answers
2k views

Find Database Column Names for List Columns

I am attempting to create a Database View derived from Sharepoint List Data in Sharepoint 2010. Currently to do this I have simply added a new List Item with Unique values, and manually mapped the ...
0
votes
2answers
873 views

Live-sync MSSQL DB <--> Sharepoint List

My experience with SharePoint is not really sophisticated so please bear with me. What I want to do is setting up a live-sync between a SharePoint list and a database table. This live-sync should be ...
1
vote
1answer
124 views

Getting information from different lists (SQL Style)

Is it possible to do something like an SQL query within SP Designer workflows? e.g I want to do something like "SELECT * FROM list-a WHERE client-id = current-clients-id". or can someone suggest a ...
1
vote
2answers
490 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...