PDA

View Full Version : ANSI SQL


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

  1. One last before the week end
  2. Converting a (+) to an outer join in SQLServer
  3. Returning the entered date
  4. NOOB ??? Thing to ask
  5. Outer Join and Inner Join
  6. impossible SQL query???
  7. add_months function
  8. Initial Caps of a String value
  9. Joins Across Servers/Databases
  10. creating stored procedure update
  11. query help
  12. stored procedure update
  13. Effective Date selection in SQL
  14. update query in pl/sql
  15. set field = current date
  16. Lowest Marks
  17. Discount-calculation
  18. Searching on friends, friends' friends, friends' friends' friends, ...
  19. Creating procedures in PL/SQL
  20. multiple-column subquery
  21. normal forms
  22. row exceptions in pl/sql
  23. Upload File
  24. Field looping
  25. PL/SQL Problem
  26. Help!!!
  27. Pagination in AS400 Stored Procedure
  28. How to improve this SQL statement?
  29. Used Disk Space
  30. Help BLOB
  31. SELECT Statement Help
  32. update recnos within groups
  33. Picking one row out of many?
  34. Keyword Search
  35. Oracle Financials Technical Lead
  36. Query Help
  37. Large DBs
  38. deleting from one table based on rows in another
  39. Search/Replace function for varchar2(2000) field
  40. Dynamic connect...?
  41. Using a column as a result in CASE statement
  42. FULL JOIN to distribute one column over several others
  43. Help with Oracle 8i Outer Join
  44. Help with Statement (PL/SQL)
  45. Running reports from forms 9i
  46. Raising an exception for "no rows selected"
  47. dQuery 3.0 or earlier
  48. How do I enumerate the database?
  49. can i make one query out of these two?
  50. store a query from a select statement into a variable
  51. Oracle, SQL+ and calling a stored proc in a package
  52. select statement w/case statement
  53. movie db query problems
  54. error using dbms.sql
  55. 9i XML extraction in "before" triggers
  56. question about searching
  57. HELP! - Call STORED PROCEDURE DB2 mainfraime
  58. SQL Student Guide
  59. More SQL Clean-Up
  60. run time error: Encountered the symbol "S" when expecting one of the following:
  61. better way to update then select
  62. Cleaning up bad Oracle 8i SQL; made it worse?
  63. what's wrong with my code? (Attaching an image)
  64. creating a text file from the contents of the database?
  65. Sorting question
  66. msde
  67. *pls help (3 day bug)* If statement not returning TRUE when it should
  68. Portable date (month + year) syntax
  69. database for portal
  70. Summing with field name
  71. Select Distinct
  72. Sql Statement Question
  73. Associative array
  74. some environmental variable in SQL*Plus
  75. Help need to write a Query in VB - MsSql !
  76. Portable way to express COUNT(DISTINCT list) ?
  77. Query a dynamic table...HELP!
  78. HELP!! - SQL Statement does not work!
  79. How to find the second largest value in a field !
  80. Sql Select...
  81. IN list returned by a function
  82. Table data type and ASP
  83. Triggers
  84. Default Password of Oracle SQL PLus
  85. Help with Dbms_output PLEASE!!!
  86. Questions about tables and SQL
  87. [multivalued DBMS] How can I make this SELECT?
  88. Attachment
  89. Using JOINS or just the WHERE clause
  90. Sql
  91. Union All & Group By
  92. Replacing Multiple rows with searched multiple values
  93. Returning small managable sets from a SELECT statement
  94. Extracting
  95. Need help creating a trigger
  96. SP2-0552: Bind variable "OLD" not declared.
  97. SQL Help
  98. Best Way To Create Point Of Sale Database
  99. SQL 2000 automated reports via e-mail
  100. Sending printer escape codes to UTL_FILE.PUT_LINE
  101. Dates and Loops question
  102. Beginning PL/SQL question
  103. Exceptions
  104. xmlparser Time-out (Oracle 8.1.7)
  105. Sql*plus okey... but Not Java
  106. Date Format
  107. Specify index for ra_site_uses_all <<URGENT>>
  108. oracle procedure help
  109. "missing expression"
  110. How to set Tab as column separator in SQL*Plus?
  111. Help! this is so basic for some of you!!!
  112. "NOT IN" vs "MINUS"
  113. SQL Help
  114. Dynamic SQL
  115. cursor is having no rows but should show at least 2
  116. pl/sql package will not compile
  117. procedure to create log and error files
  118. Big help is needed...
  119. Compbined into one select?
  120. query syntax problems
  121. Select text values
  122. CASE statement question
  123. query to return only non null fields
  124. Agg op question
  125. Shift a decimal
  126. Need some helps on this task
  127. Using variable as field name in record based on cursor
  128. To subquery or not to subquery?
  129. open recordset error
  130. 3 largest value
  131. SQL 7 Personal Edition on Laptop
  132. SQL Find Text - use like ?
  133. Connecting Sqlserver2000 To Db400
  134. Access sub-select question
  135. PL/SQL functions for binary data?
  136. A question on subquery return
  137. Enumeration variables???
  138. New column in where clause
  139. Insert records into unusual table
  140. missing or invalid option
  141. weekly to monthly
  142. PL/SQL cursors and index tables
  143. Data from two tables
  144. Newbie : Need help in Sorting
  145. RunTime Error 3706
  146. First & last record retrieve
  147. HELP! Stored Procedure problem
  148. Help with Select statement
  149. Turning one record into multiple records...
  150. External Procedure error
  151. Select last row in db atble
  152. pl/sql wrappers newbie guide?
  153. need to select date range in sql...not working..
  154. Data type mismatch in criteria expresioin
  155. anyone can help me?
  156. VBScript cannot call MS SQL SERVER Database record file?
  157. Is it possible to append and sum together?
  158. PL/SQL command to print a saved file in unix?
  159. table data for IN keyword
  160. trouble using ref cursors
  161. Stored Procedure Create Table from Variable
  162. php and mysql -- in chinese?
  163. Truncating part of a zip code
  164. Inserting data from multiple row into one?
  165. Sum and Count two tables
  166. UTL_FILE.PUT usage
  167. Passing contents of text file into variable?
  168. Dynamically substitute table name in Cursor Defn.
  169. Getting reading blob data from VB
  170. Normalisation Help
  171. SQL Select problem
  172. Newbie : Need Help in joining Multiple tables
  173. If Else question URGENT
  174. returning numeric values via sql!
  175. getting count of query??? how?
  176. inserting values for alias names within tables?
  177. Sumarized in SQL
  178. Passing HTP.PRINT statements into a variable
  179. Changing Character Case
  180. Stored Procedures?
  181. PL/SQL & Recordsets
  182. Is there a statement to view table description in MS SQL
  183. Converting SQL Scripts.
  184. How to return only the first row....
  185. Syntax Usage of DISTINCT ?
  186. pls/sql help needed urgent.
  187. Stupid Question
  188. Pls-00378
  189. small basic question concerning count
  190. Dynamic Dates and Stored Procedures
  191. A practical newbie question involving r/s schema involving mysql
  192. Dates and Differences between Query Analyzer and Enterprise Manager
  193. column formula
  194. Jet 3.5 ADD COLUMN position?
  195. Query Help
  196. Load File In A Table
  197. Retaining results from a query (in a temp table?)
  198. perl DBI update
  199. Using "&" in a search string HELP!!
  200. Data type mismatch in criteria expression.
  201. Matrix / Crosstab Query
  202. how to put the result of a query into a variable??
  203. Help with referential triggered actions!
  204. inietinfo entry point not found
  205. creating constraints
  206. How to control MS SQL Server DataBase's permissions through visual basic programing
  207. UTL_FILE in RDB (OpenVMS)
  208. A new PL/SQL nut...
  209. What's wrong with this pl/sql procedure???
  210. client server sql
  211. Questions on WHILE LOOP in PL/SQL
  212. problems with SQL inn Win 2000 and XP,again
  213. Pass error sql to ksh
  214. How to set format of Excel column while generating report in Excel?
  215. Help me please with SQL!!!!!!!!!!!!!!!!
  216. Problem calling Oracle SP from Access 97
  217. Query AS400 Column Names
  218. execute ie instance
  219. activex on oracle forms
  220. Mulitple Update in mYSQL
  221. problem about Pro*C
  222. Trigger help - Please :)
  223. Formating column widths with SQLPlus
  224. Sql Default Date Format
  225. Get index of values in buffer in a SP
  226. Cursor limits
  227. A+b=c
  228. Querying all the constraints in a database
  229. Autonumber problem Error "Data type mismatch in criteria expression"
  230. converting from Oracle to SQL Server
  231. Diagram Script I Sql7
  232. Triggers, procedures and inserting into a table
  233. A Matter of Style
  234. How to make UDF deterministic
  235. SQL Syntax error with a float
  236. Duplicate Records
  237. UPDATE multiple rows with values from another table
  238. Need help with a 3 table query
  239. Creating backup table
  240. sql report
  241. pass sql error to ksh
  242. Cannot resolve collation conflict for equal to operation.
  243. comparing tables
  244. Displaying Date in SQL View
  245. SQL and access 97
  246. UPDATE question
  247. MySql
  248. Create Cursor with Dynamic SQL
  249. SQL search spanning mutliple servers
  250. CreateFile() Error