ALTER TABLE dbo.TCONTACT_TEST ADD
LVL_SYS_NR INT AFTER ACC_NR_TE,
CNT_FAX_NR_TE VARCHAR(15)AFTER CNT_PHN_EXT_TE
----This brings up an error on the word AFTER
Hi! I created the following code in a stored procedure in SQL Server 2000. It works okay if the values I'm converting don't go above the precision and scale for the field. If there are more ...
hi
Can anyone give me an example of creating a variable to select the first day and last day of each month please?
Adam
Tables
Customer(CustomerID, CustomerName)
Order(OrderID, CustomerID, OrderAmt, ShipTo)
Select
L.CustomerID,
L.CustomerName,
Count(R1.ShipTo) OrdersShippedToTexas,
Count(R2.Ship...
Using MSSQL 2003. I need to copy all records from 'table1' where field value 'todaysdate' = (the current day) to 'table2'. I would like to schedule this to occur every night @ 11pm. How could ...
I'm trying to update one column of a table with the following query:
UPDATE Utable
Set Amt =
(SELECT
Sum(Amt)
FROM Ptable
WHERE ID IN
(SELECT ID FROM UTab...
Hello
I keep recieving the following message in Event Viewer:
"The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs." Event ID 17896
It is an informatio...
I have fallen victim to what appears to be a SQL Injection attack (...banner82.com/b.js is inserted in all tables). My system is an old ASP applicaiton that requires some protection updates (...
I have the following stored procedure (see code snippet) , which returns mutiple datasets, because I would like to use it in Reporting Services I need to combine the result sets into only one...
After trawling various websites for a good hour, I am still none the wiser as to the upgrade license cost for upgrading SQL 2000 to SQL 2005. Currently, I have a DB fail-over cluster, single C...
New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s),...
Cannot connect SQL-Server from one specific machine on corp network. Other machines connect ok.
Got this error message (vb6) when trying to connect:
Run-time error '2147467259 (80004005)':...
I'm using MS SQL Server 2005 Management Studio Express to create a simple database that will manage customer-specific PDF documents that customers will have access to on the company website. T...
I need to format the datetime on a columnin SQL 2005 to remove the time from the column
I have a complex query, from a subquery. I'm trying to return a unique column. Here is a simplified example: (Note: EMPID Should be unique, taking the latest FINISHDATETIME, if there is a dup)...
Dear Experts,
I am attempting to convert a FLOAT value to a DATETIME value in MS SQL Server. One example of a value in the FLOAT data type column is:
1181890800000.0
It represents the...
I'm one of the many people recovering from the "b.js" SQL Injection attacks. I've hardened the pages that were being exploited, and, thankfully, we're no longer susceptible through that parti...
Hello.
I am trying to build a dynamic stored procedure using the EXEC statement.
I want to dynamically populate the SELECT TOP int syntax.
Here is my query:
USE [ALERTS]
GO
SET A...
Hi!
We're using a backup with sql server agent when doing a backup / restore
procedure. In some cases I get the following error when the restore job
fails:
Executed as user: DOMAIN\A...
i have an important database that was hosted from a server in a datacenter, we were having problems with the machine so sql on it was backup up and it was reformatted. When we got it back onli...
I tried both CAST and CONVERT for the given example and throwing me "Error converting data type varchar to float."
The IsNumeric('1,234.01') return 1
I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server databa...
Hi Experts,
I've just been hit with a sql injection which contained a hex string - does anyone know how I can decode that hex to see what commands they were trying to run?
Many thanks,
In Sproc how is best to determine if an Id exists in a datatable in SQL database and return true/false?
I am having a problem with
some text values (names and descriptions) that use special characters not in the normal ASCII or UTF-8 character set. One example of this was an employee name of ...
