Author Archives: Mandeep Singh

How to recover corrupt Master Database

How to recover corrupt Master Database Hi friends, in this post we are discussing a very important task played by a SQL Server DBA How to recover corrupt Master Database. In case of MASTER database corruption in SQL Server, you can’t able to start your SQL Server. So it is a wise approach to take backup

How to Create a New Client in SAP

How to Create a New Client in SAP In this post we will learn How to create a new client in SAP. In earlier post we had discussed about What is Client in SAP?. Prior creating a New Client in SAP, we have to create a new logical system. Step 1: Run transaction code BD54: it

What is Client in SAP?

What is Client in SAP? Hi friends, in this post we sill learn about What is Client in SAP?. Client is like an individual system for an instance of R/3.  You can have multiple client for a system.  Each client can represent a different “system”. For example, you have one development box with an instance of R/3

SQL Distinct

SQL Distinct Hi friends, in this post we will learn about SQL Distinct. Distinct keyword is used to get distinct (different) values. SQL DISTINCT keyword is used in with SELECT statement, it eliminate all the duplicate records and fetching only unique records. Earlier we had discussed about SQL Group by Clause,SQL Order By Clause,SQL Select Top Clause, Like Clause SQL

SQL Group by Clause

SQL Group by Clause Hi friends, in this post we will learn about SQL Group by Clause. Group By clause is used to group the result. Earlier we had discussed about SQL Order By Clause,SQL Select Top Clause, Like Clause SQL Server, SQL AND & OR Operators, SQL Where Clause, Delete Query SQL Server, SQL Update Statement, SQL Select Statement, SQL