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!

Search results for query: *

  • Users: CDuffy
  • Content: Threads
  • Order by date
  1. 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-)
  2. 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...
  3. 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...

Part and Inventory Search

Back
Top