Following points to be accomplished – Get all the databases restoration information From all reporting, staging or testing environments Information about when the database restoration
SQL Server – Data Export to XML
One of my friend requested me to explain how many ways are there to export the data from SQL Server 2005 into an XML file.
SQL Server – INSERT through Stored Procedure
There is one post in this blog in which we explored how to use the INSERT statement in different ways. Here is another instance of
SQL Server – List-out Procedures, Functions, Triggers
In order to know which procedures, functions, and triggers exist in the database, the following queries can help you to find this out.: The below
SQL Server – Insert Data From Linked Server Table
In a situation where Servers are linked, it is possible to retrieve data from a table in one server to a table on the other
SQL Server – Self Joins
To join tables, at-least two tables are required. This does not indicate two different tables. It is possible to join a table with itself to
Big Data & SQL 