Download Smart Invoice v1.0 - ASP.NET Invoice Software System Ready to use, Open Source Invoice System Project(ASP.NET, jQuery & MS-SQL)

.Net

ASP.NET ASP.NET MVC C#/C Sharp VB/VB.NET LINQ Win Forms

Web Development

AJAX CSS HTML HTML5 Javascript jQuery

Database

SQL Ms-SQL Server MySQL Oracle

Languages

PHP Python Ruby Objective C XML Assembly Language Basic C/C++ CFML Classic ASP Fortran CGI/Perl Java Pascal

Mobile Development

SQL Ms-SQL Server MySQL Oracle

Others

SEO VBA

MS-SQL Server Tutorial - For Beginners & Professionals

|<<12>>|

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

In some conditions, we have the requirement of remove all user defined tables, user defined stored procedure and triggers from a particular database.

Demo and Full Guide

MSSQL Server 2008 remove all tables and stored procedures from database remove all tables and data from database remove all triggers remove all views drop all triggers drop all views

Remove or drop all stored procedures from database

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

Demo and Full Guide

drop all stored procedures Remove all stored procedures tips stored procedures mssql server sql server tips

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)

Demo and Full Guide

Delete all the rows 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

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

Demo and Full Guide

Get tables columns with increment value with SQL Increment value of table increment value list of Get tables columns with increment value with SQL

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.

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.

Demo and Full Guide

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

|<<12>>|