Database

public void Import_Data(String XMLFILE_Parth)
       {

           con = new SqlConnection(StrconImport); //Your connection declared somewhere in the Class :)

           DataSet ds = new DataSet();    //Your dataset to do the final dumping

           ds.ReadXml(XMLFILE_Parth);     //sending the it to the Dataset

           SqlBulkCopy sbc = new SqlBulkCopy(con); //object of bulkcopy and put in your connection object inside it

           try
           {
               con.Open();  //open the connection

               sbc.DestinationTableName = "dbo.XML_Resources_Import_temp";  //You must have this table on the SQL , match the Columns

               sbc.WriteToServer(ds.Tables[0]); //Send the Data from the Dataset to the table


           }
           catch (SqlException)
           {
               throw;
           }
           finally
           {


               if (con != null)
               {
                   con.Close();
               }
           }

       }

SELECT * 
FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias

INSERT INTO targetTable (targetColumn)
SELECT CONVERT(xml, alias.sourcecolumn)
FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias

select ...
from table1
where (startdate between convert(datetime, '04/10/2009', 101) and convert('04/20/2009', 101)
or enddate between convert(datetime, '04/10/2009', 101) and convert('04/20/2009', 101))
and userid = 100

aratireddy wrote:

tols to try with enterprise mgmt. I could'ne find that option in my sqlserver 2005.

aratireddy wrote:

plz give be query with options

aratireddy wrote:

The client also told to first create the db by the same name and select overwrite option and then restore. But i could get the overwrite option

Giorgi Dalakishvili wrote:

easier/nicer solution.

SELECT ...
       datename(month, TH_DT_HolidayDate)
       + datename(day, TH_DT_HolidayDate)
       + ', '
       + datename(year, TH_DT_HolidayDate) AS Result
       ...