I used this when creating dynamic sql query as default search condition

Ha ha, it happened with me also many times..:cool:

All of theses set to ON, and also there are more other requirements while creating indexed view

Really nice article 🙂

You can use @@ROWCOUNT

ALTER PROCEDURE [dbo].[usp_LogArchiveBBxEndTime]

@EtlArchiveLog_Id int,

@RowsSource int,

@RowsNew int,

@RowsChanged int,

@Sucessful bit,

@Description varchar(500)

AS

BEGIN

UPDATE dbo.EtlArchiveLog

SET TimeEnd = GETDATE(),

RowsSource = @RowsSource,

RowsNew = @RowsNew,

RowsChanged = @RowsChanged,

Successful = @Sucessful,

[Description] = @Description

WHERE EtlArchiveLog_Id = @EtlArchiveLog_Id

SET @RowsChanged...

Nice One 🙂

You can use below script to generate the script to add column.

SELECT 'Alter table [' +name + '] Add Rowchecksum varbinary(8000)' FROM sys.tables WHERE name LIKE 'Archivebbx%'

You can use cross database reference in the query, something like this...

USE TestDB

GO

INSERT INTO Table1

SELECT * FROM DB1.dbo.Table1

Do this for all tables one by one.

Or your database is small the...

As non clustered index contain Index Search key (Name) and clustered index key (ContactTypeId) in its leaf node.

SQL Server will scan Non clustered index.

Please refer to http://www.sqlservercentral.com/stairway/72399/

to learn about clustered...

You can pass comma separated string as a parameter and inside stored procedure call a function which will split comma separated string and return the result set.

It should not cause any difference

Thank you so much Eirikur, Jason, Alan and Lempster:-)

Or you can use Red gate schema compare tool. Please refer link below

http://www.red-gate.com/products/sql-development/sql-compare/

Check whether you can execute command line or this tool or VS Database Compare

You can use VS database project to backup schema. But I am not aware of how to automate the database project such that database project will get synced with database.

Very nice and detailed article. Thank you.