How to give keywords in a query in .NET
-
Hi I am using ASP.NET and VB as code behind. My database is Sybase. and sql. Now my problem is i want to use a select query where one fields name is date(this is keyword in Sybase). when i used sql i hve given this like "Select * from mytab where [date]='04/30/2007'" but this doesnt work for sybase . Can anybody pls help me how to use the keywords in query's Thanks in advance with regards Anitha
-
Hi I am using ASP.NET and VB as code behind. My database is Sybase. and sql. Now my problem is i want to use a select query where one fields name is date(this is keyword in Sybase). when i used sql i hve given this like "Select * from mytab where [date]='04/30/2007'" but this doesnt work for sybase . Can anybody pls help me how to use the keywords in query's Thanks in advance with regards Anitha
-
See i want to retrieve data from mytab according to the date. Like "Select * FROM mytab WHERE date='01/30/2005'" see while using sql i hve given the keywords in brackets like,[date],[user] etc. But i want to know how this is to be done if i use Sybase database.Please help me With Regards Micydon