I think your sql server is uninstalled.Any how there will be database files in the installed folders of sql server.It will be usefull to recover the databases.Those files are .mdf and .log...
I want to now one thing.what he ased is to get the last ten inserted records.I want to know whether that includes the last updated records also.Because the last modified record also can...
You mean to say abt the Dynamic tables.Considering sql server 7.0 there we are using the temporary tables this will be saved in the tempdb.But in sql server 2000 there is a data type called...
I think the query that you have suggested here will not work.Because the inner query is arranging in the asc order,whereas the outer query to that is arranging in the reverse...
For running the parameterized query you have to put the query in the query section of the MS Access.on the left side u can find the tables toolbox.below tables there is queries.go there and...
Just keep a variable "i" or something and initialize it.When you are dynamically adding the controls add this i value with the name.Then increment the i value.
I have tested the resply provided by srinika with sample tables and i found it working superbly.So try that and you surely get the solution for that.The trigger may be like this.
Thank you for the reply.But we cannot change the transaction isolation level since in is built in dll.is there any other way to achieve this.We can only change the sp code.
IF user1 is accessing a row ,this particular row should not be accessed by other users.Only when the lock is released (After user1 completes his processing with that row) that row should be...