Please refer to my previous post, in which schema and data for EMP and DEPT tables available. The topic of this post is SQL Server
Category: SQL Server
SQL Server Administration, Development and Maintenance
Oracle SQL Emp and Dept Tables For SQL Server
Below are Oracle’s most popular “emp” and “dept” tables compatible with SQL Server. — Table definition – Dept CREATE TABLE Dept( DeptNo INT, DName VARCHAR(14),
Database Restore Information with Restore Start and Completed Date Time
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
Big Data & SQL 