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
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Explain tablesample?
Do you know what is openxml in sql server?
Explain “row_number()” in sql server with an example?
Can a function call a stored procedure in sql server?
What are the different types of collation sensitivity?
Explain database normalization?
Explain activity monitors
What is temporal table?
What is left outer join in sql server joins?
What are click through reports?
Explain boyce and codd normal form(bcnf)?
What are the steps you can take to avoid “deadlocks”?
Explain following error properties?
How to create a login account in ms sql server to access the database engine using "create login" statements?