• subscribe
October 01, 2002 12:00 AM

T-SQL Tutor Project

SQL Server Pro
InstantDoc ID #26549
Downloads
26549.zip

Here's a small homework assignment to help you continue to improve your ability to write scalar UDFs. You can find the answers online in the UserDefinedFunctionsPartIIHomework.sql script file at http://www.tsqlsolutions.com, InstantDoc ID 26549. Applying the tools and tips I gave you in this column, create and populate your sample table as Listing A shows. First, write a function to handle the odd character strings that you use to store the separate date and time values. Next, assemble the strings as a date. Then, write a query to display the data in various styles. (Note the similarity of these values to the input of datetime data.) Try to make your function flexible by allowing style as a parameter.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...