Hi,guys! I have a table below: CREATE TABLE rsccategory ( categoryid NUMERIC(2) IDENTITY(1,1), categoryname VARCHAR(20) NOT NULL, PRIMARY KEY(categoryid) ) Then I do: INSERT rsccategory(categoryname) VALUES('url') IN...more >>

Hi All. I have been writing simple single stored procedures for a few years now, but a client needs some reports (under Crystal) that I seem to think the only way to get the data (from SQL2000) is to build up a results set using a stored procedure with multiple select statements, interrelated...more >>

I'm investigating a bug a customer has reported in our database abstraction layer, and it's making me very unhappy. Brief summary: I have a database abstraction layer which is intended to mediate between webapps and arbitrary database backends using JDBC. I am very unwilling indeed to write s...more >>

HI, I have a problem in formula column. I have 8 1 bit varibles in a table for ex: Flag1, falg2, flag3 ...Flag8 Now I want to create another variable as a small integer and copy all the flgas to that field. For ex: (flag1 << 0x80) | (flag2 << 0x40) | ..... | flag8 I tried all possible ...more >>

Anybody know if there is a system function that can be used from a stored procedure that determines if a given primary key has existing dependencies? I want to make a check for this and if there are none, I will delete the record. If there are, I will change a field called bitStatus from 1 to 0....more >>

Is the minimum windows version for awe to work advanced server? The db is currently hitting the 2gb ceiling and we are getting into the busy season for our business. Thanks for the comments. Mike -- Posted via http://dbforums.com...more >>

I've been scratching my head on this for quite awhile and it has me stumped. I hope to define a query which I can use to fill a "day planner" type of calendar. Although I've see a lot of these, only one has had what I think is a really nice feature - it collected into groups all events that o...more >>

Hi I am a newbie to SQL. I have a historical list of digatal points listed by time.ie: 3 fields PointName;Date/Time;State. I need to return a list of When a specific point chsnges state. For example a list everytime Point A transitions to State 1. Any help is appreciated. ...more >>

Hi, What I have is a booking table, and when updating/inserting I need to ensure that there are no date/time overlaps. The problem I'm having is that while the following script works for events on the same day, it fails miserably when a booking starts on a previous day. I've just ...more >>

Hi all question regarding how transactions work in SQL Server... stored procedure below that generates unique IDs for messages we send to the backend It looks like sometimes, the number generated is identical for a messages that were sent simultaneously. Since this seems like a concurrency is...more >>

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

Hi, I'm trying to run the ALTER TABLE command using a dynamic string for the table, like so: DECLARE @TableName CHAR SET @TableName = 'Customers' ALTER TABLE @TableName ADD ...blah Is this possible? We know this works: ALTER TABLE Customers ADD ...blah It looks like I need a w...more >>

Hello group: I've done alot of reading on this subject somewhat and have found that many people have many different opinions on this subject. My question centers mainly around using a lookup table to enable users to select a pre-defined list of values. I have developed a practice myself of ...more >>

I use select @@identity to return @@identity from my store procedure, but I could not retrive it from my Visual basic code, like variable= oRS.fields.item(0).value, it always says item can not be found.......more >>

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

Hi, I'm trying to add a modified datetime and userid to all 72 tables in my SQL 2000 database. I have the script to do one table, and a cursor, but it won't run across all tables. Any help would be appreciated. Thanks... DECLARE @tName varchar(40) DECLARE C1 CURSOR FOR select name from sys...more >>

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 I want to restore the database till the point of transaction T3 say. I know the time or i assume a certain tim...more >>

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

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

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

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

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

Hello! My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2) and MS ExchangeServer 5.5 the two following TransactSQL-codepieces show different results: 1. with attachment master..xp_sendmail @recipients = 'j.hetzel@rac.de', @subject = 'test', @message = 'test', -- ********...more >>

I have actually extended my request 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:\te...more >>

I need this to work: SELECT [ID] FROM [test] WITH (NOLOCK) where [a/c/d]='a' GROUP BY [unit #],[EFF DATE] HAVING COUNT ([unit #]) > 1 The problem is that I get an error that [ID] needs to be in the GROUP BY clause or aggregate function. if I put it in there, I will get no duplicates (because...more >>

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

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

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

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

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

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

Greetings all, This should be an easy task, and Im sure it is, but as many times as I have tried, I cant seem to get this to work properly. We changed ISPs recently from a shared host to a co-located server, and our former host was nice enough to send us a backup of our old SQL2000 database ...more >>

Hi, I would like to add a unique index that consists of two fields in a table. e.g. tbl_A (field1,field2) -- field1 & field2 Indexed and combination must be Unique. Can anyone tell me the actual sql syntax to create this index? Thanks, June....more >>

Hi, I am getting "Row cannot be located for updating. Some values may have been changed" error when I try to update from visual basic with ado. This happens only when set as default locale on the pc other language than English. Anybody can help on this¿ Thanks *** Sent via Developersde...more >>

hi all, our company is going to setup ms sql server cluster for fault tolerance, budget has to be kept minimum. actaully, i was told that sql clustering (includes shared DB data sync) can be done over a dedicated tcp/ip connection instead of using shared disk array connected to the ...more >>

I was experiencing odd behaviour from SQL Server within Vis Studio this morning and had to uninstall SQL. Trouble is I can't seem to get it set up the way it was before. I installed the developer edition, client and server tools. Can't recall if I did this last time,but now I get the error: "A...more >>

Is there a command to store a stored procedure to a script in stead of doing it manual one by one with the generate script option. I would like to make a script which copies a bunch of stored procedures each in a different file. A.M. de Jong The Netherlands. ...more >>

I was wondering if the CPU is the bottleneck. Hence I used the Performance Monitor to look up some values. Here are the results. Counter Scale Average Maximum Minimum %Disk Time 1 2.74 24.932 0 Current Di...more >>

Hello all, I have been trying to find some information about exporting data from postgresql on linux to ms-sqlserver 2000 on windows but have not been able to get hold of any information. I would really appreciate if someone can point me to some source of information. Thanks in advance, Ni...more >>

I've tried several different possibilities but don't have enough basic understanding of the ownerships and permissions that are involved so I'm looking for someone to explain what is required: I created a DTS package that includes a drop table, create table, and data transformation task. Origi...more >>

Hi, I have a few things on my databases which seem to be neither true system objects or user objects - notably a table called 'dtproperties' (created by Enterprise manager as I understand, relating to relationship graphing or something) and some stored procs begining with "dt_" (some kind o...more >>

I have two related tables in my SQL database that I wish to join as follows: ------------------------------------ tblCustomers ID (pk) Name etc. tblCustomerManagers ID (pk) CustomerID (fk) Manager (this *is* an fk but for the purposes of demonstration is not) StartDa...more >>

I have a table containing standing data about stocks, sec_std. (eg. stock name, date entered into DB, current holdings). I would like to get a recordset containing this data but with an extra field showing the current price. My prices are contained in sec_daily. So I need to pull out the late...more >>

Hallo I have a DTS Package which reads data from a Access Database and imports it to SQL Server. This package runs without error when it is executed trough Enterprise Manager. When I create a job with "Schedule Package" and then try to run the job, it gives errors like this: Ausführt als...more >>

I'm having problems creating a linked server from SQL Server 2000 to DB2. I have an System DSN using Client Access ODBC Driver. I am trying to create the linked server using Enterprise Manager as below, Linked Server: MYLINKSERVER Provider:Microsoft OLEDB Provider for ODBC Data Source:...more >>

Hi, is there any way that I can automate granting user permissions to tables/ stored procedures in SQL server 2000? I have a whole bunch of tables and rather than having to right click each table/ then permissions in Enterprise manager I would like to be able to iterate through each table obje...more >>

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

Hi. i am facing a problem. How do i save a java.util.Date in a SQLServer column declared as a 'datetime' . and please tell me how to retrieve it too. i think that java.sql.Timestamp gives 'Abstract Method Error'. thanks.. -- Posted via http://dbforums.com...more >>

I need to export certain fields of a table from sql 2000 into a dbf file, but can't find the proper query command to make it work. I also want to set this up to run each night automatically. Any help will be greatly appreciated. Randy...more >>

Hi there, I am converting a large PL/SQL project into Transact-SQL and have hit an issue as follows: I have a PL/SQL procedure that converts a string to a date. The procedure does not know the format of the date in the string so it tries loads of formats in converting the string to a date u...more >>