Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • RE: Free Encryption

    Do you know if SQL Express supports the key management TSQL functions?  I couldn't find anything that said it didn't.

    And do you think that would be an appropriate way to...

  • RE: Is it possible to create a temp table with dynamic columns?

    Of course you can create the temp table and then run ALTER TABLE statements against it to add columns dynamically.  This won't work with table variables though.

  • RE: Hiding zero collumns

    It sounds as though you'll need to query for each column separately, then use that to build your field list for a dynamic SQL statement.

    Loop through fields

     Is field sum 0

     ...

  • RE: Simple SQL statement help request...

    Using

      SELECT * FROM Table_Name

      WHERE DATEDIFF(d, Date_Field, GetDate()) = 0

    gave me

      Select, est. cost = 0.622

      Clustered Index Scan, est. cost = 0.616

       Est. row count = 2537

    Both other methods were...

  • RE: Print T_SQL Code in color

    I use UltraEdit (http://www.ultraedit.com) which is a handy app.  It comes with some predefined hiliting, but you can edit those and it allows you to also define your own...

  • RE: How do I print table properties?

    You can also query the system tables depending on how you want to use it.  Visually a diagram is often more helpful, but this can be handy if you need...

  • RE: Adding records

    I think you missed the point, he was asking about SQL Management Studio, not Enterprise Manager.

    I encountered the same issue in looking at SQL 2003, being able to edit records in...

  • RE: Navigating Yukon - A First Look

    A couple of things I have noticed, some may just be due to the fact that it is in Beta.  The first is that the results grid is not editable,...

  • RE: Delete Query based on 2 tables-DEADLINE Looming

    I think it's mainly personal preference, but I usually write out the JOIN so that it's more immediately obvious what's hapening in the query.

    DELETE dbo.ProjectDemand

    FROM dbo.ProjectDemand pd

    JOIN dbo.CADFilePath cfp ON...

Viewing 9 posts - 16 through 24 (of 24 total)