For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
Schema is the actual structure of the database described in such a form that understandable to humans...
A schema will contain definitions for tables, views, indexes, relations, procedures, functions and every other aspects can be accesses in the db...There is a possibility that for the same database there are several schemas, divided by access rights...So a schema is not equal the database but more a way one can see the database with the proper access rights...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
I'm new to mysql .. I need a One to many ralation tutorial.. like for example I made a table called MovieList with 1 column name TitleMovie and now I want to create another table called acc1_MyWatchlist and inside of it was also a TitleMovie..my question is I want insert a value in acc1_mywatchlist but only the available values in Movielist's TitleMovie and If I tried to create another table acc2_mywaychlist it should be the same as the first table and if I tried to edit some values in the MovieList table it should be affect all the table that has the same column TitleMovie....
in Access database I just use the lookup wizard but ofcourse mysql is differnt so can you give me some examples of this query..
I don't think you understand normalisation and references.
It sounds like your first table should have and ID of some type as well as the title. Other tables would then refer to that ID, not to the title. If you need to alter the title, the IDs stay the same and no other tables need to be updated.
The statement selects all the records from table TAKE_COURSE, but filters them by the WHERE clause. Saying WHERE NOT EXISTS at the start, filters out those records where the StudentIDs match but the student score is less than 60. So you should end up with all students who have a score of 60 or greater.
Dear sir i have installed sqlserver 2008 r2 sp2 & vs.net 2010 I make a project in ado.net to add data in sql database with no error. the program runs well but when i go to the add button it says that "Login failed for this user" plzzzzzzzzzz help.....
Suppose there are two computers (Ser1, Ser2) and SQL Server 2005 Express is installed on each machine, the input will be stored on the machine Ser1, if the data changes on the computer Ser1 will be updated again computer Ser2, the ask my SQL Server 2005 express can update data on the computer Ser2 from Ser1 ? How the computer config ?
Suppose there are two computers (Ser1, Ser2) and SQL Server 2005 Express is installed on each machine, the input will be saved to Ser1 or Ser2, meaning that if the computer Ser1 busy, it will save computer Ser2 or else, and 2 machine Ser this is always synchronized data.
if I understand this issue I find the document what ? or what keywords to search on google.com?
And english is not your first language, I understand that. However the results of the search I supplied will give you more information and better resources than a forum post. Your requirement is not trivial small.
Never underestimate the power of human stupidity
SQL Server 2005 Express cann't create Replication\Local subcriptions ? because sql warning: Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.
I would not expect replication to be available in an Express version as it is one of the advanced features of the database but I don't know as I use neither the Express nor do I need the replication features.
Never underestimate the power of human stupidity
I configure SQL Server Merge Replication, when merger database together, if one of the two server machines damaged or die, the software did not transfer it, i have to manually reset ip to the software to run, how to automatically switch to 1 in 2 server fails ?
It's tricky to answer without your table definitions and some sample data, but this should get you close:
WITH cteAccountTree As
@AccountID As Account_ID
cteAccountTree As P
INNERJOIN AccountTree As C
ON C.Account_ParentID = P.Account_ID
Account_Isleaf = 0
@TotalValue = IsNull(Sum(JournalDet_Debit), 0) * CASEWHEN @Currency = 0THEN AccountBranch_CurrencyConv ELSE1ENDFROM
cteAccountTree As T
INNERJOIN Account_InBranch As B ON B.AccountBranch_AccountID = T.Account_ID
LEFTJOIN Journal_Details As JD ON JD.JournalDet_AccountID = T.Account_ID
LEFTJOIN Journal_Head As JH ON JH.Journal_ID = JD.JournalDet_HeadID
Journal_BranchID = @Branch
Journal_Date Between @DateFrom And @DateTo
Thank very much for help. I'm trying to learn about recursive expression table however I cannot know how its really work The Where clause you mentioned at the end of your post to be able to get the parent account and its child(s) too and that what I forgot to mention in the post because I did not know it at the time when I wrote the post what I need to get is the parent account and its child(s) account(s) and if those child(s) account(s) is/are a parent(s) for another child(s) account(s) I got them too it seems stupid but this function is used within a procedure to get the balance of the account chart within the system.
Finally, I'm thanking you too much. could you help sending me a link to an explanation of the recursive CTE and how it is implemented
Appreciating your help. Thanks very much I will review the function again as I'm not the one who wrote it however I'm trying to optimize a Stored Procedure performance which selects from a lot of tables + calling this function. the last time I executed the procedure it nearly took over 14 minutes without a single result while it was still executing :(
hi - How can you tell if a SQL Server instance max'ed out bottleneck is Memory? It's on a 8GB box with two processors. Seems CPU ok. Memory max out the whole time while this big SELECT-INTO statement is running. Avg Disk Queue lenght ok - avg below 1.0 so doesn't appear disk/paging is causing problem.
However, fact from Task Manager memory keeps 7 GB out of 8GB over the whole time doesn't mean memory is the bottleneck? Or is it?
The same query runs on another SQL server with double the RAM finishes a few times quicker however.
I want to send Email to Many Users from One Email Address. I did configured the Database Mail. After Scheduled this Job, It is sending Emails to some users and failing to some users. Following are the Error Message am getting from the Log.
1)The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-12-08T16:01:56).
Exception Message: Cannot send mails to mail server. (The operation has timed out.).
2)The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-12-08T16:02:05).
Exception Message: Cannot send mails to mail server. (Failure sending mail.).
I am getting this Time Out Message even after Updating the Time Out to 60 Sec
If this code works then you are presumably using SQL CE or similar, which is on the local machine. That is fine as far as it goes, but if you wish to share the database with other clients then you will need SQL server.
Just got it to work, create database, tables, records
make the con strings for that.
Better than the oleDB DBF I was going to use, which took 20 sec to write 49 records.
Finished the switch to localDB this morning.
I have never heard of localDB, but it seems handy for vb.net windows apps.
I have a .sql file. the file size is 401MB. i found that a table say 'pauseddetailes' which stores the values and more than 1,00,000 records which has to be archived periodically but it is not. Due to this i couldn't import the file in MySQL , phpMyadmin. i need to truncate the table 'pauseddetails' and then import the rest of the data in the db. This particular table is independent and doesn't have any foreign key constraint.
I tried increasing the value of the upload size , execution time and memory size in php.ini file still didn't work out.
Is there any possible way. Looking for the solution.