Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

How to Remove HTML Tags from String in SQL Server

Apr 2, 2014 1 comments
Introduction:

Here I will explain how to remove html tags from string in
SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove text between < and > and get only text from string in SQL Server.
Description:

To implement this functionality we need to create one user defined function to parse html text and return only text

SQL Server - How to Drop / Delete Column from Table in 2008

Mar 13, 2014 1 comments
Introduction:

Here I will explain how to drop column in SQL Server or delete columns from table in SQL Server 2008.

Description:

In previous articles SQL Query to get list of tables in database, SQL add auto increment column to table, SQL Server ACID properties, SQL date diff function example  and many articles related to SQL Server. Now I will explain how to drop or delete columns from table SQL Server.

SQL Server - How to Get Only Month and Year From Date

Mar 12, 2014 1 comments
Introduction:

Here I will explain how to get only month and year from date in
sql server or extract only month and year from date time field in sql server.
Description:

Function Example in SQL Server 2008

Mar 9, 2014 2 comments
Introduction:

Here I will explain
sql server function example or create function example in sql server 2008. Functions in sql server is used to accept input parameters and it will return single value or table.
Description:

Clearing the Recent Servers List in SQL Server Management Studio

Mar 6, 2014 1 comments
Introduction:

Here I will explain how to clear recent
SQL server connection list from dropdown in SQL server management studio.
Description:
In previous articles I explained difference between view and stored procedure in SQL, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to clear recent SQL server connection list from dropdown in SQL server management studio.

Get Time Difference between Two Dates in SQL Server

Feb 12, 2014 6 comments
Introduction:

In this article I will explain how to get time difference between two dates in
SQL server.
Description:
In previous articles I explained SQL DATEDIFF Function to show date difference in days, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get time difference between two dates in SQL server.

SQL Sever Datediff() Function to Show Date Difference in Days Hours Minutes

Feb 6, 2014 5 comments
Introduction:

Here I will explain datediff() function in SQL Server with example to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format.
Description:
In previous articles I written SQL query to get data between two characters range, Get table size in SQL Server, SQL Server reset identity column to 1 in database, SQL Server acid properties and many articles related to SQL Server. Now I will explain datediff() function in SQL Server to get date difference in days hours minutes between two dates

SQL Server Get Data between Two Characters Range Start with A to C

Feb 2, 2014 4 comments
Introduction:

Here I will explain how to get data between two characters range in
SQL server or get user details start with A-C range in SQL server.

Description:

In previous articles I explained Acid Properties in SQL Server, Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, can function return multiple values in SQL Server and many articles relating to SQL server. Now I will explain how to get data between two characters range in SQL server.

SQL Server - Get Stored Procedure Last Modified Date or Updated Date in SQL Server

Jan 20, 2014 3 comments
Introduction:

Here I will explain how to get stored procedure last modified date in
SQL server or SQL server check last updated date stored procedure or query to check stored procedure modified date in SQL server 2008.
Description:

SQL Server - Query to Get List of Tables in Database in SQL Server 2008

Dec 9, 2013 3 comments
Introduction:

Here I will explain
SQL server query to get list of all tables in database or get list of all the tables in SQL server 2008 database.
Description:

SQL Server - How to Get Database Size in SQL Server 2008

Dec 4, 2013 1 comments
Introduction:

Here I will explain how to get database size in
SQL server or query to get database size in SQL server 2008.
Description:

SQL Server Add Auto Increment Column or Set Auto Increment Column SQL Server Management Studio

Nov 25, 2013 3 comments
Introduction:

Here I will explain how to set or add auto increment column in SQL server or create auto increment column in SQL server 2008 using management studio.
Description:

In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).
To set auto increment column in table we have different methods

SQL Server - Reset Identity Column Value to 1 in SQL Database

4 comments
Introduction:

Here I will explain how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server. or reseed identity column value in 
SQL server.
Description:

In previous post I explained how set identity or auto incrementcolumn in SQL server. After set identity property on particular column I inserted few records in table and that value automatically increase whenever I inserted data that would be like this

SQL Server - Acid Properties (Atomicity, Consistency, Isolation, Durability) Example

Sep 16, 2013 3 comments
Introduction:

Here I will explain SQL Server ACID properties those are Atomicity, consistency, isolation, durability with Example.
Description:

SQL Server - Show Time Difference in Minute Ago, Hour Ago, Day Ago, Week Ago, Month Ago

Sep 5, 2013 3 comments
Introduction

Here I will explain SQL Server query to get date time difference in minute ago, hour ago, day ago, week ago or month ago format in SQL Server 2008 / 2005 or how to get date time format in minute ago, hour ago, day ago, week ago or month ago in SQL Server 2008 / 2005.

Description

In previous articles I explained SQL Server Get only date or time from date time field,  SQL Server get list of procedures which contains table name, SQL Server can function return multiple values, SQL Server update multiple tables with inner joins, SQL Server difference between view and stored procedure and many articles relating to SQL Server. Now I will explain how to write query to get date time in minute ago, hour ago, day ago, week ago or month ago format in SQL Server.

SQL Server - Get Date or Time From Date Time Column / Field in SQL Server 2008 / 2005

Sep 4, 2013 3 comments
Introduction

Here I will explain SQL Server query to get only date or time from date time field in SQL Server2008 or 2005 or how to get only date or time from current date time field in SQL Server 2008 / 2005.

Description

In previous articles I explained sql server get list of procedures which contains table name, SQL Server difference between view and stored procedure, SQL Server difference b/w LEN and DATALENGTH functions and many articles relating to SQL Server. Now I will explain how to get only date or time from date time field in SQL Server.

SQL Server - Get Time Part Only From DateTime Column in 2008 / 2005

Sep 3, 2013 2 comments
Introduction:

Here I will explain how to get only time from datetime in SQL Server 2008 / 2005 or SQL Query to get only time part from datetime column or field in SQL Server 2008 or 2005.

Description:

In previous posts I explained get only date from datetime in SQL Server, Add row items as string with comma separated values, Exception handling in SQL Server with try catch, Add identity property to existing column in sql server, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get only time from datetime in SQL Server.  

SQL Server Get List of Stored Procedures Where a Table Name is Used

3 comments

Introduction:

Here I will explain SQL Server query to get a list of stored procedures where table is used or SQL query to get list of procedures which contains table name in SQL Server.

Description:

In previous posts I explained can function return multiple values in SQL Server, Difference between view & stored procedure in SQL, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get list procedures which contains particular table in SQL Server.  

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.