How to execute stored procedure and set temp table in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Can the query output be sorted by multiple columns in ms sql server?
Why we use functions in sql server?
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
What is mean by candidate key?
Do you know what is blocking?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain candidate key, alternate key, and composite key?
What is relationship? What number of sorts of relationship are there?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
List out the differences between global and local temp tables in sql server?
What function does a database engine serve in the 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)