Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

DevASP.Net Articles and Samples
 ASP.NET (528)  VB.NET (195)
 C# (302)  Web Services (6)
 SQL Server (62)
 
  • PIVOT and UNPIVOT Operators in SQL Server
      This article will explain that what are PIVOT and UNPIVOT operators and how we can use these operators in our query in SQL Server.

  • What are the views and how to create a view in SQL Server
      This article will discuss about views and we will also see how we can create a view in SQL Server.

  • How to get a string with unique words in SQL Server
      This article will demonstrate how we can get a string with unique words in SQL Server.

  • How to create a Trigger to pass parameter to stored procedure in SQL Server
      This article will explain how we can create a Trigger to pass parameter to stored procedure.

  • What is trigger in SQL Server?
      In this article, I will give you a good explanation of Triggers and I will also show you how you can use it.

  • What is cursor in SQL Server?
      I will give a good explanation of SQL Server cursors and syntax of cursor in this article.

  • What is User Defined Function and how to create User Defined Function in SQL Server?
      In SQL Server 2000, concept of User Defined Function (UDF) was introduced for users to create their own functions in T-SQL and UDF are available in SQL Server 2005 and 2008.

  • What is Replication in SQL Server?
      I will explain in this article about replication and types of replication in SQL Server.

  • What is Join and Join types in SQL Server
      Join is used when we have to get data from two are more tables. I will explain Join and Join types in this article.

  • Working with QUOTENAME and ASCII Common String functions in SQL server 2008.
      In this simple article you will learn that how to work with different common String functions in SQL Server using PL/SQL.

  • Working with RAND FLOOR LOG LOG10 EXP functions in SQL server 2008.
      In this simple article you will learn that how to work with different common Math functions like Rand Floor Log Log10 Exp Function in SQL Server 2008 using PL/SQL.

  • Working with ROUND () function in SQL server 2008.
      In this simple article you will learn that how to work with ROUND () function in SQL Server using PL/SQL.

  • Working with common MATH functions in SQL server 2008
      In this simple article you will learn that how to work with common MATH function in SQL Server using PL/SQL.

  • Working with PATINDEX() funciton in sql server 2008.
      In this simple article you will learn that how to work with PATINDEX () function in SQL Server using PL/SQL.

  • Working with CHARINDEX() funciton in sql server 2008.
      In this simple article you will learn that how to work with CHARINDEX () function in SQL Server using PL/SQL.

  • Working with REVERSE () function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with REVERSE () function in SQL Server using PL/SQL.

  • Working with SUBSTRING () function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with SUBSTRING () function in SQL Server using PL/SQL.

  • Working with LOWER () and UPPER () function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with LOWER () and UPPER () function in SQL Server using PL/SQL.

  • Working with DATENAME () function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with DATENAME () function in SQL Server using PL/SQL.

  • Working with Datepart() function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with Datepart() function in SQL Server using PL/SQL.

  • Working with DATEDIFF () function in SQL Server 2008 using PL/SQL.
      In this simple article you will learn that how to work with DATEDIFF () function in SQL Server using PL/SQL.

  • Working with keyword NOLOCK in SQL server 2008
      In this simple article you will learn that how to use NOLOCK keyword in PL/SQL and its advantages

  • Get top n records in SQL Server 2008 using PL/SQL
      In this simple article you will learn that how to retrieve top n records from database using PL/SQL

  • Working with SET ROWCOUNT in SQL Server 2008 using PL/SQL
      In this simple article you will learn working with SET ROWCOUNT command using PL/SQL in SQL SERVER 2008

  • How we can use Dynamic Management Views(DMV) using Sql Server 2005
      In This Article I will explain the way in which we can use DMV (Dynamic Management Views).

  • Creating Cursor using PL-Sql in Sql Server 2008
      In This article I will explain What is cursor, its Types and the way in which we can create Cursor and use it

  • Using Microsoft Notification Services using MS Sql Server 2005 (Part 2)
      In this article I will Explain regarding Microsoft Sql Server Notification Services this article consists of two parts, this is (part 2) of this article.

  • Using Microsoft Notification Services using MS Sql Server 2005 (Part1)
      In this article I will Explain regarding Microsoft Sql Server Notification Services this article consists of two parts, this is (part 1 ) of this article.

  • How we can develop database paging using PLSQL in Sql Server 2005
      In This article I will explain the way in which we can develop database paging using ROW_NUMBER() OVER keywords.

  • Implementing and Logging Error handling using PLSql in Sql Server 2005
      In This Article I will explains the way in which we can use try catch block like C#.net or VB.Net and also how we can Save Errors with properties to our log tables.

  • Using Truncate table in Procedure using Sql Server 2005.
      In this Article I will explain the best use of truncate table command. Why we should use truncate on the place of delete in Some Circumstances.

  • Using "sys.objects" in Sql Server 2008 using PL-SQL
      In This article i will Explain various members or property of Sys.Objects.

  • Techniques for Deleting Complex Records Set using Sql Server 2008
      This article Explain you 2 techniques for deletion of complex record set. And one of them is recommended.

  • Import Data from Note Pad Files to Sql Server 2008 using PL-Sql.
      In This Simple Article I will Explain the way in which we can Import Data From simple note pad txt Files to Sql Server 2008 Database Table.

  • Import data From Excel File to Sql Server 2008 Using PL-SQL
      In this article I will explain the way in which we can Import Data from Excel file, This technique did not require any Kind of Format file.

  • Check existence of any table using PL-SQL in SQL server 2008.
      In this simple article you will learn that how you can check existence of any table using PL-SQL

  • Get all objects in a database using PL-SQL in SQL server 2008.
      In this simple article you will learn that how you can get all objects in a database using PL-SQL in SQL.

  • Get table create and last modify date time using PL-SQL in SQL server 2008.
      In this simple article you will learn that how you can get table create and last modify date time using PL SQL

  • Working with new data type TIME introduced in SQL Server 2008. (SQL Server new features)
      In this simple article you will learn that how you can use new TIME data type in sql server 2008.

  • Working with new data type DATE introduced in SQL Server 2008. (SQL Server new features)
      In this simple article you will learn that how you can use new DATE data type in sql server 2008.

  • How to Generate Row Numbers using SQL 2005
      In this article I will discuss the analytical function ROW_NUMBER () that is introduced in SQL Server 2005. This function returns the sequential number.

  • How to Write Store Procedure (SP) in SQL Server
      In this article I will try to explain you how to write a store procedure in database (SQL Server 2005). This is a very basic article and it will help beginners in understanding the basic format of sto

  • Tip to Handle Nulls in SQL SERVER 2005
      Here I will try to give you a tip to handle NULLS that can make your result set disturbed and generate unwanted values which can make you to face many irritating problems.

  • Paging in SQL Server 2005 Database
      In normal situation we develop webpage and use paging property of Datagrid and Gridview. But if we use Data List that doesn’t support paging property or we need to control paging through SQL Server

  • SQL Server 2005 and WildCards characters
      This article eloborate about WildCards characters that have special meanings within SQL WHERE clauses, and SQL supports several wildcard types.

  • How we can Check Table Size in our database.
      This article is about how you can check the size of each table in your data base.

  • What is database Mirroring in SQL SERVER?
      The primary goal of Database Mirroring technology is to increase the database availability. When enabled, every update to the principal database is immediately reproduced onto the mirror database.

  • How to handle “apostrophe in a string” problem in MS SQL Server Insert Command
      In this simple article you will learn that how you can insert a apostrophe in a database with help of simple VB.Net command.

  • Check the size of each table in your Database
      This article is about how you can check the size of each table in your database.

  • How to decrypt value in SQL Server.
      This article is about how you can decrypt a value if it is store in encrypted form in the table. Here you can take the example of passwords which you have store in an encrypted form and know you want to decrypt.

  • How to encrypt value in SQL Server
      This article is about how you can encrypt a value before going to save it in a table. Here you can take the example of passwords which you want to store in an encrypted form.

  • Creating a Coma Parsing Function Using SQL Server
      This article is about how you can parse a comma string in sql server using a user defined function.

  • ADO.Net Data Providers, A Beginner’s Guide
      The article is basically about ADO and Database providers. In the days of old database system shipped with API that was specific to the particular database system.

  • How to Check Columns name and their types using Store Procedure
      This article is about how you can get the information about the table store in your database made in sql server 2000.

  • Delete All Procedures from a database using a Stored procedure in SQL Server
      In this article I’ll try to explain how you can create a stored procedure that deletes all other stored procedures from a database in Microsoft SQL Server.

  • How to dynamically change the executing SQL in a stored procedure in Microsoft SQL Server
      In this article I’ll try to explain how you can execute a different SQL statement depending upon an entered parameter in Microsoft SQL Server

  • How to create a Store Procedure in SQL Server
      In this article I will try to explain you about a store procedure, what are the advantages in using a store procedure and the default syntax of a store procedure.

  • Creating a Connection to the Data Source Using Sql Server
      This article will help you to get connected to the Sql Server database. Here I’ll discuss the basic Sql connection string and the properties involve.

  • How to define and use Cursors in SQL Server 2000.
      This article will help you understand the basic idea of cursors and learn how to use these cursors.

  • SQL Server 2000 and XML Integration.
      SQL Server 2000 tightly integrates with XML. We can get data from SQL Server 2000 in XML format. This article shows you how to get the benefits of SQL Server 2000 and XML Integration.

  • How to perform date operations in SQL Sever.
      This article shows you how to perform date operations in SQL Server using GetDate(), DateAdd(), and DateDiff() methods.

  • The Australian Software Company releases new SQL Delta Version 3.1
      Sydney, 10th May 2005 – TASC have released SQL Delta version 3.1, a high performance SQL schema and data comparison tool for analysis and synchronization of databases.

     
    Disclaimer - Privacy
    © 2002-2017 DevASP.net