What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1139

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

923

plss anybody specify tha constrian management system in dbms

2150

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1001

What is BCP? When does it used in sql server 2012?

1061

Where is my database stored on the hard disk in ms sql server?

1060

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1042

Explain about merge replications?

1024

How do you open a cluster administrator?

1053

How to return the top 5 rows from a select query in ms sql server?

1138

What are the different index configurations a table can have?

960

Can you please explain the difference between primary keys and foreign keys?

1110

Explain a join?

1067

How to create a simple user defined function in ms sql server?

1021

How to declare and use cursor variables?

1171