hi all ! i'm kind of new to MYSQL so am still learning basics. my question is how do you create a drop down list in a field in an SQL database ? thanks brino ...more >>

Hi, I need a script that I can run from ASP .Net that will delete all views that start with "Search". My site creates them on the fly and they tend to accumulate as more users visit the site. Is there a good SQL help web site that I can refer to that will be me started? Thanks, Bill Ci...more >>

I have an SQL database with rows that have parens in the data. If I run a select statement such as: SELECT SongName FROM Songs WHERE SongName = 'John Jacob (Jingleheimer Schmidt)' It returns zero rows. This also: SELECT SongName FROM Songs WHERE SongName LIKE '%John Jacob (Jingleheim...more >>

I have a query below that performs horribly: @KeywordOne char(6), @KeywordTwo char(6), @KeywordThree char(6), @KeywordFour char(6), @KeywordFive char(6) SELECT c.Something FROM dbo.tblStuff c WHERE c.SomeColumnName = 0 AND (c.Keyword LIKE '%' + @KeywordOne + '%' OR @KeywordOne is N...more >>

SQL Server 2000 SP4. Hoping to find a logical explanation for a certain behavior. Consider this script: USE pubs GO IF 1 = ALL (SELECT contract FROM dbo.authors WHERE state = 'CA') PRINT 'TRUE' ELSE PRINT 'FALSE' This, as expected, prints FALSE, since not all authors in CA are...more >>

If I have an SQL query which returns an aggregate of several decimal fields like so: (sum(COALESCE(myDecimal1, 0)+ sum(COALESCE(myDecimal2, 0)+ sum(COALESCE(myDecimal3, 0)) as MyTotal I get an rounded integer in MyTotal. However, if I do the following: sum(COALESCE(...more >>

Hi, I've installed SQL 2005 and failed to change the default data location during installation. Now I want to change it. Can I do this without having to uninstall and reinstall? And furthermore, is there a system stored procedure I can use to move existing data and log files (master, msdb, A...more >>

Hi, First post so apologies if this sounds a bit confusing!! I'm trying to run the following update. On a weekly basis i want to insert all the active users ids from a users table into a timesheets table along with the last day of the week and a submitted flag set to 0. I plan then on creat...more >>

Hi all, I am sanju, To generate report I am using table named as "tempTest" for displaying count of dealer. On back end i am using oracle. I am unable to insert the second qry The datatype of the table is as follows select * from tempTest CREATE table tempTest ( DEALER_NAME varchar2(50), ...more >>

Hi! I'm working with a database of news clippings. The database has fields for the title of the article and the text of the article (also other fields for things like sources and categories, but those have no relevance to the question). We have a single search box that normally searches both t...more >>

I give up - will someone please tell me why in _Oracle_ I can do something like: select 'CREATE PUBLIC SYNONYM '||table_name||' FOR SYSADM.'||TABLE_NAME||';' from dba_tables where owner='SYSADM'; and get: CREATE PUBLIC SYNONYM CHAINED_ROWS FOR SYSADM.CHAINED_ROWS; CREATE PUBLIC SYNONY...more >>

Hi Everyone, I am trying to write something to give me back all the data for a sertain time range for today. So for example: I need to get all records where change_date is <= today 2pm and > today at 8pm. I know i can get just the date for today by using CONVERT(CHAR(10),getdate(),102) but c...more >>

Question. I have a new table that I am adding to a script that I wrote. This table has 3 fields, the first 2 fields are used in the on statement as being = other fields in the script. The first field always has data in it, but the 2nd field is sometimes null. So my problem is if both fiel...more >>

Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these columns. Ho...more >>

Hi, i have several tables in production whose contents are renewd totally in 1 week. So everyd day we delete ~15% records and then insert 15% new. And after a few days, the performances drops : TABLE level scan performed. - Pages Scanned................................: 169617 - Extents Scan...more >>

hi, is there a function in ms-sql to get the date only from a datetime column example column 2006-09-26 00:00:00 i would like to see 2006-09-26 tia Dave ...more >>

Hello, Please find the requirement details as follows Oracle Pl/Sql Developer Location: Louisville, KY Duration: Long-term Start date: Immediate Rate: 42$/Hr Experience: 3-5Yrs Required Skills: =D8 Oracle Pl/Sql with VB experience. If any body interested in the above opportunity, p...more >>

I ran the following update query in Sql Server 8.0: update _SMDBA_._CUSTOMER_ set _SMDBA_._CUSTOMER_.client = dbo.results.adid from _SMDBA_._CUSTOMER_, dbo.results where _SMDBA_._CUSTOMER_.client = dbo.results.clientid; I got the following error: Server: Msg 2627, Level 14, State 2, Line 1...more >>

According to MS, GetLocalTime() (in C++) is only accurate to approx a second, even though it reports milliseconds, and calling it twice and computing the interval can on occasion lead to a negative interval. Is T-SQL's GetDate() more accurate than that, or at least non-decreasing? Thanks,...more >>

Hi, I am designing an application which displays news topics until midnight on the DisplayUntil date and then they should drop out. Unfortunately, they seem to be dropping out at mid-day. I'm storing the 'DisplayFrom' and 'DisplayUntil' dates as SmallDateTime fields so the date is in the...more >>

Hi, I am designing an application which displays news topics until midnight on the DisplayUntil date and then they should drop out. Unfortunately, they seem to be dropping out at mid-day. I'm storing the 'DisplayFrom' and 'DisplayUntil' dates as SmallDateTime fields so the date is in the...more >>

I am new to SS2005, and I've just started working on a small test/dev database. I recently read that one should store things like tables, views, constraints, etc. in the *.ndf file rather than in the *.mdf file. Does this make it any easier to transfer/copy files or databases or other items...more >>

I have a char(11) for SSN, and I would like to default it to 123-45-6789 so I can avoid having nulls in this column, and so I can easily find the rows in which I need to have a 'correct' SSN entered/updated. I tried using just 123-45-6789, and SQL2005 doesn't seem to be defaulting to this va...more >>

Hi Shortly, I keep invoices in a table. Occasionally, someone will fire the execution of a stored procedure (SP) that performs several UPDATEs against (potentially) all invoices OLDER than a date that is supplied to the SP as a parameter. The SP is usually a lengthy process (it takes at least...more >>

What should i do when i want to save a select resultset,but not in a new table,in memory is the best? thanks! ...more >>

Hi Guys, We've lost the password for the sa. No other users belong to the admin group. I've tried logging in using osql -E (windows authentication) without success. Is there anyway to reset the sa password? The database is MSDE and the version seems to be 7 (sql server 7 folder on pc). It is ru...more >>

/* Subject: How best to use BETWEEN Begin and End Dates to find out if an employee was/is member of any group for a certain date range? You can copy/paste this whole post in SQL Query Analyzer or Management Studio and run it once you've made sure there is no harmful code. I am working o...more >>

Hi, I have 3 tables as follow : Kanji : kanji_id .... References : ref_id .... KanjiRefs kref_idkanji kref_idref kref_value .... So, there is a many-to-many relationship between Kanjis and References (one kanji may have more than one reference type, and a reference type may ...more >>

Re SQL Server 2005 Express When I attempt to copy the master file for backing up, it is being used by another application, even after shutting down the PC completely and powering it up again. What can I do to make back-ups? Zach ...more >>

The DTS works perfectly when I run it manually. However, when I run it as a job it fails. Before you ask if i'm running it under different security context. I have already made sure of that. I was logged into the server through remote viewer, when I created and ran the package, as well as schedu...more >>

I'm looking for an efficient way to populate derived columns when I insert data into a table in SQL Server. In Informix and PostgreSQL this is easily done using the "for each row..." syntax, but all I've been able to come up with for SQL Server is the following: create table testtrigger(id in...more >>

Hi All, We have an MS SQL server that is within the company firewall. We want a particular database to be availabe to a vendor to build a website. When we had to develop a website on another vendors machine they gave us following details. SQL Address: testdata.data.com SQL Port: 1234 SQ...more >>

Hi, I am trying to export rows from SQL2005 linked to coresponding rows from Oracle to an Excel spreadsheet using SQL Server 2005 Integration Services (DTS as it was) I really am not sure what I ought to be attempting to do, however I seem to be able to create two OLE DB source 'objects' a...more >>

I have data coming from a telephony system that keeps track of when an employee makes a phone call to conduct a survey and which project number is being billed for the time the employee spends on that phone call in a MS SQL Server 2000 database (which I don't own). The data is being returne...more >>

Hello, I am using SQL Server 2000 with SP4. I have a database with two full backups at 4:00 PM and 5:00 PM and a transactional log backup at 5:30 PM. Is there a possible way to do a point in time restore to 4:30 PM, that is between two full backups? When I try to use the transactional log b...more >>

I need to be able to drop a table after a user is done with it. I have tried something like, DROP TABLE USER.tblEducation_SAP1 but I get an error. Can someone suggest the way I should be using the USER value in this instance? Thanks! ...more >>

Hi there. I'm on a SQL 2000 SP4 machine. This is a development machine, with only a couple of small databases on it. Yesterday I needed to recover a table from backup, so I went through the following process: -Used 'Create SQL script' to generate a create db statement from the current...more >>

Running SQL Server 2000. I have been asked to move the transaction logs to another drive. I was able to do that for the user databases using detach/attach. However I don't see that as an option for moving the logs for the system databases. Is there any way I can move the system database logs?...more >>

Hey, First, sorry if this post appear twice, because, I can not find my post recently send, trying to post it once again. I'm out of ideas, so, I thought, will search help here again :( I'm trying to prepare a view for ext. app. This is in normal cases very easy, but what if the view struct...more >>

Hi, I'm coming back to Sql Server after 4 years away, using other RDBMS, and there's a few things I'm struggling to remember how to do (if I could do them in the first place...) Main amongst those is EXCEPT syntax. In DB2, if I have two sets of data and I want to exclude the second set f...more >>

Hi, Is there a way to findout the query plan of the executing process using the SPID/KPID information. Thanks in advance, Thyagu.D ...more >>

I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables . Developer's should not create or alter tables . 3. Developers can create/alter Stored Procedure/User Defin...more >>

Hello, I'm not very familiar to SQL Server, but I've to upgrade a DBMS from V6.5 to V2005. >From the V6.5 I've got a backup file and a dump file (which seems to be the same, at least it has the same size). After installing V2005 - at another system - I could not find any option to import...more >>

hi,All could you tell me which case is more efficiency?(my tables have no index) And does it has any else case more efficiency? case1: "select sum(Invoice_Production.Quantity) from Invoice_Production,(select [dat_Item].ItemCode from [dat_Item],(select [dat_MachineType].MachineTypeID fr...more >>

I want to select one field from a table,but it should on some conditions which refer to 5 table ,such as A.FILED1=B.FIELD1 AND B.FIELD2=C.FIELD3 AND .... Should I use case "select sum(a.amount) from a,b,c,... where a.field1=b.field1 and b.field2=c.field2 and ..." or "select sum(a.amount) fr...more >>

I have the following cursor that I am comparing 2 tables, the production table and a copy of the production table, I want results of all address's that are like the address1 field...the problem is...my results are giving me every field and if there is more than one, it is putting it in a grid......more >>

Hi! This is my table: CREATE TABLE [Query_Result] ( sifrob VARCHAR(13), katbroj VARCHAR(15), kol FLOAT ) This is some values: INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol]) VALUES ('49501879', 'G-46052', 1) INSERT ...more >>

new to SQL Server 2000. We have an obsolete database that we need to save off for x number of years. DB2 has utilities (DB2Look/Export) that allows for the export of the data along with a schema and script that enables the future recreation of the structure of the databases and tables to includ...more >>

I'm looking at an MS SQL server database and it stores city names across the world. All a arabic , chinese etc names are converted to the latin alphabet. I feel it is probably critical we support accents as a means to distinguish between cities that would be converted to the same Latin alphab...more >>

When I want to delete a data from a table that this tabl has a trigger and this trigger reached another tables to delete the data in cursor I have this messeage: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. My trigger : CREATE TRIGGER [TOPBA...more >>