You use use them as SqlCommand strings in your normal C# code:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * INTO MyNewTable FROM myTable", con))
{
cmd.ExecuteNonQuery();
}
}
Exactly the same as you would for any other SQL command.