Category: MSSQLSERVER

MS-SQL Server Tutorial - For Beginners & Professionals

post image

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

1 Comment | Not Downloaded Yet!!! | No Demo | Post by: Pawan Kumar

Here I will discuss you to show how we can do empty database structure, without having data in it.(Delete all the rows from all the tables in Ms-SQL Server)

View Details

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

post image

Get todays Day Name SQL server

1 Comment | Not Downloaded Yet!!! | No Demo | Post by: Pawan Kumar

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.

View Details

Tags: 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 

post image

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

No Comments Yet!!! | Not Downloaded Yet!!! | No Demo | Post by: Pawan Kumar

In this post, We will learn to convert a negative number to positive number. ABS function is the SQL function, which will convert the negative number to positive one.The example can be create in any edition of Ms-SQL Server like MS-SQL Server 2005/2008. A SQL Script has been attached with the article.

View Details

Tags: ABS function  negative a number to a positive number  use ABS function 

Prev 1 2 Next 
Subscribe for Updates
loading...