top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

please explain the Properties of adhoc query?

+2 votes
339 views
please explain the Properties of adhoc query?
posted Jun 23, 2015 by Mohammed Hussain

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Properties of adhoc query:

  1. It is case sensitive
  2. Space sensitive
  3. Parameter sensitive

For More information abput adhoc query plz visit:http://www.exacthelp.com/2012/11/what-is-adhoc-query-in-sql-server.html

answer Jun 27, 2015 by Vrije Mani Upadhyay
Similar Questions
+4 votes

Table Name : Hist_table

 Shp_cd wt_grp  net_wt  tot_wt
   101   10       9      7
   102   20       8      2
   103   15       4      1

Factor_table

Fact_id fact_column factor
  1     wt_grp        2
  2     net_wt        5
  3     tot_wt        3

Note – this factor table contains rows as the column name of hist_table.
Now we have to update the Hist_table with the multiplied with the factors
For example wt_grp factor is 2 then we have to update all the wt_grp column of hist table as Hist_table.wt_grp * factor_table.factor
So the result should be

shpcd   wt_grp  net_wt  tot_wt
101     20        45    21
102     40        40    6
103     30        20    3
...