A Table can have...TIMESTAMP(Mensaje SQL Server)

Msg 2738, Level 16, State 2, Line 1 A table can only have one timestamp column. Because table 'PRUEBASGRUPO' already has one, the column 'HFIN' cannot be added. Msg 2715, Level 16, State 7, Line 1

Mensaje publicado en el 20/12/2005 - 14:00

Transpose Table

How can i transpose a Table in Micrososft SQL... I have to switch rows into columns. For example: Col1 Col2 Col3 ****************** aaaa 1111 2222 bbbb 3333 4444 cccc 5555 6666 And i Want to transpose it to: Col1 Col2 Col3 ...

Mensaje publicado en el 14/04/2004 - 19:23

Auditing data on SQL 2000

Hi, i am trying to create a generic trigger which will audit changes to data in a table. Now it is possible to know which column has been changed by using Update() or Column_update() But even with dynamic SQL i can't figure out how to insert the ...

Mensaje publicado en el 28/09/2007 - 08:51

DIVIDE BY ZERO ERROR, WHEN RUN FROM ASP PAGE

Here is the scenario, i have a stored procedure, it calculates commissions and runs fine in SQL. However when the SP is run through my asp page it will come back with a divide by zero error, but only for one sales person... I have been through ...

Mensaje publicado en el 12/04/2007 - 17:03

Problem edit boxes and text boxes

I have a problem with behaviour of some edit boxes and text boxes in a form. I'm using Visual FoxPro 9. I created the form using the form design wizard. This form has a few edit boxes and text boxes, buttons etc. The values for text foxes are assign ...

Mensaje publicado en el 20/10/2007 - 14:37

ASP Retrieve data Problem

Hello, I have a problem when I developed the ASP web application for multiple users to access SQL server 7. Users can retrieve, insert, update, and delete data. When I retrieve data sometimes it only can get first row. When I click refresh button ...

Mensaje publicado en el 18/07/2003 - 22:06

Command Pack from VB: Why does it fail?

Hello I need to execute the command PACK (that erases all the marked files for elimination of a FoxPro table) from an application written in Visual Basic. This makes it in the following way (just as me somebody indicated in this same forum) 'It ...

Mensaje publicado en el 06/09/2004 - 07:56

Dump en W2003 Server

Buenas tardes, Tengo un DL580 G" con W2003 Server con todas las actualizaciones al día. Desde hace unos 6 meses, a razón de 4 o 5 al mes, se reinicia sólo reportando los errores que abajo se describen: Microsoft (R) ...

Mensaje publicado en el 10/07/2008 - 17:34

volcado de memoria-->ALCXWDM.SYS (jm tella)

Hola He conseguido un volcado de memoria por mi problema con la tarjeta de sonido. Después de leer toda esta información veo que mi problema reside en este sys ALCXWDM.SYS que pertenece a la tarjeta de sonido integrada en placa ...

Mensaje publicado en el 05/10/2006 - 12:08

Help needed to merge a few database - same tables

Hi all, I am new to SQL and have to support application that uses MS SQL 2K. I have to merge a few database , (with the same tables structures - each one include identification database Id) to one database file with the same tables structures. The ...

Mensaje publicado en el 04/07/2006 - 13:51

submit question

Have table in my websit example: A0001 XXXX 30 A0002 XXXX 40 A0003 XXXX 50 How can submit table? Use cookie or session?

Mensaje publicado en el 08/04/2006 - 05:34

Data Set do not gets back old reference

This is a strange case while working with ADO .net in windows application. If some one can explain me what is going on here or what i am doing wrong. the story is as below. I have a Class CData In this is returm a table view. using a property. ...

Mensaje publicado en el 28/06/2004 - 22:15

storedprocedure

how can I put the result of my stored procedre into a temporart table within another storedprocedure. I have 2 stored procedure,A and B I want to call B from A and work on its resultset,how can I do that. By the way B has got one parameter called ...

Mensaje publicado en el 13/04/2004 - 23:02

Problem with update database on Session OnEnd occurs

I'm trying to update a table when the session end and can not get it to work, Tried many, many differnent ways and none of them worked. Does anyone have ASP code that they know works to update a table when the session OnEnd occurs that they could ...

Mensaje publicado en el 10/01/2004 - 19:07

table can have