PDA

View Full Version : Microsoft SQL / MS SQL Server



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

  1. About resultset paging
  2. Get Max date within same record
  3. Not enough storage is available to process this command
  4. Images
  5. BUG with LIKE and binary data
  6. Updating a column with another column
  7. how can I do this, in t-sql?
  8. Copy a table?
  9. How do I move a log file to another drive?
  10. Doozy: Stored procedure feedback during transaction
  11. Failure to obey ORDER BY
  12. MDAC 2.7a
  13. Matching data accross 3 tables
  14. Using a network drive to hold databases
  15. problem while connecting to sqlserver using application role with asp
  16. Insert/Update Trigger performing Updates
  17. Deleting Item, not Row
  18. SQL editor
  19. Something is wrong somewhere
  20. Pass table to StoredProc
  21. Syntax help
  22. Simple SQL database access with c++ code - bare bones....don't want to use wizard
  23. Disconnect users help.
  24. Error validating Formula
  25. problem with creating select statement and wildcards
  26. SQL Query
  27. Truncate table logging
  28. rollback transaction erro
  29. Selecting based on an Inclusive List
  30. Daily count
  31. Copying a file with sp_oa stored procedures...
  32. Updating TOP X rows ORDERED BY Priority
  33. MSSQL Utility?
  34. left padding with zeros
  35. IsZero(value, 1)
  36. Copying and moving files...
  37. using modulo function within query
  38. error 19 and 21
  39. Put in priority order
  40. How do you set a value to a stored procedure result
  41. Select Left Join AND Right Join
  42. dbcc traceon(1204)
  43. Multiple joins, aliases and column names
  44. Converting a varchar to money
  45. sort field in View
  46. Creating a temporary table with a varying number of Columns
  47. How can i rewrite this?
  48. CASE STATEMENTS
  49. Scheduled Job to create the schema
  50. Book Recommendation Needed
  51. Need some help on a SELECT statement
  52. Dates and times
  53. Net Send
  54. Cannot start more transactions in this session
  55. Indexed Views
  56. Inconsistantly slow query
  57. desactivate trigger
  58. WriteText, UpdateText etc...
  59. to create a xml file once I have the hdoc handle
  60. How to SPEEDUP QUERY EXECUTION?
  61. Can't use parameters in OPENDATASOURCE
  62. Complete word queries?
  63. A better way to hold column titles in separate table?
  64. Wrong query result when using join
  65. Importing data from JD Edwards into SQL Server
  66. Query yzer adds extra space/newlines
  67. How to import data from web site
  68. Error: "Syntax error converting the varchar value..."
  69. how to use userdefined datatype in UDF?
  70. simple stored proc help...
  71. TimeStamp
  72. ADODB Cmd with DSN
  73. IF, THEN, ELSE statements
  74. Date from datetime
  75. Problem with IS_MEMBER and integrated NT security
  76. Cursor
  77. from oracle (pl/sql) to sql server (t-sql)
  78. Help creating a Stored Proc which turns data from one row per day to one row per week
  79. how to find out max group count
  80. TSQL to find SQL server Service accounts
  81. Need help with openxml
  82. Looking for an experimental challenge?
  83. Automatic database restoration
  84. Transact SQL question
  85. bad chars not escaped by FOR XML EXPLICIT
  86. Date Time?
  87. how to declare a static var in UDF?
  88. Deletion of multiple records
  89. SQL Rounding to 6 decimals instead of 8
  90. East sp question for the experts
  91. use extended procedure without cursors
  92. Cascade Deletes
  93. Simple Stored Procedure query
  94. Column property changes.
  95. SQL Server Update Trigger
  96. Having Problems Returning Data from Sql to a Web Form
  97. getDate() vs {fn Now()}
  98. Need a field whose value references another value
  99. Enum/Increment a fld with SP instead of VB?
  100. truncate log
  101. Dynamic SQL to change databases
  102. T-SQL Function optional parameter ???
  103. Trigger + UpdLock
  104. CPU Spin on dual Xeon CPU's.
  105. Truncate log while server is running
  106. Checksum Algorithm/Collisions
  107. sql server batch update failure
  108. sqlstate21000 error 512 (again)
  109. Using XP_CMDSHEll with SQL Server Agent
  110. sqlstate 21000 error 512
  111. stored procedure and resultset
  112. Help about Query
  113. Schema info using ADO
  114. XML and NT Fibers
  115. Copy a table
  116. Which columns are returned by a SP ?
  117. Errors That stop execution of SP.
  118. Question of 70-229
  119. SP_INDEXES ERROR
  120. Top X WaitTimes by Division
  121. Where to put a WHERE clause
  122. Returning Tables
  123. Does the column exist
  124. WRITETEXT etc to import files into image field
  125. SET IDENTITY PROPERTY OF COLUMN?
  126. Retrieving data from sql server to excel in vb.net
  127. sp_executeSql
  128. Select Statement Help Please
  129. Query yzer editor issues
  130. To Anith - calculate the time
  131. Missing Sourcesafe Icons for Stored Procs in Interdev
  132. Triggers and Users
  133. Math in ORDER BY?
  134. SQL Profiler
  135. New release for DB
  136. CharIndex Problem
  137. Uninstall SP3 from MSSQL
  138. Deadlock problem
  139. Statistics
  140. Between Todays Date
  141. how to get the filename using Active X script
  142. TRIGGER not called when it should
  143. Recursive Function
  144. Exception Level 19 Error While Debugging
  145. How do I get the index in an insert?
  146. how to write FOR EACH ROW trigger?
  147. Page locks
  148. Simple syntax help
  149. stored procedure syntax help
  150. Single quote (') problem in SQL Server query
  151. Cannot trap error returned by stored procedure in SQL Server 2000: Suggestions?
  152. CASE (x) when NULL doesnt work on OUTER joined fields?
  153. dates in a column
  154. UserDefined Fuctions and SQL
  155. trademark and registered characters
  156. How to combine date strings with text
  157. Replace Spaces in field data with underscores
  158. SQL statement to replace spaces between words with underscore
  159. New to Stored Procedure my Insert SP is doubling
  160. XP_CMDSHELL - JOb Schedule
  161. SQL statement to skip the whitespace?
  162. Count problem
  163. Database Design
  164. SQL Server 7.0 & Enterprise Manager
  165. Is it possible to query a prior query?
  166. select a number of rows in a table
  167. Select the rows which are implicated in an not committed update command
  168. error not trapping errors?
  169. SP_OACreate
  170. Windows 2003 WEB Edition?
  171. SP returned recordsets
  172. Stored Procedure Help
  173. installing evaluation SQL sever 2000
  174. Do I have this right?
  175. Summing time......
  176. create data with "sa" owner
  177. Timing a sql statement - with profiler
  178. Extending client to access Excel files (most data still in SQL Server)
  179. Copy data into same table
  180. Avoiding large queries...
  181. Attaching and Detaching databases.
  182. Diabled Triggers
  183. BUG: certain characters up QA display
  184. Working Definition of 3rd Normal form
  185. TO SAVE IMAGE IN SQL-2000
  186. managing DB schema with VSS
  187. Select Statement Question (Again)
  188. Create random string
  189. how to join a set of fetch into one output
  190. SQL Server 2k Developer Edition in Windows XP pro
  191. Capturing queries sent to SQL Server
  192. Iterate without a Cursor
  193. Filtering
  194. Country table and International Dialing Codes
  195. ERR: OLE/DB provider returned message: Timeout expired
  196. SQL7 Views and INSERT
  197. merge record
  198. Thanks Works now.
  199. Select Into and Trigger on Destination table....
  200. Partitioned View Question
  201. SysAdmin privileges to run DTS Packages with SP3?
  202. ActiveX control for copying file in DTS
  203. Microsoft Cursor Engine - Insufficient base table information for updating or refreshing.
  204. Just a quick SP ? regarding the LIKE SQL keyword
  205. Question about 'image' data type in SQL Server
  206. Ooops, I did an UPDATE and made a mistake on 1300 records
  207. format number into currency format ($1,000,000.00)
  208. Cleaning Data for Load
  209. How to get hexadecimal values into varbinary columns?
  210. Fully Qualified Name Components
  211. calculate the time
  212. Display datetime value as date only
  213. Updating an 'archive' database
  214. Problem creating objects not as dbo
  215. error: String or binary data would be truncated.
  216. What is the difference with or without ON [PRIMARY]
  217. Insert With Identiy
  218. HOW TO - Import all Access tables into an existing SQL Database
  219. Convert index to clustered
  220. select top question
  221. Accessing an alternate SQL Server within a proc
  222. minimum query memory
  223. newbie question : Mid()?
  224. Break all connections
  225. help with sp_who
  226. Sp_OA
  227. Data Junction?
  228. createparameter ntext
  229. Best way to filter?
  230. (Stored Procedures) Can't get one table to move contents to another
  231. Accessing Temp Tables
  232. Timing a sql statement
  233. Store files in DB
  234. Case Sensitive
  235. HTTP access *FROM* SQL sp
  236. Collate
  237. => Recordset value in ADO
  238. sp_OAMethod
  239. date range query
  240. alter table/tables
  241. Help with linked server qry (error doing delete!)
  242. Text output - useless option?
  243. Changing image type to ntext via ALTER TABLE
  244. Using COUNTand SUM in a select
  245. Converting image type to ntext
  246. How to trace xid of X/open Transaction
  247. Query Optimizer Problem with Views in where Clause
  248. Sybase to MSSQL conversion Looping
  249. Optimizer Problem in Where clause in View
  250. Why not simply WHILE FETCH_STATUS = 0?