Top "Select-query" questions

How can I select from list of values in SQL Server

I have very simple problem that I can't solve. I need to do something like this: select distinct * from (1, 1, 1, 2, 5, 1, 6). Anybody …

sql-server select-query

SQL Server PRINT SELECT (Print a select query result)?

I am trying to print a selected value, is this possible? Example: PRINT SELECT SUM(Amount) FROM Expense

sql-server tsql select-query

SELECT * FROM tablename WHERE 1

I've been curious. What are the differences between these respective queries: SELECT * FROM `tablename` SELECT * FROM `tablename` WHERE 1 SELECT * FROM `…

sql select-query

Wildcard as parameter of stored procedure

Suppose, I have a stored procedure, that accepts one parameter - id, and returns some data corresponding to this id. …

sql stored-procedures interbase select-query