|
hi experts.
i have a several special characters in my column
like example
goes here
empno emp name
1 ve?u.r
2 raj
3 venki
4 Stáció
5 gái
6 Vecsés
7 Mosonmagyaróvár
8 sachin
i want to list out the names with only special characters plz help me out
regards
venu
|
|
|
|
|
|
use patindex function to find out the column with special character .
|
|
|
|
|
i have 10000 rows in that different different special characters r there how can i list with patindex plz specify
|
|
|
|
|
ex a-zA-Z0-9
the above pateern will accecpt only value in betwwn them for other they will return for presence of special character .
plz check it
|
|
|
|
|
hi friend
How to view trigger so that we can modify, we donnot name of trigger.
plz help me
Thank and Regards
Azad Yadav
|
|
|
|
|
The management studio lets you view and modify triggers easily.
If you want to scripts, use exec sp_helptext "Your_Trigger_Name" -- actually, any database object to view the trigger. And use Alter to modify the trigger.
Eslam Afifi
|
|
|
|
|
use this statement
select * from sys.triggers
which will return all the trggername list
|
|
|
|
|
how to draw my own control from scratch
|
|
|
|
|
in a general database?
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hello Friends,
I've a table as given below
ID LChild RChild
1 2 3
2 4 6
3 5 7
4 8 9
5 10 11
6 12 13
7 0 14
Now i've to find out the LChild of 1, 1 has 2 in it's left and 2 has 4,6 as it's child and 4 and 6 has also two-two child each......At final 1 has 7 child on it's left and on it's Right it's 6
And also i've find out for each ID i.e 1,2,3,4,5,6,7
|
|
|
|
|
Yes I have same table and want sql query for counting left and right node
|
|
|
|
|
Hi all,
Someone once posted here an excellent self join code on aggregates but just couldn't find it. The problem is similar as follows:
PriKey Field1 Field2 Field3 Field4
1 54 Ninna 42 1
2 2 Sybil 53 2
3 6 Michelle 44 3
4 12 Abigail 47 4
5 67 Geneana 55 5
6 23 Abigail 40 4
7 21 Evelyn 41 6
8 6 Sybil 57 2
9 85 Ninna 57 1
10 3 Sybil 49 2
11 78 Evelyn 50 6
12 4 Michelle 51 3
I want to group by on Field4 and for each, I want the maximum in Field1 such that the output is as follows:
PriKey Field1 Field2 Field3 Field4
8 6 Sybil 57 2
3 6 Michelle 44 3
9 85 Ninna 57 1
6 23 Abigail 40 4
11 78 Evelyn 50 6
5 67 Geneana 55 5 I believe the solution involves a self join and the max aggregate function. Thanks in advance.
----------------------------------------------------------
Lorem ipsum dolor sit amet.
|
|
|
|
|
Hi,
Assuming the table is called "kh" and you want it ORDER BY Field1 you could try this. The syntax works with T-SQL (Sybase). You may need to amend it for your DB if different.
SELECT t1.PriKey,t1.Field1, t1.Field2,t1.Field3,t1.Field4
FROM kh t1 INNER JOIN (SELECT MAX(Field1) AS Field1,Field4 FROM kh GROUP BY Field4) t2 ON (t1.Field4 = t2.Field4)
WHERE t1.Field1 = t2.Field1
ORDER BY t1.Field1
I hope it helps.
Cheers,
Kevin
|
|
|
|
|
yes it did, thanks!
----------------------------------------------------------
Lorem ipsum dolor sit amet.
|
|
|
|
|
Hi,
We want to synchronize SQL 2005 database, of a client between their two
branches in different cities, For that i found Web Synchronization, is helpful to us.
But I found that While configuring Web Synchronization, i have to use Domain
Name, Static IP, SSL critificate, Which might be cosltly to our customers. So i
want to ask three questions,
1. Is Web Synchronization possible without configuring Domain Name?
2. If I got Static IP, Is that possible to use IP Address in Webserver Address, while
synchronization?
3. Can I use Self Signed SSL Certificate?
Thanks in advance....
|
|
|
|
|
Currently I am connecting to an Access database via ODBC and a CRecordSet. I know I can create an ODBC entry for SQL Server and continue to use CRecordSet. All I have to do is change the connection string. I have used ADO in the past to connect to SQL Server but I am tempted to continue to use CRecordSet. What is the best way to connect to SQL Server? If I continue to use CRecordSets will I have problems later. Will the connection be slower.
Any past experience advice would be apprecated.
Thanks
|
|
|
|
|
I would not use ODBC as it is another layer of abstraction on your DAL. I have not used it in a very long time. The question to me is ALO or OLEDB[^] having done some research I decided to stick with OLEDB.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Ado.NET is Cool for that
see this http://www.dotnetfunda.com/articles/article103.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
select m.pharmacyid as MemberJoinedPharmacy,
tempTrans.pharmacyid as MemberFirstTransaction,
tempTrans.transactiondate,
m.datejoined,
m.cardno, m.title, m.firstname, m.lastname,
m.street, m.suburb, m.state, m.postcode,
m.lastsale, p.pharmacyname
from member m
join pharmacy p
on m.pharmacyid = p.pharmacyid
join (select top 1 * from transactioncurrent t
where m.memberno = t.memberno
and t.voucherno is null
order by t.transactiondate) tempTrans
where m.datejoined >= '2009-01-01'
and m.pharmacyid in (select ph.pharmacyid
from pharmacy ph
where ph.pharmacygroupid = 87)
and m.datejoined <= tempTrans.transactiondate
and m.pharmacyid <> tempTrans.pharmacyid
order by m.pharmacyid
|
|
|
|
|
By db engineer I assume you mean the database engine? If so, obviously, yes there is something wrong - what that may be we can have very little idea without any other information.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi Bob,
thanks for ur reply, already worked out...
|
|
|
|
|
What sort of syntax error? Where is it? These will be stated in the error message.
|
|
|
|
|
thanks mate, already worked out....
|
|
|
|
|
i tried to drop the primary key of the table using
alter table customer drop primary key but it says
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'primary'.
what might be the problem
|
|
|
|