Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



SQL Server Interview Questions
Questions Answers Views Company eMail

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 4830

what is the main difference between after trigger and instead trigger.

2 19387

I have to display ten columns values from diffrent ten tables. how many joins are require?

CarrizalSoft Technologies, HCL,

10 13379

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 19494

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5591

what is a cursor and what is its use?

L&T,

2 8062

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 8850

what is trigger

CarrizalSoft Technologies, NIIT,

1 4489

what is difference between nchar and char in Sql server ?

3 7496

How can we write or define DDL statements in Sql server and DML statements?

3 5997

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 7076

write down the code for "how we delete a table without using of Drop command " ?

CarrizalSoft Technologies, Sonata,

7 10215

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 4048

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 3798

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 12241


Un-Answered Questions { SQL Server }

Explain about SQL server 2005?

802


List the different index configurations possible for a table?

737


What are character string data types in ms sql server?

884


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2211


Is the log file is a part of file group?

785


How to drop an existing table with "drop table" statements in ms sql server?

828


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

853


What is the difference in accessing db between sql server vs sql azure?

168


Is port 1433 secure?

804


What protocol does sql server use?

757


Can a cursor be updated? If yes, how you can protect which columns are updated?

820


What do you mean by authentication modes in sql server?

854


What is difference between unique and primary key?

723


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1823


How much memory that we are using in Logshipping Concept?

1613