|
YES.
backword compatibility is possible. But the other is not
Regards
KP
|
|
|
|
|
hi,
how to play music during the processes of downloading a document in webapplication.
p.sethi
|
|
|
|
|
This is not the right forum to ask such a question.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
|
You might also want to consider how annoying that could become and the fact that you're taking up valuable bandwidth streaming the music along with whatever you're downloading...
I for one would just quit the download and leave.
|
|
|
|
|
I'm new in mssql. I was trying various ways, but no luck.
I have two tables "jobs" and "measures".
JOBS fields are:
[U]JOBID JOBNAME MEASURE[/U]
1 programming 11
2 corbel 22
MEASURES fields:
[U]ID MEASURE[/U]
11 hours
22 lb
[U]The result should be:[/U]
1 programming hours
2 corbel lb
Regards Arthur S.
|
|
|
|
|
Hi,
try the following
Select jobs.JOBID, JOBS.JOBNAME, MEASURES.MEASURE
from JOBS, MEASURES
WHERE JOBS.MEASURE = MEASURES.ID
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
SELECT j.jobid, j.jobname, m.measure
FROM Jobs j
INNER JOIN Measures m ON j.measure = m.id
Regards
KP
|
|
|
|
|
Hi,
Im inserting into one column image at the same time text. but when I insert data I get this error:
Specified argument was out of the range of valid values. Parameter name: Images/laughing.gif
Why is it so?
Thanks
|
|
|
|
|
nclauder wrote: Im inserting into one column image at the same time text
Where r u inserting the this data?
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
In sqlserver database.
Thanks
|
|
|
|
|
Hi,
I am inserting a new record to a SQL 2005 database table(tClients). I have a Primary Key called iClientID in that I use to bind clients, that is Auto Number.
I want to retrieve the iClientID once I inserted the record, as part of my stored procedure. Here is my insert statement.
<br />
<br />
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)<br />
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)<br />
<br />
|
|
|
|
|
DECLARE @Id INT
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)
SELECT @Id = SCOPE_IDENTITY();
|
|
|
|
|
Thanks Colin,
I just have one more question... What is SCOPE_IDENTITY()?
|
|
|
|
|
playout wrote: I just have one more question... What is SCOPE_IDENTITY()?
What you asked for. The ID of the most recently inserted row (in this scope).
|
|
|
|
|
SCOPE_IDENTITY
Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a module -- a stored procedure, trigger, function, or batch.
Regards
KP
|
|
|
|
|
Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.
Regards,
Satips.
|
|
|
|
|
i have 3 tables
1 master
2 advance
3 loan
here some employe taken only advance,some only loan ,some both and some not availed.
i want to list like this those are availed.
emp_code emp_name adv_amt, loan
emp_code is id for all three files
regards
chandru
|
|
|
|
|
SELECT MASTER.EMP_CODE,MASTER.EMP_NAME,ADVANCE.ADV_AMT, LOAN.LOAN
FROM MASTER ,ADVANCE,LOAN
WHERE
MASTER.EMP_CODE=ADVANCE.EMP_CODE
AND
MASTER.EMP_CODE=LOAN.EMP_CODE
AND
LOAN.AVAILED='Y'
vivek
|
|
|
|
|
by excuting this query only those records who are availed both loan, advance will be displayed.
thank you
chandru
|
|
|
|
|
SELECT emp_code, emp_name, sum(adv_amt) as adv_amt, sum(load) AS loan
FROM (
SELECT emp_code, emp_name, adv_amt, 0 AS loan
FROM master m
INNER JOIN advance a ON m.emp_code = a.emp_code
UNION ALL
SELECT emp_code, emp_name, 0 AS adv_amt, loan
FROM master m
INNER JOIN loan l ON m.emp_code = l.emp_code
)a
GROUP BY emp_code, emp_name
Regards
KP
|
|
|
|
|
|
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End.
Actually I am fetching data from other database(named as retailexcel but in same server). I have wriiten a view (in retailexcel database) to get required data from four table of other database. My problem is when I fetch those data(about 40000 to 50000 record) It taking to much time. I tried catch feature of asp.net2.0. Time reduced but not significantly. So I am trying to import those tables to my database (named Inventory) from that retailexcel.
Now problem is every day or two, record of those tables changes. How can I keep update my tables (which are importing from retailexcel)
Please suggest me some idea.
Thanks
regards
imran khan
|
|
|
|
|
Can you schedule a SQL-Server job that runs once a day?
|
|
|
|
|
How would I update the field 'filename' in my SQL Server DB so that it replaces all '-' with an '_'? Is that possible?
FOUND IT.
|
|
|
|