Save dynamic query output in a variable in sql server

In this article we are going to learn save dynamic query output in a variable. For that first i need to create a table. So you can find script of creating table. Table Name : InvoiceLocations CREATE TABLE [dbo].[InvoiceLocations]( [Id]… Continue Reading →

How can i list foreign key in sql server

In this article we are trying to find how many ways that we can find foreign key sql server. There are so many ways to find out but currently i am going to talking about only 3 ways. I am… Continue Reading →

How to get length of string without using any existing function in C#

Question: Write a program which return a length of string without using any existing function in C#. Answer: using System; namespace consoleProgram { class Program { static void Main(string[] args) { string str = “my name is pramod kumar thakur”;… Continue Reading →

How to use single inheritance in java

How to use single inheritance in java In this article we learn single inhetitance by using “has a relationship” ang “is a relationship”. Now, first of all we write the program by using “has a relationship ” in Single Inheritance…. Continue Reading →

While loop in sql server

declare @i int=10 while(@i<=20) begin print @i set @i=@i+1 end I hope this code is helpful. Happy coding 🙂

Program of table of any number in C.

In this article, we will learn to how create a program of table of any number in C. Let’s write a program of table of any number in C.   Step 1: Let’s open turbo C/C++ and write the following code…. Continue Reading →

Prime number in C.

Program to find prime number in C. Prime number : A prime number is a number whose only factors are 1 and itself. That means there is no whole number that evenly divides the prime number. Let’s write a program… Continue Reading →

Overriding in C++.

Overriding: Overriding function having same name as well as same parameters replace the base class to the derived class(inherited class).

Count word in sql server

In this blog i am going to write a function which returns word count in sql server. Sql server does not provide inbuilt function for calculating word count. So we have to write a custom function in sql. CREATE FUNCTION… Continue Reading →

Programing code to Interchange numbers in C++.

This program ask to the user to enter two numbers (value of First and Second ) to interchange and display the result on the screen