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:

Odoo 17 - Custom adds

    [1] Diario/Seq https://apps.odoo.com/apps/modules/17.0/sequence_for_journal