Interested to Buy Any Domain ? << Click Here >> for more details...
what is execute scalar?
- 11 Answers
- 24641 Views
- Atharva Infotech, Dohatec New Media, Make eIT, Protech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thirushakar
Scalar will return only one value.
(ie we can read or write only one data at the time)
| Is This Answer Correct ? | 33 Yes | 11 No |
Answer / versha
When we want any aggreagate answer then we use execute
scaler examples like avg,sum etc
this return one row and one column
| Is This Answer Correct ? | 24 Yes | 2 No |
Answer / muthu kumar
when we want to retrieve data that has single value then we
can prefer to execute scalar.
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / prabhat saxena
execute scalar return a object type value, by defalut it
will return first row of fst column value, mostly we used
it with aggregate function like sum(),max(),min(),avg()....
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / tonny
Executes the query, and returns the first column of the
first row in the result set returned by the query.
Additional columns or rows are ignored.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / yograj pandey
Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a database. This requires less code than using the ExecuteReader method, and then performing the operations that you need to generate the single value using the data returned by a SqlDataReader.
A typical ExecuteScalar query can be formatted as in the following C# example:
cmd.CommandText = "SELECT COUNT(*) FROM dbo.region";
Int32 count = (Int32) cmd.ExecuteScalar();
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / usha
This method is used to execute commands that return single
value rather than resultset.
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / adsd
scalar will returns single value.scalar eg like avg,sum etc
it vl return oly one column as output
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vivek kumar
execute scalar method return only one value that means you
can use this with max, min, sum function
| Is This Answer Correct ? | 3 Yes | 1 No |
Define partial class?
How can we load multiple tables in a dataset?
How to pass multiple tables in datasets simultaneously?
What providers does Ado.net uses?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is ado and rdo?
What is the hierarchy of data in databases?
Explain what a diffgram is and its usage ?
Diff B/W DataSet vs DataTable
Call a stored procedure from ado.net and pass parameter to it ?
7 Answers Keane India Ltd, TCS,
Explain the two fundamental objects in ado.net?
How to retrieve the user id which is provided while windows authentication?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
