|
|
|
|
Viewing 0 - 20 out of 12 Articles |
qna | SQL
- Count Function
Hello,
I am a beginner SQL learner. I not sure where to add a count statement in a existing SQL code. The code is below. So I can understand how to do this.
Thank You.
SELECT
sg.StoreCode,
......
Posted in: SQL | By: rekha singh | Date: 31 Aug 2010 5:20 pm | Comments (5)- Need Help for Sql query
Hi All,
I have a table with a field say username which is a char field (to
accomadate values like 1, 11nml, 3 and also abc12, xyz456 etc.). Since
username is a char field I get the output like
......
Posted in: SQL | By: rekha singh | Date: 31 Aug 2010 4:31 pm | Comments (4)- How to find Top Sql through Queries
If someone ask for top sql they from enterprise manager can find some expensive queries. But the result may vary based on the metrics or criteria of expensive. Measurement may vary on,
a) L......
Posted in: SQL | By: rekha singh | Date: 02 Aug 2010 12:32 pm | Comments (0)- Database Monitoring Application
Dear all member,
I wanted to ask about the good application of monitoring database that is compatible with Oracle, SQL Server 2000.2005 and 2008. Because the database in my company consists o......
Posted in: SQL | By: rekha singh | Date: 18 Jun 2010 5:02 pm | Comments (0)- SQL Server Express 2005 disappear triggers ??
I'm supporting a SQL Server Express 2005 database that is actually house on a rather stout server platform though not sure why in this case it would matter. On several tables in the pr......
Posted in: SQL | By: rekha singh | Date: 20 May 2010 12:54 pm | Comments (0)- An interesting JOIN and pairing problem
Have a file with recs like ...
1,house, chicago
2,apt, detroit
3,house, miami
4,house, boston
5,apt, boston
6,house, houston
7,apt, dallas
8,house, detroit
9,house, boston
10,apt, de......
Posted in: SQL | By: rekha singh | Date: 18 May 2010 2:14 pm | Comments (0)- Converting to Date Time
I have a table with three columns Month (values JAN,FEB,MAR, APR) etc
Monthno (values 1-12)
Year 2009,2010, etc
How do I take the above fields and create a date that represents the fir......
Posted in: SQL | By: rekha singh | Date: 12 May 2010 11:15 am | Comments (3)- Excel to SQL server DB
Hi
I want to exprot the data from excel sheet to database table ....
and i have this code which does it but its giving error
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
G......
Posted in: SQL | By: rekha singh | Date: 10 May 2010 5:57 pm | Comments (8)- Error Uploading Excel to Database form Vb.net
Hi
I am uploading the Excel sheet to Database through Vb.net .. and I have Written Stored Procedure in SQL Server and i have written it with te help of this link
http://www.aspsnip......
Posted in: SQL | By: rekha singh | Date: 10 May 2010 5:49 pm | Comments (1)- MS SQL Server 2005 full-text indexing
Instead of buying Visual Developer Studio 2005 and SQL Server, I made my database-driven website using the free versions: Visual Web Developer Express and SQL Server Express. However, I still wanted t......
Posted in: SQL | By: rekha singh | Date: 08 May 2010 6:05 pm | Comments (0)- Fastest way to search data from table ..
Hi All
I have a table where it has 45000 Rows of data and a Column Named Description will be used to search
Just if user enters the Text like this *"Bailed out With"*&......
Posted in: SQL | By: rekha singh | Date: 08 May 2010 5:16 pm | Comments (7)- How to find out why mysql using large amount of cpu
Can someone help me find out why mysql is using large amount of cpu.
What info do you need? Here's what I know to give....
If I go to cpanel and "show current CPU usage"
&......
Posted in: SQL | By: rekha singh | Date: 07 May 2010 5:38 pm | Comments (0)
1
|
|
