1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT
Latest Answer : Select Columnname from Tablename Groupby Columnname Having Count*>1 ...
Latest Answer : I Think the question is not well formed.. Please Elaborate ...
Latest Answer : CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON BEGIN TRAN DELETE [dbo].[Pataint_master] WHERE ([BranchID] = @BranchID ...
Latest Answer : #temp table: the table define with single '#' called local temp table, it can be used only a single project of a databse for exemple if we are making a new query in query builder and declare a #temp table then this temp table only can be used for that ...
Latest Answer : It is used to view the table structure. ...
Latest Answer : Comparing to SQL Server 2000 SQL Server 2005 have more features1. Reporting services are available 2. .Net integration3. HTTP protocols ...
Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?
Latest Answer : Here is the Top 30 features of Sql 2005http://www.microsoft.com/sql/prodinfo/features/top30features.mspx ...
Latest Answer : http://msdn2.microsoft.com/en-us/library/ms175890.aspx ...