有这么一张表
CREATE TABLE [dbo].[CompanyConfig] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[e_id] [int] NOT NULL ,
[eesinaNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[isTel] [int] NOT NULL ,
[quhao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[logoImage] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[personEesinaNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isDefaultMoney] [int] NULL ,
[TelCycle] [int] NULL ,
[TelLoopNumber] [int] NULL ,
[isShowAd] [int] NULL ,
[saleID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO有这样一条记录
id e_id eesinaNum password isTel quhao logoImage personEesinaNum isDefaultMoney TelCycle
7 74 11023062220632 805145 1 0755 NULL 432358 1 1 1 1 NULL为什么写这条 SQL语句
select * from CompanyConfig where eesinaNum = '11023062220632'
查不出这条记录 !!!
有没有人遇到过个这样的问题???是字符串过长嘛??
CREATE TABLE [dbo].[CompanyConfig] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[e_id] [int] NOT NULL ,
[eesinaNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[isTel] [int] NOT NULL ,
[quhao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[logoImage] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[personEesinaNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isDefaultMoney] [int] NULL ,
[TelCycle] [int] NULL ,
[TelLoopNumber] [int] NULL ,
[isShowAd] [int] NULL ,
[saleID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO有这样一条记录
id e_id eesinaNum password isTel quhao logoImage personEesinaNum isDefaultMoney TelCycle
7 74 11023062220632 805145 1 0755 NULL 432358 1 1 1 1 NULL为什么写这条 SQL语句
select * from CompanyConfig where eesinaNum = '11023062220632'
查不出这条记录 !!!
有没有人遇到过个这样的问题???是字符串过长嘛??
from CompanyConfig
where replace(replace(rtrim(ltrim(eesinaNum)),char(13),''),char(10),'') = '11023062220632'