how to remove cached your connection to Team Foundation under your user settings

if you still get an error message that mentions your old IP address, try emptying the cache folder at the following location:

C:\Users[USER]\AppData\Local\Microsoft\Team Foundation\X.0\Cache

This should force Visual Studio to use the new IP address that you provide in the sln file

Getting the list of parameters from a stored procedure in SQL

use the INFORMATION_SCHEMA.parameters view
 
SELECT parameter_name, ordinal_position,parameter_mode,data_type
FROM INFORMATION_SCHEMA.parameters
WHERE SPECIFIC_NAME = 'USP_TableList'


use sys.parameters and join that with sys.types

SELECT s.name AS parameter_name,
   parameter_id AS ordinal_position,
   CASE is_output WHEN 0 THEN 'IN' ELSE 'INOUT' END Parameter_Mode,
   t.name AS data_type
FROM sys.parameters s
JOIN sys.types t ON s.system_type_id = t.user_type_id
WHERE object_id = object_id('USP_TableList')

Here is the output

parameter_name	ordinal_position	parameter_mode	data_type
@id	1	IN	int
@Date	2	IN	date
@char	3	INOUT	char

Update query failing with error in MySQL Workbench

Follow the following steps before executing the UPDATE command: In MySQL Workbench

    Go to Edit --> Preferences
    Click "SQL Editor" tab and uncheck "Safe Updates" check box
    Query --> Reconnect to Server // logout and then login
    Now execute your SQL query

or

SET SQL_SAFE_UPDATES = 0;