Search results for query: *

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.

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...

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...

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...

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?

Can you recommend a good book or article that will give me a conceptual understanding of what I'm doing when I write SQL joins, etc? Something written at a beginner level would help me the most. I'm a junior developer and I'd like to understand more of the overall concepts or theory behind what...

I have a table named NoteTable. I also have a second temporary table that contains some of the identical data as NoteTable. I want to delete all rows from NoteTable where the same items exist in the temp table, and also delete those same items from the temp table. Example: NoteTable...

The following query... SELECT ItemId, NoteSeqNum FROM NotesTable WHERE ItemId = 6434 AND NoteTypeId = 1 ..returns these results: ItemId NoteSeqNum 6434 11 6434 12 6434 13 I need SQL to return only those items with less than the max NoteSeqNum. So this would be my desired result: ItemId...

I have the following table: CREATE TABLE NoteTest ( [ItemId] [int](10) NULL, [Note] [nchar](10) NULL ) Each ItemId should only have one note row in the table. But for some items, multiple rows with identical notes were entered. I need SQL to go through the NoteTest table and identify...

I'm a junior web developer. I need tips on how to troubleshoot stored procedures. As far as I know, you can't step through the execution of a stored proc, the way you could C# or VB code.

I need to select using a WHERE clause that contains a list of specific items. What's the syntax? I want to do this: SELECT * from ASSET WHERE AssetId (is in the following list of IDs: 214, 727, 317 or 283)

I recently found a nice command "sp_helptext mysproc" that lists the definition of a stored procedure. Is there anything equivalent to list the definition for a table? I'm always wanting to find out the datatypes for table columns. We have so many tables it's a pain to find the table in...

I have four rows in a table. I want to take the current values in those fields and create an UPDATE script that I can use to overwrite any future changes to these rows, to set them back to what they are today. Here are the rows: AssetId ClientId AssetNum ClientRef -----------...

How can I restrict my database access to stored procedures only, and only to specific stored procedures that I specify? No plain SQL queries allowed.

I have GamesNew table and a GamesOld table that are mostly copies of each other, although the GamesNew has some new rows that are not in GamesOld. In the GamesNew table there is a Description column that now has bad data. For each GamesNew.GameId I want to update the Description column with...

I have some tables in Database A that I need to write to Database B, according to the following mapping: LOAN.Amount -- writes to --> Asset.Balance LOAN.Type -- writes to --> AssetNote.Note LOAN.LienHolderName -- writes to --> Asset.ClientId CUSTOMER.Id -- writes to --> Client.ClientId etc...

I have a table like this: VendorID VendorDate -------- ---------- 1234 10-1-2008 3467 10-22-2008 7655 10-9-2008 etc... I need to set all the values in the VendorDate column to NULL. How do I do this? Either SQL or a stored proc if fine.