1 How is the error handling in stored proc of T-SQL2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table? 3-what is disconnected
Latest Answer: In SQL Server 2000 We can check by @@Error0 i.e. error.ex: IF @@Error0 BEGIN ROLLBACK ...
How do you BCP only a certain set of rows out of a large table?
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
what are the differences between sqlserver 2000 and sql server 2005
Latest Answer: there are lots of things added in sql server 2005>here they hav added xml command>even ur clr is also there ...
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: 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?
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 ...
View page [1] 2 3 4 5 6 7 8 9 Next >>
Go Top
