摘要: 1. Use stored procedures instead of heavy-duty queries. This can reduce network traffic as your client will send to the server only the stored procedure name (perhaps with some parameters) instead of ... 阅读全文
posted @ 2009-10-08 11:18 programming snail 阅读(393) 评论(0) 推荐(0) 编辑
摘要: select语句中只能使用sql函数对字段进行操作(链接sql server),select 字段1 from 表1 where 字段1.IndexOf("云")=1;这条语句不对的原因是indexof()函数不是sql函数,改成sql对应的函数就可以了。left()是sql函数。select 字段1 from 表1 where charindex('云',字段1)=1;字符串函数对二进制数据、字... 阅读全文
posted @ 2009-10-08 11:13 programming snail 阅读(322) 评论(1) 推荐(0) 编辑