Category: MSSQLSERVER

MS-SQL Server Tutorial - For Beginners & Professionals

Remove or drop all stored procedures from database

  MSSQLSERVER |   Thursday, April 23, 2015   4596   4/23/2015 3:45:22 PM No Comments Yet!!! | No Download | No Demo | pawan
 Tags: drop all stored procedures  Remove all stored procedures  tips stored procedures  mssql server  sql server tips 

Sometimes, there is a case, when we need to remove all stored procedure completely from the database.

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

  MSSQLSERVER |   Wednesday, August 27, 2014   3482   8/27/2014 12:56:57 AM 1 Comment | Not Downloaded Yet!!! | No Demo | Pawan Kumar
 Tags: Delete all the rows  Delete all the rows from all the tables in Ms-SQL Server 

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)

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

  MSSQLSERVER |   Sunday, August 17, 2014   4140   8/17/2014 1:33:15 AM No Comments Yet!!! | Not Downloaded Yet!!! | No Demo | Pawan Kumar
 Tags: Get tables columns with increment value with SQL  Increment value of table  increment value  list of Get tables columns with increment value with SQL 

Here Pawan Kumar has explained, Get tables columns with increment value with SQL Snippet.

Get todays Day Name SQL server

  MSSQLSERVER |   Friday, August 1, 2014   4293   8/1/2014 9:23:42 AM 1 Comment | Not Downloaded Yet!!! | No Demo | Pawan Kumar
 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 

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.

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

  MSSQLSERVER |   Sunday, July 27, 2014   9250   7/27/2014 5:09:38 PM No Comments Yet!!! | Not Downloaded Yet!!! | No Demo | Pawan Kumar
 Tags: ABS function  negative a number to a positive number  use ABS function 

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.