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