Sql Server Articles (246) - Page 6

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

246 records found.
 
Pardhu2020
How to convert the row data to column in sql server 
Last updated on: 20 Feb 2014 01:10:05 AM by Pardhu2020 | Views: 4179 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.
Pardhu2020
Using import and Export Data tool how to send data from database to flat file 
Last updated on: 19 Feb 2014 05:23:32 AM by Pardhu2020 | Views: 4112 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In SSIS we using the import and Export Data we can send data from data base to flat file and same way flat file to database.
muralikrishnasurap-12704
SQL Joins and replace NULL values with Predefined text 
Last updated on: 22 Jan 2014 04:07:11 AM by muralikrishnasurap-12704 | Views: 14346 | Category: Sql Server |
We all know use of joins in SQL Server where we can merge two(or) more table information into one set of data based some predefined conditions.
Me_Himanshu
Insert, Update using OpenXML in Sql Server 
Last updated on: 21 Dec 2013 02:25:04 PM by Me_Himanshu | Views: 38054 | Category: Sql Server |
We were needed to insert basic details of a user through a registration page.The basic details being firstname, lastname, age, DOB, Address etc..Now inserting and updating the values in the database is very simple thing..But keeping in mind the performance, sometimes we need to adopt alternative methods of performing actions.Here We will Use OpenXML technology of SQL Server,i.e taking the bulk data in XML format and then inserting all the data in one or different tables
vishalneeraj-24503
Working with Cast and Convert Sql-server function 
Last updated on: 21 Dec 2013 07:07:44 AM by vishalneeraj-24503 | Views: 3942 | Category: Sql Server |
In this article we will learn about Working with Cast and Convert Sql-server function.
vishalneeraj-24503
Working with Choose in-built Sql-Server Function. 
Last updated on: 19 Dec 2013 04:32:02 AM by vishalneeraj-24503 | Views: 2844 | Category: Sql Server |
In this article,we will learn about working with CHOOSE in-built SQL Server Function.
vishalneeraj-24503
Working with OUTPUT Parameters in Stored Procedure 
Last updated on: 17 Dec 2013 12:09:41 AM by vishalneeraj-24503 | Views: 4700 | Category: Sql Server |
Votes: 1 | Rating: 3 out of 5
In this article, we will learn about Working with OutPut parameters in Stored Procedure.
  • vishalneeraj-24503
    Working with Transaction in Stored Procedure 
    Last updated on: 13 Dec 2013 12:15:51 AM by vishalneeraj-24503 | Views: 4474 | Category: Sql Server |
    Today we will see about working with Transaction in Stored Procedure. Sometimes it's required to have a Transaction in Stored procedure.Because if we are dealing with multiple DML(Data Manipulation Language) operations in sql-server,then we must implement transaction. If multiple statement is executing at the same time,so it's mandatory to have a Transactions. Transaction is a group a set of tasks into a single execution unit.Each transaction begins with a specific task and ends when all the tasks in the group successfully complete.If any of the tasks fails,the transaction fails. Therefore,a transaction has only two results i.e. Success or Failure. Incomplete steps result in the failure of the transaction. Users can group two or more Sql statements into a single transaction using the following statements: 1). Begin Transaction 2). Rollback Transaction 3). Commit Transaction By definition a transaction must be Atomic, Consistent, Isolated and Durable.
    Allemahesh
    How to create and use the File and File Group in Sql Server 2008. 
    Last updated on: 05 Sep 2013 04:41:11 AM by Allemahesh | Views: 6059 | Category: Sql Server |
    This article will explain how to create and use the File and File Group in SQL Server 2008.
    Deviprasads
    Missing Index Analysis and Creation. 
    Last updated on: 07 Aug 2014 06:59:23 AM by Deviprasads | Views: 24044 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    We get little confused, when the word INDEX comes into the picture? We ask so many questions to our-self before creating a non cluster index, as far as the performance is concern.
    Deviprasads
    A modified version of sp_helptext in SQL Server 
    Last updated on: 28 Jul 2013 04:23:03 PM by Deviprasads | Views: 17548 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    One of the most favorite Microsoft shipped Stored Procedure is sp_helptext and it can be used very often in our daily development job. Here we are going to modify that sp's logic little bit to help us more efficiently.
    aswinialuri-19361
    Back Up and Restore a database using sql server 
    Last updated on: 25 Jul 2013 07:38:13 AM by aswinialuri-19361 | Views: 5228 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    This article will explain you how to restore the database and how to take an backup of our database file , different types of backup and how it will be used.
    Niladri.Biswas
    Let us learn ROLLUP function in SQL Server 
    Last updated on: 20 May 2013 11:18:13 PM by Niladri.Biswas | Views: 3506 | Category: Sql Server |
    In this article, we will understand the basic functionality of ROLLUP function.
    Adamgorge
    Fundamentals of SQL Trace in SQL Server 2012 
    Last updated on: 02 May 2013 01:56:12 AM by Adamgorge | Views: 5305 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    An SQL Server trace can be used to record events that you are interested in. You can create trace file and trace table workloads easily using SQL Server Profiler.
    Niladri.Biswas
    Understanding SQL Server User-Defined Functions (UDFs) 
    Last updated on: 26 Aug 2013 12:26:30 AM by Niladri.Biswas | Views: 5681 | Category: Sql Server |
    In this Article we will learn about User-Defined Functions (UDFs) in Sql Server.