SQL Fonksiyonları

<SqlDelete Connection="$(MyConnection)" Table="XmlScriptTestPad">
   <Where>
     <Criteria Name="Name">
        <Value Culture="" Target="None">Dead People</Value>
      </Criteria>
   </Where>
</SqlDelete>

<SqlExec Connection="$(MyConnection)" IgnoreErrors="True">
   DROP TABLE XmlScriptTestPad;
</SqlExec>

<SqlInsert Connection="$(MyConnection)" Table="XmlScriptTestPad">
   <Columns>
      <Column Name="Id">1</Column>
      <Column Name="Name">
         <Value>$(MyName)</Value>
      </Column>
   </Columns>
</SqlInsert>

<SqlSelect Connection="$(MyConnection)" Table="XmlScriptTestPad" TemplatePath="/*/person" Into="/*/details">
   <Columns>
      <Column Name="Name" Node="name"/>
      <Column Name="Id" Node="surname"/>
   </Columns>
   <Where>
       <Criteria Name="Name">
          <Value>gnomes</Value>
       </Criteria>
   </Where>
</SqlSelect>

<SqlUpdate Connection="$(MyConnection)" Table="XmlScriptTestPad">
   <Columns>
      <Column Name="Name">
         <Value>you my friend</Value>
      </Column>
   </Columns>
   <Where>
       <Criteria Name="Id">
          <Value>2</Value>
       </Criteria>
   </Where>
</SqlUpdate>