Use the ANSI information_schema views, this will also work in MySQL

select table_name 
from information_schema.columns 
where column_name = 'classtypeid'

• Use select into statement in sql

  I use SQL Server 2008. I have a database (Database1) that has one table (Table1) and I want copy the data of this table to another table (Table2) that it is in another database (Database2). How to I…

• inserting value in to SQL table and use SELECT statement

  I am trying to insert values from one table in to the other, with an additonal parameter that is required. For instance: INSERT INTO table1(someInt, someOtherInt, name, someBit) SELECT someInt,…

• SQL Server 2005 - Table Functions in a Select statement

  I have a table called PurchaseOrderDetail. TABLE PurchaseOrderDetail PurchaseOrderDetail int, Comments nvarchar(500) In the Comments field of each item I have a ‘;’ separated list that stor…

• Select rows not in another table, SQL Server query

  Subject table CREATE TABLE [dbo].[BS_Subject]( [SubjectID] [bigint] IDENTITY(1,1) NOT NULL, [DepartmentID] [bigint] NOT NULL, [SubjectName] [varchar](50) NOT NULL, [SubjectDescription…

• Spatial metadata table in SQL Server 2008

  I have a db and want to know if it contains any spatial tables. Is there a table in SQL Server that holds spatial metadata i.e. a list of all the spatial tables in the current db? Oracle has the use…

• SQL Statement Help - Select list of CustomerID, OrderDate with the most records in a table

  I'll be using the AdventureWorks Database to illustrate my problem. I need to show for a particular customer a list of OrderDate with the most Orders. My intial attempt was as follows: SELE…

• In clause in Select statement of SQL Server 2008

  I have an SQL Server Query: select *from table1 where column in ('list of values') When I execute this, I get all the details, however, when I do this: select *from table1 where column in (…

• autonumber in select statement in SQL Server

  I would like to create a select query statement with autonumber.. like.. select * from tbl1 will give me everything from table. The result I'd like to get is.. 1 data 2 data 3 …

• Select statement in trigger sql server

  How do I get the first column value of the inserted row in an AFTER INSERT trigger? I have a table for which I created a trigger for AFTER INSERT, and I want to get the first column value of the …

• SQL Statement Help - Select latest Order for each Customer

  Say I have 2 tables: Customers and Orders. A Customer can have many Orders. Now, I need to show any Customers with his latest Order. This means if a Customer has more than one Orders, show only t…