How you can get a list of all the table constraints in a database? : Sql server administration
No Answer is Posted For this Question
Be the First to Post Answer
What is the temp table?
Explain cursor as data base object?
What is exclusive locks?
What are the new scripting capabilities of ssms? : sql server management studio
What have included columns when we talk about sql server indexing?
What are the different types of subquery?
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
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
What is the dbcc command and why is it used?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
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)