Search results
-
J
Creating Table using Transact sql statement
Hi All, How to Create tables using Transact sql statements in MS ACCESS 2007. Please provide the solution with example..... Thanks in Advance -
J
Truncate Table in MS Access 2007
Hi All, I am developing Windows Application using C#.net with MS ACCESS 2007 as my Database. During Development I have entered so many records in my database.I am having tables with datatype as AutoNumber.. Now my requirement is I want truncate tables I mean I want to delete all records and... -
J
How to get Identity value of Last Inserted Row
Hi All, I am having a table with one of the Column as SerialNo whose datatype is Autonumber... whenever I Insert a row I want to get the SerialNo of that row.. In Sql Server , there is @@Identity so if we want last inserted row Serialno we write like this... Select @@Identity I want to ask... -
J
How to Last Inserted rows AutoNumber value
Hi All, I am having a table with one of the Column as SerialNo whose datatype is Autonumber... whenever I Insert a row I want to get the SerialNo of that row.. In Sql Server , there is @@Identity so if we want last inserted row Serialno we write like this... Select @@Identity I want to... -
J
How to Truncate Table
Hi All, I am developing Windows Application using C#.net with MS ACCESS 2007 as my Database. During Development I have entered so many records in my database.I am having tables with datatype as AutoNumber.. Now my requirement is I want truncate tables I mean I want to delete all records and... -
J
query to get records between two Dates
Please tell me the Solution If Possible...... what Should I do..... -
J
query to get records between two Dates
Hi All, I am developing a Windows Application using .Net Framework 2.0 and My Database is MS ACCESS 2007. In my table , to store Date I used Text as datatype for Column and storing the date in dd/MM/yyyy format. My problem is when I am finding records between two dates like this...