Viewing 10 posts - 31 through 40 (of 40 total)
Hi,
Thanks for the reply.
My main concern in this query is how to pass the multiple user inputs for the same column?
User might enter a big sentence with AND /...
July 29, 2009 at 12:06 pm
How will this work?
Can u pls explain?
July 29, 2009 at 6:41 am
Extending the table structure given in the article[/url]
I have added an extra table for UserListing.
CREATE TABLE dbo.tblUser ( codUser INT, codName VARCHAR(20),PRIMARY KEY (codUser));
insert into dbo.tblUser values (1, 'abc');
insert into...
January 2, 2009 at 3:15 am
Thanks for the reply.
GilaMonster (11/5/2008)
Remember that not all users will have rights to open the symmetric key.
Thats fine. What If somebody hacks the database and access the mdf file,...
November 5, 2008 at 10:07 pm
Here is my query:
--------------------------------------------
create table #tempp
(
Id int IDENTITY(1,1),
[profile] varchar(max)
)
OPEN SYMMETRIC KEY KOLSymmetricKey
DECRYPTION BY CERTIFICATE KOLProfile037;
go
select [Profile],
CONVERT(nvarchar, DecryptByKey(EncryptedProfile)) EncryptedProfile
from #tempp
go
I got the answer. I was using a different...
November 5, 2008 at 5:30 am
Hi Amit Khanna,
Thanks for ur reply. I am an asp.net developer, not a dba :rolleyes: but still i have a good knowledge on db.
I have used joins on tables,...
August 26, 2008 at 3:09 am
Hi Amit,
Can you (or anybody) explain me how this CTE works..??
I am confused.. 🙁
Thanks in advance..
August 23, 2008 at 11:48 pm
Thanks a lot Amit Khanna.. 🙂 Great job..
Updating the temp table as done by Arjun tewari will not be a good idea in this case..
declare @i int
set @i=234
update #temps...
August 22, 2008 at 3:30 am
create table #Like_Test( Col1 varchar(5) )
insert #Like_Test values('_Cus')
insert #Like_Test values('Cus_')
insert #Like_Test values('C_us')
insert #Like_Test values('Cus')
insert #Like_Test values('Cu_s')
select * from #Like_Test where Col1 Like '%Cu_%'
How can we really get the row...
August 13, 2008 at 11:08 pm
Here, in India i have noticed that they call us "Software Engineer" not an IT guy, and that looks good. 😉
June 26, 2008 at 2:21 am
Viewing 10 posts - 31 through 40 (of 40 total)