Forum: MS SQL  Jul 1st, 2009 |
| Replies: 2 Views: 533 Hi,
in MS SQL we have TOP some_value clause which means that only some first records are selected. For example:
select top 10 products from table_products
How can I select rows for example... |
| Forum: MS SQL Jun 25th, 2009 |
| Replies: 6 Views: 660 ahh. ok :) I have resultset generated from Sybase query. I have rewritten existing code into T-SQL and results I get are not equal so I think that result from Sybase is correct. |
| Forum: MS SQL Jun 25th, 2009 |
| Replies: 6 Views: 660 the queries I used in both cases are exactly the same and using the same database. |
| Forum: MS SQL Jun 25th, 2009 |
| Replies: 6 Views: 660 I think that collations are not used because order attribute is of type smallint |
| Forum: MS SQL Jun 25th, 2009 |
| Replies: 6 Views: 660 Hi.
I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause... |
| Forum: MS SQL May 21st, 2009 |
| Replies: 1 Views: 804 Hi Everyone.
I have problems with solving a sql question. There is an assumption:
The database of naval ships that took part in World War II is under consideration. The database has the... |
