When working with SQL Server, it is lot more fun if you know how to use queries and make changes or retrieve data. Initally, let us learn the basic concepts related to it. 1. CREATING A TABLE THAT IS EXACTLY SAME AS SOMEOTHER TABLE SELECT * INTO table1 FROM database .. table2 This query will Continue reading

MERGE command is used to perform INSERT, UPDATE OR DELETE operations on a target table based on the results from the source table. On finding match, we can then specify certain actions on it. If a match is found, update operations are performed; else insertions are done. It is important for you to specify at Continue reading

SQL provides different data types for storing data and they are classified into various categories. Let us have a look at the different categories of data types –    Exact Numeric – These data types are using to store numeric data.   Approximate Numeric – These are also used to store numeric data but with Continue reading

SQL Server Storage The storage engine is responsible for storing data onto the disk and retrieving data from the disk. When a database is created two types of files are made – 1  .      Data files 1.1  Primary data files 1.2  Secondary data files 2   .    Log files Data Files – Data files Continue reading

Cut Command in UNIX is used to cut out the desired output from the file and display the result. In UNIX language, cut is used to cut out certain section from each file. You can cut out either field, character or a delimeter or bytes. cut OPTION… [FILE]… Anything that is written inside the square Continue reading