Answer Posted / balaji.p
select ident_current(column) from table name
| Is This Answer Correct ? | 2 Yes | 17 No |
Post New Answer View All Answers
What are the steps you should follow to start sql server in single-user mode?
How do you create a clustered index?
How to connect to SQL Azure Database by using sqlcmd?
What is @@rowcount in sql?
Do you know the cursor optimization tips?
What are the differences between union, intersect, and minus operators?
What are the new features of sql server 2012 reporting service?
What happens to a trigger with multiple affected rows?
How to read data in a table with "select" statements?
How many types of cursor type are there?
What are character string data types in ms sql server?
What is Extended user-defined?
Do you know what is difference between index seek vs. Index scan?
Write a SQL query to make a column as unique?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?