我的开发天空 [很惊人的 asp.net 教学] 十八页

[复制链接]

goodday

2007-10-31 08:56 PM

考我近来的难题

一条 t-sql 留最后1000 条多的delete

Super-Tomato

2007-10-31 10:21 PM

原帖由 goodday 于 2007-10-31 08:56 PM 发表
考我近来的难题

一条 t-sql 留最后1000 条多的delete

使用DELETE, ORDER BY 和 LIMIT 1限制刪除即可

Dhilip89

2007-10-31 10:31 PM

原帖由 goodday 于 2007-10-31 08:47 PM 发表
好久没来
上面的两大高手过招

大家快排排坐，看程式~~~~

我也发招

Program to compute

static int Fibonacci (int x)
{
Console.WriteLine ("x = {0}", x);
if (x

我也来一个:

fibonacci.c

#include <stdio.h>
main()
{
int n, i;
printf("Input: ");
scanf("%d", &n);
printf("Fibonacci sequences: %d\n", n);
for (i = 0; i <= n; i++)
{
printf("%d", f(i));
if (i <= n - 1) printf(", ");
}
printf("\n");
}
int f(int n)
{
if (n <= 1) return(n);
return(f(n - 1) + f(n - 2));
}

复制代码

dhilip89@dhilip89-desktop:~$ gcc '/home/dhilip89/Desktop/fibonacci.c' -o fibonacci.out
dhilip89@dhilip89-desktop:~$ '/home/dhilip89/fibonacci.out'
Input: 20
Fibonacci sequences: 20
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584, 4181, 6765

goodday

2007-10-31 10:37 PM

"Delete from AuditLog where LogNumber not in (select Top 1000 LogNumber from AuditLog order by LogNumber desc)"

Super-Tomato

2007-10-31 10:50 PM

原帖由 goodday 于 2007-10-31 10:37 PM 发表
"Delete from AuditLog where LogNumber not in (select Top 1000 LogNumber from AuditLog order by LogNumber desc)"

最後1000條的話就不用選擇最高的LogNumber, 而且最好是使用所有資料庫都支援的sql寫法, 這樣比較有伸縮性.

goodday

2007-10-31 11:10 PM

番茄兄我的Fibonacci 错咯

Dhilip89

2007-10-31 11:15 PM