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.
If you run following script in this SQL Command. Itwill give you same results and no performance difference. It will return the current server time.
Best way to use an INFORMATION_SCHEMA view. These views are most standard across the plateform.