|
I advice you to use
try
{
myConnection.Open();
result = myCommand.ExecuteNonQuery();
}
catch (SQLException e)
{
// handle exception
...
// log exception
...
throw;
}
finally
{
myConnection.Close();
}
This is a good using of try/catch/finally. Using statement dispose object which created after using in
body of statement.
Return to innocence
|
|
|
|
|
Is it a good idea to have my Data Access Layer on Web Service?
What I mean is, All communication of different tier with the underlying database must all be done using XML web sevices.
What are the Cons and Pros of my idea?
Thanks in Advance.
|
|
|
|
|
Mark Anthony Sabado wrote: Is it a good idea to have my Data Access Layer on Web Service?
Yes. It is a good idea to have a DAL in a webservice.
Mark Anthony Sabado wrote: What I mean is, All communication of different tier with the underlying database must all be done using XML web sevices.
Well, if the other tiers of the application are over an internet connection then that's the safest way to go.
If the other tiers of the application are on the same LAN as the database then you are just adding in an extra layer of slowness. Unless the webservice adds something of value over calling to the database direct then don't use that in a LAN environment.
|
|
|
|
|
Hi All,
I have taken a backup from ABC Database which was stored in SQL Server 2000 server.
Now I need to restore the same backup to same DB which is in SQL Server 2005.
Can I do this operation successfully?
Thanks in advance.
|
|
|
|
|
YES.
it is possible to restore, backup of SQL Server 2000, in SQL Server 2005.
Regards
KP
|
|
|
|
|
But it's worth remembering that you cannot go back - you cannot restore a SQL Server 2005 database backup on SQL Server 2000 server.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
