MS-SQL Server Tutorial - For Beginners & Professionals

How to drop or delete all tables, all user defined stored procedure, views and triggers from MSSQL Server 2008 with example

Remove or drop all stored procedures from database

Delete all the rows from all the tables in Ms-SQL Server

In MS-SQL Server How to  get tables columns with increment value with SQL Query Example

Get todays Day Name SQL server

Get todays Day Name SQL server

There are functions which already provided by SQL. We will use these function to achieve our expected result. To get todays day name using system datetime ,we can use following query.

Demo and Full Guide

how to get todays date in sql how to get todays date in sql server get today's date in sql server sql get today at midnight sql get today date without time sql get current day sql get current day of week sysdate in sql server


how can we convert negative a number to positive number in SQL Server 2005/2008.