sql语句求助？
在编写用户有多种方式登录的时候，SQL语句是这样写的“SELECT * from users
WHERE (Pwd = @pwd) AND (abNumber = @ab) OR
(Pwd = @pwd) AND (bbNumber = @bb) OR
(Pwd = @pwd) AND (ccNumber = @cc) OR
(Pwd = @pwd) AND (CallCenterNumber=@hujiao) OR
(Pwd = @pwd) AND (MsgNumber = @msg) OR
(Pwd = @pwd) AND (XunHuNumber = @xunhu) OR
(Pwd = @pwd) AND (CunChuNumber = @cunchu) OR
(Pwd = @pwd) AND (VirtualNumber = @vpn) OR
(Pwd = @pwd) AND (DataExNumber = @dataex) OR
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
我一个项目，有个插入操作，具体是这样的：
我有进货信息表。在出货时选择相应的进货信息，输入数量，选择部门后，点保存按钮，由于网络延时，点一下没有反映，于是用户就又点一下，导致一次插入了两条记录:
例：
......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
