Congratulations to all
monthly winners of July 2014
Welcome Guest !
Submit and win prizes
Top 10 Posts
Prizes won by member
Subscribe to RSS
Post Coding Horror
ITIL Career Advice
PMP Career Advice
Ask a career advice
Search career advices
Post An Article
Questpond Interview Questions
Deccansoft Interview Questions
Interview Questions FAQs
Post An Interview Question
Post An Interview Experience
Search Interview Questions
Write a Post
Post a Video
Post a Code
Post a Blogs
Post a Poduct Catalog
Post Job Details
News and Events
Trusted RSS Feeds
Recommend an article
Post a News
Search Community Resources
Submit & win
Online Interviews Test
> Sql Server
Have question? ask now
Online training by expert
Winners & Prizes
Like us on Facebook
Top Articles Author
Thu, 21-Aug-2014 Authors
All Time Authors
(Statistics delayed by 5 minutes)
An Interview Question
A Post in Forum
A Career Advice Question
A Product Catalog
An Interview Experience
A Coding Horror
Sql Server Articles (174) - Page 1
Articles posted by registered members of DotNetFunda.com. You can also
post an article
win monthly prizes
as well as gain community
174 records found.
Missing Index Analysis and Creation.
Last updated on: 07 Aug 2014 06:59:23 AM by
| Views: 6225 | Category:
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.
Cascading delete in SQL Server
Last updated on: 19 Jun 2014 06:08:01 AM by
| Views: 6554 | Category:
out of 5
In this article, we shall learn how to enable cascading delete option while creating foreign keys constraints in the SQL Server database.
SSRS Demo Using Stored Procedure with Parameters
Last updated on: 22 Feb 2014 05:43:46 AM by
| Views: 2429 | Category:
out of 5
Hi friends today we will discuss about SSRS reports using Stored Procedure with Parameters.
How to create a SSRS report using sql server query
Last updated on: 21 Feb 2014 01:27:38 AM by
| Views: 1751 | Category:
out of 5
Hi friends today we are going to have a walk through on how to create SSRS reports using SQL queries
How to convert the row data to column in sql server
Last updated on: 20 Feb 2014 01:10:05 AM by
| Views: 1794 | Category:
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.
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
| Views: 1774 | Category:
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.
SQL Joins and replace NULL values with Predefined text
Last updated on: 22 Jan 2014 04:07:11 AM by
| Views: 4154 | Category:
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.
Insert, Update using OpenXML in Sql Server
Last updated on: 21 Dec 2013 02:25:04 PM by
| Views: 29464 | Category:
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
Working with Cast and Convert Sql-server function
Last updated on: 21 Dec 2013 07:07:44 AM by
| Views: 1983 | Category:
In this article we will learn about Working with Cast and Convert Sql-server function.
Working with Choose in-built Sql-Server Function.
Last updated on: 19 Dec 2013 04:32:02 AM by
| Views: 1388 | Category:
In this article,we will learn about working with CHOOSE in-built SQL Server Function.
Working with OUTPUT Parameters in Stored Procedure
Last updated on: 17 Dec 2013 12:09:41 AM by
| Views: 1376 | Category:
In this article, we will learn about Working with OutPut parameters in Stored Procedure.
Working with Transaction in Stored Procedure
Last updated on: 13 Dec 2013 12:15:51 AM by
| Views: 2622 | Category:
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.
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
| Views: 2618 | Category:
This article will explain how to create and use the File and File Group in SQL Server 2008.
Understanding SQL Server User-Defined Functions (UDFs)
Last updated on: 26 Aug 2013 12:26:30 AM by
| Views: 2711 | Category:
In this Article we will learn about User-Defined Functions (UDFs) in Sql Server.
A modified version of sp_helptext in SQL Server
Last updated on: 28 Jul 2013 04:23:03 PM by
| Views: 7614 | Category:
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.
Write for us
If you find plagiarised (copied) content on this page, please
let us know
original source along with your correct email id (to communicate) for action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 8/21/2014 8:06:41 AM