I know practically next to nothing about SharePoint. I am trying to find out if and how you can have a SharePoint object pull data from an SQL Server.
Essentially I want to be able to do something like this:
SEELCT Field1, Field2, ..., Fieldn FROM [MyServer].[dbo].[MyDatabase].[MyTable]
The query results would be displayed within SharePoint.
Can anyone point me in the direction of tools and/or tutorials on how this can be done?
Thanks