Microsoft SQL Server Forum

I have a book cataloge where I have an author id linked up to the book. However, I'm finding that some books have mulitple authors, and I'm wondering if there is a way to add more than one id to the author id field. Or do I have to have many author id fields? Any way around that? Thanks, Bill *** Sent via Developersdex...

Hello. Can anyone tell me if a SQL Server 2000 database can be recovered only from the MDF and log files ? I have no backups. Thanks in advance

I'm having a problem writing the correct sql to bind togeather three tables. Here's the problem: I have a table for detail information on books that are in our catalog, and a table for authors. Unfortunatly, it is not a one to one relationship. Some books are written by several authors, hence, I've created an intermidiate table called...

I have two tables one on SQLServer and one on DB2. I want to update SQLSERVER table with some information that is on the DB2 table. I have unique id to match the records. I want to refresh some of the fields for records that key match from db2 to SQLServer. Records not found on db2 that are on SQL need to be deleted and records on db2...

Hi I am trying to produce an update trigger. I understand the concept of delete and insert triggers without a problem. Unfortuantely, the update triggers do not have particularly simple documentation in BoL. So, can someone please explain to me, quite simply how I would produce a trigger on the following: I have table 1 which we'll...

I have a query that generates xml: SELECT id, Name FROM Table ORDER BY 1 FOR XML RAW It returns a single row with one column: XML_F52E2B61-18A1-11d1-B105-00805F49916B <row ID="1" Name="A"/><row ID="2" Name="B"/><row ID="3" Name="C"/>

I will make it simpler to look... I have DB1 - as backup for day 1 LOg1 as backup of logs T1 T2 T3 T4 T5 ...some transaction on day 2 Now i backup again DB2 Log2

Hi, Ive a few questions and would be grateful for any assistance/comments from experience as Ive not that much dba experience , we have 3 servers all containing sql 2000 standard edition, two (prod and standby) located in the U.S. and Im hoping to set up the third as a reporting server locally in Europe...presumably having the data close as...

hi, I'm having trouble with a query. running it in SQL Server 7's Query Analyzer gives me the correct output, but when I put that code inside my php file it won't respond the same way. How come? The query: $query2 = "INSERT INTO bestilling (mid, orgid, bestilt) VALUES('$nymid', '$orgid','1')"; the last column(bestilt) will get the...

Hi, In case of a remastering of a client, I need to backup the Enterprise Manager configuration (the groups, the declared servers in the groups), instead of registering all servers manually once again. Does anyone know how it could be done ? TYA rjp

My configuration is as follows. I have a Linux MySQL server database on one box and I want to connect to it from a local Windows XP laptop. My application was developed using SunOneStudio. I have registered the DSN and tested the database connection via ODBC in Windows XP. It apparently connects from XP to the server. I have compiled...

Hi, I have written a stored proc with some temporary tables and also used a getdate() in my stored proc. When i try to call the sproc the error is that we can only use extended sprocs or function inside a sproc. Now if try to write the stored proc directly inside a fuction ie copy paste after changing my temp tables to tables the problem is ,...

According to BOL, columns in an ORDER BY clause do not have to be in the SELECT column list unless the SELECT includes DISTINCT, or the UNION operator. Is this a SQL Server thing, or SQL standard behavior? That is, if I were to write absolutely pure SQL-92, must columns in the ORDER BY clause be present in the SELECT list?

Hi all, I need to be able to obtain the full contents, i.e. sql statements inside, of all procedures in SQl Server 2000. I am using MS type 4 JDBC driver. I know that from the database metadata, I could get the names of all stored procedures and their column structures. However, I did not find any thing that will help me to obtain...

I need this to work: SELECT FROM WITH (NOLOCK) where ='a' GROUP BY , HAVING COUNT () > 1 The problem is that I get an error that needs to be in the GROUP BY clause or aggregate function. if I put it in there, I will get no duplicates (because it is the identity field). The whole point of this is to find dups. Thanks for any help.

I have a table that has a Text datatype column that has gotten some garbage characters in it somehow, probably from key entry. I need to remove the garbage, multiple occurances of char(15). The replace function does not work on Text datatype. Any suggestions?

My code prints out 0 for the value of charindex ( 'Hello.', '.' ). Did I miss something? I think it should print out 6!

I have a scenario like this....... update esan set tes_address_city = 'TEST1' --at some time update esan set tes_address_city = 'TEST12' --at some time update esan set tes_address_city = 'TEST123' --at some time backup database TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS.db' backup log TESTWMS to disk =...

Hi everybody, I need some help in SQL Server. I am looking for a command that will "Drop all user table" in a user database. Can anyone help me? Thank you very much Sabrina

I want to use fabricated hierarchical recordset in VB6 using ADO. I wrote code like dim rs as adodb.recordest set rs=new adodb.recordest rs.fields.append "a1",adChar,30 Then in loop I put rs.addnew rs("a1")=... re.update when I associated this with hierarchical flexgrid I saw what I expected. On

I am putting together a SQL table which will hold a latitude and longitude for each record. An example of a latitude is: 47 05 36.5 Which column type would best represent this and retain the spaces between degrees, minutes, seconds? Text, varchar, char? Thanks Jeff jeff-godfrey@wa.nacdnet.org

Hi there, it's me again. I am having trouble with a view again. I am trying to do a calculation, but there are some checks that need to be taken into consideration. Maybe a view is not the right way to deal with this. I don't know. This is the beginning of my query. SELECT coalesce(f.filenumber, i.filenumber) as filenumber,...

Hello, I have a rather large table in MS SQL 2000 that I'm writing reports in Crystal from, but I'm unsure how to get the various data files (from different departments) into the table. Below is a small chunk of the table: DeptCode;Type;AveMonthVolume;WorkedFTE;TotHours;Benefits I'm getting data from multiple places, but as I import...

Hi, I installed one more instance of my SQL Server 2000 on a Win2K server and then tried to install SP3 for the the instance which I installed. The first error it showes me was "Digital Signature not found" for MDAC and immididately after that another pop up showed this error "Microsoft Data Access Component Package Failed (-1)" and...

Hi All, I have a requirement of calling a Executable from SQL Server. I know we can use - EXEC @result = Master..xp_cmdshell @<command_string> However I want to get the return value (int) from the executable. xp_cmdshell always returns 0 or 1. How can the executable return code say 99 be obtained in SQL Server?