User Profile

Collapse

Profile Sidebar

Collapse
cbhrook
cbhrook
Last Activity: Feb 14 '08, 07:26 PM
Joined: Feb 14 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cbhrook
    replied to Need example query using Timestamp
    in SQL Server
    The following 2 queries produce the same results (order of year does not matter):
    select * from Drawing_title where dwg_maint_date> '01-02-2008'
    select * from Drawing_title where dwg_maint_date> '2008-01-02'


    You may also reference the time in your query:
    select * from Drawing_title where dwg_maint_date> '2008-01-02 08:00:00' order by dwg_maint_date...
    See more | Go to post

      Leave a comment:

    • cbhrook
      started a topic Create user similar to 'sa'
      in SQL Server

      Create user similar to 'sa'

      In SQL Server 2000, how do you create a new user that essentially has the same permissions as the default 'sa' user, preferrable through Enterprise Manager?
      See more | Go to post
      No activity results to display
      Show More
      Working...