Top "Sql" questions

Structured Query Language (SQL) is a language for querying databases.

Find all tables containing column with specified name - MS SQL Server

Is it possible to query for table names which contain columns being LIKE '%myName%' ?

sql sql-server tsql system-tables
SQL SELECT WHERE field contains words

I need a select which would return results like this: SELECT * FROM MyTable WHERE Column1 CONTAINS 'word1 word2 word3' …

sql select
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

sql oracle
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? …

sql sql-server sql-server-2005 tsql stored-procedures
SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card …

sql sql-server select join sql-update
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two …

sql sql-server tsql datetime sql-server-2005
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle …

sql sql-server sql-server-2008 tsql
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like …

php mysql sql security sql-injection
How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its 'parent' table, see below: Table: sale id (…

sql sql-server tsql sql-server-2005 sql-update