|
SELECT TABLEA.COL1,TABLEB.COL2 FROM TABLEA INNERJOIN TABLEB
ON TABLEA.COL1 = TABLEB.COL2
|
|
|
|
|
Try this:
select b.col2 from tableA a,tableB b where BINARY_CHECKSUM(a.col1) = BINARY_CHECKSUM(b.col2)
Girish Kumar Sharma
|
|
|
|
|
Hello,
I had been running my application on Windows XP. It uses Jet 4.0 engine for database connection.
Now in my new system, I have installed Windows XP(sp2)which comes with MDAC 2.8 and it doesn't contain Jet engine. MDAC 2.5 is the last version that comes with Jet and the later versions do not.
I've tried but I can't install Jet or MDAC 2.5 as MDAC 2.8 is already installed with windows xp. I've installed office 2003 but Jet won't install with it.
How can I get Jet engine?
or
what is the alternate to JET engine in MDAC 2.8. can I just change the provider and keep my application working?
-- modified at 20:15 Thursday 18th January, 2007
|
|
|
|
|
The Jet 4.0 engine is part of the operating system from Windows 2000 onward. Because of this, you have to apply an OS hotfix to upgrade it. For information on getting the latest version, see this KB article (239114)[^].
|
|
|
|
|
I'm trying to standardize the phone number format for some historical records. The phone numbers have been entered in different formats in the past. I would like to extract just the numerical characters from the old phone numbers so I can reformat them into an xxx.xxx.xxxx format. I've looked into using the Replace and Substring functions, but I was hoping an easier solution existed.
|
|
|
|
|
I found a solution using code provided on this site:
http://www.vsj.co.uk/articles/display.asp?id=540[^]
Here is a Scalar-valued SQL Function to do the job:
<br />
SET ANSI_NULLS ON<br />
GO<br />
SET QUOTED_IDENTIFIER ON<br />
GO<br />
CREATE FUNCTION RemoveNonNumerics <br />
(<br />
-- Add the parameters for the function here<br />
@sInputValue varchar(24)<br />
)<br />
RETURNS varchar(24)<br />
AS<br />
BEGIN<br />
-- Declare the return variable here<br />
DECLARE @Result varchar(24)<br />
<br />
-- Add the T-SQL statements to compute the return value here<br />
SELECT @Result = @sInputValue<br />
<br />
-- Remove non-numeric characters<br />
declare @i INT<br />
select @i = 25<br />
while @i > 0<br />
begin<br />
SELECT @i = patindex('%[^0-9]%',@Result)<br />
SELECT @Result = replace(@Result,substring(@Result,@i,1),'')<br />
end<br />
<br />
-- Return the result of the function<br />
RETURN @Result<br />
<br />
END<br />
GO<br />
|
|
|
|
|
hai,
How we able to add extra 15 minutes to a already existing date time data type column in sql server
thanks and regards,
Siva
Sivakumar
|
|
|
|
|
With DateAdd.
DateAdd(15, mi, @date)
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
hi all,
I have written one StoredProcedure that select Data from Table
in ADO.Net i have taken transaction object like below
Sqltransaction tran = con.Transaction
tran.BeginTransaction
Where should i maintain transactions in ADO.Net code in Sql Server stored Procedure using Begintransaction end Transaction
pls give clarify my doubt , where I can maintain and pls distinghish both transaction situations
i will be looking 4 u r reply
Thanks in Advance
Have a Nice Day
|
|
|
|
|
|
Why do you need a transaction for a simple select?
What about adding (nolock)?
|
|
|
|
|
The choice as to where to maintain the transactions depends on your usage, but a good guideline is never mix the two. If yo choose to put transactions in your SPs, then DON'T put them in the application code as well.
IMO, keepeng the transaction management in the application code is more flexible, and allows use of distributed transactions (should they ever be needed) more gracefully. It also allows transaction scope to span multiple SP's if needed.
Note that transactions are rarely (if ever) needed for Select statements, but should generally be used for data modification statements (Insert, Update).
|
|
|
|
|
The point of a transaction is to give consistency across multiple operations. If you need that consistency within a stored procedure, use BEGIN TRANSACTION /COMMIT TRANSACTION /ROLLBACK TRANSACTION in the stored procedure text. If you need that consistency across multiple calls from the client application, use the SqlTransaction object.
I personally favour consolidating as many basic operations as possible, that are directly related, into a single stored procedure or query batch, in order to avoid being 'chatty' with the database (and incurring a lot of network latency). Therefore I very rarely use SqlTransaction objects.
|
|
|
|
|
can some body let me know what is the main diffrence between SQL function and Store Procedure.
Pavan Pareta
|
|
|
|
|
|
1.stored procedures allow default values for parameters user defined functions do not.
2.stored procedures allow you to use temp tables user defined functions only allow table variables.
3.you can use table valued user defined functions for normal table functionality such as joins, select *, etc. which can be useful sometimes.
4.both have cached execution plans.
In general I would suggest to use procedures when you can and function only when a procedure won't do the job, just because it seems that functions could allow you to kill your performance when used in where clauses on queries with alot of rows, or even if used in select list on queries with alot of rows. Also functions calling functions makes sense to an application developer but doing something like that in your databse functions may be tempting, but imho is a bad idea.
|
|
|
|
|
|
Hi,
Can anyone help me with the code to copy data from datatable to SqlServer table. Please dont use the SqlBulkCopy technique as i am working in .net 1.1 which does not support that. Give me the code to copy the rows in datatable one by one to database.
Thanks in advance...
Usha
|
|
|
|
|
|
Hi,
Again I am back with ANY operator
can anyone give me an example of how to use any operator in sql server?
Regards,
Uma
|
|
|
|
|
SELECT Col1, Col2, Col3
FROM TABLE1 WHERE
Col4 >= ANY
( SELECT Col1 FROM TABLE2 WHERE DateAdded >= '21-Oct-2006')
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi there.i have two button controls on my UI of a web application.i name them as 'previous' and 'next'.when i click on 'previous',i should be able to go to the previous record and when i click the 'next' button,i should be able to go to the next record in an sql server database.i also have two buttons for adding and editing records in a dataset.can i get help in writing code in c# preferably.
thanks.
|
|
|
|
|
hi
use BindingContextConcept and try with this code.Ihope will help for u r requirement and give replay
write in nextbutton_click event
this.BindingContext("nameofDataSet","NameofTable").position= this.bindingContext("NameofDataset","nameoftable").position+1;
this is for prevbutton_click event
this.BindingContext("nameofDataSet","NameofTable").position= this.bindingContext("NameofDataset","nameoftable").position-1;
if the record cursor reaches first record then u can disabl prev and same for next
Have a nice day
|
|
|
|
|
thank u very much.i had also mentioned about adding and editing records.i tried with controlname.databindings.add.but thats not working since i am implementing in a webapplication and that method only seems to work for windows forms.can i get any help in this?
thanks in advance.
|
|
|
|