Database Discussion Boards

Re: Microsoft Access and Record Level Locking

paas9-Apr-09 1:14

paas

9-Apr-09 1:14

Luc Pattyn wrote:
I would delegate all DB modifications to one specialized thread, and probably give it an input queue

Thanks for the reply. Delegating all DB modifications to one thread with an input queue is an interesting thought. I'll probably give that a try if I can not figure out why this version of an Access MDB, which is supposed to support record-level locking, does not seem to at least in this multi-threaded app. Unfortunately SQL Server Express is not an option, and a retry loop could get real ugly in this app.

Run Store Procedure Same Time

dataminers8-Apr-09 6:02

dataminers

8-Apr-09 6:02

Hi,

How can I run (or call) more than one store procedure at the same time?

For example I have a 3 store procedure;

First is sp_GetResult
Second is sp_Allotment
Third is sp_Price

How can I run sp_Allotment and sp_Price stored procedures at the same time (like thread) in sp_GetResult stored procedure.

Note: I use MS SQL Server 2005

Best Regards...

Re: Run Store Procedure Same Time

Rob Philpott8-Apr-09 6:59

Rob Philpott

8-Apr-09 6:59

Don't think you can. Sql Server determines its concurrency automatically and steps through stored procs iteratively.

Regards,
Rob Philpott.

how to hide trigger so that othe user cant not modify or view

azad yadav8-Apr-09 0:56

azad yadav

8-Apr-09 0:56

hi friend

How to hide trigger so that othe user can not modify or view
plz help me

Thank and Regards
Azad yadav

Re: how to hide trigger so that othe user cant not modify or view

anup keshari8-Apr-09 3:31

anup keshari

8-Apr-09 3:31

u have to set the permission for object by using the managaement option and set the permission for other user.

let me know if need any things

Re: how to hide trigger so that othe user cant not modify or view

anup keshari8-Apr-09 3:50

anup keshari

8-Apr-09 3:50

sorry for the above go the database and then security and there u can set the deny or grant for alter or view

special characters in my column

venu6567-Apr-09 20:20

venu656

7-Apr-09 20:20

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

Re: special characters in my column

Eslam Afifi7-Apr-09 22:30

Eslam Afifi

7-Apr-09 22:30

Use regular expressions to match the special characters.
Regular Expressions Make Pattern Matching And Data Extraction Easier[^]
The expression would be something like "[\u0041-\u005A]", which matches character range from A to Z.

Eslam Afifi

Re: special characters in my column

anup keshari8-Apr-09 0:26

anup keshari

8-Apr-09 0:26

use patindex function to find out the column with special character .

Re: special characters in my column

venu6568-Apr-09 0:59

venu656

8-Apr-09 0:59

i have 10000 rows in that different different special characters r there how can i list with patindex plz specify

Re: special characters in my column

anup keshari8-Apr-09 3:27

anup keshari

8-Apr-09 3:27

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

how to view trigger in sql 2005

azad yadav7-Apr-09 18:40

azad yadav

7-Apr-09 18:40

hi friend

How to view trigger so that we can modify, we donnot name of trigger.

plz help me

Thank and Regards
Azad Yadav

Re: how to view trigger in sql 2005

Eslam Afifi7-Apr-09 22:14

Eslam Afifi

7-Apr-09 22:14

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

Re: how to view trigger in sql 2005

anup keshari8-Apr-09 0:29

anup keshari

8-Apr-09 0:29

use this statement

select * from sys.triggers

which will return all the trggername list

test

sanket_patil1117-Apr-09 5:20

sanket_patil111

7-Apr-09 5:20

how to draw my own control from scratch

wrong forum; bad subject line

Luc Pattyn7-Apr-09 6:14

Luc Pattyn

7-Apr-09 6:14

in a general database?

Smile | :)

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

Count Left Nodes

.NET- India 7-Apr-09 2:05

.NET- India

7-Apr-09 2:05

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

Re: Count Left Nodes

Upen Nathwani28-Jul-11 8:06

Upen Nathwani

28-Jul-11 8:06

Yes I have same table and want sql query for counting left and right node

Self Join and Aggregate Functions

swjam7-Apr-09 1:19

swjam

7-Apr-09 1:19

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.

Re: Self Join and Aggregate Functions

Kevin Horgan7-Apr-09 3:44

Kevin Horgan

7-Apr-09 3:44

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

Re: Self Join and Aggregate Functions

swjam7-Apr-09 13:09

swjam

7-Apr-09 13:09

yes it did, thanks!

----------------------------------------------------------
Lorem ipsum dolor sit amet.

Web Synchronization without domain name

vyasdev20096-Apr-09 21:46

vyasdev2009

6-Apr-09 21:46

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....

Best way to connect to SQL Server 2008

Just someone else6-Apr-09 6:32

Just someone else

6-Apr-09 6:32

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

Re: Best way to connect to SQL Server 2008

Mycroft Holmes6-Apr-09 12:11

Mycroft Holmes

6-Apr-09 12:11

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

Re: Best way to connect to SQL Server 2008

Vimalsoft(Pty) Ltd6-Apr-09 20:44

Vimalsoft(Pty) Ltd

6-Apr-09 20:44

Ado.NET is Cool for that Smile | :)

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.