Home » SQL SERVER » SQL Interview Q & A » Page 3

SQL Interview Q & A

A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.

SP_RENAME in SQL Server

SQL Server SP_NAME  is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.

 2,547 total views,  9 views today

How to send a SQL Server query results in e-mail message

How to send a SQL Server Query result in e-mail message?

If we have configured SQL Server Database Mail then we can easily send query result as an attachment in mail body.

 19,499 total views,  72 views today

How to access a data of table from another database in SQL Server?

How to copy a data of table from another database in SQL Server?

Suppose, you have a database1 and table1 and one another database2 and table2  in SQL server.

Now you are required to select data of a table1 of database1 from database2 of table2.

What would be a query for that?

 13,339 total views,  42 views today