PDA

View Full Version : Microsoft 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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118
  1. installing SQL server, no features to be selected
  2. First & Last records in a group
  3. Can STWithin or STContains be used to update columns based on point within polygon re
  4. how to solve error 40 on MSSQL 2005 ?
  5. problem filtering
  6. Failed to open attachment file
  7. One to Many Relation ( Sql Server Back end )
  8. Script
  9. PIVOT query
  10. Want to insert from two tables into a single with a hard coded value
  11. Help w/reducing redundencies in XML output
  12. locating duplicate records in a table
  13. Question abt reading from SSIS Flat file source
  14. Select Query
  15. Checking lock granualrity in SQL Server
  16. Checking for deadlock over last period of time
  17. How to convert this date
  18. What's wrong with my case statement?
  19. Replication - Several Transactions Occurring
  20. Massive index size
  21. Sql query to pull certain row
  22. Database 'X' cannot be opened. It is in the middle of a restore while activating SB
  23. Dense / Spares Indexes
  24. License question
  25. How do i log the SQL server sessions?
  26. installing 2008
  27. Excluding data for certain criteria only
  28. The question about System Catalog
  29. Delete Duplicate Records-without primary key
  30. sql complex query
  31. sql server count of
  32. Help with same row values from subquery
  33. connect to MS SQL via Solaris (using OLE DB...)
  34. An INSERT EXEC statement cannot be nested
  35. Complicated SQL query
  36. convert codepage 1252 to 65001 (UTF8)
  37. can't connect an SQL 2000 Instance from Win 7 with enterprise Managerq
  38. Capture Database & Server Name in a Derived Column to identify source of data before
  39. Filtered Where Clause
  40. SQl Security - Check for specific data
  41. Query help, common rows, simple?
  42. Sum Question
  43. Random Behaviour with JOBS
  44. NPI Download Files from CMS
  45. Date format issue
  46. Smart Card
  47. Smart Card System for new building
  48. Sql Server Tuning
  49. [ANN] ODB C++ ORM 1.8.0 released, adds support for SQL Server
  50. Running an automated procedure to email when event is 14 days away
  51. Slow ADODB RecordSet MoveNext
  52. Grouping Help
  53. Display Duplicates which have a different state
  54. How to know if SQL server is still in Evaluation ?
  55. Adding a child Table
  56. Good Beginner Book For SSAS?
  57. Convert Help Please!
  58. Advice on how to combine date and time into one field
  59. Exclude if returned value is 0
  60. User Interface for Web DB
  61. Finding the highest current number only for an increasing range
  62. ORDER BY and UNION together again!
  63. Stored Proc insert - multiple tables
  64. Accounts to use for replication
  65. Any equivalent of runstats()
  66. Finding out physical size of table
  67. Changing a date
  68. retrieving only 50 chars from a detail table
  69. Another DB design question . . .
  70. How to add data to column
  71. sql server procedure
  72. Moving Postgresql to MS SQL?
  73. Filtering Alias Column
  74. sqlserver non clustered index row locator
  75. Help understanding query results
  76. Adding Info
  77. BCP out
  78. MS SQL to clean XML
  79. Sql Help(Update)
  80. Best practice to update a table
  81. Table Partitioning - MERGE RANGE deadlocking
  82. merge transformation in ssis
  83. Copy Wizard utility
  84. Ftp task
  85. keep duplicate with highest score fuzzy grouping
  86. Loop through table
  87. how to present utf8 in sql server 2008?
  88. How to cast a Varchar column to DateTime
  89. HELP!!-Y am i getting this error?
  90. SQL Spatial - All object between the coordinates
  91. Store Procedure Help
  92. Execute Stored Procedure Via Batch File
  93. Help with MSSQL and VBS
  94. Sense-checking request
  95. SSRS Report toggle feature hanging VS2008 IDE
  96. Convert Column value to Row
  97. Need SQL Help
  98. Installing SQL Server 2008 R2
  99. Join into new data
  100. Join into new data
  101. Finding all the SQL for a particular Session
  102. Getting session information
  103. Rotate view
  104. Is the following possible through SQL?
  105. need help with decrypting a table encrypted with EncryptByKey
  106. .bak size increase each time you replace the .bak with new .bak ?
  107. Setting up a read only user
  108. Hierarchy sql query
  109. Insert multiple rows with a trigger that invoke a function
  110. adding values to columns
  111. Join help
  112. How do I update the SQL Server 2008 to include the studio?
  113. hresult e_fail error in ssis
  114. Designing a date-dependent table
  115. back-up script
  116. Sending database to another person/computer
  117. ssis query through variable
  118. Query that joins two tables and retrieves a sum
  119. Compare time difference action
  120. IRR Function - Issue comparing results between systems
  121. Need help retrieving highest paired value
  122. error: user not associated with a trusted SQL Server connection
  123. ssis expression through variable
  124. How to Create a New Partition on a Cube using T-SQL in SQL Server 2000?
  125. Normalization and Query Performance
  126. whats wrong in this code ?
  127. BCP Password Issue
  128. Analysis 2000 - Migration issue
  129. ssis flat file header issue
  130. how to make a sql script that will restore by backup database ?
  131. Ignore Prefix
  132. Selecting into XML format
  133. Merge Replication - Phantom Conflicts
  134. Accessing a Report Server Url when SSRS is configured for SharePoint Integrated mode
  135. Oledb source query through expression
  136. Convert varchar to float, decimal
  137. Setting in ssrs server to ignore default timestamp 12:00:00 AM
  138. Updating Date in SQL Query (Excel Connections OLE DB Query)
  139. Send Mail Task Failing in DTS Package
  140. Cant connect remote after Update?
  141. SQL Update Join
  142. installation of SQL Express 2005 on windows 7
  143. Union returns duplicates
  144. Need Help on Store Procedure to generate Custom ID for each Asset
  145. can not connect to database engine
  146. Problem with ssis variables
  147. Help-Obatining 2nd last record
  148. help with CONTAINS syntax
  149. Transaction (Process ID 65) was deadlocked on lock resources with another process.
  150. Indexes on views
  151. Pivot, Case, or ???
  152. Selecting IF?
  153. Must be a better way of producing a summary table
  154. Checking all tables that have a specific column name?
  155. connect sqlserver with power builder
  156. Domain model
  157. Re-construct 4 tables into 1 table and sort Fraction value [Question]
  158. view multiple records in a single row
  159. getdate() mystery
  160. IDENTITY_VAL_LOCAL() in sql
  161. LinkedServers
  162. Is there an easy way to calculate a range bar from (stock) tick prices?
  163. Implementing Policy based, time based and customer based pricing
  164. SQL Help with Many to Many Table
  165. How to move a Batch file using T-SQL in SQL Server 2000?
  166. Reset table field value to 1
  167. read xml node elements using sql query
  168. SQL Server 2008 - Import formatted word doc
  169. Please Help
  170. column wise data to row data wise data in sql
  171. Loop through Different Objects in a Database ?
  172. SQL User Instance - close open connection after attach a database
  173. Privilege
  174. How to fix Violation of PRIMARY KEY
  175. update difficult
  176. Help with Query
  177. Trigger does not execute
  178. trigger to Insert records in the same table
  179. Difficult Query
  180. A question regarding SSIS
  181. Rating - calculate or save
  182. who created table
  183. Create My "Own" SQL
  184. How to learn?
  185. Need help to solve a T-sql query.
  186. Split long text without cutting words
  187. Counting orders where customers purchased 1 item, >1 same color, >1 different color?
  188. Look Back Through Records to Apply Funds Appropriately
  189. Real easy one - list the constraints
  190. Monitoring SQL Server
  191. How to connect to sql server under unix by c
  192. LIKE query using nvarchar(MAX) field
  193. 'Index' Problem
  194. tricky query
  195. Execute within single ticks
  196. SqlServer 2000 stop working after few hour
  197. How to Convert a DB2 'Date' Datatype to a SQL Server 'DateTime' Dataype?
  198. Searching by ignoring special characters
  199. SQL Migration
  200. how to truncate just a column ?
  201. Beginner question about insert into table
  202. reporting services (SSRS) with SMTP authentication
  203. MS SQL License
  204. Differentiating between two Schemas
  205. Exporting yourdatabase to SQLServer commands
  206. Compatibility Level 80 to 90
  207. mobile database file
  208. how to insert and retrieve data from .mdf file
  209. is it good choice to choose ms sql as database for the asp.net shopping cart ?
  210. Help with SQL
  211. Minus # of months
  212. Duplicates in Select Statement
  213. Calculating Time Difference between two different dates
  214. Problems using DISTINCT?
  215. Update Column with % of total for each row.
  216. problem while retrieving data from the db
  217. Pivot one more than one column...
  218. hw to recover a dropped table
  219. Importing a Database
  220. Return Result Set from Stored Procedure
  221. Getting The task reported failure on execution error while executing a DTS package.
  222. how to solve this problem ?
  223. how to change the date format to dd:mm:yyyy ?
  224. how to sum all the salary in a year ?
  225. Incorrect Syntax near '/'
  226. CHECK Constraint question (easy)
  227. Interval Type
  228. Display Distinct Records question
  229. ERROR : Invalid input parameter values. Check the status values for detail.
  230. Audit Trigger in stored procedure
  231. license limit of 4096 MB
  232. SQL Querying issue
  233. Subquery returned more than 1 value
  234. active transaction tables.
  235. getting previous reults even afetr a successful transaction.
  236. Return Value Woes
  237. Lost on how to write this query
  238. mixing isolation levels
  239. Help me with a code, please
  240. hw to spellout number into character
  241. Fulltext Search DB Guru's please help!
  242. Security Vulnerabilities of SS2008 in SS2000 Compatibility Mode?
  243. sysdtssteplog in MSDB
  244. fulltext issue after upgrading sql 2005 to 2008
  245. Display another value
  246. Select next available range
  247. How to pivot this case (in MSSQL 2000)
  248. SQL Server 2000 - Replay traces
  249. Need sql query to filter alphanumeric data
  250. why this query throws an error ?