Loading
Creating a SQL Server Database Programmatically using SQLDMO
The attached source code creates a SQL Server database programmatically using SQLDMO.
IIF and Choose Functions in SQL Server 2012
Here, I have provided an article showing you how to utilize the two new logical functions Choose and IIF in SQL Server.
Generating Script in SQL Server 2012
This article demonstrates how to generate script in SQL Server database.
Higher and Lower Precision System Date and Time Functions in SQL Server 2012
In this article, we covered system date and time in-built functions such as Sysdatetime, Sysdatetimeoffset, Sysutcdatetime, Getdate etc that returns the current date and time from the SQL Server.
Mathematical Numeric Functions in SQL Server 2012
Here, you will see how to use mathematical numeric functions in SQL Server, including how to round values.
Database Server-side Applications.Extensions to SQL
Developers have struggled with the power and limitations of SQL. SQL is language oriented to manipulate data set, but enterprise applications always need to implement business logic that goes beyond the reach of SQL. This article is intended to illustrate the main constructs in these database management systems.
Using OUTPUT Clause for Getting Deleting Information from Several Tables.
In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
Searching in User Profile Properties
Enabling search in membership profile properties using SQLSERVER2005 pluggable assembly created by C#.
Datename Function in SQL Server 2012
Here, you will see the DateName function that represents the specified datepart of the specified date such as day, month, year, quarter, hour, minute in SQL Server.
Sql Server 2005 features - Part II
In this article i have explained about the features introduced in the sql server 2005 edition.
New Built in Functions in SQL Server 2012 : DateTime Functions
In this article, let us see how to use the 7 new builtin DateTime functions of Microsoft SQL Server 2012 Release Candidate 0 with their syntax and sample queries.
How to Start and Stop Database Engine in SQL 2005
This article will show how to start, stop and restart the database engine in SQL Server 2005.
Best Practices for Data Transfer in SQL Server 2005
This article talks about some best practices and the process of data transfer in SQL Server 2005.
New Data Type Conversion Functions in SQL Server 2012
Today, I have provided an article showing how to utilize the new data type conversion Functions in SQL Server 2012.
Accessing Rmote SQL server by Remoting (TCP)
This article describes how to build a distribution application that accesses MS SQL Server 2000 with a remoting service.
An Overview of The New Features of SQL Server 2008
Gives an overview of the new features of SQL Server 2008.
Get Autoclose and Autoshrink Values for the Databases in Sql Server
In this article you will learn how to Get autoclose and autoshrink values for the databases in sql server.
SQL Server Integration Services (SSIS) - Executing SSIS package from Stored Procedure
SQL Server Integration Services (SSIS) – Executing SSIS package from Stored Procedure.
Predicates in SQL Server 2012
This article demonstrates use of predicates with SQL queries in a SQL Server database.
Useful SQL Commands in SQL SERVER
This article is about some very useful commands of SQL Server.
Create and Delete Database in SQL Server 2012
In this article, we will see how to create and remove a database in SQL Server 2012.
Determine the Second Highest and Nth Highest Salary From a Column in SQL Server 2012
In this article, we will see how to determine the second highest and Nth highest salary from a column in SQL Server 2012.
Creating a View Visually in SQL Server 2012
In this article, we will see how to create a view visually in SQL Server 2012.
Creating a View Programmatically in SQL Server 2012
In this article, we will see how to create a view programmatically in SQL Server 2012.
Offset and Fetch Next Keywords in SQL Server 2012
In this article I will explain the use of the new keywords OFFSET and FETCH NEXT in SQL server 2012.
How to Fetch Record Using Cursor in SQL Server 2012
In this article I am explaining how to fetch records using a cursor in SQL Server 2012.
How to Work With INSTEAD OF Trigger in SQL Server 2012
In this article I am going to explain about the INSTEAD OF trigger in SQL Server 2012.
How to Work With an AFTER Trigger in SQL Server 2012
In this article I explain triggers in SQL Server 2012.
How to Use Over Clause With Order By in SQL Server 2012
In this article I am going to explain how to use an over clause with Order By in SQL server 2012.
Throw Statement in SQL Server 2012
In this article I will explain the use of the throw statement in SQL Server 2012.
