Top Solutions

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.

I have the specified start date time and end date time i.e (end date time is end of sequence), I add a time interval (this can vary) to the start date time in minutes and this gives me the end date time. we can set time interval 15minutes (60 sec*15 min=900sec).

We need to add [ValidateAntiForgeryToken] attribute before our action. And also should add @Html.AntiForgeryToken() in our form.

Here I am using CTE(Common Table Expression) for Delete duplicate rows. PARTITION BY : It devides the query result into partitions Row_NUMBER : gives unique name for all duplicate rows ie., if one row record repeated for 3 times . it gives the index such as 1,2 and 3 Using this query we can delete all duplicate rows in a table

Simple example of how to create a drop down list in ASP.NET MVC using DropDownListFor.