![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions 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 Read Answers (3) | Asked by : samir khan Latest Answer : Select Columnname from Tablename Groupby Columnname Having Count*>1 ... Read Answers (10) | Asked by : Srinu Latest Answer : I Think the question is not well formed.. Please Elaborate ... Read Answers (1) | Asked by : Chetan Shewale 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 ... Read Answers (3) | Asked by : soumya 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 ... Read Answers (5) | Asked by : sunileswar behera Latest Answer : Therefore sp_columns dataloader.rescomps will display column names and their descriptions. ... Read Answers (8) | Asked by : Priya Latest Answer : Comparing to SQL Server 2000 SQL Server 2005 have more features1. Reporting services are available 2. .Net integration3. HTTP protocols ... Read Answers (3) | Asked by : vvkumar 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 ... Read Answers (4) | Asked by : shradha kale Latest Answer : http://msdn2.microsoft.com/en-us/library/ms175890.aspx ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||