How can I login programmatically into Sitecore? For example if you would like to connect a small part of the Sitecore API to a desktop application, you would need to login into sitecore first to ac...

I'm trying to write a sql query to get all the fields in a given item in Sitecore. To say I am stuck is putting it mildly. I'm guessing I have to do some self joining on the fields table, but I'm...