use of SUBSTRING function in WHERE clause using SQL SERVER 8

Question

Hi all,

   Good Day!  I am using SQL SERVER 2008 and Microsoft Visual Studio 2008.  In the i have a database table which contains a column for data and time as string. in that column i have both date and time. In my application i have to select date and based on that date i have to get the data from table and show in data grid view control. So i want to compare only with date. 

And i referred the below link. But it is not working for me.

Use of SUBSTRING function in where clause 

http://www.dailyfreecode.com/code/substring-function-292.aspx 

 

 I tried this query, But not working for me.

SELECT * FROM tAerator WHERE SUBSTRING(fldAEdnt,0,10)='07-07-2015' 

 

 can you please give me way to solve this problem.

 

 

Thanks & Regards

Suji D 

Answer 1

Frnds

 

not copied table data only procedure n function

Answer 2

madam

 

follow the below procedure to take script

 

 

 

Choose the advance button from the bellow dialog box at the top

 

 

select schema and data from the dropdownlist in the bellow dialogbox of option

 

Type of data to script

 

 

Answer 3

If the SQL server versions are same then just take a backup of your database (.bak file) and retore it in the new system. OR 

While generating the scripts choose "Schema With Data" option