PDA

View Full Version : SQL Server


  1. Calculating StDev in SQL 7
  2. Help with sp_executesql
  3. Simple way to determine the number of days in a month for any given date
  4. asp / sql server dates in recordsets
  5. Setting column length in sql ?
  6. Update Query Problem
  7. Record count begin with big number
  8. Query Help Please.
  9. SET QUOTED_IDENTIFIER OFF
  10. Lock hint question
  11. Using MDX to find an average for leaf members on rows...dynamically
  12. Value of a record based on a previous record
  13. Business Objects and Microsoft Reporting Services
  14. Truncate Table vs. Drop Table
  15. Re: String / Variable Problem - Dynamic Table Name
  16. Fast way to get values from previous record
  17. Scheduled report for database names and sizes
  18. EM DTS Designer ODBC source as a file DSN doesn't work!
  19. {fn CURDATE()} inside stored procedure
  20. Stupid Problem - Please help
  21. Stupid Problem - Please help
  22. Monitoring Tools.
  23. sysjobhistory in SQL 2000 Server
  24. Help - With Script
  25. Multiple instances ready for Production prime-time?
  26. Extract a string in a Stored Procedure
  27. automatic number problem
  28. Whats better?
  29. SQL 2k Sp3 q from Newbie - "Select" clause
  30. Re: how to lock the store procedure and allow one process to acces
  31. how to lock the store procedure and allow one process to acces it at a time
  32. sql 2000 licenses
  33. Upsized ACCESS Database to SQL Server 2000 with AS/400 Link
  34. BACKUP failing!!! HELP!
  35. SQLServer 2000 JDBC /SQL Exception Error Messages - Meaning?
  36. Performing a query using two tables
  37. How to backup up Win2K and SQL server
  38. toad for sql server
  39. Problem restoring SQL Svr 2000 Master db - wrong server version?
  40. Re: Joins on same table .. solution with Temps
  41. Joins on same table
  42. Way to view all stored procedures
  43. Re: subquery performance mystery
  44. Re: Assign records to Analysts
  45. UPDATE values from an array?
  46. Trapping errors
  47. Restoring database
  48. Query Analyzer question
  49. ado "sql authentication" connections affected by loss of domain controller
  50. complex security on SQL 7
  51. Beta testers wanted for new "blueshell Data Guy Professional"
  52. tracing sql from code
  53. Getting rid of DOUBLE SPACING!!!
  54. TABLE Variables
  55. How to do this update?
  56. Data for source column is too large for the specified buffer size...
  57. Opening Mulitple Recordsets
  58. Delete trigger in SQL Server 7
  59. 2 query question...
  60. MSSQL Server accounting
  61. Stumped. Totally... (but there must be a way!?)
  62. converting rows to columns
  63. Path to a "personal knowledge database"
  64. Make MS SQL Server case-sensitive
  65. Calling user-defined function without 'dbo.' -- possible?
  66. joint venture
  67. Replication solutions?
  68. Re: Accessing Active Directory using SQL Server 2000
  69. Script Question
  70. A cursor with the name 'deadrow' already exists.
  71. Production release methodology
  72. delete child table rows based on predicates in a parent table
  73. Registry key setting for MS SQL Server
  74. Odd syntax error with shape queries SQL2000/Win2003
  75. how to bring back a list of duplicates from a column
  76. Insert Question
  77. COALESCE as a Performance Enhancer??!?
  78. Creating a diary - structure problems!
  79. How to parse a string column with comma delimited
  80. Urgent Help Needed!!!
  81. Newbee
  82. Stream size limitation
  83. Encrypting data within the DB
  84. Pls Help: can't connect to server - login fails
  85. Only enable the string truncation prevention of ANSI_WARNINGS
  86. Append Query Problem
  87. Re: DTS from SQL Server to DB2
  88. Error reading password-protected FM in SQL Server
  89. changing default values
  90. How To Get 1 Million Visitors
  91. problem with a simple check
  92. Stored Procedure Syntax Problem
  93. Read SP source code from VB
  94. Nested
  95. Newbie SQL Grouping Problem
  96. HELP - SQL Server Crash ? Memory leak ?
  97. Bol error
  98. performance degradation on data transfer
  99. Problem with .mdf File
  100. MSDE questions.
  101. Passing an IN (a, b, c) list to a sproc as a string -- best method?
  102. SQL DB move from one storage subsystem to another subsystem
  103. SQLExecMS ver 2.1 has been released
  104. How can you tell what the primary key of a new row will be?
  105. Creating a Script out of Sample Data
  106. locks preventing backup of database
  107. Small Business Server 2000
  108. Tricky grouping query
  109. DTS package problem
  110. Filtered out code
  111. Finding the port the MSDE is running on --
  112. Question regarding Stored Procedures, Views and ASP
  113. Help with file placement please...
  114. Invalid Cursor State Error
  115. Re: Very Big Table Problem
  116. Automatical table update within a database
  117. Stored Procedures With VB
  118. Syntac error (missing operator)
  119. Re: internalization of (generic) application layer software to the database TSQL
  120. windows authentication
  121. can you, by default, allocate uniform extents upon creation of index/table?
  122. Assistance with Stored Procedure
  123. Maintaining Variable After EXEC
  124. Question on SQL Installation
  125. missing tables in sysobjects
  126. Checking all views for errors after upgrade
  127. mssql$microsoftsamdm
  128. exec(select...), how supress the output?
  129. Problems with DTS package. Access denied
  130. condition with group by
  131. Comment on Replication
  132. Re: Stored Procedure Syntax
  133. MS-SQL Script Question
  134. Normalization connundrum
  135. Pricision of float
  136. Wildcards in SQL Server stored procedures
  137. Logon time looks faulty
  138. sql server does not exist or access denied
  139. error 1069
  140. Problemer med en DTS-package
  141. Re: Tricky schema question - dimension can split and combine over time
  142. Need help regarding index keys for MS7 and MS-2K
  143. Force Row Level locking in SQLServer 2000 ?
  144. Re: Deadlocks workaround?
  145. Re: how to select max amount rows
  146. Re: Deadlock Question