|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Connect from sql query via IP adress - is i possible? Posted by Just D. at 7/31/2004 12:23:11 PM Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the ...more >>
Querying Multiple SQL Servers in one statement Posted by Devin at 7/29/2004 11:19:20 AM I currently have information stored on two different SQL
servers. I need to run a query that qeurys both at the
same time making comparisions. I would like to be able to
do this in on select statement. Both machines are on a
local network.
First I need to know if this can be done, and if...more >>
Update Posted by mottu at 7/29/2004 4:22:06 AM
I've Emp table with empno, name, dept. The data for the
dept are A,B,C
I want to update that table Edu for A, Sport for B,....
using self join in single statement.
is it possible?
Regs,
Mottu
...more >>
Append Data Posted by GW at 7/29/2004 12:28:31 AM Hi,
Appreciated it if someone could help me with regards to
the abovesaid problem.
I don't know how to append data using SQL Query Analyzer
from table a to table b because it will create duplicate
table b.recordnumber(auto number) in table b. I tried to
use DTS but failed due to the du...more >>
working with dates Posted by Dion at 7/26/2004 12:43:28 PM I am trying to join two tables on a date field. My
problem is the hour/minute section. I want to match
07/26/04 on both tables, regardless of the
hour/minute/second piece of the number. I am used to
doing this in Access/Excel by getting rid of the decimal
part of the number, but can't f...more >>
Count(*) and Like Posted by kk at 7/26/2004 4:34:47 AM I have a SQL statement like the below listed inside a
stored procedure.
-------------------------------
declare @cnt int
declare name varchar(250)
set @name = 'aaa'
Select @cnt = count(*) from table1
where name like @name + '%'
select @cnt
--------------------------------
@cnt is alw...more >>
time Posted by sara at 7/25/2004 8:54:24 AM Hi
i am new in mssql7.before i am using sybase and
some of the tables having field type time.after
convert to mssql7 i changed that field type as timestamp.
i want to store time in that feild.For select and update
query there was no prbm in sybase, but here it is showing
error"The columns dat...more >>
Using if statement in SQL from MS Access Posted by anonymous NO[at]SPAM discussions.microsoft.com at 7/21/2004 1:58:40 AM HI,
I am new to SQL but have experiene in access. I would like
to convert the following from access SQL to proper SQL.
Can anyone help. How should this be done in SQL??
[new_field_name]: iif([fieldname]="Help","HELP",
[fieldname])...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help with Query Posted by spacejunk at 7/20/2004 11:52:58 AM I have two columns I want to compare, both varchar, and
would be in this format
Subject | Instructor
----------------------
ACCT101-nnnnn | jcdoe
ACCT101-nnnnn | jcdoe
ACCT102-nnnnn | jcdoe
ACCT102-nnnnn | jcsmith
----------------------
The subject is made up of (Table.Subject + '-' + ...more >>
Can we ask English Query to show a Graph ? Posted by KK at 7/15/2004 10:31:17 AM Hi
My EQ model dispalys a normal table when you ask a question such as;
show me the amount of goods solds for last 5 years.
it shows the amount grouped in to 5 years.
It would be nice if I can show it in a graph rather than the data.
I have seen a GRAPH verb in EQ but can't find a sin...more >>
renaming database Posted by dave at 7/8/2004 5:35:39 PM I tried to renaming database using query analyser of sql
server 2000 but I got this error msg.
Server: Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform
the operation.
My sysntax was
sp_renamedb 'old_dbname', 'new_dbname'
How to handle this? w...more >>
SQL DB Posted by William at 7/5/2004 6:19:56 AM G'Day folks,
My question is related to deleting an existing db in sql.
The reason why I need to delete the existing db in sql is
to update the db from my log file.
Example for the table jobs, I need to delete all JobId's
from the db.
Can anyone tell me the function that will allow m...more >>
Rounding Problem Posted by s.isa at 7/4/2004 11:50:24 AM Hi all,
Is there any function that truncates a decimal numeric without rounding, if
i use cast it rounds the figure but can i don't want that i.e i want it to
be as follows:
23.1238 turns to 23.123 and not 23.124 so it keeps only three decimals as
is
Please advise if there is any fun...more >>
Access equivelant Posted by anonymous NO[at]SPAM discussions.microsoft.com at 7/2/2004 10:42:59 AM This was the script for access:
oRS.Open "Select * from AlertHistory Where Date
=#"&DateValue(LogTimeStamp)&"#;",oConn
does anyone know the equivalent for sql server?
Cheers!...more >>
Technical questions Posted by eNerGiZer1010 at 7/2/2004 7:40:29 AM Hi folks,
I have a project underway and am having a couple
technical difficulties. My duty is to run my access
database with sql server.
My fist problem is for table jobs.
If I want to delete a certain number of JobId's what do I
have to write in the criteria. For example if I want to ...more >>
select statement run very slow after installing sp3 Posted by new at 7/2/2004 5:46:20 AM Select statement is running 3 time slower than before
after I installed sp3 in SQL 2000.(before is sp1).
Do anyone know why and how to fix it?
Thanks all reply....more >>
Linked Server and Verify Connection Posted by Matt Tapia at 7/1/2004 11:01:42 AM I am adding a linked server to another SQL server within a stored procedure.
I need to verify the link was made before I start running any more code. How
can I verify that I have connected successfully to the linked server?
...more >>
SQLSTATE = 23000 error Posted by ylona schneider at 7/1/2004 7:35:13 AM I need some serious help.
I know nothing of SQL or anything but our business has a
program called Shoplink and we use it to do our order
processing. When i try to save an order I get this error:
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity
constraint violation: Primary key f...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |