please give me query code of unique fuction
select UNIQUE (name) from emp_info
Incorrect syntax near the keyword 'UNIQUE'.
Answer Posted / sakthi
select DISTINCT (Column_Name) from Table_Name
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is the difference between substr and charindex in the sql server?
What is a sql join?
How to create a scrollable cursor with the scroll option?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Do you know data definition language, data control language and data manipulation language?
What is table constraint?
How many types of subqueries are there in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what is the system function to get current user's user id? : Sql server database administration
Please explain go command in sql server?
Mention the different types of triggers?
What happens when converting big values to numeric data types?
What is the bookmark lookup and rid lookup?
How do you start single user mode in clustered installations?