Re: about locks - Database Discussion Boards

indian14311-Mar-07 20:54

11-Mar-07 20:54

Sir,
Can we update or insert into a table by updating or inserting a view on that table. If we can, then how and if we cant then whats the remedy for that and reason for that. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Re: View

Sylvester george11-Mar-07 23:50

Sylvester george

11-Mar-07 23:50

yes we can update table thru views if the view is not readonly

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: View

Krish - KP12-Mar-07 1:38

Krish - KP

12-Mar-07 1:38

YES. (in continuation to sylvesterg)
It is possible, if view contains all not null / foreign key columns of base table.

View is like a filter/window by which data in a tbale is viewed.

Regards
KP

View

indian14311-Mar-07 20:52

indian143

11-Mar-07 20:52

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Creating Search Index in SQL Server

N a v a n e e t h11-Mar-07 20:32

N a v a n e e t h

11-Mar-07 20:32

Hi

I need to implement search facility. How can I do that ? How can I make a search index table ? How google is maintaining their search index ? Will they store all contents from the pages what they crawled ?

Cheers
Navaneeth!!

www.w3hearts.com

Re: Creating Search Index in SQL Server

mghiassi25-Mar-07 9:44

mghiassi

25-Mar-07 9:44

Hi You can use a SELECT statement that it contions a CONTIONS keyword simply

about locks

Renuka Reddy11-Mar-07 19:35

Renuka Reddy

11-Mar-07 19:35

give me the what is locks....
where we r using....
whick purpose....
give me detailed please....

Re: about locks

N a v a n e e t h11-Mar-07 20:38

N a v a n e e t h

11-Mar-07 20:38

Relational databases like Microsoft's SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock.

check these links

http://www.revealnet.com/newsletter-v3/0202_F.htm[http://www.revealnet.com/newsletter-v3/0202_F.htm^]

http://www.sql-server-performance.com/at_sql_locking.asp[http://www.sql-server-performance.com/at_sql_locking.asp^]

Cheers
Navaneeth!!

www.w3hearts.com

Cannot Update..theres an error

blitz2bleach11-Mar-07 11:40

blitz2bleach

11-Mar-07 11:40

hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user

I make the query in the stored procedure but the error said: "Incomplete SET clause..unable to parse query text"
i just want someone to check out the query and pls tell me what wrong or incomplete to my query

UPDATE UserTable
SET ((UserTable.[password] = [@password])
WHERE ((UserTable.username = [@username])

another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values...

here is the query

SELECT COUNT(*) AS Num_of_User
FROM UserTable
WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password]));

error:unable to parse query text
it is correct query for accessing the values from the database?

Im using a visual web developer IDE, i dont think if im using a sqlserver 2000 or 2005

thanx for helping

Re: Cannot Update..theres an error

Colin Angus Mackay11-Mar-07 11:49

Colin Angus Mackay

11-Mar-07 11:49

blitz2bleach wrote:
UPDATE UserTable
SET ((UserTable.[password] = [@password])
WHERE ((UserTable.username = [@username])

The SET clause has two sets of opening brackets and only one closing.
The same goes for the WHERE clause.
Also, you encapsulate the parameters in square brackets which mean they will be interpreted as column names.

I would have written your SELECT query without the profusion of brackets. You also encapsulated the parameters in square brackets which mean they will be interpreted as column names.

Try this:

SELECT COUNT(*) AS Num_of_User
FROM UserTable
WHERE username=@username AND pasword=@password;

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

Re: Cannot Update..theres an error

Harini N K11-Mar-07 23:47

Harini N K

11-Mar-07 23:47

Hi

Use square brackets if you have spaces in column or table name or if column name is a SQL Keyword

For eg.,

SELECT [ID],[Product Name],Price From [Products of ABC]

Harini

Sqlserver 2000 and Sqlserver 2005

alav11-Mar-07 4:03

alav

11-Mar-07 4:03

Hi all
What are the advantages of sqlserver2005 over sqlserver2000?
Thanks in advance

Re: Sqlserver 2000 and Sqlserver 2005

Jerry Hammond11-Mar-07 5:30

Jerry Hammond

11-Mar-07 5:30

Better datatypes

“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan

Re: Sqlserver 2000 and Sqlserver 2005

Paddy Boyd12-Mar-07 1:48

Paddy Boyd

12-Mar-07 1:48

More satisfyingly expensive.

Use Mssql like Access

Tyler4511-Mar-07 4:38

Tyler45

11-Mar-07 4:38

Hello Friends,
I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible?
If it is, how can it be?
Thanks for your helps?
Best Regards
Eray

Re: Use Mssql like Access

Dave Kreskowiak11-Mar-07 6:40

Dave Kreskowiak

11-Mar-07 6:40

It's kind of possible, but the only way to make it work is if the machine has SQL Server Express installed on it. You simply cannot get around that requirement.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Use Mssql like Access

S Douglas12-Mar-07 0:43

S Douglas

12-Mar-07 0:43

If you absolutly can't run SQL Express, have you looked at SQL Server Compact Edition[^]

http://www.microsoft.com/sql/editions/compact/default.mspx[^]

I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

Re: Use Mssql like Access

LongRange.Shooter16-Mar-07 7:38

LongRange.Shooter

16-Mar-07 7:38

The whole purpose of Sql Server is to have data developement projects move out of the amateurish world of Access. What you do is the following:

The application would go on any machine but you create a connection string
in the app.config that contains all of the connection data.

Now in your connection string you specify some url "\\DevelopmentServer" for example.
Whatever you do -- eliminate all existance of localmachine from your connections!!!

Now on the development machines you modify the hosts file as follows
your machine : DevelopmentServer 127.0.0.1
others machine: DevelopmentServer {your ip address}

The only downside to this approach is that any time your IP is reissued via DHCP you need to have the others update their hosts file. The other possibility is you have your engineers give your machine a fixed address until you can deploy a real database server with a fixed address.

storing many no. of labels n textboxes at one time

manni_n10-Mar-07 7:10

manni_n

10-Mar-07 7:10

i have 1 labels, 1 text box and one check box
suppose label contains name,
in textbox user have to enter its age
and checkbox is checkd if he is married.

i have given conneection string using oledb in access sheet
and its storing the values of label, textbox and checkbox succesfully
but nw i have problem when i have many number of labels like thereare more than one name and correspondin textboxes and checkboxes.
when i enter all the values i want them to get store on one button click in my acccess table.

m uanble to implement any logic.
can smbody help.... please tell the stored procedure
u can tell on either acces or SQL server 2000.
thanks

How to select any field that contain a certain word .. SQL server 2000

kindman_nb10-Mar-07 6:22

kindman_nb

10-Mar-07 6:22

Hi

I'm easy to me to select any field that begain with any letter or word ,,
but how can I select all fields that contain a word like "bil" ..

jooooo

Re: How to select any field that contain a certain word .. SQL server 2000

alexrad11-Mar-07 0:36

alexrad

11-Mar-07 0:36

full text index

Re: How to select any field that contain a certain word .. SQL server 2000

mghiassi11-Mar-07 0:19

mghiassi

11-Mar-07 0:19

Hi You can select these fields by LIKE operator
Example:
SELECT * FROM MyTable WHERE MyField LIKE %c "bil" c%

Re: How to select any field that contain a certain word .. SQL server 2000

mghiassi11-Mar-07 2:15

mghiassi

11-Mar-07 2:15

Hi Excuse me
Your code look like this
SELECT * FROM MyTable WHERE MyField LIKE '%bil%'

Re: How to select any field that contain a certain word .. SQL server 2000

kindman_nb11-Mar-07 5:28

kindman_nb

11-Mar-07 5:28

Thanks My friend
it's ok Rose | [Rose]

jooooo

SQL 2000 Client [modified]

TheEagle10-Mar-07 0:55

TheEagle

10-Mar-07 0:55

Hi..

Iam trying to connect to a host sql server 2000 using SQL enterprise manager.I made it successfully using one of my desktop computers but I could not do it using my new Laptop.When I try I get the error:specified sql server not found.I dont know what cause this problem.May be because I have Mcafee installed on this laptop But I don't know how to fix this problem?.

Please any advice could be helpful.

-- modified at 11:01 Saturday 10th March, 2007

I am too late but i will never give up

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