How to find the latest updated value in a table without
sending any parameters to that query
Answer Posted / honey
by using scope_identity()
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What do you mean by sql server 2005 express management tools?
How many database files are there in sql server 2000?what are they?
What is the ‘fillfactor’?
What is cross join in sql server joins?
how you can move data or databases between servers and databases in sql server? : Sql server administration
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is it’s similarity with sql server?
What does truncate do?
What are xml indexes?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What are the types of indexes?
What is a heap?
If a stored procedure is taking a table data type, how it looks?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration