1

Oh my god this is going to drive me nuts. There's a SQL Server table in, I want to say, model, or msdb, with a bunch of pre-populated values, including numbers, and some other random stuff like common strings and what not. I can't seem to construct a google search to tell me what it is. Can anyone help?

Xedni
  • 3,662
  • 2
  • 16
  • 27
  • 1
    What is your question ? I read it more than 3 times still didnt understood – Pரதீப் Jan 25 '17 at 04:49
  • If you are familiar with SQL Server, there are several built in databases including `model`, `msdb`, `master` and so forth. In one of those databses, there is a rarely used table which comes default with SQL server which contains a bunch of boilerplate values including the numbers 1 through, I want to say 255, letters, symbols, and certain phrases. I'm trying to remember what that table name is – Xedni Jan 25 '17 at 04:53
  • 3
    Is this `select * from master..spt_values` ? is what you are looking for – Pரதீப் Jan 25 '17 at 04:56
  • Yes! Thank you @Prdp – Xedni Jan 25 '17 at 04:57
  • After reading you comment I understood what are you looking for. Question is not that clear at least to me – Pரதீப் Jan 25 '17 at 04:58
  • Hi, what is this table, and wts the use of it? – Abdul Rasheed Jan 25 '17 at 07:04

1 Answers1

1

Just echoing Prdp's answer, it was master.dbo.spt_values

Xedni
  • 3,662
  • 2
  • 16
  • 27
  • Hi, what is this table, and wts the use of it? – Abdul Rasheed Jan 25 '17 at 06:50
  • 1
    @AbdulRasheed not much. It's a holdover from older databases. Truthfully I've never used it in my work, but I have occasionally used it for generating mock data or just to play around with things. There's a good discussion of it here http://stackoverflow.com/questions/4273723/what-is-the-purpose-of-system-table-master-spt-values-and-what-are-the-meanings – Xedni Jan 25 '17 at 15:15