Tuesday, June 07, 2011

SQL Server::SQLCMD

cd C:\Archivos de programa\Microsoft SQL Server\100\Tools\Binn
C:..>SQLCMD -s 192.168.1.30 -U sa -P pass


sp_databases
use

sp_help tablename
select * from SYSOBJECTS where TYPE = 'U' order by NAME


references:
[1] http://msdn.microsoft.com/en-us/library/ms180944.aspx
[2] http://msdn.microsoft.com/en-us/library/ms165702.aspx

No comments:

Python3 version alternatives and virtual environments

Solving multiple python installation:   sudo update-alternatives --install /usr/ bin /python3 python3 /usr/ bin /python3 .5 1 sudo update...