Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CDuffy

  1. CDuffy

    How could you know how many columns you have in your table

    Cheers Andel, it is exactly what i was looking for. Patrick 8-)
  2. CDuffy

    How could you know how many columns you have in your table

    Hi everybody, As you can see I am starting with SQL 7 and I would like to know if it exist a query which can automaticaly tell you how many columns you have in your table. this is to be able to calculate the Null Bitmap. thanks for your information Patrick 8-)
  3. CDuffy

    spt_values ???? what does that do ???

    Hi everybody I would like to have more information upon the following procedure spt_value. I find it in the definition of a variable to convert data to KB Does some one know exactly what that query is doing ? why does have it to run form master? select @pagesize = v.low / 1024 from...
  4. CDuffy

    SQL 7 DB Sizing Query

    I have a lot of DB in various Customers places and I have to check if there is a pattern in the size of the tables and indexes to be able to create a sizing tool for the future DB I will have to create. I need a query to extract from my DB, - the table name, - size of the table, - size of...
See more

Part and Inventory Search

Back
Top