测试1:
-- Search for a contact
SELECT
leibie,
rz,
gz,
tx,
r
FROM jcwdb.dbo.rhkini
WHERE id = 1;
GO--有无均ok
测试2:
insert into tb_fp ([悬挂类型]) values('1')
/*id一项未操作,自己叠加*/
测试3:
-- Search for a contact
SELECT
ProductID,
ProductName
FROM TestData1.dbo.Products
WHERE ProductID = 2;
GO--有无均ok
测试4:
insert into tb_fp ([悬挂类型],[接触导线型号],[柱号A],[柱号B],[最大风速],[线路情况],[ZH],[L],[R],[T],[a1],[a2],[跨距],[ZY2],[计算结果],[项目描述],[计算人],[计算日期]) values('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','20121221')
/*列名的[]可有可无*/ /*可以只存一个列,注意表设计中允许空值否*/ /*id一项未操作,自动叠加*/
insert into tb_headspan (覆冰厚度mm) values('TEST') --两个杠也是注释
测试5:
use jcwdb
go
select * from Tb_User WHERE (upwd = 123) AND (uname = 123)
测试6:
use DBLAB
-- Search for a contact
SELECT
*
FROM DBLAB.dbo.userinfo
--WHERE (userid = 9 )or( userPwd = "zhouyan")
WHERE userName = '周艳'
GO--有无均ok