What are TRIGGERS in SQL - Server

We are going to discuss about TRIGGERS in SQL – SERVER in this article. Triggers are very important in enterprises level database management. You have to understand following table: This command will create a table on which we will apply triggers: 1. Create table Staff(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), name varchar(55), email varchar(55)); 2. Create table Log_Audit(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), StfId int, StfName varchar(50), StfEmail varchar(50), AuditAction varchar(50), AuditTime datetime); Fill your Staff table with the following data: 1. Insert into Staff(name, email) select ‘Rajat’, ‘rajat@example.com’; 2. Insert into Staff(name, email) select ‘Anjali’, ‘anjali@example.com’; 3. Insert into Staff(name,Read More →

Explain the number of ways in which a parameter can be passed to a method ? Parameters can be passed to a method in following three ways : Output Parameters − If the goal is to return more than one value. Value Parameters − In This method the actual value of an argument is copied into the formal parameter of the function. If changes are made to the parameter inside the function there is no effect on the argument. Reference Parameters − The reference to the memory location of an argument is copied into the formal parameter.Argument is affected by the alterations made to theRead More →

Arrays of characters is a good example to explain Strings in C#.  But actually Strings are Objects in C#. While declaring a string variable, an object of type “String”  is  instantiated. Various useful properties and methods are supported by String objects. Some examples are given below: Length –  To get the length of a string. Insert(index, value) To insert the desired value into the string where the stating / indexing point is specified.  IndexOf(value) to get the first index of the first occurrence of the value within the string. Remove(index) to remove all characters in the string after the specified index. Replace(oldValue, newValue) to replaceRead More →

To understand what encapsulation means, it can be considered as “surrounding” an entity, to keep and protect whatever is inside the surrounding. It has a similar concept in programming as well, here encapsulation has a wider meaning than combining the members together within a class; it has a function of access restriction to the inner workings of that class as well. Access modifiers implements Encapsulation. An access modifier defines the scope and visibility of a class member. Encapsulation is also termed as information hiding. C# supports the following access modifiers: public, private, protected, internal, protected internal. Example of Encapsulation : class Account { private doubleRead More →

A method that calls itself is called a recursive method. Calculating the factorial of a number is One of the tasks that can be solved using recursion. In Maths,  Factorial of a number x is denoted as x! and it is : For example:5! = 5*4 * 3 * 2 * 1 = 120 It concludes that the factorial of any number can be calculated using number x number-1 and such that : number-1 reaches “1”. We can define our method based on the above conclusion and statement : static int Factorial(int number) { if (number == 1) { return 1; } return number *Read More →

Outbound and Inbound Marketing

Outbound and Inbound Marketing Training by Escalera Technologies is a Job Oriented course on live projects of digital marketing, branding and promotion. We will teach you starting from the scratch and take you to a level of Marketing Guru. You will face and solve practical problems in the guidance of experts from marketing industry with 25 years of experience. Inbound Marketing Course will teach you all the basics and advanced concepts of Digital Media Marketing. You can read our syllabus of Digital Marketing : Click here You will learn the art of Traditional Marketing as well. Join us / Know More : Contact Now  Read More →

A local MySql database is used for locally hosted website and web development as discussed in the previous articles. Why MySql ? MySql is opensource. MySql queries are as simple as writing a sentence to fetch data (after some practice). MySql support community and user base is huge. You will get answers for almost any query on forums. How to transfer MySql database ? Go to your database or table after opening localhost/phpmyadmin. In the tabs on the middle of screen you will see import and export database options. Go to export and select default options select Sql option and click download. You will getRead More →

In this article we will discuss about some important tools for PHP Website Development. PHP website can be developed and tested locally ( using desktop or laptop computer ). PHP is a server side scripting language and hence a local OR web server is needed to test and run a PHP website. Most widely used web server for php is Apache. Most of the web applications are incomplete without a database. You will see millions of developer using MySql as their preferred database with PHP and lastly you have to download an install PHP. In this article we are discussing about installing and running phpRead More →

If you are planning to build a basic website for your / client’s organization you can always go for a CMS ( Content Management System ) rather than a website with 5-6+ HTML Pages. Benefits of using a CMS for Basic website development with SEO (Search Engine Optimization) in mind are as follows : A website with repeated html page templates ( in 5-6 basic pages like about us, faq, contact us etc.) take more space than a website with dynamic page template content. It means that the code within the <head> tag will be repeated for every page as every page will have uniqueRead More →