Sql Server Articles (246) - Page 5

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.
 
Bandi
Altering Tables in SQL Server 
Last updated on: 21 Apr 2015 06:12:16 AM by Bandi | Views: 3492 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In this article, we are going to look into ALTER TABLE statement and the best practices for altering a table
Bandi
Foreach File Enumerator in SSIS 
Last updated on: 21 Apr 2015 06:03:24 AM by Bandi | Views: 5956 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In this article, we are going to look into steps to loop though each file under a folder using ForEach file Enumerator.
Bandi
For each Loop Container in SSIS 
Last updated on: 21 Apr 2015 05:41:05 AM by Bandi | Views: 4198 | Category: Sql Server |
In this article, we are going to look into ForEach Loop Contrainer in SQL Server Integration Services. There are seven different types of Loops/enumerators under ForEach Loop Container..
Bandi
Sequences in SQL Server 2012 
Last updated on: 20 Apr 2015 08:26:25 AM by Bandi | Views: 2353 | Category: Sql Server |
Votes: 1 | Rating: 4 out of 5
Sequences are introduced in SQL Server 2012, to generate sequential number according to the definition. Also, it is independent of any other objects. As comparison to IDENTITY, Identity property is specific to single table where as Sequence produces numbers to different objects.
Bandi
SQL Server Agent Jobs Creation 
Last updated on: 21 Apr 2015 05:19:44 AM by Bandi | Views: 2274 | Category: Sql Server |
Votes: 1 | Rating: 4 out of 5
I would like to give the basic job creation steps using SQL Server Agent.
Bandi
Updatable Views in SQL Server 
Last updated on: 20 Apr 2015 05:24:30 AM by Bandi | Views: 2232 | Category: Sql Server |
The one of most important usage of updatable view is to do two-way synchronisation between two databases in the same server.
Bandi
Creation of Views with different options 
Last updated on: 20 Apr 2015 04:44:24 AM by Bandi | Views: 2504 | Category: Sql Server |
Views in SQL Server provides you to work with virtual tables, to hide complex queries or sensitive data.
  • Vijethamm
    Connecting to SQL database through Sql Server Management Studio 
    Last updated on: 24 Feb 2015 08:57:55 PM by Vijethamm | Views: 3439 | Category: Sql Server |
    This article is initial step which helps the Beginner to get connected to SQL Server using the tool SQL Server Management studio.
    Bandi
    ALTER COLUMN in SQL Server 
    Last updated on: 23 Dec 2014 12:52:39 AM by Bandi | Views: 2708 | 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.
    Bandi
    Computed Columns in SQL Server 
    Last updated on: 24 Dec 2014 12:50:20 AM by Bandi | Views: 3598 | 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.
    Bandi
    SCHEMA Creation, TRANSFER and DROP 
    Last updated on: 29 Dec 2014 08:32:54 AM by Bandi | Views: 2088 | Category: Sql Server |
    Iam going to give an overview for SCHEMAs in SQL Server, by explaining CREATE , ALTER, DROP schemas.
    Pritik889
    Database backup in sql server 2008 
    Last updated on: 05 Dec 2014 05:17:53 AM by Pritik889 | Views: 2299 | Category: Sql Server |
    In this article we are going to discuss about SQL server backup task procedure.
    Sheonarayan
    Cascading delete in SQL Server 
    Last updated on: 19 Jun 2014 06:08:01 AM by Sheonarayan | Views: 11126 | 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.
    Pardhu2020
    SSRS Demo Using Stored Procedure with Parameters 
    Last updated on: 22 Feb 2014 05:43:46 AM by Pardhu2020 | Views: 63970 | Category: Sql Server |
    Votes: 2 | Rating: 4.5 out of 5
    Hi friends today we will discuss about SSRS reports using Stored Procedure with Parameters.
    Pardhu2020
    How to create a SSRS report using sql server query 
    Last updated on: 21 Feb 2014 01:27:38 AM by Pardhu2020 | Views: 3962 | 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