How to access data yearly from DB in C# ?
how to access data yearly from database in C#.
I have code but i m not able to retrieve data yearly from DB table.
string date1 = dateTimePicker1.Value.Date.ToString("dd/MMM/yyyy");
September 10, 2014 at 1:20 AM
How to insert XML data into a database column? Column data type is CLOB
August 11, 2014 at 4:18 PM
Nb hours between 2 time stamps meets specific criteria
sql - I have 2 columns with time stamps and 2 empty columns, named DAYHOURS AND NIGHTHOURS. I want to update DAYHOURS and NIGHTHOURS with Number of hours fall under - 06:00 to 21:00 and 21:00 to 06:00 respectively. Thanks
August 7, 2014 at 1:18 PM
MySQLselect into new table Example code
I have a big table in MySQL database and I want to create a new table with all the data in it. I have heard that there is SQL statement "mysql select into new table" which selects the data from one table and create and insert data into
July 9, 2014 at 3:19 PM
How to create a .mdf file from script (.sql)
I have a sql database in 2008 server. now i want it to convert to 2005. so i script it. just help me to create a .mdf file back from the script.
April 22, 2014 at 10:22 AM
Please help me out
Description* You are hired to develop a laptop inventory information system for Sheridan College in order to keep track of the information about the laptops lent to the students. Users can add or remove data as well as perform searches on th
February 12, 2014 at 8:29 PM