|
in sql server2005 is it possible to add a new column in view,other than than select column names from table name
|
|
|
|
|
Rmesh wrote: in sql server2005 is it possible to add a new column in view,other than than select column names from table name
I don't understand what you mean. Do you want to add a column to the view that does not exist already in a table? If yes, then you can only add computed columns. The view contains no data whatsoever, it can only link to existing data therefore any column on the view must be exsting data or derived from existing data.
|
|
|
|
|
hi everyone, it's my first time here in this part of the forum and i'll be greatly thankful if i can get some help from ado experts,
im trying to connect to oracle db from c# when i get this error
(ORA-00911 Invalid Character)
ConnectMe = new OracleConnection("Data Source=orcl;Persist Security Info=True;User ID=DLDSP;Password=LIVE8;Unicode=True");
ConnectMe.Open();
OracleCommand cmdProfile = new OracleCommand("SELECT DName FROM Profile;", ConnectMe);
DAdap = new OracleDataAdapter(cmdProfile);
DSet = new DataSet();
DAdap.Fill(DSet); // **** I'm getting the error on this step **** //
please help!
All globalizations are wrong, including this one!
|
|
|
|
|
Hi Friends ,
I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .
Can you please guide me.
Thanking you ,
Param.
param
|
|
|
|
|
param thaker wrote: I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .
This is not possible in SQL Server 2000. It may be possible in SQL Server 2005, but I doubt it. Certainly you could use CLR stored procedures to encrypt and decrypt data, however doing so on key or indexed columns is not advisable because it will dramatically hurt the performance of your database.
|
|
|
|
|
Hi,
I installed sql server management studio 2005 in my windows 2003 OS system,at yesterday(08-Dec-2006).But today(09-Dec-2006),it is not worked.what is the reason for not working sql server management studio 2005 in my system?
Please Help me.
Thanks in Advance,
T.Rameshkumar
|
|
|
|
|
P.T.R.K wrote: I installed sql server management studio 2005 in my windows 2003 OS system,at yesterday(08-Dec-2006).But today(09-Dec-2006),it is not worked.what is the reason for not working sql server management studio 2005 in my system?
You need to supply more information. Did you change anything between yesterday and today?
|
|
|
|
|
I have a database and a form. When I load the form, the database will get converted into an XML file and will get displayed in my form. If I change some values in the xml which is displayed in my form, those changes should get reflected in my datagrid(which shows the contents of the database) and also in my database. So far, I can update the datagrid but not the database. How can I do this? Any kind of help would be sure appreciated.
rachael
|
|
|
|
|
hi rachael, im not sure but try this link.
All generalizations are wrong, including this one!
|
|
|
|
|
I tried this, but i is not updating the database. It is just getting appended to the already existing rows.
|
|
|
|
|
That's funny!! it is updating just fine with me!! please try again and make sure.
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
I tried it again, I don't know why the new data are just getting appended but not updating the database.
rachael
|
|
|
|
|
In the 12 years ive been developing software ive never been so stumped on one issue for so long...
I took over the design of the companies web application from my boss.
I tidied up 75% of the code and now have a pretty tidy way of doing things as follows...
each page inherits a page called 'basePage', this has all the necessary functions in it for data manipulation, such as...
<br />
GetConnection() as SqlConnection (returns it unopened but populated with the connection string)<br />
GetDataTable(sql as string) as DataTable<br />
ExecuteQuery(sql as string) as integer<br />
etc...<br />
Recently we started getting "Timeout Expired" errors "while obtaining a connection from the pool".
Ive tried various extremities of parameters in the connection string such as "min pool size=5;max pool size=1000;connect timeout=90;". and have read numerous articles on the subject.
I have also turned off connection pooling entirely and still receive the same error (differing only by not mentioning "the pool").
Before you ask - yes, i am using try catch blocks in my basepage functions and always closing and disposing my objects in the finally block.
Today i received no less than 840 timeout error reports on the server in one hour - there was only 46 people using the application at the most within that hour.
The timeouts seem to happen all at once for a few minutes, like a big bottleneck. The server itself was running fine - not even brushing 50% cpu usage. But the web application itself would slow down quite badly, taking up to a minute to serve the page.
I set up some tracing and noticed that some pages made no less than 60 calls per page load to the GetConnection() method 
This is due to various business objects being called and checking data etc...
Before i even suggest that any of the business model be redesigned, id like to ask.. has anyone ever come across this type of situation before?
are most of you spitting coffee on your monitor over the 60 page calls like i nearly did? 
or have you seen this before in big applications with many components?
Any help, comments or suggestions are welcomed.
Regards,
Guy
---Guy H (  ---
|
|
|
|
|
Guy Harwood wrote: I set up some tracing and noticed that some pages made no less than 60 calls per page load to the GetConnection() method
Is the code closing the connection before getting another?
Guy Harwood wrote: are most of you spitting coffee on your monitor over the 60 page calls like i nearly did?
You might want to see if you can rationalise some of these calls. For example, if you alwasy call the same three stored procedures in sucession then you might be able to create a wrapper stored procedure that calls the other three so you can only doing one call to the database. You can then iterate over the result sets and pull out multiple sets of data from one database call. (If you are using DataReaders the NextResult() method is the one that moves to the next result set)
The thing that causes the most slow down in an application is roundtrips to the database. If you can reduce the number of roundtrips it would improve performance, and reduce the number of connections you are making.
I'll also admit that I've never had to alter the timeout of the connection from the 15 second default.
By the way, what edition of SQL Server are you using?
|
|
|
|
|
Hi Colin,
Yes the code always closes the connection before getting another.
Ive used the nextresult() stuff before, very handy and will come in useful when i end up knocking down those 60 calls per page load!
We are using SQL Server 2000 with SP4 on 2003 server.
The server has 3GB ram and 2 Xeon 2.4GHZ processors (effectively 4 cpus according to sql server).
I did notice something odd in the event viewer application log earlier that was entered right about the time the errors started pouring in...
Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
wasnt doing any maintenance and never seen it before.
---Guy H ( ---
|
|
|
|
|
Guy Harwood wrote: Error: 15457,
If you Google “SQL Server 15457” there are quite a number of hits, would seem error code 15457 is an informational error code, but most of the people posing questions about this error code have the same issues you’re experiencing. Most of the issues seem to be related to the db getting locked or query time out values changed. Might want to take a look.
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20684322.html[^]
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
For some stupid reason i never looked this up 
seems a restart solved the problem. gonna look into it more and see what i find.
thanks everyone 
---Guy H ( ---
|
|
|
|
|
Guy Harwood wrote: seems a restart solved the problem.
 Hope it works out for yea.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Hi 2 all,
Is there enyone who have explanation
about this error
Server: Msg 8624, Level 16, State 21, Line 52
Internal SQL Server error.
|
|
|
|
|
alexrad wrote: Is there enyone who have explanation
about this error
Would you care to tell us what you were doing at the time?
|
|
|
|
|
Google[^]
"My advice to you is to get married. If you find a good wife, you will be happy; if not, you will become a philosopher." Socrates
|
|
|
|
|
Need support....
I d'like to copy a file aspnetdb.mdf (ms sql 2005 db) created with microsoft visual web developer 2005 to my websites host. I have already a website copied with asp 2.0 sites to my host without problems.
But now it is the first time that i try to copy a ms sql 2005 db. The aspnetdb.mdf works fine on my local PC. Now the provider told me, that i have to create a db Login in his Control Panel for accessing sql 2005 server.
I have to define a Login user name and a password. And later a sql 2005 db.
My Problem: Why should i create an new sql 2005 db on the host server. I d'like to transfer my local sql 2005 db (microsoft visual web developer 2005) to the host?
What changes are necessary in the web.config:
The definition on my local pc:
<connectionStrings>
<add name="ASPNETDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Do I have to add a user id and a password?
What connection string is necessary to access to my host sql server?
Do you know some recommended tutorials? I could not see a solution in the following video:
http://www.asp.net/learn/videos/view.aspx?tabid=63&id=5
Thanks a lot for your support.
You see -- I am a beginner....
Best regards
ullk
|
|
|
|
|
ullk wrote: My Problem: Why should i create an new sql 2005 db on the host server. I d'like to transfer my local sql 2005 db (microsoft visual web developer 2005) to the host?
Becuase the log in information is held in the master database. That has to map to the users set up in the individual database. If the internal user ids don't match between your database and the master database then when you log in it won't know what set of permissions to use on the database.
ullk wrote: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True
I'd imagine that your ISP has a full SQL Server set up. In which case you will be connecting to a database that is defined in the server rather than a file that it attaches to the server when called. You'll have to change your connection string to reflect that - You'll need to speak to your ISP for the details for the Data Source and Database elements of the connection string. And you'll drop the AttachDbFilename part. (most likely)
ullk wrote: Do I have to add a user id and a password?
Only your ISP can answer that. It depends how they've set up their SQL Server. The login that you create in your ISP's control panel may be a SQL Log in, or it may be one you can use for a trusted connection. I'd imagine that it would be the SQL Login though - it would be easier for your ISP to manage.
|
|
|
|
|
Right now I have a program that queries a database and saves the data into a a strongly typed dataset
Then I perform various calculations on each record and fill in 5 null fields with data
Lastly, I click upload and it does a for loop, for each data row and calls the update method to update the database with the calculated values.
This works all fine and dandy, except the upload part is rather slow.
it looks something like
DataAdapter.StoredProcedureUpdate(Primary key, NewValue1, NewValue2, NewValue3, NewValue4, NewValue5)
I'm guessing that the upload part is slow because its repeating a process where 3/4 of the work done is not the update function
1. creating the connection
2. connecting and authnicating
3. calling the update procedure
4. closing the connection
I'm still somewhat new to ADO.NET so I'm not quite sure if its actually doing this.
Does anyone have some good suggestions on a better method?
Perhaps a way to call a bulk update through ADO.net or SQL?
|
|
|
|
|
Guys , This is a popular Interview question,
i would like to know the various queries that can be written to achieve this.
Table: Employee
Columns: Name, Salary
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
