How do you BCP only a certain set of rows out of a large table?
Latest Answer: WHERE cluase can be used with bcp commands and all the conditions can be mentioned in the query to generate the set of rows you want to copy. ...
I want to know what do we mean by Database Testing, as well as what role does a Database Tester plays meaning does he performs the similar role as a DBA does or what exactly?What things are performed in
Latest Answer: There are various levels in database testing, starting from just seeing whether the database has correct value to 'SQL injection'.Generally database testing includes verification of-Accuracy of Data-Data Integration-Data type and field size validation ...
what are the differences between sqlserver 2000 and sql server 2005
Latest Answer: 1)-In SQL SERVER 2000 there where maximum 16 instances, but in 2005 you can have up to 50 instances.2)-Database mirror concept supported in SQL SERVER 2005 which was not present in SQL SERVER 2000.3)-SQL SERVER 2005 has reporting services for reports ...
How to select Distinct columns from the table, table having 20 columns and i want all columns
Latest Answer: SELECT DISTINCT *FROM Tabe1 ...
There is a problem in creating relationship between two tables using SQL Server Database.What are the requirements and data that should be had before creating table relationship.
Latest Answer: The datatype of the both the columns used in relation must be the same ...
Latest Answer: Prefix column name with table name like tableName.columnName ...
Hello:I would like you to help me guys for my Project Dynamic Document Management System (DDMS) .I was looking for any information to help me to make my project ,but I couldn’t find good recourses
What are the general functions available in SQL?
Latest Answer: Aggregate Functions:
AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() ...
What is the difference between the full, simple and bulk log recovery models?
Latest Answer: SIMPLE: Uses full or differential copies of the database. Truncates the
transaction logs automatically. Does not backup the transaction log file(s).
Changes made after the last backup cannot be restored (they are lost).
FULL: Includes both database ...
What will you do if a trigger fails during execution?
Latest Answer: Rollback your transaction ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
