The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
USE [xxx] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CEM_BulkOpsInsert] @tablename varchar(50), @table varchar(100) AS BEGIN SET NOCOUNT ON; Declare @error nvarchar(255) Declare @subject1 varchar(200) Declare @sql varchar(255) exec SF_BulkOps 'Insert',@tablename,@table Set @sql = 'Delete From ' + @table + ' WHERE LEN(ID) > 4' exec @sql Set @sql = 'select ' + @error + ' = COUNT(ID) From ' + @table + ' WHERE LEN(Error) > 4' exec @sql IF @error > 0 BEGIN Set @subject1 = 'Errors Exist In ' + @table + ' For ' + @tablename EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Host', @recipients = 'firstname.lastname@example.org', @body = '', @subject = @subject1; END END
|SQl Query to find x consecutive Nbrs in a Table||30||94|
|AD permissions required to allow computer objects and service accounts to register SPNs||1||25|
|Is there a better way to combine two queries||7||25|
|i can not succeed to feed a Store Proc (with an identity column) with a Datatable from C# , what am i doing wrong ? .||11||21|