Recent content by hapax

Well, I usually just go through the GUI, and right-click, Delete Database. But maybe SQL "DROP databasename" works without complaining about foreign keys? I'll have to try that next time, or maybe the sp mentioned earlier in this thread.

Is there a way to just delete a SQL Server database, without it complaining about foreign keys and such? Is there a command to just ignore any issues and just drop the database anyway? I'm always running into this when I'm developing.

What is BOL?

I want to store items in a database. The columns for each item will be things like author, title, description. I also want to somehow associate keywords with each item. These will be used for a search feature on a website, to locate items that have certain keywords. Each item can have one or...

Thanks for the info. I guess db size could be an factor? 1000 PDFs at 1MB apiece, would be 1GB extra space to back up every day. Or would SQL Server compress the PDF's size?

For a website, what are the pros and cons of putting PDFs in a SQL Server database, versus just storing them in a web server directory? So far I've only ever put text in a database, but I understand you can also put PDFs, images, etc in there. I need to store about 1000 PDFs for use in my web...

Much thanks to you both. I knew this was a pretty common thing but didn't remember how.

I need to create a table something like this: Patient table ---------- ID Name Categories The thing is, for each of these records there can be multiple Categories. Something like this: ID: 321 Name: Bob Categories: Flu, Diabetes, Cancer How can I do this? I need a separate Categories table...

How can I script out the contents of a table - all the data in all the rows? I'm looking for results similar to what the Database Publishing Wizard produces, but I only need to copy one table not the whole database. I want to recreate a table on a second database. I want to automatically...

I just got assigned to a new website that uses some COM for backend processing. When I run the code locally on my PC, I get the following error when the code hits the point to instantiate one of the COM objects: “Retrieving the COM class factory for component with CLSID...

Thanks, works

OK, I fixed the misspelling of decimal, but it still doesn't work: SELECT CONVERT(decimal(25,15), CONVERT(text), gam.attribute_detail_text) < @NorthLatLine

I haven't gotten it working yet. Here's my actual line (in a WHERE clause): SELECT CONVERT(decimail(25,15), CONVERT(text), gam.attribute_detail_text) < @NorthLatLine do you see anything wrong?

How do I convert a "text" type value to a "numeric" type, in T-SQL? I tried the following but it throws an error: SELECT CAST(my_text as numeric) Note: The text values are in proper number format, so I don't need to worry about that too much. I just need to convert them to numerics so I can...

I have the following query: Select * FROM Unit u inner join Event ev on ev.UnitId = u.UnitId But what I really want is something that does the opposite - returns all the records where no ev.UnitId exists for a given u.UnitId. How do I do that?