代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/423601/2026328
sql 随机卡号.sql
--3.产生随机卡号的存储过程(一般用当前月份数\当前秒数\当前毫秒数乘以一定的系数作为随机种子)
create procedure proc_randCardID @randCardID char(19) OUTPUT
AS
DECLARE @r numeric(15,8)
DECLARE @tempStr char(10)
SELECT @r=R
www.eeworm.com/read/423601/2026332
sql 原始速度.sql
create table Test
(
bookid int,
bookName varchar(20),
bookPrice int,
bookProductName varchar(20)
)
delete from test
----
set nocount on --提高执行时间30%--50%
declare @bid int
www.eeworm.com/read/423601/2026338
sql top.sql
--TOP
select * from jobs order by min_lvl
--返回具体行数
select top 3 * from jobs order by min_lvl
--返回比例行数
select top 50 percent * from jobs order by min_lvl
--在最后一行附加多行信息
select top 3 with
www.eeworm.com/read/422730/2034566
sql script.sql
CREATE TABLE `address` (
`address_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`name` varchar(50) default NULL,
`address` varchar(200) default NULL,
`post` varchar(1
www.eeworm.com/read/422730/2034680
sql data.sql
INSERT INTO `brand` VALUES (1,'索尼','/images/logoes/20070806115655_s.gif','/images/logoes/20070806115709_s.gif',NULL,1);
INSERT INTO `brand` VALUES (3,'宏基','/images/logoes/20070806151456_s.gif','/imag