Sybase - La FAQConsultez toutes les FAQ

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
  
SELECT  
     convert(char(4), spid) Spid,  
     convert(char(4), blocked) Blk,  
     convert(char(4), cpu) CPU,  
          left(loginame,15) 'Users',  
     left(hostname, 15) 'Host',  
          left(db_name(dbid),15) DB,  
          convert(char(20), cmd) Command,  
     convert(char(12), program_name) Program ,  
     convert(char(10), status) Status  
FROM master..sysprocesses  
WHERE  spid = @@spid  
AND status not in ( 'BACKGROUND', 'sleeping')  
ORDER BY cpu DESC

1
2
3
  
sp_configure connections, n 
--n est le nombre de connections souhaitées.

1
2
  
set nocount on

1
2
  
set nocount off

1
2
  
set rowcount n

1
2
  
Set rowcount 0

1
2
  
SELECT * FROM MATABLE LIMIT 10, 30

1
2
3
4
5
6
7
8
  
SELECT * FROM (  
         SELECT TOP 10 Field1, Field2 FROM (  
         SELECT TOP 30 Field1, Field2  
         FROM  matable  
        ORDER BY monchamp asc  
        ) AS tbl1 ORDER BY monchamp desc  
        ) AS tbl2 ORDER BY monchamp asc

1
2
3
4
 
--Retouner 100 lignes d'une table T_Client 
SELECT TOP 100 * 
FROM t_client

1
2
3
4
5
6
7
  
SET ROWCOUNT 100 
GO 
SELECT * FROM t_client 
GO 
SET ROWCOUNT 0 
GO