|
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
|
|
|
|
|
SQL Server:
exec sp_rename @objname='TableName.ColumnName', @newname='NewColumnName'
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
:-Dwrite querry to compare row in table A and in table B.
for example
if in table A contains row values as a 12
b 14
c 15
if in table B contains row values as a 13
b 21
c 43
compare table A's row c with table B's row c.
pradeep kulkarni
|
|
|
|
|
The questions you're asking are very easy, and you're obviously typing in your homework. Please try yourself, if you can't work this out, you should quit your course.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
write querry to display all books whose name start with 's'
please help me
pradeep kulkarni
|
|
|
|
|
SELECT * FROM <tablename>
WHERE COLUMNNAME LIKE 'S%'
|
|
|
|
|
Please don't do people's homework, it's not helping them
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
hi ,
this is santhosh in my project i want to store 3 images in one column in sqlserver and when the time of displaying(in front end c#) it should display seperately , plz tell me how to do this
thank you
santhosh
|
|
|
|
|
Why do you want to store three images in one column? Seems like a bit of a normalisation issue here.
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 ,
in my project documentation is prepared like that that's why i am trying to store 3 images in one column plz help me
.......santhosh
|
|
|
|
|
write a querry to delete table.
pradeep kulkarni
|
|
|
|
|
drop table [dbo].[TableName]
I am Entry level person
|
|
|
|
|
DELETE TABLE WHERE <condition>
EX:DELETE TABLE EMP WHERE EMPNO = 1;
|
|
|
|
|
That doesn't work. You can't conditionally delete a table.
Either way, don't do the guys homework.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi,
I have two tables A and B.
A have a column col1 with list of values comma separated.
B also has a column col2 with list of values comma separated.
Now I should get records joining on both the columns where values in col1 = values in col2 all the values should match.How can I achieve this.
For example.
table A
col1
delhi,chennai,kolkata,mumbai
delhi,mumbai
delhi,chennai
table B
col2
delhi,mumbai
now i want to get all the records from table A where ever the column col1 has both delhi and mumbai
this is my problem.
Regards,
Uma
|
|
|
|
|
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
|
|
|
|