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
How data can be copied from one table to another table?
How can you know if the row fetched from cursor is still valid in underlying table?
How to select true false based on column value in sql server?
Explain about system stored procedure?
What are the advantages of sql stored procedure?
What is isnull() operator?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Explain various data region available in ssrs with their use?
What are views in ms sql server?
What is optimization and its types?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Find nth lowest salary or get nth lowest salary?
what is hash nonclustered index
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
Difference between LEN() and DATALENGTH() in sql server ?