Database

Pankaj18 wrote:

So, is there a way to insert the data in SQL.

// Update the demographics for a store, which is stored 
    // in an xml column. 
    string commandText = "UPDATE Sales.Store SET Demographics = @demographics "
        + "WHERE CustomerID = @ID;";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@ID", SqlDbType.Int);
        command.Parameters["@ID"].Value = customerID;

        // Use AddWithValue to assign Demographics.
        // SQL Server will implicitly convert strings into XML.
        command.Parameters.AddWithValue("@demographics", demoXml);

        try
        {
            connection.Open();
            Int32 rowsAffected = command.ExecuteNonQuery();
            Console.WriteLine("RowsAffected: {0}", rowsAffected);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }

I are Troll

ELSE SELECT 'W' UNION SELECT 'R'

IF EXISTS(SELECT 1
   FROM group gr1
   WHERE gr1.group_key = 'RA'
   AND gr1.gra_valid = 1
   AND 0 = (gr1.gra_flags & 7)^3) 
      SELECT * FROM callsigns WHERE mantype = 'R'
ELSE IF EXISTS(SELECT 1
   FROM group gr2
   WHERE gr2.group_key = 'RA'
   AND gr2.gra_valid = 1
   AND 0 = (gr2.gra_flags & 7)^1) 
      SELECT * FROM callsigns WHERE mantype = 'W'
ELSE
      SELECT * FROM callsigns WHERE mantype IN ('W','R')

J4amieC wrote:

Why dont you give it a try,