14 DFómh 2009 · Is the important thing here to get a distinct list of those values, or to get that list of values into SQL? As @JeppeStigNielsen says, there are other ways to get distinct values …

I need to write a query to retrieve a big list of ids. We do support many backends (MySQL, Firebird, SQLServer, Oracle, PostgreSQL ...) so I need to write a standard SQL. The size of the id set cou...

I want to show on a GUI a table of all resource names. In one cell in each row I would like to list out all of the applications (comma separated) of that resource. So the question is, what is the …

What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored procedures, that would be even more helpful.

I have a query requiring details of a known list of customers (e.g by CustomerID - 1,79,14,100,123) The IN () function is what I would like to use for the query.

16 Ean 2014 · My SQL code is fairly simple. I'm trying to select some data from a database like this: SELECT * FROM DBTable WHERE id IN (1,2,5,7,10) I want to know how to declare the list …

13 Lún 2011 · I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored …

18 MFómh 2013 · I am going to get the list of all users, including Windows users and 'sa', who have access to a particular database in MS SQL Server. Basically, I would like the list to look …

20 Aib 2009 · How do I get a list of all index & index columns in SQL Server 2005+? The closest I could get is: select s.name, t.name, i.name, c.name from sys.tables t inner join …

My problem was with parameterised queries. The injected list param, always ended up having its values surrounded by quotes in the resulting SQL IN clauses which was confusing as hell. The …