PDA

View Full Version : Microsoft SQL / MS SQL Server



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

  1. Read and write binary data by using ADO
  2. select into blocking
  3. How to find duplicate records in the table?
  4. Enterprise Manager Problem
  5. Help with Dates please
  6. Bit and Text Columns
  7. count
  8. comma separated to SQL Server DB table
  9. Select Top - percent range?
  10. min( ) function.
  11. How to ensure if column A is null, column B has to be null
  12. Can "Computed Column" be a stored procedure in SQL Server 2000?
  13. Need help with a select top 1
  14. First Time Trans Error Control -- Help Please
  15. GMT time to local server time
  16. remove time from getdate()
  17. Hierarchies
  18. Error handling in SQL
  19. how to add another column to a query result?
  20. Is it possible to do this using TSQL instead of cursor ??
  21. Transactions - ADO/SQL or both?
  22. Performance difference using "between" in the where clause
  23. Crosstab query - Nearly there!
  24. copying image data
  25. Problem with Trusted Connections
  26. T SQL Debugger Problem
  27. Perform cascade delete
  28. Newbie - Moving around (scrambling) data?
  29. Difference between strings
  30. Ambiguous between two types of query
  31. SQL Server IDENTITY_INSERT with CTable<CDynamicAccessor, CRowset>?
  32. RowLock
  33. Login failed for user...
  34. Indexing a view
  35. Eliminating duplicates
  36. Problem with transaction
  37. suspect on sp execution order
  38. BETWEEN Function with Dates
  39. Transaction
  40. Error backup
  41. Maximum Size of a created table
  42. RAISERROR
  43. Rollback update
  44. Trapping errors from stored procedure calls
  45. Join problem in a View
  46. **Tracing**
  47. Column name case sensitive using Turkish client
  48. Get source statement of a view, proc or func
  49. Usage and Benefit of Table Variable
  50. How to recover a SQL Server database after a crash
  51. Handling error messages
  52. COUNTING PROBLEM !!!
  53. Performance tunning in SQL Server 7.0
  54. Nesting IF's in Stored Proc
  55. controlling user edits and using timeouts
  56. What am I doing wrong with this SP??
  57. How to write this query... please help!
  58. using 'exist'
  59. proxy account setting.. pls help
  60. Replace character in SELECT results
  61. Trace statements executed by ASPs
  62. Can't call UDF as sub-query
  63. Stored procedures and database in the table
  64. SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER???
  65. Recursive query
  66. Removing Duplicates from a table..
  67. SQL Server SP3 problems
  68. Space used in a column
  69. Index problem with Update
  70. Temp table question
  71. Null > ''
  72. Entity Relationship Diagram - database design problem
  73. EOF error in BCP
  74. NEWBIE NEED HELP
  75. Triggers and importing data once again
  76. Selecting all columns, but in a different order in SELECT statement
  77. how to show image retrieved from BLOB on the web page
  78. Triggers and importing data
  79. How to switch off transactions?
  80. Detecting Largest Movers
  81. Oracle 8. The service OracleTNSlistener80 can't start.
  82. Selecting Date
  83. Does RANK and weightage goes hand in hand
  84. Check for locked record
  85. CONTAINSTABLE v/s FREETEXT
  86. HELP ME : check for locked record
  87. Design: one table or two tables, depending on usage
  88. Q324479
  89. HowTo Select an ID where a "Date" is between startDate and endDate?
  90. Interesting behaviour of : LIKE v + '%'
  91. Grouping and sorting by date
  92. Cannot execute dynamic query in stored procedure
  93. recreating a crosstab query - explanation of an example requested
  94. The simples thing ;)
  95. Test for existence of a #temp table
  96. CrossTab Question
  97. How to capture this error?
  98. Block cursor using OLE-DB
  99. MMC problem
  100. Run .BAT from a package
  101. New Stored Procedure. Help me to write it.
  102. return distinct
  103. Lock record
  104. OSQL
  105. function - Is Server up
  106. Renumber a field
  107. Temporary Table Query
  108. UPDATE with inner join
  109. To limit the number of connections for user
  110. Sequential Number Generator
  111. protected it as a system table
  112. Formatting datetime values
  113. Transactions and Table Lock
  114. Copy data from one table to another
  115. Parameterized Views
  116. Commit Control - forgot to mention
  117. Commit Control
  118. SUM
  119. Functions
  120. Manipulating the results of sp_who
  121. Stored procedures and UNION (SQL Server 2000)
  122. size of the results of a SQL query
  123. DTS task
  124. how to extract data filtering by a DateTime field (depending sample period time) ?
  125. Function to find position of the last numeric character inconsistent
  126. Record Locking.
  127. ORDER BY Question
  128. strange subquery behaviour?
  129. Sql Script Parameter???
  130. Grouping....SQL Server or VB Code?
  131. Create and Drop tables in a linked server
  132. Built In- stored procedure
  133. Writing "text" columns in ADO.NET
  134. Index on Computed Column and ADO Insert
  135. Datetime update
  136. Row size limit (8060) calculation
  137. Invalid character value for cast specification
  138. Limiting similar rows in SELECT statement...
  139. Paging resultsets in SQL Server - another solution
  140. format file and bcp/bulk insert
  141. Help w/ SQL doesn't work
  142. MSDE/SP3 MemoryLeakage
  143. SQL DMO + Foreign Keys
  144. combine two select statement
  145. Conversion from SQL 7.0 to SQL 2000.
  146. Using variable in From clause
  147. Enumerators - Replace Numeric Values with Text
  148. SQL Server encryption to hide the contents of fields
  149. SQL Server 2000 vs. DB2 databases.
  150. Database corrupt, can we use the transaction log?
  151. How to know which SQLServer Service pack is installed?
  152. Crossatb / Transform query --- WARNING Msg
  153. BOM
  154. to sum the cost of unique items...
  155. Help w/ SQL
  156. ACCESS_VIOLATION
  157. What is equivalent to instrRev() function of VB-6 in Sql 2K ?
  158. xpsql.cpp: error 5 from CreateProcess on line 675 - Help Please
  159. Access Violation?
  160. Query with variables
  161. PK columns
  162. BETWEEN OPERATOR
  163. Insert Dummy Records
  164. getting decimal places when dividing integers
  165. Profiler Question (Profiler Message)
  166. 2 part qry
  167. Rebuild a table
  168. ADO.NET with Instead-Of-Insert Triggers, sets NULLs
  169. sequence number in a view
  170. Update and Select Statement
  171. Profiler Question (Setting Filters)
  172. Was the text column changed?
  173. Help for a novice, Please!
  174. how to view sysobjects in all databases
  175. What is ad hoc query or script?
  176. SQL2K Stored Proceedure -> .ADP 10000 Record Limitation Setting
  177. IsNumeric Bug?
  178. INSERTing HTML-File won't work
  179. Have trigger supply value for NOT NULL column on insert
  180. Object_id routine can't find my stored proc, which is prefixed with SYSDBA
  181. Stored Procedure not returning the wanted resultset
  182. for xml explicit is a pain!!!
  183. CDONTS-Sending HTML mail-8000 character limit
  184. Problems with extended procedures
  185. create an Excel spreadhseet
  186. Select Distinct
  187. Howto: Auto increment Primary Key in SQLServer
  188. parameter passing from osql
  189. Inserting Data Outside A Transaction
  190. Favourite topic: primary keys (natural vs surrogate/artificial)
  191. What's best: Heap or Clustered Idx on combined key?
  192. Err : -2147217887 Row Size problem
  193. Any idea for a stored procedure ?
  194. Insert a file in a SQL field
  195. Using conditional logic in a select statemet (I.e IFs)
  196. mssql, duplicate code, and the dearth of correlation
  197. user defined cursor from a sp
  198. Adding a table from another server
  199. Data type query
  200. SQL Server dialect functions
  201. trigger error
  202. Sql server driver registration
  203. Store pdf's
  204. connection variable in Function of SQL server
  205. Fatal errors with SQL (asserts, invalid page reads etc)
  206. Strip Leading Characters ??
  207. GROUP BY?? Simple!
  208. Copying entire table
  209. An impossible question?
  210. Sql Server Deadlock
  211. stepping through store proc
  212. Help please...
  213. Trigger - wont allow me to insert
  214. help on join in from clause
  215. SQL Out Mail in Inbox
  216. How stop a xp_cmdshell process ???
  217. How to call routines in .NET dll from sql server?
  218. Replace data in one column out of 14
  219. Killing long running queries
  220. IN clause with 2 fields
  221. Autoincrementing a column for rows with null
  222. SQL and variable position and length inserts
  223. First () Function
  224. Trigger Help
  225. About 'Union'
  226. Unable to connect
  227. update and having clause??
  228. Combining Fields
  229. SQL select statement problem...
  230. XML OUTPUT
  231. Kill process
  232. Access query Sql View
  233. QUERY CHALLENGE
  234. Hex values
  235. Passing a file to SP_XML_PrepareDoc
  236. varchar truncated at 255 characters
  237. Abstraction of table variable declaration
  238. Trigger hangs!
  239. Counting 1st Record only
  240. SQL Worklfow using Office XP Developer
  241. Table design
  242. Programmatically checking syntax of SQL
  243. A Trigger's Parent
  244. help for very larg time
  245. Help with Stored Procedure returning recordset
  246. rowcount in trigger
  247. Database set to Single User? How?
  248. Creating tables and merging them for multiple data
  249. Server Drive Letters
  250. CAST & CONVERT nondeterministic