sql query problem
-
hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.
no knowledge in .net
-
hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.
no knowledge in .net
-
Well is there a record that matches that value for that field? You'd also have been better off posting here http://www.codeproject.com/Forums/1725/General-Database.aspx[^]
hi, yes JHizzle table has more than one thousand records matching to the value. and i don't want to use like keyword
no knowledge in .net
-
hi, yes JHizzle table has more than one thousand records matching to the value. and i don't want to use like keyword
no knowledge in .net
-
Touch tricky to nail ti down without being able to see it I'm afraid but;I've just noticed one thing that's a bit odd about your query. There's a space at the right hand side of your search string. What happens when that's removed?
still no results, on removing space from the the value. does backslash affect my query or the starting number that is prefix in my query?
no knowledge in .net
-
hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.
no knowledge in .net
there is one space in end of this '529042010\All Data 4cr\0.66cr_calicut_1401 ' remove space i.e. you use '529042010\All Data 4cr\0.66cr_calicut_1401'
Gaurav Dudeja http://www.gdinfotechindia.com
Dont be afraid of changing your life to better ! -
hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.
no knowledge in .net
In case you are not getting any matching rows even after removing the extra space from the end of the string, and you are sure that there are matching values in the table, there must be a small catch somewhere which you/we are not able to understand. Few questions: 1. Are you getting matching rows with LIKE clause? select * from csvdata where [source] LIKE '529042010\All Data 4cr\0.66cr_calicut_1401%' 2. What is the datatype of the target column? 3. Can you please paste some values directly from csvdata table which, you think, should match with the condition?
-
hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.
no knowledge in .net
Write this Question in General database forum........... :)