Help with Syntax Error
Fri, 22 Aug 2008 10:37:40 -0600
I'm trying to implement the following query:
UPDATE ScheduledDeliveries SET TargetDeliveries=IIF((TargetDeliveries +
@Increment) >= 0, TargetDeliveries + @Increment, 0)
WHERE ContractID=@ContractID AND CategoryID=@CategoryID AND DueDate=@DueDate
But I get the error: Syntax error near '>'.
Can anyone spot ...
|
Moving data from DB_A to DB_B
Fri, 22 Aug 2008 17:38:02 +0200
Hi,
I need to move data from table CODES in DB CLIENTS to table BRANDS in DB
STORES.
The structure of table CODES is:
COD char(2)
NAME Char(30)
while the structure of table BRANDS is:
BRAND_ID int
Brand_NAME nvarchar(255)
How to create a query to copy the data from one table to another while
ch ...
|
Problem login to SQL Server
Fri, 22 Aug 2008 08:30:31 +0700
Hi,
I have my Access Database as a front end connectere to SQL Server. The
database worked well yesterday and this morning all of users in my office
receive an error below:
Connection Failed
SQLState = '01000'
SQLServer Error = 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
...
|
Connection Error question
Thu, 21 Aug 2008 18:35:49 -0400
Hi All,
Using ms sql 2005 on Windows XP SP2
Why would I get the below error? In the Surface Area Configuration I went
into the Remote Connector and selected as follows:
Local and Remote connections
Using both TCP/IP and named pipes.
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provi ...
|
Clustered index and database ordering
Thu, 21 Aug 2008 22:15:11 +0100
I've been reading about clustered indexes, and I'm confused.
My understanding is that the rows are actually ordered within the database
based on the clustered index. In that case, what happens when I add a new
row? Does the database re-order itself so that the new row is in the correct
place in the database ...
|
Retrieving Row Numbers
Thu, 21 Aug 2008 10:07:17 -0600
Greetings,
Using SQL Server, I'd like to query a simple table. But I'd like one of the
columns returned to be the row number of that row (the row number would not
actually be stored in the table).
I searched the Web a little and found ROW_NUMBER(), however it requires an
OVER statement that doesn't make ...
|
SQL Server 2005 or 2008?
Wed, 20 Aug 2008 23:20:50 -0700
Hello,
My company is going to purchase the developer and the enterprise edition of
SQL Server, we are going to be using Vista as our operating system and I
wondering would it be better to get the newer edition 2008 or stay with
2005. Also, is there a big difference between 2005 and 2008? If so what
can it ...
|
|
|
sp_send_dbmail] @query_result_header = '1', not working
Wed, 20 Aug 2008 16:03:30 -0700 (PDT)
When the below is executed and the email is sent there are no column
headers.
What did I miss? I read by turning that bit to "1" the email would
include headers?
Thanks in advance.
exec [msdb].[dbo].[sp_send_dbmail] @profile_name =
'dbmailden', @recipients = 'email@email.com',
@subject = 'Weekly Tic ...
|
Sql Server management studio?
Wed, 20 Aug 2008 06:30:19 -0700
Hello,
Currently I have SQL Server 2005 Express editon in my PC. I decided to
download SQL Server 2005 Enterprise Edition (180 Days Evaulation from
Microsoft) When I finished installing the software I get Visual Studios
2005. I didn't get SQL Server Management Studios. What Gives? I want to
get 2005 ...
|
Connecting via ODBC Connection in Sql Server 2005
Tue, 19 Aug 2008 22:35:18 -0700
Hello,
I am such a newbe I need help. I just have SQL Server 2005 installed in my
work PC and I trying to figure out where do I go or how do I connect via
ODBC to AS400 from SQL Server Management Studio 2005. I create a ODBC link
from our AS400 accounting database. I want to access the data. I could
...
|
