Thursday , January 24 2019

Recent Posts

Lesson 8: Object In C#


c# object: A class and an object are different things. A class defines a type of object, but it is not an object itself. An object is a concrete entity based on a class, and is sometimes referred to as an instance of a class. Objects can be created by using …

Read More »

Facebook keyboard shortcut Keys


Facebook keyboard shortcut Keys: In Today’s Life everyone is active on Facebook,  you can use keyboard shortcuts and make your activity on facebook much easier! Facebook has shortcuts (access keys) for people who only use their keyboards to navigate.Keep in mind that keyboard shortcuts can differ by browser (ex: Firefox, …

Read More »

Dynamic Dependent Select Box using Ajax in PHP

Dynamic Dependent Select Box using Ajax in PHP

Here in this Tutorial , I want to share a code for Dynamic Dependent Select Box by using a single Table with the help of Ajax .   1.Create a Database in Xampp named it as Demo. [crayon-5c4994b798a31248684814/] 2. Make A PHP file and define markup and script for select …

Read More »

Date Formatting in C#

Studyclues_C#_Date Format

Date Formats in C#: Date Formatting in C# is a date and time format string defines the text representation of a DateTime or DateTimeOffset value that results from a formatting operation . It can also define the representation of a date and time value that is required in a parsing …

Read More »

30 Basic Interview Questions in PHP

30 interview questions php by

30 Important interview questions with answers for php freshers 1.What is PHP? PHP is an open source server side scripting language commonly used for web applications. 2.What is Open Source Software? Software in which the source codes are freely used, modify, and shared by anyone are called Open Source Software. …

Read More »

Lesson 4 : PHP VARIABLES -2

PHP Variables 2

PHP Variables are depends upon the scope was divided into 4 types. Scope is nothing but defined as the range of availability a variable has to the program in which it is declared. The Four types of PHP Variables are : Local variables Function parameters Global variables Static variables PHP …

Read More »

Indexes in Sql Server one by one


Indexes in Sql Server one by one:- Indexes: Indexes are created to Improve performance of data accessing or data retrieval Index Improves performance of “select” operation. Types of Indexes: 1.simple Index 2.composite Index 3.Unique Index 4.Clustered Index 5.Non Clustered Index Sample Tables: Table 1:EMPLOYEE [crayon-5c4994b7999c8297077657/] 1.Simple Index:- If the Index …

Read More »

Set Operators in Sql Server (one by one)


Set Operators in Sql Server (one by one): SQL server provides the following set operators which combines results from two or more Queries into a single result set. Those are: 1.Union 2.union All 3.Intersect 4.Except To combine the results of two queries we need to follow the below basic rules …

Read More »



Subqueries:- 1.A query inside another query is known as subquery. 2.First inner query is executed then result of inner query is input for outer query. 3.Outer can be insert/update/delete/select 4.inner query must be always select. Types of Subqueries:- 1.single row subquery 2.Multirow Subquery 3.Co-related Subquery [crayon-5c4994b79a37e931582465/] Sample Tables: Table 1:EMPLOYEE …

Read More »

Every Sql Server Developer Should know this Tips


Every SQL Server Developer Should Know this tips 1.Query Execution Order in Sql Query:- 1.From clause 2.Where clause 3.Group by clause 4.Having clause 5.Select clause 6.Order by clause 2. Find  Number of Tables In a Single DataBase   [crayon-5c4994b79a815578457211/] 3.Find All Number of Columns In a DataBase [crayon-5c4994b79a81c607541769/] 4.Find Number of …

Read More »