Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sqlcmd   (RSS)

A simple example on how to get Return and Out parameter values using Ado.Net

Another short one. How to capture OUT and RETURN parameter values from a stored procedure in .Net. Well, I’ll let the example speak for itself. First create a stored procedure, this just take an in parameter and an out parameter, it declares a local variable
Posted by maspeng | 1 Comments
Filed under: ,

(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

The scenario: You try to connect to Sql Server but you are getting the following connection error (they vary depending on the provider used): Using the .Net SqlClient provider: ------------------------------------------------------------------------------------------------------------------------------------------------------------
Posted by maspeng | 1 Comments

Command prompt utilities, some resources in one place.

Sometimes there is some confusion on the different Command Prompt utilities. I will not go into detail on this, rather providing a collection of the online resources. The short summary is this: - ISQL is no longer supported, use SQLCMD - ISQL uses DB-LIB
Posted by maspeng | 0 Comments
Filed under: , ,
 
Page view tracker