SQL Server

Different types of keys in SQL

In this article I have tried to explain what is key and the different types of keys available with sql server-Super, Primary, Candidate, Composite, Secondary, Foreign and tried to provide example for each to make it more clear

SSIS - Creating a New package using Aggregate function

SSIS (Sql Server Integration Service): Here we can see about how to Create a package and to execute and manage it. This article explains the basic steps of creating a ssis package using an oledb source and oledb destination in which we get an aggregate result in destination using aggregate function in between them. Find how to create a New package using Aggregate function.

SQL query to display all Sundays in the current month.

In this article, I am going to explain how to display all Sundays of the current month. In my last post, I have discussed how to display whole dates of the current month. Now we will see how to display all Sundays of the current month.

Passing multiple values to SP

In this article,I explain about passing multiple values to a SP in order to retrieve the records from the table. Here, I used one table valued function to split the parameters and I choose comma as a delimiter to split.

Date and Time Functions of SQL Server 2008 R2

This article will describe the date and time functions which are available in the latest version of SQL Server 2008R2. Article will also show all the syntaxes which are required to use it in scenarios wherever required. This article is useful to all those who are working in Sql server database.

Count how many Sundays, Mondays, Tuesdays... in current month using MS SQL

In this article I am going to explain how to display how many Sundays, Mondays, Tuesdays etc in the current month. Now I will be explaining here how to do this. Please read and use it your application whenever it is required.

To display the whole dates of the current month in sql using CTE

In this article I am going to explain how to display the whole dates of the current month. For example current month is having 30 days, so how to display 1 to 30 days. This can be done many ways but finally I got below solution in my own. Learn how to display the whole dates of the current month in sql using CTE

Ranking Functions in Sql Server 2008

Ranking functions are the function which are used to order the numbers, to partition the result set, to arrange the number in sequence, to select the particular row with specific condition and to solve complex sql problems in easy manner.

Generate Script with data in SQL Server 2008

In this article, I am going to explain about How to Generate Script with data in SQL Server 2008 Database tables using Generate SQL Server Script Wizard. Generate Script is new concept of SQL Server 2008. It is useful for generate script with data in database tables.

Sql Server Constraints

This Article is about using Constraints in Microsoft Sql Server. There are six constraints Primary key, Foreign key, Unique, Not null, Check and Default. These Constraints allows us to define the ways in which we can automatically enforce the integrity of a database. Each constraint plays an important role in our database architecture.

Separation of column value using delimiter

In this article,I explain how to separate the column value by using a delimiter into different columns . The following article contains one sample table,function used to split and a procedure to separate the column value.

String Functions in Sql Server- Part2

In this article i explain about the Built-in String Functions in Sql Server. String Functions present in this part are Soundex, Difference, Quotename, Space, Charindex, Patindex, Substring, Replicate, Str. These string functions are used to format the string and in addition they are used to concatenate or compare strings.

String Functions in Sql Server- Part1

In this article i explain about the Built-in String Functions in Sql Server. String Functions present in this part are Upper, Lower, Ltrim, Rtrim, Left, Right, Ascii, Unicode, Char, Nchar, Reverse, Replace, Len, Stuff. These string functions are used to format the string and in addition they are used to concatenate or compare strings.

Pivot and Unpivot relational operators

In this article i explain about the concept of using pivot and unpivot relational operators to change a table-valued expression into another table. To convert one column in the table into multiple columns in the output PIVOT concept is used.

Triggers in sql server

In this article, I will explain about Triggers, types of triggers, working with DML triggers.

Split function(table valued) in sql

The table valued split function split one column based on some Di-limiter and create another table which shows result in column wise. De limiter can be comma or even white space. This function can be used any where the requirement is to split the value of column to be used as part in the program.

How to convert MS Access Database into SQL Server database?

In this article I have explained about how to convert/Migrate MS Access database (.mdb) into SQL Server Database (.mdf). Large numbers of data are stored in MS Access database is affecting your project speed and also difficult to handle data in MS Access. In that difficult situation we need to migrate MS access database to SQL Server Database with already available data on that existing MS Access tables. This article is help to you for transfer MS Access database to SQL Server database.

Operator in Sql Queries

SQL stands for Structured Query Language It can access and manipulate databases. It is an ANSI (American National Standards Institute) standard. Even Though SQL is an ANSI, there are many different versions of the SQL language. They all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. Sql Server is a Relational Database Management System.It is stored in database objects called tables.A table consists of columns and rows.

How to take back up and restore SQL server database?

In this article I have explained about how to take up of SQL Server database and restore backup database. In this example I have used SQL Server management studio for access SQL server database. This back up file is used to restore it another server or same server in future.

SSRS – Grouping – How to group the some particular fields in SSRS Reporting Services - Part 6

SSRS – Grouping – How to group the some particular fields in SSRS Reporting Services. Last few weeks i have been working with SSRS Reporting Services, moreover i shared some topices with you. It will be my success if any one reader uses my article.

To list Database name,Table name and procedures name in sql server

In this article, I will explain how to get list of database name in the sqlserver, list of tables name in the cuurent databse column names in the current table and stored procedures names that exist in the current database. given simple examples

SQL Server built-in String Functions with example

In this article, I will explain some of the SQL Server built-in String Functions with example. some of the built in function like lenth of the string LEN,LTRIM-left trim,RTRIM rigth trim,LEFT,RIGTH SUBSTRING,REPLACE, string REVERSE string LOWER and string UPPER

SSRS (SQL Server Reporting Services) – Manage custom code in SSRS - Part 3

I explained about Creating Reports and Expressions in Part 1 and 2 respectively. Here, I would like explain about how to create your own custom code or function with parameters. We can call these custome codes through Edit Expression windows of each fields in the SSRS Reports.

SSRS (SQL Server Reporting Services) – Expressions or Functions used in SSRS - Part 2

Expressions are usually used for appearance of the data in a report. In this article, i would like explain expressions or functions used in SSRS for each and every field which are inside the report. I would like to share my own findings of expressions or functions, why because, in which expressions I struggled a lot and I had wasted my time.

SSRS Tools and Methods and its Property and Function

This article explain you about some of the features that are available in SSRS and its functionality and how to use those property that are available in SSRS and how to implement the functions that are available and this will be helpful to make use of some of the few functions that are available in reporting services.