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.
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
Important: You should first run
upgrade. Neither of them automatically runs the other.
you can get the version of your nodejs by issuing command:
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.
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]
DECLARE @SQL varchar(5000)
SET @SQL = ' SELECT * FROM TableName';