... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble).
How?
CREATE PROCEDURE [Common].[usp_ScrambleMultivalue]
(
@TableName ...
... 'P') IS NOT NULL
DROP PROCEDURE [usp_CountRecordsPerTablePerColumn];
GO
CREATE PROCEDURE [usp_CountRecordsPerTablePerColumn]
(
@p_Value int,
@p_Column varchar(max)
)
AS
/***********************************************************************************
** ...
... columns.
How?
IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL
DROP PROCEDURE [usp_ListDistinctValuesAndCounts];
GO
CREATE PROCEDURE [usp_ListDistinctValuesAndCounts]
(
...
... OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL
DROP PROCEDURE [Common].[usp_MyStoredProcedure];
GO
-- drop a view if it exists
IF OBJECT_ID ( '[Common].[uvw_MyView]', 'V' ) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.