A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
USE [myDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sbs_ClearAllData] AS BEGIN SET NOCOUNT ON; -- Clear out tables EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'IF OBJECTPROPERTY(object_id("?"), "TableHasForeignRef") = 1 DELETE FROM ? else TRUNCATE TABLE ?' EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'IF OBJECTPROPERTY(object_id("?"), "TableHasIdentity") = 1 DBCC CHECKIDENT ("?", RESEED, 0)' -- Populate a couple of the tables. INSERT INTO myTable1 (Id, Code, Description, IsCredit) VALUES (NEWID(), 'D', 'Debit', 0) INSERT INTO myTable2 (Id, Code, Description, IsCredit) VALUES (NEWID(), 'C', 'Credit', 1) END
|Start Stop time - SQL looking to create a table with just the time a vehicle started moving and stopped||7||21|
|SQL Server / Update DB?||22||38|
|i can not succeed to feed a Store Proc (with an identity column) with a Datatable from C# , what am i doing wrong ? .||11||22|
|SQL Availablity Groups Shared Path||2||16|