Right click on the database and choose ‘Tasks’ and go for the option ‘Generate Scripts’. This is wonderful tool which allows you to generate scripts for all the objects…

SELECT INTO command helps you to do this : SELECT  * INTO Test_Datafrom HumanResources.Employee Test_Data will be a  new permanent table and data from Employee will be transferred as it…

There are two types of sub queries : 1. Non correlated 2. Correlated Correlated – This is a situation where the Sub Query uses a Col or more Col’s from…

There are 7 types of data types which are native for SQL,they are : 1. Exact numeric – bigint,int,smallint,tinyint,decimal,numeric.2. Approximate numeric – float,real.3. Monetary – money,smallmoney.4. Date and Time –…

1. Permanent Table2. Temporary Table3.Table Variable Permanent table is our normal table which we create from Create Table Table Name command,however Temp are of two types : a) Local Temp…

You can use the clause called TableSample for this purpose. Select * from DatabaseLogTableSample(10 percent) TABLESAMPLE was introduced in SQL Server 2005.

a) Open SQL Server Configuration Manager.b) In SQL Server Configuration Manager, expand Services, and then click SQL Server.c) In the details pane, right-click the name of the instance you want…

Why to use SQL Management Object Method while using Copy Database option ? Answer : Source database can remain online when the copy activity is being done.

 Hi Friends, This is meant for sharing my thoughts/findings among the people around me. Trust me, you can find real good tech stuff over here. Happy Blogging 🙂 Thank You,…