|
yes we can update table thru views if the view is not readonly
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
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
|
|
|
|
|
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
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 ?
|
|
|
|
|
Hi
You can use a SELECT statement that it contions a CONTIONS keyword simply
|
|
|
|
|
give me the what is locks....
where we r using....
whick purpose....
give me detailed please....
|
|
|
|
|
|
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
|
|
|
|
|
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;
|
|
|
|
|
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
|
|
|
|
|
Hi all
What are the advantages of sqlserver2005 over sqlserver2000?
Thanks in advance
|
|
|
|
|
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
|
|
|
|
|
More satisfyingly expensive.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
Hi
You can select these fields by LIKE operator
Example:
SELECT * FROM MyTable WHERE MyField LIKE %c "bil" c%
|
|
|
|
|
Hi
Excuse me
Your code look like this
SELECT * FROM MyTable WHERE MyField LIKE '%bil%'
|
|
|
|
|
Thanks My friend
it's ok
jooooo
|
|
|
|
|
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
|
|
|
|
|
You've either got a name resolution problem or a firewall issue.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|