Can we have more than one NULL in a column having unique
constraint?

Answer Posted / saurabh

no

Is This Answer Correct ?    11 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How data can be copied from one table to another table?

513


How can you know if the row fetched from cursor is still valid in underlying table?

522


How to select true false based on column value in sql server?

508


Explain about system stored procedure?

601


What are the advantages of sql stored procedure?

542






What is isnull() operator?

571


What are the basic functions for master, msdb, model, tempdb and resource databases?

557


Explain various data region available in ssrs with their use?

494


What are views in ms sql server?

600


What is optimization and its types?

539


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

558


Find nth lowest salary or get nth lowest salary?

597


what is hash nonclustered index

539


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

1561


Difference between LEN() and DATALENGTH() in sql server ?

596