插入值到数据库表中，（在线等）急

Question

查询分析器，上面有一个下拉选择DATABASE，默认是MASTER，

Answer 1

use 数据库名
insert into Tcuser_contact(cpname,lid,linkman,sex,email,depsrt,position,telc,relcity,telcity,faxc,faxcity,faxnum )values('cpname','1','linkmun','1','[email protected]','1','2','countryPhoneID','cityPhoneID','PhoneNumber','countryFaxID','cityFaxID','FaxNumber')

Answer 2

改為：
insert into 數據庫.dbo.Tcuser_contact(cpname,lid,linkman,sex,email,depsrt,position,telc,relcity,telcity,faxc,faxcity,faxnum )values('cpname','1','linkmun','1','[email protected]','1','2','countryPhoneID','cityPhoneID','PhoneNumber','countryFaxID','cityFaxID','FaxNumber')

Answer 3

use 数据库名
insert into Tcuser_contact(cpname,lid,linkman,sex,email,depsrt,position,telc,relcity,telcity,faxc,faxcity,faxnum )values('cpname','1','linkmun','1','[email protected]','1','2','countryPhoneID','cityPhoneID','PhoneNumber','countryFaxID','cityFaxID','FaxNumber')

Answer 4

use 数据库名
是不是
user dbnameinsert into Tcuser_contact(cpname,lid,linkman,sex,email,depsrt,position,telc,relcity,telcity,faxc,faxcity,faxnum )values('cpname','1','linkmun','1','[email protected]','1','2','countryPhoneID','cityPhoneID','PhoneNumber','countryFaxID','cityFaxID','FaxNumber')

Answer 5

insert into merchant.Tcuser_contact(cpname,lid,linkman,sex,email,depsrt,position,telc,relcity,telcity,faxc,faxcity,faxnum )values('cpname','1','linkmun','1','[email protected]','1','2','countryPhoneID','cityPhoneID','PhoneNumber','countryFaxID','cityFaxID','FaxNumber')务器: 消息 208，级别 16，状态 1，行 1
对象名 'merchant.Tcuser_contact' 无效。

Answer 6

merchant..tcuser_contact
--or
merchant.ownername.tcuser_contact