Ques:- How do u connect ado.net to sql server
Asked In :-
Razorpay-Startup, scandid, Zyoin Web Pvt., Waffor, Nippon Data Systems, Skill Mine Technologies, FIN Infocom, SSA, ZoomRx, ColorTokens,
Ques:- List out the differences between Union, Interact and Minus operators?
Asked In :-
Dhruvsoft Services, Advanced Business & Healthcare Solutions India, Unistring Tech Solutions, Twilio, HIL, iNube Software Solutions, Motilal Oswal Securities, Kloudrac, Concerto Software, 8KMiles Software Services,
Right Answer:
- **Union**: Combines the results of two queries and removes duplicates. It returns all unique rows from both queries.
- **Intersect**: Returns only the rows that are common to both queries. It shows the intersection of the two result sets.
- **Minus**: Returns the rows from the first query that are not present in the second query. It shows the difference between the two result sets.
- **Union**: Combines the results of two queries and removes duplicates. It returns all unique rows from both queries.
- **Intersect**: Returns only the rows that are common to both queries. It shows the intersection of the two result sets.
- **Minus**: Returns the rows from the first query that are not present in the second query. It shows the difference between the two result sets.
Ques:- What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
Asked In :-
TNQ Technologies, Novalnet e-Solutions, XBRL Ultima, Anand Rathi, Indium Software, Envision Financial Systems India, Samsung R&D Institute India, Cavisson Systems, 3clogic, Smart Soc Solutions,
Right Answer:
The plus (+) operator in SQL Server 2005 can function as:
1. Arithmetic addition for numeric values.
2. String concatenation for character strings.
3. A way to indicate outer joins in certain join syntax (though this usage is deprecated).
The plus (+) operator in SQL Server 2005 can function as:
1. Arithmetic addition for numeric values.
2. String concatenation for character strings.
3. A way to indicate outer joins in certain join syntax (though this usage is deprecated).
Ques:- How to find out duplicate records in sql server.
Asked In :-
Solace Infotech, Sardonyx Technologies, SysTrack Solution, Angular Minds, Yudiz Solutions, Apttus Software, CTRLS DATACENTERS, Softeon India, Dassault Systemes, IDS Infotech,
Ques:- What is merging?
Asked In :-
Apttus Software, Artech Infosystems, ISC Software, Cimpress India, Qualminds Technologies, BOM, SoftNice, Tenpath, LogiCoy, China Bank,
Right Answer:
Merging is the process of combining data from two or more sources into a single dataset, often used to consolidate records or integrate changes in data. In SQL Server, this can be done using the MERGE statement, which allows you to insert, update, or delete records in a target table based on matching conditions with a source table.
Merging is the process of combining data from two or more sources into a single dataset, often used to consolidate records or integrate changes in data. In SQL Server, this can be done using the MERGE statement, which allows you to insert, update, or delete records in a target table based on matching conditions with a source table.
Ques:- Statutory & taxation
Asked In :-
ClearTax, China Bank, IBG Fincon, CLA (CliftonLarsonAllen), california department of tax and fee administration,
Right Answer:
Statutory taxation refers to taxes imposed by law, which must be paid by individuals and businesses as mandated by government regulations.
Statutory taxation refers to taxes imposed by law, which must be paid by individuals and businesses as mandated by government regulations.
Ques:- What are the due date for filing of quarterly TDS Return?
Asked In :-
Geojit, Haldor Topsoe, Varma & Varma, MP Chitale & Co, UTS Consultants, China Bank, Vasan & Sampath, Mcb Bank, AmeriSave Mortgage, h&r block,
Right Answer:
The due dates for filing quarterly TDS returns are as follows:
- Q1 (April to June): July 31
- Q2 (July to September): October 31
- Q3 (October to December): January 31
- Q4 (January to March): May 15
The due dates for filing quarterly TDS returns are as follows:
- Q1 (April to June): July 31
- Q2 (July to September): October 31
- Q3 (October to December): January 31
- Q4 (January to March): May 15
Ques:- WHAT IS EMD?
Asked In :-
Geojit, IOOF, China Bank, bdo uk llp, cohnreznick llp, mahajan & aibara, frontline accounting,
Right Answer:
EMD stands for Earnest Money Deposit. It is a sum of money paid to demonstrate a buyer's commitment to a transaction, often in real estate or bidding processes.
EMD stands for Earnest Money Deposit. It is a sum of money paid to demonstrate a buyer's commitment to a transaction, often in real estate or bidding processes.
Ques:- What is the difference between manufacturing , sales & service company?
Asked In :-
Ameriprise India, InvestoSure, China Bank, Amul, voya financial, hbl - habib bank limited, bata, britam, franchise tax board, crowe horwath llp,
Right Answer:
A manufacturing company produces goods, a sales company sells products, and a service company provides services rather than physical products.
A manufacturing company produces goods, a sales company sells products, and a service company provides services rather than physical products.
Ques:- Direct & Indirect Taxation
Asked In :-
Geojit, China Bank, AudaCity Capital, h&r block, kenya revenue authority, frontline accounting,
Right Answer:
Direct taxation is a tax paid directly to the government by the individual or organization on their income or profits, such as income tax and corporate tax. Indirect taxation is a tax collected by an intermediary from the person who bears the ultimate economic burden of the tax, such as sales tax, VAT, and excise duty.
Direct taxation is a tax paid directly to the government by the individual or organization on their income or profits, such as income tax and corporate tax. Indirect taxation is a tax collected by an intermediary from the person who bears the ultimate economic burden of the tax, such as sales tax, VAT, and excise duty.
