debasisdas

Hi Abner, Nice intro. :) Welcome to Daniweb.

Are you trying to create a report out of this query ?

To implement indexes for getting performance is always an option. But to go for that one needs to have complete knowledge of the database design and the flow of data (how application hits the DB).

Welcome back.

May be your connection string is stored with wrong credentials. Find more on [URL="http://www.connectionstrings.com/sql-server-2008"]connection strings[/URL].

try the following , may work for you. [CODE]DELETE ServiceID FROM tblServices where serviceid in (select ServiceID FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG')[/CODE]

Try this. [CODE]SELECT TABLE_NAME,NUM_ROWS FROM USER_TABLES[/CODE]

what exactly is last row ? When you store records in database , it is not necessary that the last entered row will be always stored at the bottom of the table.

Hay Soma, Welcome to Daniweb.

Hi Davy, Welcome to Daniweb.

i think your column name is [B]post_type[/B] not [B]post-type[/B].

you need not write any code for that. the device reads the code and the value is populated on any control that has focus, that may be any editable control in any application or simply a notepad.

That is good if coach is not a member.

[QUOTE=loving3232;1543720]use them to make a new data [/QUOTE] What exactly you are trying to do ? are you trying to implement some encryption algorithm ?

ensure that the remote host is up and running.

Yes you need to use Dynamic SQL. Try [URL="http://www.java2s.com/Code/SQL/Procedure-Function/EXECUTEdynamicSQLcommand.htm"]this sample[/URL] or [URL="http://lists.mysql.com/mysql/207796"]this[/URL].

you need to look into [B]user_constraints[/B]

That thread is split from a 7 years old thread.

Let me tell you databases are not created at run time, for what ever reason.

Yes coach and member should be related through sport not directly.

because that is not practical for a technical forum where most of the people post code.

do you have the required drivers installed on your system ?

Hi jerodev, Welcome to Daniweb.

yes you need to create the commands using a script. to conform, this can't be done in a single line command.

try using IS NULL read more [URL="http://msdn.microsoft.com/en-us/library/ms181765.aspx"]here[/URL].

Please check your [URL="http://www.connectionstrings.com/"]connection string[/URL].

use this [CODE]SELECT column_name FROM cols@SrcDatabase WHERE Table_name = UPPER('Emp'); or select column_name from user_tab_cols@SrcDatabase WHERE Table_name = UPPER('Emp');[/CODE]

what happens when you comment this line [CODE]sd.InitialDirectory = "C:\"[/CODE] and then try to create the file by browsing the file dialog ?

try this [CODE]$sql = "SELECT 'name','owner' FROM table WHERE 'verified'='1' AND (name LIKE '$%term%' OR 'owner' LIKE '%$term%')";[/CODE]

Welcome to daniweb.

Welcome to Daniweb.

as already explained in the previous post you are using [B]total[/B] as an alias for [B]SUM(exam_fee)[/B] but trying to fetch [B]exam_fee[/B] not [B]total[/B].

post your code here, i will fix it.

You are asking about database login ? A single login will do.

do you have any code that you are working on ?

[QUOTE=djansyle;1545925]send multiple screenshot images from my client to server.. [/QUOTE] what client, which server... mail server, application server, database server ....what ? [QUOTE=djansyle;1545925] any code will help... [/QUOTE] lets see the code that you are working on

[URL="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97917"]This[/URL] discussion may be useful to you.

There is no rule of thumb to follow to optimize a query. and what you are trying to do is not optimization, but removing some requirements.

Lets see what is the code that you are working on to get the desired output.

You need to store the payment details in a single table with a payment type flag that specifies what type of payment that was.

If you have two separate databases what is the problem ?

you need to create trigger on each of the events on the base tables.

I can't see the block of the code that you are referring to in the code that you have posted here.

Any specific reason, why your queries are rejected ?

Are you getting any error message ?

what is the underlying database ? What is the query that you are using ?

[QUOTE=vb6lover;1541429]i need your help [/QUOTE] we help those who help them selves. [QUOTE=vb6lover;1541429] to make a webbrowser work automaticly[/QUOTE] nothing works automatically, you have to make it do that by writing some code. BTW- What is the code that you are working on ?

Hi Rik, Nice Intro. Welcome to daniweb.

In this case important question is what are going to do with all those data .

Glad to learn that being an arts graduate you have hands on experience in Programming language. Your posts shows you have spend some time on programming. Even though there are few companies who are still working on VB, you need to accept that it is an outdated technology. Believe me, …