Software Applications Programming Errors and solutions.

How to use insert into table by using select query in sql. You can insert recordset at a once by using select query this way. INSERT INTO @Tablename(Col1, Col2)     SELECT Col1, col2     FROM table2 This will select records from table2 and will insert in table1.

Macro That Automatica​lly Updates Data Itself In Excel If you need to have a database that automatically updates itself.  In fact, if you have a folder with different excel files, say folder Y (all the same form/template), and the first X cells of these files need to be extracted to another excel workbook (file Z). Every file represents 1 row in workbook  Z. But this should be done automatically. So if I copy a new excel file in folder Y, the first X of this new excel file should automatically (can be with a ‘button demand’)  be copied into workbook Y. Option Explicit Const cstFolder = "C:\Users\ATC0155\Documents\Toolbox\Excel\1208 20 selfupdate" Const cstCols = 5 Sub DoUpdate() Dim wks As Worksheet Dim strFile As String Dim appExcel As Excel.Application Dim lngRow As Long ' Prepare the sheet to receive the data Set wks = Sheet1 wks.Cells.ClearContents ' Run through each file in the folder strFile = Dir(cstFolder &

namespace Akadia.BasicDelegate { // Declaration public delegate void SimpleDelegate(); class TestDelegate { public static void MyFunc() { Console.WriteLine("I was called by delegate ..."); } public static void Main() { // Instantiation SimpleDelegate simpleDelegate = new SimpleDelegate(MyFunc); // Invocation simpleDelegate(); it's the object of delegate. } } } objectname.Eventname += new objectname.delegatename(functionname()); in this we are calling events by creating an object of that particular class providing events but when we attaching delegates we are not using the object name or we cannot use object name, instead we are using class name of that particular delegate provided . Delegate is neither meant to do any action nor to persist a value. so there is no need to access the delegate by an object. And we can even declare the delegate outside of the class. There is no significant in declaring the dele

Following is example of using group by clause in select query using axapta. Group by clause will display data as per mentioned fields after group by clause. SELECT D.DNO ,D.DNAME ,D.DLOCATION , Max(E.salary) FROM Emp E, Dept D                                                       where E.Dno = D.Dno                                                      Group by E.Dno, D.Dno, D.DNAME ,D.DLOCATION ; when you use group by clause then you will get distinct records which used with group by clause. You can use group by when you use any aggregate function in query but if you use distinct in query then you can get distinct of records. I hope now you are clear with concept of group by clause in ax. You can comment if you want to know anything additional.

 If there are two table A,B in which three column a,b,c are common. I have to find rest of record in A which are not in B. select * from table1 minus select * from table2 You can see some examples in link below Queries in Oracle You can get sql tutorial here SQL select Examples

Concept of etworks Consist of two or more computer connected to each other. Share resources (such as disks, files,directories, printers, CD-ROMs etc.) Exchange files, data and allow electronic communication between them. Types of Networks Local Area Network (LAN) Metropolitan Area Network (MAN) Wide Area Network (WAN) Local Area Network Confined to a relatively small area. Generally limited to a geographical area such as a school, building or an office. Rarely are LAN computers more than a mile apart. Metropolitan Area Network (MAN) Covers larger geographical areas, such as cities. Wide Area Network Connects larger geographical areas, such as the whole of India or the world. Dedicated transoceanic cabling or satellite communication may be used to connect this type of network. Peer-to-peer operations Peer-to-peer operations All computers are considered equal. Designed primarily for small to medium local area networks. Advantages Less initial expense

#include #include // The main() function. int main() { std::cout << "Compute a random number? (y/n) "; char ans; s td::cin >> ans; if (ans == 'n') goto done; else { int ran = std::rand(); std::cout << ran; } done: return 0; }