Stairway to SQL Server Replication SQL Replication can solve many problems in running database-driven applications. The publication/subscriber model isn't completely easy to understand, the complexities of scripting and monitoring replication systems takes some thought. Here, at last, is a series of articles that takes care to produce a jargon-free approach to SQL Server Replication of all types..

CONVERT(varchar(20), GETDATE(), 0) /*03 17 2010 1:54PM */ CONVERT(varchar(20), GETDATE(), 1) /*03/17/10 */ CONVERT(varchar(20), GETDATE(), 2) /*10.03.17 */ CONVERT(varchar(20), GETDATE(), 3) /*17/03/10 */ CONVERT(varchar(20), GETDATE(), 4) /*17.03.10 */ CONVERT(varchar(20), GETDATE(), 5) /*17-03-10 */ CONVERT(varchar(20), GETDATE(), 6) /*17 03 10 */ CONVERT(varchar(20), GETDATE(), 7) /*03 17, 10..