sqlserver常用命令

导入SqlServer：
bcp Lbs..Lbs_Log_2009_02_01 in 2010-10-12-00.txt -t"\t" -c -S127.0.0.1\
lingdong -T

SqlServer执行存储过程：

sqlcmd -Slocalhost -dlbs -E -Q " exec create_table_lbs @tableName='Lbs_Log_2010_10_29'"

存储过程判断表是否存在：
if not exists
(select * from dbo.sysobjects where id = object_id(@tableName)
and OBJECTPROPERTY(id, N'IsUserTable') = 1)