Computer programming code solutions

  User 'guest' at  home/ms-sql-server/

  • Home
  • PHP
  • ASP.NET 2.0
  • VBA
  • MS Excel
  • MS Access
  • MySQL
  • MS SQL Server
  • HTML
  • CSS
  • Site Map
  • Contact
  • About



  Click here for more information..

Email:


Password:


  Register
Reset password

Sign in with OpenID

RSS feed  Click to subscribe to the RSS feed.

Browse MS SQL Server Content


autonumber datatype

By: Mark Kiehl


To create an autonumber datatype, make your field a type INT, and then in the column properties, revised the Identity ..

Click to view this record..

Datetime type to simple date using DATENAME and concatenation

By: Mark Kiehl


SELECT DATENAME(dd,design_reviews.date)+' '+LEFT(DATENAME(month,design_reviews.date),3)+' '+DATENAME(yy,design_reviews...

Click to view this record..

1   ... 2   Next

    Copyright © 2009   Mark Kiehl,   All Rights Reserved           Site created by http://www.bizwebsites.us/           Script time elapsed: 0.009348869324