天骄 电视剧在线播放:请问这句SQL语句是什么意思?
来源:百度文库 编辑:中科新闻网 时间:2024/05/04 12:25:56
strSqlModify = "UPDATE tblNewspaperInfo SET NewspaperInfoName = N'" + strNewspaperInfoName + "', NewspaperInfoURI = N'" + strNewspaperInfoURI + "',";
strSqlModify += "NewspaperInfoAbstract = N'" + strNewspaperInfoAbstract + "', NewspaperInfoCounter = " + intNewspaperInfoCounter + ", NewspaperInfoLogo = N'" + strNewspaperInfoLogo + "', NewspaperInfoUpdateTime = GETDATE() WHERE (NewspaperInfoID = " + intNewspaperInfoID.ToString() + ")";
什么意思?里面的“N’”是什么?
strSqlModify += "NewspaperInfoAbstract = N'" + strNewspaperInfoAbstract + "', NewspaperInfoCounter = " + intNewspaperInfoCounter + ", NewspaperInfoLogo = N'" + strNewspaperInfoLogo + "', NewspaperInfoUpdateTime = GETDATE() WHERE (NewspaperInfoID = " + intNewspaperInfoID.ToString() + ")";
什么意思?里面的“N’”是什么?
字符串前面的N代表:将字符串强制转换成扩展字符型
如,原来是char类型,则转换成nchar类型
原来是varchar类型,则转换成nvarchar类型
扩展字符型支持包括unicode编码在内的各类字符,而普通字符型则不支持
如果包含 N,则该字符串将解释为 nvarchar 数据类型,最大值为服务器的可用内存。
一般如果组成的字符串不超过4000的话,不使用N关键字效果也一样。
这个是数据更新
N不知道什么意思,好像不对
不知道..