PDA

View Full Version : ANSI SQL


Pages : [1] 2 3 4 5 6 7 8 9

  1. SQL question
  2. Test for null?
  3. Tricky SQL, using MAX, no full tablescan
  4. PLSQL: Create generic group by function
  5. Tree organization
  6. Multiple results from single column
  7. Simple PL/SQL Block Error
  8. Using Sum() in self-join
  9. SQL & PHP question
  10. multiple fields in SELECT WHERE IN
  11. Schema evolution in production environment
  12. fine tune BCP & optimize Procedure - really confused
  13. Changing values in inserting record via triggers
  14. select number of days
  15. Array as a parameter PL/SQL.
  16. Can an Java Array be passed to a SP
  17. Timestamp query - Newbie
  18. What's up with float?
  19. Merge Replication
  20. Time/DateStamp Update Query Using SQL
  21. looping through all days of the year
  22. select query for records which do not appear in another linked table
  23. Alternate query to get around inner join/outer join at same time
  24. (seemingly) simple query question
  25. :new.<variable_name>
  26. A Database Trigger Calling an Oracle Procedure which in turn calls a Java function
  27. Oracle Error Message :ORA-29531: no method putsData in class Insert
  28. Table Access OR File Manipulation
  29. Count of different values
  30. retrieving line of last error
  31. PeopleSoft export query??
  32. IF NOT EXISTS in Oracle?
  33. multiple image uploads......
  34. PL/Sqlplus-extracting data from Table to comma delim file
  35. Store Var's in MySql table
  36. Normalisation
  37. ORA-06530 :Reference to uninitialised composite
  38. ordering results from Celko hierarchy
  39. PL/SQL to TSQL
  40. (ObjKommun IN ('xxxx%', 'oooo%'))
  41. multiple insert delays
  42. nvl2 in 8.1.7.3.0
  43. T-SQL and Daylight Savings Question
  44. import from file
  45. SQL Cluster and language characters
  46. How do you concatinate when one value is Null?
  47. How do I Check for null fields?
  48. Sql
  49. Sql
  50. Sql1
  51. some questions
  52. jim hoffman's sql tutorial
  53. SQL Plus "Normalization"
  54. Transact-sql / PL-sql translation
  55. Oracle OBJECTs
  56. Query question, please help!!
  57. Adding Leading Zeros
  58. problem with group by
  59. How to join three tables
  60. sql query
  61. execute an Or logical into a select
  62. How do I create and AND Where clause?
  63. DoCmd.OpenReport WhereCondition prblms
  64. SQL Injection - ATTENTION
  65. SQL Help please??
  66. MS Query Analyzer: how to calculate a time span with two DATETIMES?
  67. SQL trigger
  68. SQL to XML?
  69. BCP SQL 7 Loading issues
  70. Oracle CLOB xml to tables?
  71. recordcount
  72. can this sql work correctly?
  73. Script Conversion
  74. command script for delete
  75. this is new to me
  76. populate numeric col with data from varchar
  77. What is this symbol : (+) ??
  78. Forcing leading zero
  79. error during merge replication in sql
  80. How to copy an Oracle Long Column in PL/SQL
  81. converting minutes to seconds in query
  82. identity insert
  83. Timestamp Field
  84. order by
  85. tracing SQL statements in Java
  86. SQL 6.5 for Windows 2000
  87. crosstab
  88. what's the best way to update multiple fields
  89. help please.
  90. ORA-04091: Table A is mutating, trigger/function may not see it
  91. user-defined function (UDF) : transact-sql
  92. Unique command in SQL
  93. going from text file to datetime field using format file
  94. Joining 2 Tables
  95. PL/SQL: couldn't create trigger
  96. Sub Query With Subtotals
  97. How can I open an OS text file inside one Stored Procedure
  98. converting oracle sql to sql server sql
  99. Simple Select Statement
  100. Having problems creating a function or procedure
  101. Normalisation - Query
  102. Booking database - query
  103. problem getting right output when using SQL
  104. sqlplus logon question
  105. How find the record count from SQL output ?
  106. Database Deisgn for MES/Industrial Automation
  107. Import fail in oracle 8i Err- Imp00037
  108. What does this mean?
  109. Converting Oracle Encode Function to T-SQL Syntax
  110. working out optimal SGA for your database
  111. Trigger and strings
  112. SUM PRODUCTS Possible in SQL?
  113. Execute an update query in a stored procedure
  114. pb Order by
  115. populating a primary key using a before insert trigger
  116. Problem SQL select statement
  117. Calling a pl/sql func with OCI - please help
  118. Consolidating Like Items and Summing Totals
  119. reading user input?
  120. How do I?
  121. Novice Seeks Book Advice
  122. REPLACE Function for Bad Characters?
  123. Export query in text file
  124. sql help
  125. Rank with median on ties
  126. Want to get any 10 records from resultset
  127. Removing headers from sql output
  128. CreateFile() Error
  129. SQL search spanning mutliple servers
  130. Create Cursor with Dynamic SQL
  131. MySql
  132. UPDATE question
  133. SQL and access 97
  134. Displaying Date in SQL View
  135. comparing tables
  136. Cannot resolve collation conflict for equal to operation.
  137. pass sql error to ksh
  138. sql report
  139. Creating backup table
  140. Need help with a 3 table query
  141. UPDATE multiple rows with values from another table
  142. Duplicate Records
  143. SQL Syntax error with a float
  144. How to make UDF deterministic
  145. A Matter of Style
  146. Triggers, procedures and inserting into a table
  147. Diagram Script I Sql7
  148. converting from Oracle to SQL Server
  149. Autonumber problem Error "Data type mismatch in criteria expression"
  150. Querying all the constraints in a database
  151. A+b=c
  152. Cursor limits
  153. Get index of values in buffer in a SP
  154. Sql Default Date Format
  155. Formating column widths with SQLPlus
  156. Trigger help - Please :)
  157. problem about Pro*C
  158. Mulitple Update in mYSQL
  159. activex on oracle forms
  160. execute ie instance
  161. Query AS400 Column Names
  162. Problem calling Oracle SP from Access 97
  163. Help me please with SQL!!!!!!!!!!!!!!!!
  164. How to set format of Excel column while generating report in Excel?
  165. Pass error sql to ksh
  166. problems with SQL inn Win 2000 and XP,again
  167. Questions on WHILE LOOP in PL/SQL
  168. client server sql
  169. What's wrong with this pl/sql procedure???
  170. A new PL/SQL nut...
  171. UTL_FILE in RDB (OpenVMS)
  172. How to control MS SQL Server DataBase's permissions through visual basic programing
  173. creating constraints
  174. inietinfo entry point not found
  175. Help with referential triggered actions!
  176. how to put the result of a query into a variable??
  177. Matrix / Crosstab Query
  178. Data type mismatch in criteria expression.
  179. Using "&" in a search string HELP!!
  180. perl DBI update
  181. Retaining results from a query (in a temp table?)
  182. Load File In A Table
  183. Query Help
  184. Jet 3.5 ADD COLUMN position?
  185. column formula
  186. Dates and Differences between Query Analyzer and Enterprise Manager
  187. A practical newbie question involving r/s schema involving mysql
  188. Dynamic Dates and Stored Procedures
  189. small basic question concerning count
  190. Pls-00378
  191. Stupid Question
  192. pls/sql help needed urgent.
  193. Syntax Usage of DISTINCT ?
  194. How to return only the first row....
  195. Converting SQL Scripts.
  196. Is there a statement to view table description in MS SQL
  197. PL/SQL & Recordsets
  198. Stored Procedures?
  199. Changing Character Case
  200. Passing HTP.PRINT statements into a variable
  201. Sumarized in SQL
  202. inserting values for alias names within tables?
  203. getting count of query??? how?
  204. returning numeric values via sql!
  205. If Else question URGENT
  206. Newbie : Need Help in joining Multiple tables
  207. SQL Select problem
  208. Normalisation Help
  209. Getting reading blob data from VB
  210. Dynamically substitute table name in Cursor Defn.
  211. Passing contents of text file into variable?
  212. UTL_FILE.PUT usage
  213. Sum and Count two tables
  214. Inserting data from multiple row into one?
  215. Truncating part of a zip code
  216. php and mysql -- in chinese?
  217. Stored Procedure Create Table from Variable
  218. trouble using ref cursors
  219. table data for IN keyword
  220. PL/SQL command to print a saved file in unix?
  221. Is it possible to append and sum together?
  222. VBScript cannot call MS SQL SERVER Database record file?
  223. anyone can help me?
  224. Data type mismatch in criteria expresioin
  225. need to select date range in sql...not working..
  226. pl/sql wrappers newbie guide?
  227. Select last row in db atble
  228. External Procedure error
  229. Turning one record into multiple records...
  230. Help with Select statement
  231. HELP! Stored Procedure problem
  232. First & last record retrieve
  233. RunTime Error 3706
  234. Newbie : Need help in Sorting
  235. Data from two tables
  236. PL/SQL cursors and index tables
  237. weekly to monthly
  238. missing or invalid option
  239. Insert records into unusual table
  240. New column in where clause
  241. Enumeration variables???
  242. A question on subquery return
  243. PL/SQL functions for binary data?
  244. Access sub-select question
  245. Connecting Sqlserver2000 To Db400
  246. SQL Find Text - use like ?
  247. SQL 7 Personal Edition on Laptop
  248. 3 largest value
  249. open recordset error
  250. To subquery or not to subquery?