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

What is a job?

3 6168

What are primary keys and foreign keys?

4 8136

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 11479

If a stored procedure is taking a table data type, how it looks?

1 6448

How m-m relationships are implemented?

2 8310

How do you know which index a table is using?

4 12908

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 8431

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 8978

How can you get @@error and @@rowcount at the same time?

9 24287

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 11953

What are the type of joins? When do we use Outer and Self joins?

3 10238

Which virtual table does a trigger use?

TCS,

8 27404

How do you measure the performance of a stored procedure?

Infosys,

3 16189

Questions regarding Raiseerror?

1 6873

Questions on identity?

Infosys,

2 7019


Un-Answered Questions { SQL Server }

How to use union to merge outputs from two queries together in ms sql server?

1069


How does index makes search faster?

979


how to use DTS package in 2000,2005,2008 in sql server

1838


Define msdb database?

1016


What are the new scripting capabilities of ssms? : sql server management studio

1067


What is the difference between char and varchar2 datatype in sql?

1066


When we should use @@error?

965


How to create a new schema in a database?

1151


What is failover clustering overview?

1088


What is sql server agent and what are the two modes of authentication in sql server?

1056


What is difference between views and stored procedures?

989


How do you create an execution plan?

948


What are the steps you should follow to start sql server in single-user mode?

904


How to modify an existing stored procedure in ms sql server?

1079


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1027