Home Forums SQL Server 2008 T-SQL (SS2K8) sp_getrecords to get all records from a table RE: sp_getrecords to get all records from a table

  • August 28, 2013 at 12:35 am

    #1645409

    Your stored procedure should be working fine. The code below is working on my system.

    use AdventureWorks2008R2;

    go

    create PROC [dbo].[sp_getrecords]

    (

    @TableName varchar(4000)

    )

    AS

    begin

    exec('select * from '+@TableName+'')

    end;

    go

    exec [sp_getrecords] 'DatabaseLog';

    exec [sp_getrecords] 'HumanResources.Department';

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **