In this article we will discuss, How to create while loop SQL server We will be using Employee table. Below example we need to insert 1000 products to a item table using while loop.
In this article we will discuss, to connect ADO.NET code to SQL Server Database and retrieve data. We are using SQLConnection,SQLCommand and SQLDataReader classes are present in System.Data.SqlClient namespace. System.Data.SqlClient is also called as .Net data provider.
In this section, I explain how to find your bank balance using sql query. This questions asked by many interviewer, so please do this practice before go to interview.
In this article, I describe how to append prefix to all existing value in a field using sql query. Here I am adding ‘+’ prefix to countrycode in a country table.
In this article, I found a sql query to find first, last and total days in a month from the current or any date using inbuilt functions such as DATEADD(),DATEDIFF() and DAYS() functions. Here i am using current date. If you want to get any date then replace your date with GETDATE()
In this article, I found a sql query to find day, month and year from the current or any date using inbuilt functions such as DATEPART() or DAY(), MONTH() and YEAR() functions.
If you need to get previous date time.(i.e., current date minus 1)
If you need to get the day name (i.e. Monday, Tuesday, etc.)
In GETDATE() function will return current date and time from the SQL Server.
We are going to learn how to implement Progressive (continuous) for an article using SQL server using SUBSTRING.