SELECT And DELETE Procedures

Hello,

I am moving from Access to SQL and I am trying to create DELETE and a
SELECT procedures.
I was following the Asp.Net 2.0 Membership, Roles, etc procedures but I
am not getting there.

Could someone, please, post just the 3 procedures for this example?
It would be a start for me to work on ...

I have related two tables: <Content> and <ContentLocalized>

   <Content>
       |----- [ContentId]   Type=UniqueIdentifier   PK
       |      [ContentName]    Type=NVarChar(100)
       |
       |     <ContentLocalized>
       |           [ContentLocalizedId]   Type=UniqueIdentifier   PK
       | -------> [ContentId]   Type=UniqueIdentifier   FK
       |           [ContentCulture]   Type=NVarChar(5)
       |           [ContentHtml]   Type=NVarChar(MAX)

Basically I want to create 3 stored procedures:

   1. SELECT [ContentHtml] Given [ContentName] and [ContentCulture]

   2. DELETE a content in <Content> and all its dependencies in
<ContentLocalized>
       given [ContentName]

   3. DELETE a content record in <ContentLocalized> given [ContentName]
and [ContentCulture]

I allready have an Access Query for (1) but I don't think I should try
to use it in SQL:

SELECT ContentLocalized.ContentHtml
FROM Content INNER JOIN ContentLocalized ON
Content.ContentId=ContentLocalized.ContentId
WHERE (((ContentLocalized.ContentCulture)=[@ContentCulture]) AND
((Content.ContentName)=[@ContentName]));
Thank You Very Much,
Miguel