USE [BPI]
GO
/****** Object:  StoredProcedure [dbo].[spOther_ListTablesAndColumns]    Script Date: 11/18/2011 11:50:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spOther_ListTablesAndColumns]
 
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
SELECT C.Table_Catalog DB,C.Table_Schema, C.Table_Name, Column_Name, Data_Type
 
FROM Information_Schema.COLUMNS C JOIN Information_Schema.TABLES T
 
ON C.table_name = T.table_name
 
WHERE Table_Type = 'BASE TABLE'
 
 
END

USE [BPI]
GO
/****** Object:  StoredProcedure [dbo].[spOther_CountRecordsTables]    Script Date: 11/18/2011 11:51:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spOther_CountRecordsTables] 
 
AS
DECLARE @CountTable nvarchar(200)
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
    -- Insert statements for procedure here
	SELECT @CountTable=COUNT(*) FROM [tblDistribution_base]
	Print'There are '+@CountTable+' records'
	END

USE [BPI]
GO
/****** Object:  StoredProcedure [dbo].[spOther_SumValues]    Script Date: 11/19/2011 19:11:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spOther_SumValues]
 
AS
DECLARE @SumTable nvarchar(200)

BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for procedure here
    SELECT @SumTable=sum(value) FROM [tblDistribution_base]
   
   
    Print'Total is '+@SumTable
    END

quote:

---

Originally posted by visakh16

sorry didnt get whats tblDistribution_base. is that table containing all table information?

---

quote:

---

Originally posted by piflechien73

quote:

---

Originally posted by visakh16

sorry didnt get whats tblDistribution_base. is that table containing all table information?

---

Hello,

Sorry if it was not clear. This table is just one of the user tables I created in the dB. I counted/summed for one table in the example, but of course I would like to automatize the process for all tables of the dB without naming them.

---