I have a databses wit specific collation, I want to change collation to another collation name.
How can I achive that ?
Thanks,
in insert statement how do i append a carriage return to a field. (at the end)
Hi Experts,
I have old window 2000 advanced server with SQL 2000 Server. I want to move SQL database to new window 2003 server and new SQL 2000 Server. What is the effect can be occur when ...
PROBLEM: Receive error message:
Server: Msg 105, Level 15, State 1, Line 128
Unclosed quotation mark before the character string 'Un
into NewTable FROM (select tbl_ecom_productdescriptor...
Hi all,
i have a rather urgent problem with gathering statistics from a sql server table.
I would need to gather the median and the interquartile range for the records in the table that f...
HI,
At present my SQL Server table has the following field as the Primary Key: mst_rec_nm
I would like a SQL script to re-assign the Primary Key to this field: rtns_prm_key
thanks a lot...
I am attempting to write an sql query to select the top 3 distinct scores from a table structured as follows:
ID Score User
1 10 5
2 ...
I have a client who has installed my software on a 64-bit box, making database connection to a 64-bit Ms SqlServer 2005.
My software's default connection string is like:
DSN=mySystemD...
Hi
After database is restored, is it nesscary to update statistics on all table and reorg rebuild all table again?
As I have experienced that there is very poor performance after the DB i...
My customer is running SQL svr on Winxp machine. All was working fine until today. For some reason, when he was surfing the internet his computer just shut itself down. He rebooted and ever...
Tried to deploy report to page on website and got the following error.
TITLE: Microsoft Semantic Model Designer
------------------------------
A connection could not be made to the ...
Hello All,
I need to connect to a Sybase ASE 12.5.3 ESD2 Database in order to read data from a couple of tables. No one here is accessing these databases from .Net so I need some help. I tr...
Hi,
I've got the need to select everything from table1 and only 1 row from table2. Table2 can hold any number of rows from 0 to 10,000
I've tried the following with no joy. Any ideas?
...
I am sure there is a simple fix for this but I can't find it. I can make a connection to mysql using mysql -u root -p without a problem and I can use mysql -h local -u root without a problem,...
Hi,
I created a view... and I want the view to give me "Today's Date" if a certain date field is blank...
But I'm not sure how to tell the view to give me today's date.
WHEN dtApproved ...
Hi Experts,
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\exceltest.xlsx" +
@";Extended Properties=""Excel 8.0;HDR=YES""";
Doesn't open office 2007 x...
Hello,
I have a table which contains more than 200,000 records. Out of this i wish to conditional delete some records, the quantum of this records is around 70,000.
Once the records are ...
Platform:
W2K SP3
Oracle 8.16
9iAS 1.0.2.2.2a (Apache web server in https, forms / reports server 6i)
Problem:
I keep getting that error listed above, which says: Your connection to...
I have a mysql database and have a datetime type column called mydt
How can I check the current date is larger then the mydatetime??
How can I get the current datetime??
e.g.
Today dat...
Hi,
What is the easiest way to read and manipulate an HSQL database directly? Is there a tool I could use?
Thanks.
I am able to use the Relations link on my ERD diagram that I created in Visio and tell it one-to-many, etc., but how can I get the actual one-to-many and other symbols to show on the actual li...
Hi,
Following is the procedure I am talking abt.
It ran suceefully before 2 weeks.I wonder what happened?
******************PROCEDURE create_user2*************
CREATE OR REPLACE procedur...
I have three systems 1 Windows 2000 and the other 2 running Linux. The ORACLE server is a LINUX server 192.168.1.220 (MDLITTLE). The other Linux system is a client that boot from a CD that i...
We are using Oracle 8.17 and I am trying to load data into a oracle table. Data starts going into the table and then when a commit point reached -logical record count 13077. There should be ...
I have a webpage that is executing updates to a SQL 2000 database.
From time to time I get the following error message when executing the updates on tables:
& was deadlocked on lock res...
