Which command displays the SQL command in the SQL buffer, and then executes it

Which command displays the SQL command in the SQL buffer,
and then executes it?

Question Posted / guest

3 Answers
18866 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which command displays the SQL command in the SQL buffer, and then executes it?..

Answer / sundar

Run Command

Is This Answer Correct ?

25 Yes

4 No

Which command displays the SQL command in the SQL buffer, and then executes it?..

Answer / krishna

sp_executesql

Is This Answer Correct ?

5 Yes

3 No

Which command displays the SQL command in the SQL buffer, and then executes it?..

Answer / srinivas chebrolu

By using LIST command in sql we can display recently executed query

by using / command we can execute it

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More SQL Server Interview Questions

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers

default databases available in sql server and there uses ?

4 Answers TCS,

How do I open a .db file?

0 Answers

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers

Is foreign key a primary key?

0 Answers

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers

What are the operating modes in which database mirroring runs?

0 Answers

What are the benefits of using stored procedures over sql statements?

3 Answers Ness Technologies,

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers

What is plan freezing?

0 Answers

What are the different types of join?

0 Answers

Differentiate between mongodb vs. Sql server?

0 Answers

For more SQL Server Interview Questions Click Here