Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
No Answer is Posted For this Question
Be the First to Post Answer
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
How do you know if sql server is running on your local system?
What is de-normalization and when do you do it?
How do I find my localdb version?
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
Do you know what is similarity and difference between truncate and delete in sql?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How do you troubleshoot SQL Server if its running very slow?
How to define output parameters in stored procedures?
What are the various editions of sql server 2017 that are available in the market?
What is the stored procedure?
How to optimize stored procedures in sql server?
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)