Weekend Training
ASP.NET MVC, HTML 5 weekend training, click here
eBook free

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Top Articles Author
Sat, 31-Jan-2015 Authors
All Time Authors

Latest members | More ...

(Statistics delayed by 5 minutes)

Sql Server Articles (178) - Page 1

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



Last updated on: 29 Dec 2014 08:32:54 AM by Bandi | Views: 332 | Category: Sql Server |
Iam going to give an overview for SCHEMAs in SQL Server, by explaining CREATE , ALTER, DROP schemas.


Computed Columns in SQL Server 

Last updated on: 24 Dec 2014 12:50:20 AM by Bandi | Views: 447 | Category: Sql Server |
A computed column is computed from an expression that can use another column or columns in the same table. Functions, variables, constants, non-computed column names or any combination of all these may be used along with operators to create a computed column.



Last updated on: 23 Dec 2014 12:52:39 AM by Bandi | Views: 584 | Category: Sql Server |
The ALTER COLUMN T-SQL portion of the ALTER TABLE command is used to change a named column. There is a list of scenarios where this is not possible, such as a column used in a PRIMARY KEY or FOREIGN KEY constraint.


Database backup in sql server 2008 

Last updated on: 05 Dec 2014 05:17:53 AM by Pritik889 | Views: 597 | Category: Sql Server |
In this article we are going to discuss about SQL server backup task procedure.


Missing Index Analysis and Creation. 

Last updated on: 07 Aug 2014 06:59:23 AM by Deviprasads | Views: 8306 | 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.


Cascading delete in SQL Server 

Last updated on: 19 Jun 2014 06:08:01 AM by Sheonarayan | Views: 7162 | Category: Sql Server |
Votes: 1 | Rating: 5 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 Pardhu2020 | Views: 10166 | Category: Sql Server |
Votes: 1 | Rating: 5 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 Pardhu2020 | Views: 2038 | Category: Sql Server |
Votes: 2 | Rating: 5 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 Pardhu2020 | Views: 2059 | 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.


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: 1976 | 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.


SQL Joins and replace NULL values with Predefined text 

Last updated on: 22 Jan 2014 04:07:11 AM by Muralikrishna.Surap@Gmail.Com | Views: 4878 | 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.


Insert, Update using OpenXML in Sql Server 

Last updated on: 21 Dec 2013 02:25:04 PM by Me_Himanshu | Views: 30200 | 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


Working with Cast and Convert Sql-server function 

Last updated on: 21 Dec 2013 07:07:44 AM by Vishal@Neeraj | Views: 2190 | Category: Sql Server |
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 Vishal@Neeraj | Views: 1531 | Category: Sql Server |
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 Vishal@Neeraj | Views: 1688 | Category: Sql Server |
In this article, we will learn about Working with OutPut parameters in Stored Procedure.

Navigate to page:  1  2 3 4 5 6 7 8 ... 12