Generate SQL Server Views (MyGeneration)

Added a new MyGeneration template archive that contains a template that generates views from your tables (SQL Server) - Generate SQL Server Views.

Returns NULL's if blank string and column allows NULL's. Also breaks down dates into component parts (i.e. Month, Day, Year) and to other formats:

  • Short Date (mon dd yyyy)
  • Short Time (hh:mm)
  • US Date (mm/dd/yyyy)
  • ANSII Date (yyyy.mm.dd)
  • UK Date (dd/mm/yyyy)
  • German Date (dd.mm.yyyy)
  • Italian Date (dd-mm-yyyy)

Example Output:

USE [news]
GO

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
         WHERE TABLE_NAME = 'vw_News')
   DROP VIEW vw_News
GO

CREATE VIEW [vw_News]
AS
SELECT
		[ID] AS [NewsID],
		NULLIF ([Title], '') AS [News Title],
		NULLIF ([Url], '') AS [News Url],
		[Added] AS [Date Added],
		CONVERT ( char(11) , [Added] , 113) AS [Date Added_ShortDate],
		CONVERT ( char(5) , [Added] , 108) AS [Date Added_ShortTime],
		CONVERT ( char(10) , [Added] , 101) AS [Date Added_USDate],
		CONVERT ( char(10) , [Added] , 102) AS [Date Added_ANSIIDate],
		CONVERT ( char(10) , [Added] , 103) AS [Date Added_UKDate],
		CONVERT ( char(10) , [Added] , 104) AS [Date Added_GermanDate],
		CONVERT ( char(10) , [Added] , 105) AS [Date Added_ItalianDate],
		{ fn DAYNAME ([Added])  } AS [Date Added_DayName],
		DAY ( [Added] ) AS [Date Added_Day],
		{ fn MONTHNAME ([Added])  } AS [Date Added_MonthName],
		MONTH ( [Added] ) AS [Date Added_Month],
		YEAR ( [Added] ) AS [Date Added_Year]
FROM [news]
GO
PRINT 'View Creation: vw_News Succeeded'
GO

Comments

Post a Comment

Popular posts from this blog

Text Clips for Programmers Notepad 2 (XHTML)

Update (23 June, 2005) : Added DOCTYPEs. More Programmers Notepad 2 text clips. Some tags are not included (b, big, i, small, sub, sup) as these can be replaced with existing tags (em, strong), or styled using CSS. Create a file in the clips sub directory of the Programmers Notepad directory, with the extension .clips (i.e. xhtmltags.clips) and paste in the following code: <?xml version="1.0"?> <clips name="XHTML Tags"> <clip name="------ DOCTYPEs ------"></clip> <clip name="XHTML 1.0 transitional"><![CDATA[<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">|]]></clip> <clip name="XHTML 1.0 strict"><![CDATA[<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">|]]></clip> <clip name="XHTML 1.1...
Read more

Shrink Image (JavaScript)

This function shrinks an image, so its dimensions are no bigger than the maximum dimensions you define. // get new dimensions so it fits within the maximum // o = original dimensions / image, m = maximum dimensions function shrink(o, m) { // r = resized var r = {width: o.width, height: o.height}; // if an image, rather than an object, resize it if(o.nodeName && o.nodeName.toLowerCase() == "img") r = o; if(r.width > m.width) { r.height = r.height * (m.width / r.width); r.width = m.width; if(r.height > m.height) { r.width = r.width * (m.height / r.height); r.height = m.height; } } else if(r.height > m.height) { r.width = r.width * (m.height / r.height); r.height = m.height; } return r; } To use, simply supply the image and the dimensions to constrain it to: var image = document.getElementById("image"); var max = {width: 1024, ...
Read more

Select box manipulation with jQuery

If you read the jQuery mailing list , you may be aware that I have updated my plugins for working with select boxes . Summary of changes: addOption replaces any options with the same value (so think of it as an add/replace options plugin selectOptions selected options in addition to what was already selected, but there is now an option for it not to do this There are two new methods: copyOptions which is for copying options between select boxes ajaxAddOption allows you to add options via AJAX (i.e. could be used for create options dynamically from a server script)
Read more