return al rows function in sql 2005

• erdbeeermundinord

  SSC Rookie

  Points: 30

  More actions

  November 8, 2005 at 6:55 am

  #166624

  where is the return all rows function in sql 2005?

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  November 8, 2005 at 7:17 am

  #602784

  Uhm, please specify what you mean exactly. At least, if not this works:

  SELECT * FROM [tablename]

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/