SharePoint MVP Bijay


.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 12057
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 2007
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 2072
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 2148
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 2173
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 2321
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 2393
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 1800
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 2221
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 1918
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 3027
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 1404
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 1427
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 1446
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 1877
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

SET XACT_ABORT ON in sql server
Posted By Bijay Kumar
16-Nov-2013 1:43 PM
Category : SQL Server
Views 1418
In this post we will discuss about SET XACT_ABORT in sql server 2008. Also you can check out my previous posts on:-

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements
Posted By Bijay Kumar
16-Nov-2013 12:32 PM
Category : SQL Server
Views 2567
Recently while working in an Asp.Net project, while communicating with data base using

Create a database by command in sql server 2008
Posted By shobhit
29-Sep-2013 4:27 PM
Category : SQL Server
Views 1294
In this post we will discuss how to create database by using command in sql server 2008. Also you can check my previous posts on:

Data files and Log files in sql server 2008
Posted By shobhit
28-Sep-2013 1:41 PM
Category : SQL Server
Views 1971
In this post we will discuss about Data files and log files in sql server 2008. Also you can check out my previous posts on:

Identity in sql server 2008
Posted By shobhit
19-Sep-2013 6:54 AM
Category : SQL Server
Views 1182
In this post we will discuss about identity column and identity functions in sql server 2008. Also check out my previous posts on:

Triggers in sql server 2008
Posted By shobhit
18-Sep-2013 9:33 AM
Category : SQL Server
Views 1947
In this post we will discuss about Triggers in sql server. Also you can check my previous posts on:-

Error functions in sql server
Posted By shobhit
18-Sep-2013 8:37 AM
Category : SQL Server
Views 1626
In this post we will discuss about various error functions in sql server 2008. Also you can check my previous posts on:-

Transaction in SQL Server 2008
Posted By Bijay Kumar
14-Sep-2013 4:40 PM
Category : SQL Server
Views 1644
In this post we will discuss about Transactions in SQL Server 2008. Also you can check out my previous posts on:-

Constraints in SQL Server 2008
Posted By Bijay Kumar
13-Sep-2013 8:29 PM
Category : SQL Server
Views 7114
In this article, we will discuss about different Constraints in SQL server.The Constraints are like Not Null, Unique, Primary key, Check, Default, For

Modify table structure in GUI in Sql Server 2008
Posted By shobhit
13-Sep-2013 7:00 PM
Category : SQL Server
Views 990
In this post we will discuss about how to modify table structure in GUI in sql server 2008. Also you can check out my previous posts on:

Get weekday name in sql server 2008
Posted By shobhit
13-Sep-2013 10:54 AM
Category : SQL Server
Views 1405
In this post we will discuss how to get the weekday name in sql server 2008. Also you can check my previous posts on:-

How to find the difference in retrieving data with and without using index in sql server 2008?
Posted By shobhit
13-Sep-2013 10:23 AM
Category : SQL Server
Views 1485
In this post we will discuss how we can find the difference in retrieving data with and witout using Index in sql server 2008. Also you can check out

Change authentication mode after installation of SQL Server
Posted By Bijay Kumar
12-Sep-2013 2:36 PM
Category : SQL Server
Views 901
In this post we will discuss how to change authentication mode after installation of SQL Server 2008. Also you can check my previous posts on:

Query to get records between two dates in sql server 2008
Posted By Bijay Kumar
05-Sep-2013 9:20 AM
Category : SQL Server
Views 1438
In this post we will discuss how we can retrieve records between two dates in sql server 2008. Also check out my previous posts on:

Single stored procedure to insert update and delete in sql server 2008
Posted By shobhit
26-Aug-2013 8:51 AM
Category : SQL Server
Views 1562
Here is this post we will discuss how to write a single stored procedure that will insert, update and delete in the table in Sql server 2008. Also you

Go to Page:       





LinkedIn Bijay



SharePoint Product Review or Sponsor Posts or Product Reviews
SharePoint Training and Office 365 Consulting
SharePoint Youtube Channel EnjoySharePoint


.Net Articles Tags