PDA

View Full Version : SQL Server

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 [51] 52 53 54 55 56
  1. Moving rows to columns
  2. Question about optimization
  3. SQL query problem
  4. Help With a DATETIME Query
  5. Querying tables from different databases
  6. Carrage Returns, Stored Procedures
  7. INNER JOIN using surrogate ID, or [Date] BETWEEN?
  8. Assistance with Stored Procedure
  9. Reading text into varchar
  10. Help With Another UPDATE Query Please!
  11. Update Takes Long Time to Complete!?
  12. Query Analyzer : losing the ___ rows processed message
  13. arrays in tsql?
  14. SQL Logins
  15. Data type change in SQL view
  16. DEFINITIVE ANSWER PLEASE -- can you UPDATE ntext datatype field???
  17. Rebuild master never ends.
  18. STORED PROC to "UPDATE" ntext field -- PLEASE!
  19. Variable Paramters to Functions
  20. Check Data Before Update
  21. IIS crash and format
  22. Assigning values to multiple variables (via subqueries) for use in an update
  23. Merging rows within same table
  24. Stored Proc to assign variable from subquery not working -- ugh
  25. test
  26. Backup of active log after db failure
  27. Self Joins
  28. sql server 2000 - dts can't 'see' stored procedure
  29. SQL Server storing large amounts of data in multiple tables
  30. Error 7399
  31. Tracing values in DTS package/stored procedure
  32. DTS and stored procedure
  33. QUITTING
  34. SP3 & CURSORS
  35. Key Word Searching
  36. Auto-increment fields when moving a base from Access to SQL server
  37. Detecting or monitoring for long-running queries.
  38. eliminating (inverse) duplicates in result
  39. Insert problem with linked server
  40. Nested SELECT HELP....
  41. zusammengesetzter Primary Key mit Deleted-Flag
  42. SQL Server 2K truncating text fields at 255 chars
  43. Rotating information from Recordsets to columns.
  44. Inserting Duplicate Data
  45. Creating join statements
  46. Case Conditional in SQL Statement - MS SQL 2000
  47. Sound device/driver
  48. Fetch Question
  49. Custom Error Messages
  50. formula column
  51. VISUAL BASIC/ SQL PREFERRABLY SYBASE/ CONTRACT/ AR
  52. Transaction Log - Audit
  53. get description in table
  54. Import Human-Readable text file into SQL Server 2000
  55. Postal Lottery: Turn $6 into $60,000 in 90 days, GUARANTEED
  56. Retrieve One Row at a time
  57. Two "Cache" related full time positions.
  58. how to add column in database at runtime.
  59. TEMPDB now at 4 GB
  60. Website Monitoring
  61. SQL Server Hogs 100% CPU
  62. FoxPro Index called from SQL Server
  63. null pages
  64. Cannot convert Varchar to Numeric issue
  65. Looping database queries
  66. Changing table owner
  67. Calculating Time Difference
  68. Return Value in a Stored Procedure
  69. Many fields update from a Group by Clause
  70. Connection.CommandTimeout
  71. No results from Full-Text Search in SQL 2000
  72. Table design problem
  73. OT: SQL Server Hosting
  74. Rows as Columns
  75. where clause messed up
  76. Cursor, Query, View and Recordset
  77. SQL Server Monitoring
  78. About virus
  79. Magic upper limit to number of job steps in a job
  80. Select, insert and delete queries timing out
  81. multi-thread tasks using a single connection object concurrently
  82. SELECT a random row for each different Type
  83. Order by clause
  84. Order By Clause
  85. Data File in a Different machine on the network.
  86. Query Help
  87. Re: Taste this critical pack
  88. Creating a Stored Procedure from 3 queries
  89. Reasonably simple query question
  90. Desktop Engine and DTC
  91. AutoNumber
  92. Performance Complex SQL Issue
  93. Erro running a query if dashes present in the string
  94. Recordset Problem
  95. How can i get a return code of 1 for an osql command which has a lower severity..
  96. How could I do that (Query)
  97. SQL Server Replication and the growth of the subscriber log
  98. Duplicate records are being inserted with one insert command.
  99. Bulk Insert - Cannot perform SET operation.
  100. DEFAULT keyword performance
  101. Alter table permission to dbo
  102. Looking for physical design suggestions...
  103. sum() for textual fields?
  104. Concatenating a field while grouping records
  105. Two int fields or one varchar field
  106. SRV_DONE_ERROR
  107. DTS import renames my SPs to previous names
  108. Which one to buy?
  109. SQL 2000 Server Hangs...!
  110. Problems installing SQLServer 2000 Developer Edition on Windows XP Pro
  111. Strange database deadlock
  112. Am I being role happy?
  113. Bulk insert of long unicode strings
  114. Multiple selects on same column, same table, one query
  115. Query Performance Problem
  116. Question re: multiple joins
  117. How to Update with SQL EXISTS(?)
  118. To make an existing column become an identity column
  119. Unable to begin a distributed transaction
  120. Newbie Howto:Import, update, delete legacy data to SQLServer db
  121. Replication on SQL Server
  122. What is this ?
  123. Returning results while the query is executing
  124. Autonumber...
  125. How to set a User Variable within a DTS package...
  126. Deleting extra tempdb log and data files
  127. Convert Access Function to SQL
  128. Is there a High water Mark in sql server
  129. Obscure ODBC error Help!!!!
  130. Changing SQL Keys
  131. Database Books and Whitepapers
  132. Help!! SQL Server 2000 extended stored procedure hangs in Windows 98
  133. Request: Help creating a difficult view.
  134. Problems with partitioned views and pruning
  135. SQL Server 2K BackUp
  136. syntax for updatetext
  137. Cluster Database Failover Data in SQL Server?
  138. DTS automatic dat file import
  139. full text search and ampersand
  140. Getting database size: a stored procedure to do it......
  141. Using Stored procedures in a join
  142. Brainstorming: Ideas for categories database structure please
  143. getting table counts
  144. autogenerate numbers from 000001 to 999999
  145. Remote Database updates take long time to complete
  146. basic design question re effective relationship
  147. getdate() causes locks in views
  148. overflowing a local varchar
  149. Error in connectiong to second named instance of SQL Server 2000
  150. Please update your Virus checkers !!
  151. 2 group by in a single query
  152. MS -SQL Server 2000 -connection closes randomly
  153. When executing DTS package in program, the application will have no response during the execution
  154. Re: sp_msgetserver Returns no records (Should be sp_MSgetVersion)
  155. Re: career in SQL/Database administration
  156. SQL query suggestions/help
  157. Select multiple records into a table
  158. question about dummy constraint
  159. Many to Many to Many SQL Query
  160. How to get list (text) of all tables and columns?
  161. BEGIN TRANSACTION or BEGIN DISTRIBUTED TRANSACTION
  162. How do I select a column from sp_spaceused into a local variable?
  163. Delete duplicate records from huge tables
  164. Can "CREATE DATABASE" or "CREATE TABLE" be wrapped in transactions?
  165. Move LDF -Has anyone seen this happen?
  166. Course 2073: Programming a Microsoft SQL Server 2000 Database
  167. Problem with JDBC Driver for MS SQL Server
  168. Sum of Two Union Queries
  169. Combining Data from Variable number of tables
  170. SQL7 on Windows XP Home
  171. Adding staggered running total and average to query
  172. SQL Server Error: Exception_Access_Violation
  173. SQL Server does not exitist or access denied error
  174. Learning SQL Server
  175. DTSRun Encrypted
  176. One Statement Update - Join, no cursor ?
  177. SQL Resource Kit - dbgen - Database Generator
  178. Stored Procedures vs ADO vs T-Sql
  179. can stored procedure run more than 1 sql statements
  180. SQL Statement
  181. information_schema permissions
  182. Cube/Rollup without Group By?
  183. Please update your Virus checkers - SWEN-A is rampant - and I'm getting squillions of emails.....
  184. Log to big in SQL
  185. Problem with linking servers
  186. Date format export/import
  187. Force shutdown of SQL Server Instance
  188. Slightly Dumb Question about JOIN
  189. SELECT Top. Which method is best?
  190. money type problem
  191. Suggestions for a simple/introduction to querying OLAP
  192. Large table/slow query/ can performance be improved?
  193. Dividing two Count() Results
  194. cascade update / foreign key
  195. Transactions with remote connection
  196. Replication
  197. 2000 Personal edition install question
  198. stored procedure
  199. Newbie sqlserver update problem
  200. Stored procedure in database X, executes stored procedure in database Y, wrapped in transaction?
  201. MS SQL on the machine with multiple network cards
  202. JDBC with MSDE
  203. I can't create a temp table
  204. Replication
  205. Replication
  206. Jobs, DTS and OLAP
  207. Databse Offline
  208. add new record - weird results
  209. Problems running stored procedures
  210. Windows NT Logon Problem
  211. Multiple-step OLEDB operation generated errors
  212. Use Database
  213. Login failed - Catalog information cannot be retrieved
  214. Sql Server 2000 linked server to Access 97/2000 incompatability
  215. table structure problem
  216. How to repair torn page on SQL data file?
  217. Permissions Issue when linking to MS SQL 2000 DB from MS Access XP
  218. Invalid object name
  219. SQL Date Query
  220. Compatibility of SQL Server 7.0 with Windows 2K
  221. DTS run from .NET
  222. PHP mssql_connect(): Échec de connexion
  223. Trailing 0's
  224. Column encryption
  225. Keep a few connections open all the time or open/close connections on the fly?
  226. VB.NET Retrieving Identity form MSSQL2000 without using stored procedures
  227. Get the closest date
  228. trusted connection
  229. sql query help
  230. SQL 7.0 to SQL2K Migration including Jobs and DTS packages
  231. Deleting data by comparing to another table
  232. indexing question
  233. Find number of licenses
  234. how to get decimal to date form
  235. UNION statement doesn't work
  236. Pervasive SQL and Btrieve --> SQL Server
  237. ORDER BY earliest date in a row
  238. Key column information is insufficient ....
  239. Key column information is insufficient ....II
  240. Re: better - One large Tbl or 4 sub Tbls?
  241. parameter query
  242. ADO or ODBC Recommendations
  243. Help me create this Trigger
  244. prevent SP compilation
  245. Looking for query plan determination information
  246. HELP: SQL Server Won't Release Memory
  247. SqlServer 7.0 ODBC error when querying with order by
  248. User defined functions in SQL server 7.0
  249. DataDirect Server Wire vs. MS ODBC
  250. Blanks in ColumnNames causes ODBC-Error