PDA

View Full Version : Microsoft SQL / MS SQL Server



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

  1. Variable not read
  2. usage rate
  3. Query problem.
  4. Profiling Cursor Activity
  5. Arthimetic overfilow
  6. To catch date of the server in a Stored
  7. re-declare (re-use) a cursor in a stored procedure
  8. BULK INSERT exercises from exam 70-229 training kit don't work
  9. ALTER and UPDATE in store procedure
  10. Reversing Numbers
  11. system stored procedure
  12. Need an advice on 'declare cursor' statement
  13. How to I RANK my list?
  14. help with where criteria in sql statment
  15. Line Feed vs Carriage Return
  16. SQL Views and rounding ( * 1.0000000000)
  17. sysxlogins
  18. Where's my question
  19. Views
  20. cast problem -- int to varchar
  21. Client Handling
  22. How to Join...
  23. Update error?
  24. Passing arrays to SP
  25. SP vs. RPC ?
  26. SQL Server Service Packs
  27. CREATE TRIGGER [testtrigger] ON *
  28. User Permissions in SQL Server 2000
  29. DATETIME
  30. FOR XML containing HTML
  31. Your comments please..
  32. query on changing object owner
  33. To catch date of the server in a Stored
  34. install 2 instance in same directory?
  35. Cannot deallocate a cursor?
  36. JOIN/UNION question
  37. Corrupted db: How to restore log from a specific time?
  38. Handling Multiple Clients
  39. Eliminate logging while doing Bulk Insert
  40. Query Help, max(lastdate) user <> 'Master'
  41. Incrementing a value on a rolling basis
  42. Timeouts and Memory Leaks
  43. significant figures
  44. Choosing a column on the fly
  45. Alternative for T.O.A.D.
  46. Kudos to the gurus
  47. how to list all the file names in a directory in Stored Procedure
  48. how to list all the file names in a particular directory in Stored Procedure.
  49. Multiple Instances of SQL Server 2000
  50. sp_trace_setfilter
  51. Update field with other fields data minus one day
  52. Advanced SQL optimization[VERY LONG, BUT PROBABLY VERY INTERESTING]...
  53. Any of way Capturing/Listing CurrentActivity.Process Information ???
  54. Using web services inside TSQL
  55. Updating part of the text in an NTEXT field
  56. Comparing two tables
  57. Without cursor
  58. Which is Better
  59. DBCC Question
  60. Compare Date problem
  61. Error handling and custom error messages
  62. Database design confusion
  63. Sql Image Data
  64. DTS Error
  65. Query Timeout Problem
  66. RAISEERROR from within constraint?
  67. Apostrophe in a string
  68. Need Urgent assistance with a SQL Query
  69. SQL Query Assistance
  70. column calculations
  71. SQLMail with outlook and modem
  72. SQL Server - Alternate for First() Last() functions available in MS Access
  73. Best way to query a flat fixed length text file
  74. Question on triggers and special 'deleted' 'inserted' tables
  75. Replace .0
  76. Nested Queries
  77. Ban the cursor!
  78. Your comments please...
  79. Decimal to Hexadecimal Conversion
  80. Profiler Question (Stored Procedures)
  81. Need Query Help
  82. Create a system table
  83. resource low - Transact-SQL
  84. Tracking changes for web app
  85. Using a table from seperate database?
  86. HELP: SQL script to backup all databases
  87. Profiler Question (Scans)
  88. SQL subquery question
  89. cursor not fetching records properly
  90. Repositioning a Column
  91. data encryption in sql server 2000
  92. emailing from trigger
  93. update statement
  94. Generate Table script from query yzer...
  95. KB Articles
  96. Way out for Branch database
  97. Using Identifiers as Parameters in SQL server
  98. add serial number
  99. Diffgram in SP
  100. UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE
  101. match query questions
  102. Transaction Log
  103. Scaling problems with SQL Server
  104. Server 7.0 Performance and Activity -- KB Article - 286191...ATTN MS
  105. Why are some stored procedures assuming a system type
  106. %ls
  107. ORDER BY clause causes read-only recordset
  108. Look up Tables
  109. Way out for Back office
  110. Object property question
  111. Right Justified
  112. CREATE TRIGGER
  113. Error handling: our solution
  114. Query execution time?
  115. Select all the user table
  116. Stored Procedure Not Returning
  117. List numbers in sequential order
  118. Can it have dependences without a relationship among the tables?
  119. SQL-server-VB60: error on .recordcount??
  120. Joining Tables from different DBs => Do I have to care about performance?
  121. full text search
  122. communicate between xp_cmdexec and t-sql
  123. Stored Procedure Newbie Question --
  124. Need Web-Based DB Record Editing Tool
  125. Ordered Data Inserted into TEMP table, is Read out in Different ORDER??
  126. Removing Trailing Slash
  127. how delete 1 symbol in words!
  128. Query, Join on nearest
  129. Please give me some advices about my DTS+MSMQ solution!!
  130. SET IDENTITY_INSERT from OLEDB code
  131. Hexadecimal to Decimal conversion
  132. Detach database greyed out
  133. Execution Plan ysis
  134. ODBC Drivers and SQL Server Date Error
  135. Oracle RowNum Equivalent
  136. Sorting in SQL
  137. SUM() for current week
  138. string formatting
  139. How put an image in a table quickly ?
  140. JOINs in Views
  141. Date Format for other locale settings SQL Server
  142. Log shipping / data load
  143. How to store Date in SQL Server
  144. extended proc (dll) or activex ?
  145. How to store Date in SQL Server?
  146. Datawarehouse ?
  147. SQL Server 2000 SP3: Why is Table variable slower than temp tables?
  148. Extended stored procedure and Cursors
  149. Strange problem with delimited identifiers
  150. how to add attachments when sending mail using stored procedure
  151. Exporting Different Tables to Same Flat File
  152. Extended Stored Proc diff btw 7.0 and 2000
  153. dblib Assertion
  154. Date type
  155. Loking for car makes DB model
  156. view a query's SQL in VB
  157. How to merger tables?
  158. Transact-SQL Debugger
  159. MS SQL Views with cross join
  160. Why we do double work?
  161. how to pass in list and insert them one by one
  162. Viewing the event log
  163. SELECT to find items NOT common in a table
  164. find the free hard disk space
  165. How to select and then loop while insert
  166. Why are subqueries recongized as dependencies
  167. Joining on Null values
  168. Using Inserted and Deleted tables in Conjunction in a Trigger
  169. How to convert timestamp values to numeric (SQL70)
  170. Need Help in Stored Proc Syntax
  171. single quotes in select statement
  172. Minimum Distance Theory Question...
  173. Advanced Stored procedure
  174. Problem: Copy data from server 1 to server 2
  175. dynamic sql dropping and select into
  176. Error message in execution of a DTS Package
  177. DMO BulkCopy and trigger
  178. Disable Triggers On Update
  179. If statements in views
  180. Unique constraint
  181. cursor with insert/select
  182. ouput to printer
  183. Datetime Question
  184. shrinking database with sqldmo
  185. Strange date criteria.
  186. how to evaluate regular expressions from SQL Server 2000
  187. Urgent syntax question
  188. ScheduleTrasfer of data
  189. Problems with WHILE and PRINT
  190. DTS package failed on sql server agent
  191. Simple stored proc in query question
  192. Enterprise manager DTS just-in-time debugging does not work
  193. xp_cmdshell driving me nuts! Experts please help!
  194. Easy one..!
  195. Record Length
  196. I defined PK, how to restore original value for quality field
  197. Yahoo POP3
  198. Second Normalized Form..
  199. How to add an image into a database
  200. Triggering stored proc after number of rows or time expiry?
  201. Why do we do double work?
  202. How to re-set the pubs and northwind databases:
  203. SQL Server's 'form server'
  204. Getting column name in Select statement
  205. Adapt date from Oracle to SQLServer
  206. change cursor code to set based code
  207. How to restore the original value for a field
  208. Recommendations For A Good Start
  209. Stored Procedure Servers Error
  210. Store Procedure plus parameter where condition..
  211. concatenate text fields
  212. How to verify SQL service pack?
  213. Calling stored procedures from Access modules
  214. How to fill a table from a string
  215. User Defined Functions, and other stories....
  216. SQL Query for deleting duplicate records
  217. There is insufficient system memory to run this query.
  218. redefine 2nd question on my SP help needed???
  219. Passing null for select
  220. nText
  221. Hierarchies/Relational Division
  222. Import text file
  223. Date comparisons
  224. MSsql's alternative for MySQL's LIMIT command
  225. A question on UDF programming
  226. SET OPTIONS
  227. Select quantity from 2 tables
  228. difiiculties with ::fn_trace_gettable()
  229. proxy account for sqlagent setup
  230. DMO + Foreign Keys
  231. Entering a tab in a cell in the Enterprise Manager
  232. create views from parameterized stored procedures
  233. Table Size
  234. search with chinesse font in query ?
  235. Group by, count, type of query beyond my ability
  236. need help on a stored procedure
  237. Database Design Problem
  238. Update trigger problem
  239. query chalange
  240. index problem
  241. How to derive summary info from one single table..
  242. Crystal and Multi-statement Table-valued Functions
  243. Requesting help with complicated query
  244. Output parameter
  245. Stored procedure questions
  246. Table data type - thoughts?
  247. sp_OACreate permissions in SQL Server 2000.
  248. ODBC standard TCP port number!
  249. tell when the Stored Procedure is modified?
  250. Grouping in SQL server 7.0