PDA

View Full Version : Microsoft SQL / MS SQL Server



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

  1. t-sql
  2. Integrity via foreign keys or application?
  3. Triggers & Inserted Data Length...
  4. cannot create using sp_oacreate
  5. Query to find names in 2 tables
  6. How to get midnite time always for any given date...
  7. sytax problem
  8. CASE
  9. Searching on Day/Month Portion of DateTime
  10. Update on SQL database with stored procedures in another SQL database
  11. Deadlocking problem
  12. Character Fields to numbers?
  13. BLOBS & Database Space
  14. ACCENT INSENSITIVE
  15. How use Subquery better ???
  16. SQL SERVER JOB
  17. Case statement help
  18. SQL Counting Records from another Table
  19. Connection Timeout
  20. Is it possible to run a SQL script from a batch file ?
  21. Foreign Key help
  22. Using ISNULL in Dynamic SQL
  23. connection with server behind the firewall Router
  24. Text Datatype
  25. set iValCount = exec(sSQL) ... ERROR
  26. Specifying Numeric datatype in a SP
  27. Dynamic column names
  28. Selecting by time slots
  29. Need help about stored procedures
  30. Executiuon Time (repost)
  31. Cursor Question
  32. Query yser - Getting hold of a copy
  33. Brain Drain. Please help
  34. how to display decimal part of number?
  35. FULL-TEXT CATALOGS
  36. Consecutive events
  37. Newbie SQL programming question
  38. Is there "subform" in SQL 2000???
  39. Copy tables without using checkbox......how??
  40. Need help with select statement
  41. Table name in variables?
  42. View syntax question
  43. Inconsistency in SQL
  44. Remove Identity Property
  45. format a COMPUTE BY clause
  46. Novice - String concatentation
  47. VBA in Access linked to SQL tables not working
  48. Create Identity Field
  49. Raising error from SPROc in VBS Script
  50. How to update from another registry
  51. UPDATE from Two Tables Into One Table
  52. Please rescue me from OLE DB Hell
  53. Case Sensitive query
  54. email, profiles and from properties...
  55. How use this query better ???
  56. Insert trigger sqlserver 2000 and Visma Salesoffice
  57. Rewrite Query using Inner Join, Left Join e.t.c
  58. Help with Tricky UPDATE sql statements.
  59. How to Pick a Random Record?
  60. Dynamic SQL use of parameter/variable
  61. dr("field").toString returns "400.0000" instead of "400"
  62. question about sp
  63. strange (newbie?) problem
  64. stored procedures run through while debugging
  65. Help avoid Cursor to calc Correlation
  66. How use UNION with Sum() ???
  67. SELECTing sequence of data
  68. Delete
  69. Clustered index on GUID
  70. Adding aggregate functions
  71. Bug in Coalesce?
  72. SELECT TOP 2
  73. Insert Identity back into same record?
  74. Retrieving SQL Server SPs Return Recordset Column Names
  75. Null in check
  76. cant restore a database
  77. Bulk Insert
  78. Compound SQL query Q
  79. bcp help
  80. sp_OAMethod - Param value of spaces How? - Repost
  81. Very Slow when date range includes future date
  82. Problems with transactions
  83. SQL Query Output to Excel file
  84. Complex Multi-table query
  85. MS SQL Server 2000 very serious design flaws with transactions andlocking ? (Unusable for ERP systems)
  86. am i in an end-less loop here?
  87. Trigger Help Needed.
  88. Execute Immediate in a stored procedure?
  89. Using a Left outer Join on Three Tables
  90. rename coulmn using sql statement
  91. datetime datatype question
  92. Int field type and error messages..
  93. MAX of two values
  94. Bit datatype
  95. Heeeeeelp: Prevent to Drop the Databse
  96. Query yzer bug??
  97. More evidence of brain-damage...
  98. Statistics updates ...
  99. Looping through a list and inserting into a table
  100. ORDER BY conflicts with UNION operator
  101. Insert method
  102. Dependancy problem?
  103. SQL Server 7 Optimiser
  104. Sp_rename
  105. Add Quote : Sql Server 2000
  106. Looking for a specific character
  107. Logging changes in a table!
  108. DTS import csv - dynamic file name
  109. Encryption
  110. Why do I get an error?
  111. how to determine whether a field has null value
  112. Parent-child insert/copy
  113. Create Database
  114. Create Table and Boolean Data Type
  115. A Relational Model Question
  116. Dynamic SQL: INSERT single and double quotes
  117. Please help write this query
  118. SQL conversion help needed
  119. Debugger with triggers
  120. SQL Newbie Primay-Foreign Key question
  121. Problem creating function in MS SQL 2000??
  122. Identities
  123. sequneces in sql-server
  124. Find out the commands executed
  125. CAST anomaly
  126. Managed Code Interoperability
  127. Backing up with a low priority
  128. Formatting string in WHERE Clause
  129. SP with Table name as Variable
  130. Invalid Object Name
  131. Opposite but equal?
  132. count of distinct rows
  133. an easy Q
  134. String convertion to date
  135. Dropping a recordset during a stored procedure
  136. help with SQL statement
  137. How to add more fields to the cursor ?
  138. Stripping data out of a field, slightly diffrent case this time
  139. generating incrementing number in column on select
  140. Stored Procedures
  141. Can U Debug or step through a Stored Procedure???
  142. For Each ....
  143. A very strange problem
  144. Grabbing value for a trigger
  145. Multiple Instance
  146. How get result of SQL call into variable?
  147. Help Requested ... VBScript runtime Error
  148. Extended Stored ProcedureExtended SP's - srv_paramsetoutput length > 255
  149. Programmatically accessing SQL server name
  150. Distributing obfuscated/hidden SP's?
  151. Error in select
  152. SOS! how can I recover?
  153. Large read-only table for queries - what index?
  154. SQL View with Decimal Output
  155. Table Managment
  156. International (Croatian) characters conversion while updating
  157. Setting up environment variables
  158. Will anyone know this?
  159. Need Help -Expected end of statement
  160. SQL querry vs Access qry
  161. Views or WHERE
  162. Case with Nested In Select Not Working
  163. huge table and view
  164. Help with a query Urgent
  165. new proc
  166. stored procedure that calls other procedures
  167. SUM() question
  168. Question on Stored procedure
  169. Adding the same user to all databases
  170. SELECT - Number of days between records
  171. Covert Functions
  172. retrieve deleted records for a specici userid
  173. is there anything wrong w/ this proc?
  174. Generate results based on another collection of results? (users and zip codes)
  175. Two levels Summary Report
  176. rollback doesn't reclaim unique id.
  177. Query Help!
  178. About percentages
  179. SQL help
  180. possible to run a select with an if statement in it?
  181. speed challenge
  182. Identity column
  183. Losing uncommitted Data?
  184. WHERE clause and wildcards
  185. "Cleanup" function
  186. Finding Duplicate Values in a table
  187. SQL Statement
  188. Return sp's result row into local variables?
  189. sha1 crypt
  190. Multi table queries with agregates
  191. impementing a complex sequence
  192. Stored procedure
  193. Query
  194. Testing a Stored Procedure
  195. SQL Statement question
  196. Dynamically building up a WHERE clause
  197. Monitoring Structure Databases
  198. Compare string case sensitive
  199. Selecting results from a Stored Procedure
  200. Query Required
  201. SP with unknown number of arguments or one delimited argument
  202. Help with complex query
  203. UDF problem
  204. easy question.
  205. GROUP BY challenge...
  206. SQL Timeout Expired
  207. Spellcheck in SQL Server
  208. TSQL Query
  209. Procedure returns first EXEC not last?
  210. verifing whether a table with same name exist or not before creating new table
  211. concatenating in xp_sendmail message
  212. Using VB Script to email....
  213. why I couldn't get the same order of retrieved records as inserting them?
  214. xp_sendmail
  215. column default to fiscal year
  216. showing numbers after the decimal point....
  217. Exec procedure and date parameters
  218. Best Way to Replace COM?
  219. Count two distinct items in a table.
  220. Concantonated Keys
  221. merge two table
  222. information_schema
  223. Dynamically set the column name for IF UPDATE ( column ) in trigger
  224. Query Help
  225. Locking questions ...
  226. Global Temporary Table
  227. xp_cmdShell 'dir s:\backup' Access Denied
  228. Full-text Index bug
  229. Creation of primary key
  230. Getting the Columns comma separated
  231. SELECT fieldnames FROM table
  232. SP Resultset
  233. Adding non exsisting rows in a view.
  234. Sorting VarChar in ascending order
  235. CASE in UPDATE?
  236. Using functions in Query yzer - escape character?
  237. Ignoring 'Having' clause
  238. Select data from linked server
  239. XA warnings in SQL 7.o using Informix
  240. Check For Indexes
  241. Full recovery and torn page detection
  242. Select of non DBO Table in UDF...can't do it.
  243. Grouping and Ordering
  244. Connect to Web Database from VC++
  245. How do I get a server list in a combobox?
  246. Line break in message when using xp_smtp_sendmail
  247. Create a View from a Stored Procedure
  248. is it a bug in Stored Procedure?
  249. CHAR(0) within a string
  250. Money amount shows as "1,23" instead of "1.23"