Gal kas naudojat Microsoft SQL serveri?

IT
#1

Gal kas naudojat Microsoft SQL serveri?

#2

mysql buvo tokia funkcija limitavimo, pvz:

"select * from lentele LIMIT 5,10;" - kurios pagalba galejo duomenis pateikti porcijomis, o kaip si problema isprendziama cia???

#3

negi niekas nezino?

#4

Bijau pameluot, bet gal su zodziu TOP?

cia pagooglines radau pvz:

The driver might not, but the database does. It doesn´t use the LIMIT
keyword, though.

You have to write something like:
SELECT TOP(10,20) …(normal query goes here)…

Can´t remember the exact syntax. Maybe the driver can be enhanced to
look for the first SELECT statement, rip it out of the query and
replace it with SELECT TOP(x,y)?

#5

Sintaksė čia: http://msdn.microsoft.com/library/en-us/tsqlref/ts_sa-ses_9sfo.asp?fra
me=true

Shar