1161 0
SQL server connection string examples in C# & XML
In this article, I have provided various examples of SQL server connection string in C#, ASP.NET Web.Config file in XML format and MySQL connection string in C#.
Type
Article
C# SQL-server-connection-string sql-server-connection-string-c# sql-server-connection-string-integrated-security c#-database-connection
1070 0
Restore (Import) database from .bak file in SQL server (With & without scripts)
In this short article, I am giving steps with images to restore database from .bak file in SQL server & I have also explained ways in sql server to restore database from bak file using script.
Type
Article
SQL restore database using .bak sql server sql restore database from bak file script
1057 0
SQL server date format and converting it (Various examples)
This article provides you in-depth knowledge of SQL server date format available and how to convert from one date format to other using examples
Type
Article
SQL Sql server date format date format conversion SQL
1036 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
sql performance tips
983 2
Where can I download SQL server 2016 express full?

Hi, I have searched on google about links to download complete sql server express 2016 full version but i wasn't able to find it, as previous version of SQL Server Express were available in both web and full downloads, so can anyone provide me link(s) to download full sql server express 2016(preferred) or 2017 edition

Need offline installer, thanks

...
Type
Question
SQL-Server-2016 sql express 2016 offline installer sql express 2016 management studio

953 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
SQL stored procedure in sql server stored procedure in sql sql create stored procedure sql server procedure
879 2
Getting error 'A transport-level error has occurred when receiving results from the server.'

When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

...

Type
Question
SQL sql-server transport-level error
753 0
Row constructor in SQL server (Explanation With example)
This article gives a quick explanation about Row constructor (Table value constructor) in SQL server with various usage example
Type
Article
SQL Row constructor Table Value Constructor
746 1
How to open sql server configuration manager in windows 10?

I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks

...
Type
Question
SQL sql server configuration manager in windows 10
743 1
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question
SQL Back-up all-databases SQL-Server

Page 2 of 5