.Net Articles By Category: SQL Server (64)



How to return multiple values from a function in sql server 2012?
Posted By Bijay Kumar
09-Jun-2015 7:11 PM
Category : SQL Server
Views 9792
In this post we will discuss how to return multiple values from a sql server function in sql server 2012. Here my requirement is I want to return mult

The service did not start due to logon failure in sql server
Posted By Bijay Kumar
28-Jan-2014 6:01 AM
Category : SQL Server
Views 1615
I go the error message while trying to start MSSQLSERVER service. The detailed error message is: Windows could not start the SQL Server (MSSQLServer)

How to trim spaces in column values in sql server 2008?
Posted By Bijay Kumar
08-Jan-2014 6:20 AM
Category : SQL Server
Views 1738
In this post we will discuss how we can get trims values of a column in sql server 2008.Also you can check out my previous p

Difference between Sequence and Identity in Sql Server
Posted By Bijay Kumar
23-Dec-2013 3:27 PM
Category : SQL Server
Views 1807
In this post we will discuss some of the difference between Sequence and Identity in Sql Server. Also you can check out my previous posts on:

Sequence in SQL Server 2012
Posted By Bijay Kumar
23-Dec-2013 2:59 PM
Category : SQL Server
Views 1788
In this post we will discuss about What is Sequence in SQL Server 2012? How to create a sequence in sql server 2012? And How to use sequence in SQL Se

Get stored procedure source text in sql server 2008
Posted By Bijay Kumar
22-Dec-2013 1:26 PM
Category : SQL Server
Views 1892
In this post we will discuss how to get stored procedure text in sql server 20

The database could not be exclusively locked to perform the operation rename database in sql server 2008
Posted By Bijay Kumar
05-Dec-2013 1:26 PM
Category : SQL Server
Views 1980
In this post we will discuss how we can resolve the error The database could not be exclusively locked to perform the operation which comes while rena

Rename database in sql server 2008
Posted By Bijay Kumar
05-Dec-2013 1:24 PM
Category : SQL Server
Views 1465
In this post we will discuss how to rename an existing database in sql server 2008. Also you can check out my previous posts on:

Rename table name or column name in sql server 2008
Posted By Bijay Kumar
05-Dec-2013 10:32 AM
Category : SQL Server
Views 1865
In this post we will discuss how we can rename a table name or a column name in sql server 2008 through sql query.Also you c

Drop Primary Key Constraint in sql server 2008
Posted By Bijay Kumar
05-Dec-2013 9:58 AM
Category : SQL Server
Views 1549
In this post we will check how we can drop a Primary Key Constraint in sql server 2008.Also you can check out my previous po

Add Primary Key Constraint to existing table in sql server 2008
Posted By Bijay Kumar
05-Dec-2013 9:56 AM
Category : SQL Server
Views 2328
In this post we will discuss how we can add Primary Key Constraint to existing table in sql server 2008.Also you can check m

Various Date Formats in SQL server 2008
Posted By Bijay Kumar
24-Nov-2013 9:17 AM
Category : SQL Server
Views 1157
In this post we will discuss about various date formats in sql server 2008. Also you can check my previous posts on:-

Get version in sql server 2008
Posted By Bijay Kumar
22-Nov-2013 3:20 PM
Category : SQL Server
Views 1189
In this post we will discuss how we can check whether our sql server is 32 bit or 64 bit, version of sql server 2008.I

How to use If else in sql server 2008?
Posted By Bijay Kumar
18-Nov-2013 3:37 PM
Category : SQL Server
Views 1188
In this post we will discuss how to use If Else statement in sql server 2008. Also you can check my previous psots on:-

Sql Server 2008 joins tutorial
Posted By Bijay Kumar
18-Nov-2013 3:22 PM
Category : SQL Server
Views 1597
In this post we will discuss about various types of joins in SQL Server 2008. The joins are like Equi-joins, Non Equi-joins, Self-joins, Cartesian-joi

Go to Page:       


SharePoint MVP Bijay











Write SharePoint Product Review Advertise SharePoint Products in EnjoySharePoint.com
SharePoint Online Training Write SharePoint Articles in EnjoySharePoint.com
SharePoint Consulting Office 365 Consulting
SharePoint Youtube Videos EnjoySharePoint


.Net Articles Tags