Search In
The IFNULL( ) function is available in MySQL, and not in SQL Server or Oracle. This function takes two arguments.
If the first argument is not NULL, the function returns the first argument. Otherwise, the second argument is returned.
TRIGGERS IN MS-SQL
Triggers are special kind of stored procedures that triggers automatically when an event occur. Triggers are written to fire when a specific event on table occurs. Following are the events that may force trigger-:
1) DML operatio
Wireless Fitility is used to provide connectivity between the nodes that comes within its range.
WiFi is primarily a local area networking (LAN) technology designed to provide in-building broadband coverage. It is based on IEEE 802.11
How to insert value in an auto incremented column in SQL
Sometimes we have situation to insert value in an auto incremented column. Let's discuss this with a simple example.
Example
1) Here is my table structure.
CREATE TABLE Student(
Id INT
I’m trying to connect a client app locally deployed to a server app I deployed to heroku, using socket.io. The app works great locally but I can’t establish the web sockets when deployed to heroku.
My server code:
impor
When you design software or web pages, you need to deal with a variety of formats and languages. And many programming languages and language frameworks are used to make your work efficient and responsive.
Most of the time, you must convert o
In this 21st century, Search Engines are the backbone of every internet user. Here are some of the hidden Tips & Tricks which will help you in improving your search on Google:-
Quotation Marks(“”) - Use of quotation m
In my previous blog, I had explained how to add a message in queue. Now here is the sample code to read the message from a queue
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(RoleEnvironment.GetConfigurationSett
TELNET is a protocol that is based on the telephone and network model of the internet.
Telnet is a revolutionary idea to share the screen of the user with someone other who is no one near but with connected with the network.
T
Pivoting in sql
Pivoting in sql means changing rows to columns and columns to rows. We often need to change rows to columns in some scenario. Suppose I
