Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49174 Views
- HP, I also Faced
- E-Mail Answers
Post New Answer View All Answers
When cursors are useful?
Explain activity monitors
Explain primary key?
Why is the need for data conversion transformations?
How to find out what is the default collation in a database?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is the use of keyword with encryption. Create a store procedure with encryption?
How to recreate an existing index in ms sql server?
How to create nested stored procedure?
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 a table does not have a unique index, can a cursor be opened on it?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How will you decide the active and passive nodes?
List out some of the requirements to set up a sql server failover cluster?
What is a view and what are its advantages?
