Hi
Can anyone help with the 2 bits of code below by correcting the error for me.
UPDATE tblTDPageNewURL
SET tblTDPageNewURL.TestText = tblTDPageNewURL1.TestText
FROM tblTDPageNewURL1
INNER J...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21336251.html
Hi: I need loads of help, first is my Employee table doesn't create because there is this error message that keeps coming up: Server: Msg 128, Level 15, State 1, Line 3 The name '222-22-2222' is n...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21383036.html
I have a web application that will allow me to attach files (XLS, DOC, PPT, JPG, etc.) and view them later when clicked from the browser. The browser will automatically open the proper application...
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_21435641....
I've got the procedure below set up to read specific symbol values from an IN list. Unfortunately, now I need to change it to accept the symbol as a passed parameter. Right now the user may pass ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21460893.html
When I try to create an an database in ms sql as
create database xyz;
I am getting the following errors. I am doing this on a server which is used to host user accounts.
For a previously c...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21469366.html
i'm trying to set two variables, compare the two, and generate an alert if the two counts are not the same. i'd like that alert to return the endpoint and counts from both variables that are not e...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21623289.html
What is the best way to download all e-mail messages onto my personal pc?
I used to "select all" and "save as .txt", but in this case, attachments are not downloadable.
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_21694869....
i'm getting the following error which seems to be in the @SQLSTR, cuz when i rem out the EXEC(@SQLSTR) it runs ok. the error is
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syn...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21943856.html
Please tell me why and what I can do?
CREATE TRIGGER ALEXTR ON ALEX
FOR UPDATE
AS
DECLARE @intRowCount INT, @id int
INSERT into ALEX1
SELECT *from deleted
se...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11467698.html
I go to run a scheduled task and it seems to try to write history to the MSDB database but I get error 3009. I looked up on MS KB and it says to use the DBCC CHECKINDENT on the two tables. BUt I ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20109860.html
