|
|
I need to update a field so the values change from all upper case to title case. Can anyone please point me to a sql script example of how to do this. Thanks,
Jason W.
|
|
|
|
|
Hi,
U can use...............
UPDATE Customer
SET
C_Name = LOWER(C_Name)
I hope this will help u..........:->
Regards,
Ritesh
|
|
|
|
|
Thanks for the try, but that won't work. Lower gives the following results:
Select lower('TEST')<br />
---- <br />
test
The following would work if there was only one word:
Select upper(left('TEST',1)) + lower(substring('TEST', 2, len('TEST')))<br />
----- <br />
Test
Problem is when you have more then one word such as:
DECLARE @TEST as varchar(50)<br />
SET @TEST = 'TEST TEST TEST'<br />
Select upper(left(@TEST,1)) + lower(substring(@TEST, 2, len(@TEST)))<br />
--------------------------------------------------- <br />
Test test test
The results I want are
---------------------------------------------------
Test Test Test
Any idea on how to output this format?
Thanks again.
Jason W.
|
|
|
|
|
Hi,
In that case u have to write ur own logic...........
Here is my idea.............
1>Loop through ur string and separate our the substring till u get Space.
2>Then apply ur logic which u shown for this word and append it with @Result.
3>COntinue with ur loop till u get Next substring(word) use step 2 and append it to the @Result with Space
4>Continue till the length of Entire String......................
u might be having better logic...................:->
Regards,
Ritesh
|
|
|
|
|
Hello!
Is it posible to export DataGrid (not DataSet!) to Excel? If it is, how?
I can't find any exapamle on net...
|
|
|
|
|
Well I mean I can't find any example for Win DataGrid. So is it posible to export
data from Win DataGrid to excel?
|
|
|
|
|
Hi, Is there any way of getting table & field name from an SQL database
Need to extract field& table name from VB
|
|
|
|
|
Hi,
U can get the Name of all the Tables in ur current DB using
SELECT name,xtype FROM sysobjects WHERE xtype = 'U' AND name 'dtproperties'
And u can get the list of all the Columns with there Table name using
SELECT so.name TableName,sc.name ColumnName FROM syscolumns sc
INNER JOIN sysobjects so on sc.id = so.id
WHERE so.xtype = 'U' AND so.name <> 'dtproperties'
Hope this will help u.....................:->
Regards,
Ritesh
|
|
|
|
|
You can also get a wealth of information using the OleDbConnection 's GetOleDbSchemaTable method.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
Hi, my computer have sql server and install service pack 3. I also have vb.net. Now I want to uninstall sql server service pack 3 and install sql server service pack 3a. Because I want to install sql server reporting services. But I don't is it possible to uninstall sql server 2000 service pack 3. Does any one know is it possible or not??? If it is possible, how could I do that?
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
|
I can install sp3a over sp3 without any indication. But when I try to install SQL server reporting service it still let me know that I don't have sp3a. I don't know how to solve that problem... I don't know how to fix it...
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
http://www.microsoft.com/sql/downloads/2000/sp3.asp[^]:
"If you have applied SP3, you do not need to apply SP3a. SP3a is only for SQL Server users who have not applied any versions of SP3. However, you should use SP3a rather than SP3 moving forward."
Specific differences: SP3a can be applied to trial versions of SQL Server, it includes MDAC 2.71a (security and installation fixes to MDAC 2.71), and it disables UDP port 1434, the service attacked by Slammer, when networking is disabled.
If you've not already done so, you should apply MS03-031[^] to bring your server up to version 8.00.818, then apply the hotfix in KB 826161[^] to your client tools so you can modify the properties of a SQL Server login without having to set the login's password.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
hi all,
i have created one validation form,loginname and pass have to check fromthe new user table that i had already created.i was trying to write code but could not complete. can u all please help/guide me to write the code.
|
|
|
|
|
|
Oh help...
I'm experienced in programming but new to .NET, and am having a problem updating bound data that feeds the drop-down items in a combo box. I'm using a data adapter to feed an INSERT statement to a table using the connection directly (I don't use a DataTable). I use ExecuteNonQuery to update the table and it works fine. However, as the bound control works from another data adapter, the new item doesn't show in the drop-down. I created a small project and found that if I called Adapter.Fill() after executing the insert, it would show up. However, that adapter was hooked up to a dataset. Do I have to completely rejigger my code, or is there some way to force a refresh of the data? I tried a CurrencyManager but got nowhere.
Thanks for any help.
Jim Stanley
Media Services, Inc.
|
|
|
|
|
hi
this doesn't work
what should i do????
public void GetData( )
{
SqlConnection sqlConnection;
SqlCommand sqlCommand;
sqlConnection = new SqlConnection ( ConfigurationSettings.AppSettings["DataBaseConnection"] );
sqlConnection.Open();
sqlCommand = new SqlCommand ( "storedProcedure_2" , sqlConnection );
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while ( sqlDataReader.Read() )
{
do somethings...
SqlCommand sqlCommand_2 ;
sqlCommand_2 = new SqlCommand ( "storedProcedure_2" , sqlConnection );
sqlCommand_2.CommandType = CommandType.StoredProcedure;
SqlDataReader sqlDataReader_2 = sqlCommand_2.ExecuteReader();
while ( sqlDataReader_2.Read() )
{
do somethings...
}
sqlDataReader_2.Close();
}
sqlDataReader.Close();
sqlConnection.Close();
}
|
|
|
|
|
hi
i have a problem.
this code doesn't work why? and what should i do plz?????
public void GetData( )
{
SqlConnection sqlConnection;
SqlCommand sqlCommand;
sqlConnection = new SqlConnection ( ConfigurationSettings.AppSettings["DataBaseConnection"] );
sqlConnection.Open();
sqlCommand = new SqlCommand ( "storedProcedure_2" , sqlConnection );
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while ( sqlDataReader.Read() )
{
do somethings...
SqlCommand sqlCommand_2 ;
sqlCommand_2 = new SqlCommand ( "storedProcedure_2" , sqlConnection );
sqlCommand_2.CommandType = CommandType.StoredProcedure;
SqlDataReader sqlDataReader_2 = sqlCommand_2.ExecuteReader();
while ( sqlDataReader_2.Read() )
{
do somethings...
}
sqlDataReader_2.Close();
}
sqlDataReader.Close();
sqlConnection.Close();
}
|
|
|
|
|
|
Hi
Its getting pathetic and I dunno why !!
I am trying to read/insert/update an excel sheet using ADO .NET. I am using
following connection string to connect to the data source.
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\inetpub\wwwroot\App\files\file.xls;Extended Properties='Excel
8.0;HDR=YES;MAXSCANROWS =1'
The development machine contains Microsoft Office and everything upto date
and the application is working fine.
On server I am getting following exception since last One Month!!
---------------------------------------------------------------------
Could not find installable ISAM.Microsoft JET Database Engine at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvider() at
System.Data.OleDb.OleDbConnection.Open() at
MyPledge.ViewClientPaymentData.LoadData() in
C:\Inetpub\wwwroot\MyApp\ViewClient.aspx.vb:line 58
---------------------------------------------------------------------
I have asked the server admin to do following ...
- Give Rights to Read/Write to ASP NET process on directories containing
excel files
- Update Jet Drivers from following URI,
http://www.microsoft.com/downloads/details.aspx?FamilyID=1E268B39-533E-48B0-B8D7-1781BEFDE1F8&displaylang=en
But I am still getting this message...
CAN anyone, PLEASE PLEASE help me??? I am one of the big .NET lovers but
this thing is REALLY REALLY REALLY making me start to hate it .. :S :S :S...
eff_kay
-------------------
Therez No Place like ... 127.0.0.1
|
|
|
|
|
First and foremost, make sure the version of ADO is at least as high as your development box. The Jet drivers may not help if the ADO layer is not in synch.
find it here.[^]
second, I think the Extended Properties section should be in double quotes rather than single:
Extended Properties="Excel 8.0;HDR=YES;MAXSCANROWS =1";
You will need to escape the quotes or use an @ style literal string.
HDR=YES is the default, so you could ommit it. MAXSCANROWS =1 only considers the 1st row when determining column data types. I think the default is 8, so this part could also be ommitted, performance hit is negligible, and you appear to beleive the data types will be consistent. I have seen both of these be problematic with different versions of ADO.
The ISAM error usually seems to mean that the current version of ADO/jet did not like the connection string, so experimenting with the Extended properties to try the minimal specification (Just "EXCEL 8.0") should be worthwhile.
Why would anyone waste time arguing with an accountant about anything? Their sole function is to record what happenned, and any higher aspirations are mere delusions of grandeur. On the ladder of productive contributions they are the little rubber pads at the bottom that keep the thing from sliding out from under you. - Roger Wright
|
|
|
|
|
Thank u very much for the help.
it helped and now things are running good.
eff_kay
-------------------
Therez No Place like ... 127.0.0.1
|
|
|
|
|
Good day SQL experts and seniors,
I have a SQL job which is scheduled to run everytime when SQL agent starts.
The job will invoke a stored procedure. This stored procedure will run
continuously using "While Loop" by referring to a flag stored inside a SQL
table. If the flag is set to "OFF", the stored procedure will stop.
Problem arises when CPU usage is high whereby the job will be terminated
unexpectedly with an error message "Executed as user: SERVER_NT_P1\SysAdmin.
ConnectionRead (recv()). [SQLSTATE 01000] (Message 10054) General network
error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The
step failed". The MSSQL is already installed with service pack 3 and in
normal condition the job can continue executing for days.
What is the root cause of this issue? Inside my code, there is no any SQL
statement which is called across database server (only got statement to grab
record from other database resided in the same server). Anything I can do to
avoid this error from occuring?
Below are the stored procedure called by my SQL job:
------------------------------------------------------------------------------
CREATE Procedure Proc_RE_On_Off_Process<br />
As<br />
<br />
declare @execution_status varchar(5)<br />
declare @delay_time varchar(10)<br />
<br />
select @execution_status = RE_On_Off_Flag from SPC_RE_On_Off_Process<br />
<br />
if @execution_status <> 'ON'<br />
begin<br />
insert into SPC_RE_On_Off_Log <br />
values (getdate(), 'RE process is not started')<br />
end<br />
else<br />
begin<br />
insert into SPC_RE_On_Off_Log<br />
values (getdate(), 'RE process is started')<br />
end<br />
<br />
while @execution_status = 'ON'<br />
begin<br />
exec Proc_Run_RE_Jobs<br />
<br />
if @@Error <> 0<br />
begin<br />
insert into SPC_RE_On_Off_Log<br />
values (getdate(), 'Process stopped due to error: ' + cast(@@Error as <br />
varchar(20)))<br />
break <br />
end<br />
else<br />
begin<br />
select @execution_status = RE_On_Off_Flag, @delay_time = RE_Delay_Time <br />
from SPC_RE_On_Off_Process<br />
if @execution_status <> 'ON'<br />
begin<br />
insert into SPC_RE_On_Off_Log <br />
values (getdate(), 'RE process is terminated')<br />
break<br />
end<br />
else<br />
begin<br />
waitfor delay @delay_time<br />
end<br />
end <br />
end
------------------------------------------------------------------------------
Any idea would be greatly appreciated. Thanks
SayHigh Soon
|
|
|
|
|
In the SQL Server Database Wizard I put local and trusted connection.After I press Next I got the error
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection Failed:
SQLState:'08001'
SQL Server:17
about connection string I dont know for sure where to control about it because Im a new user.Sorry for the disconvenience and please help me with some further instructions
|
|
|
|