Forum Replies Created

Viewing 15 posts - 151 through 165 (of 172 total)

  • RE: Schema/Data Dictionary/Table Definitions Query

    Excellent!  Thanks!  now i can set up my DDL to document whats in the database automagically!

  • RE: Schema/Data Dictionary/Table Definitions Query

    how do i get the column description filled in when i create the tables?

  • RE: Export Question

    transferspreadsheet wants the target xls file to already exist.  haven't used the output to.

  • RE: Truncate of the Database needed?

    why not just script the database you created and then run the script on the new database.  there won't be any history to worry about.

  • RE: SQL SERVER 2005 (MSDE version)

    I read an article yesterday that said the 2005 throttle was set to 5 concurrent queries, after that they get queued

  • RE: Using IN in the WHERE clause

    Or since you have already gone to the trouble of building the list of items that you can search for in @stritems

    where charindex(Convert(varchar(20), item_key) + ',', @stritems) > 0

    convert the...

  • RE: TRIMing the entire table in one shot

    its on the Resources menu at the top of the form

    or go straight there http://www.sqlservercentral.com/scripts/

  • RE: TRIMing the entire table in one shot

    sounds like what you really want is a function to trim off the leading and trailing blanks.  Sql doesn't come with one but you can make your own

    create function dbo.MyTrim

       ...

  • RE: Permissions

    Domain groups are by far the best way to manage your memberships.  The nice thing about it is that when you get a new person, just add them to the...

  • RE: Lock Question (Yawn!)

    OOPS! sorry, should have initialized CounterValue to zero!

  • RE: Lock Question (Yawn!)

    how bout a nice little function to turn your code into:

     

    INSERT Table1 (Field1, Description, SeqNo, InsMonth) SELECT @Field1, @Description, NextSeqNo = NextSeqNum,

    @InsMonth

    ---------------------------------

    create table Counters(

        YearMonth int        -- YYYYMM

        ,CounterValue int

       ...

  • RE: Lookup tables

    Thats because I'm an Evil Devloper!  and our beloved database team insists on this structure.  What do you use that allows you to sleep peacefully at night?

  • RE: Lookup tables

    I've seen this kind of thing a lot, usually working to convert free form text input fields into the "standard" values.  just make two lists, one for the user input...

  • RE: Move records to a new table based on date

    You definitely want a scheduled job of some kind to do this.  A trigger would fire every time someone did an insert or update or delete depending on how you...

  • RE: Data Type Issue

    As a developer and designer I almost never use the CHAR(X) data type except as Char(1), Varchar(X) is much better.  Char(X) will always give you X characters even if you use...

Viewing 15 posts - 151 through 165 (of 172 total)