Hello readers, In this tutorial, I am going to create a User Defined Function to convert Number into Word. User Defined Function to Convert Number into Word: Suppose you have a requirement where you have to show Amount of some kind into both Number and Word. I am creating a User Defined Function that will…
Row Number Function in SQL Server
In this tutorial, I am going to explain you about Row Number Function in SQL Server. This is built-in Ranking Function provided by SQL Server for assigning a sequence number to records in a result set. Row Number in SQL Server: ROW_NUMBER is a built-in SQL Server function that is used to show sequence number…
Like Operator in SQL Server
Hello Friends, In this tutorial we are going to Learn Operator in SQL Server. Like Operator is used to perform a pattern matching search in a Query. Like Operator in SQL Server: Like Operator is used to perform a pattern matching search in a Query. Like Operator is used in the where clause of select,…
Forms in Node.Js
Hello readers, In this tutorial, we are going learn how can we create HTTP Server with Forms in Node.Js. Introduction: An HTML Form is a group of one or more fields/widgets on a web page that can be used to collect information from users for submission to a server. Forms are a flexible mechanism for…
Dynamic Query in SQL Server
Hello Friends, In this blog, we will see how we can execute Dynamic Query in SQL Server. Sometimes you need to generate dynamic SQL queries that built on fly and execute. Here we are going to see how we can execute dynamic queries in SQL Server. Introduction to Dynamic Query: There are two approaches to execute…