How to filter out duplications in the returning rows in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How can I create a report based on a query? : sql server management studio
do views contain data ?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to find Duplicate Records In table?
What is difference between after and before?
Define Check points and End Points?
Can we join two tables without primary key?
How to divide query output into multiple groups with the group by clause in ms sql server?
Write a SQL queries on Self Join and Inner Join.
What is indexing a document?
which one will take 1st priority in case of insert statement and select statement???
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
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)