Uncategorized

Difference Between sp_who & sp_who2

Posted on Updated on

Purpose of sp_who and sp_who2  is same.But some key differences are:

sp_who supports the limited columns information about currently running process in the SQL Server.

sp_who2 supports some extra columns information about currently running process in the SQL Server then sp_who command.

sp_who command is documented and officially supported by the Microsoft.

sp_who2 command is undocumented and don’t have any support from Microsoft.

sp_who2 is more widely used for better information of the running process.

The following images show the clear information about  sp_who and sp_who2.

sp_who

sp_who2

Installing SQL Server Management Studio

Posted on Updated on

Installing SQL Server Management Studio and connecting with Database

Difference between update and upgrade in Ubuntu

Posted on

apt-get update updates the list of available packages and their versions, but it does not install or upgrade any packages.

apt-get upgrade actually installs newer versions of the packages you have. After updating the lists, the package manager knows about available updates for the software you have installed. This is why you first want to update.

Important: You should first run update, then upgrade. Neither of them automatically runs the other.

Know version of NodeJS on Ubuntu

Posted on

you can get the version of your nodejs by issuing command:

node --version

Permissions error while installing Hyperledger Fabric Composer-Cli

Posted on

On Ubuntu (the supported Linux development environment) using sudo to install composer is not recommended.

Problem is the npm prefix which can get set to /usr/local to which the user doesn’t have write access. Issuing an npm config set prefix /home/[user]/ will solve the problem.

For example if username is “abcd” then try issuing following command:

npm config set prefix /home/abcd/

You may have an old version of Composer or one of the components installed. Try using npm ls -g –depth=0 to see if you have some composer code already installed, and if so remove it with npm uninstall -g composer- where might be cli, or playground etc. Then retry with the install -g command.

EF: Dynamic SQL Problem in Stored Procedure (Entity Framework)

Posted on

If your Stored Procedure is using Dynamic sql as shown in following example, you would probably be getting int as the return type of your EF: Function for this SP

CREATE PROCEDURE [sp_test]
AS
BEGIN
DECLARE @SQL varchar(5000)
SET @SQL =  ' SELECT * FROM TableName';
EXEC (@SQL)

END

Work-Around: