How to change default systemdate from ymd to dmy

-- Set date format to day/month/year.
SET DATEFORMAT dmy;
GO
DECLARE @datevar datetime2 = '31/12/2008 09:01:01.1234567';
SELECT @datevar;
GO
-- Result: 2008-12-31 09:01:01.123
SET DATEFORMAT dmy;
GO
DECLARE @datevar datetime2 = '12/31/2008 09:01:01.1234567';
SELECT @datevar;
GO
-- Result: Msg 241: Conversion failed when converting date and/or time -- from character string.
GO

http://stackoverflow.com/questions/6054794/how-to-change-default-systemdate-from-ymd-to-dmy

Reset Identity Seed after deleting records in SQL Server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Go
Also maybe you need shrink your table
ALTER INDEX PK_yourIndexName ON YourTableName REBUILD
Also maybe you need duplicate your records on table
DECLARE @intFlag INT
SET @intFlag = 1
WHILE (@intFlag <=21)
BEGIN
INSERT INTO yourTableName SELECT TOP 1
field1,
field2,
field3,
...
FROM yourTableName
SET @intFlag = @intFlag + 1
END

How to increment DateTime field in MS-SQL

DECLARE @intFlag INT
SET @intFlag = 1
WHILE (@intFlag <=21)
BEGIN
UPDATE tblMedia SET mediaDate = DATEADD(day,@intFlag,GetDate()) WHERE order = @intFlag
SET @intFlag = @intFlag + 1
END


Dummy Images

Sometimes you need to use dummy images. 

http://dummyimage.com/

Sample dummy image;

http://dummyimage.com/225x200&text=1

I used in MS-SQL like that;

DECLARE @intFlag INT

SET @intFlag = 1
WHILE (@intFlag <=21)
BEGIN
UPDATE tblMedia SET bigImage = 'http://dummyimage.com/500x500&text=' + CONVERT(varchar(10), @intFlag) WHERE order = @intFlag
SET @intFlag = @intFlag + 1
END


SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

1) Example of WHILE Loop
DECLARE @intFlag INT
SET 
@intFlag 1
WHILE (@intFlag <=5)
BEGIN
PRINT 
@intFlag
SET @intFlag @intFlag 1
END
GO

ResultSet:
1
2
3
4
5

2) Example of WHILE Loop with BREAK keyword
DECLARE @intFlag INT
SET 
@intFlag 1
WHILE (@intFlag <=5)
BEGIN
PRINT 
@intFlag
SET @intFlag @intFlag 1
IF @intFlag 4
BREAK;
END
GO

ResultSet:
1
2
3

3) Example of WHILE Loop with CONTINUE and BREAK keywords
DECLARE @intFlag INT
SET 
@intFlag 1
WHILE (@intFlag <=5)
BEGIN
PRINT 
@intFlag
SET @intFlag @intFlag 1
CONTINUE;
IF @intFlag -- This will never executed
BREAK;
END
GO

ResultSet:
1
2
3
4
5

http://blog.sqlauthority.com/2007/10/24/sql-server-simple-example-of-while-loop-with-continue-and-break-keywords/