PDA

View Full Version : microsoft.public.sqlserver.programming


Pages : [1] 2 3 4 5

  1. Whats the wrong with this Query? (3 replies)
  2. SQL Native Client as DSN not able to access temporary tables... (0 replies)
  3. Creating a User Defined Aggregate Function (2 replies)
  4. Trap error on Full text catalog search (0 replies)
  5. Re: Using SQL Server 2005 - SQL Native Client as DSN throws up errorwhile inserting values into temporary tables in the application (0 replies)
  6. Scheduling A Stored Procedure? (2 replies)
  7. cancel update if no column has changed (1 replies)
  8. Can not update remote table??? (1 replies)
  9. server side cursor created by jdbc (2 replies)
  10. Sub Query faster than inner Join? (3 replies)
  11. Script for inserting incremental unique values ? (4 replies)
  12. Multi Record Insert (1 replies)
  13. help needed in writing a recursive function (6 replies)
  14. how to update identity values (1 replies)
  15. Re: normalizing data warehouse (0 replies)
  16. Query on SQL Server 2005 (2 replies)
  17. SELECT statement question (LEFT JOIN) (1 replies)
  18. Stored Proc (2 replies)
  19. Help with strings (2 replies)
  20. Configuring SQL Server Express 2005 for Remote Access (1 replies)
  21. XP_CMDSHELL (7 replies)
  22. Updating a view ... (SQL Sever 2000) (9 replies)
  23. Using Replication (0 replies)
  24. Update Query Returns -1 Represents ? (4 replies)
  25. Building View Dynamically .. Need Help! (5 replies)
  26. Problems with a SP with a Temporary Table in .NET (0 replies)
  27. How to delete Duplicate records from table (0 replies)
  28. Re: Newbie:UNION with SELECT TOP (9 replies)
  29. Re: Calculation in sql (0 replies)
  30. Re: Scripting foreign key relationship on a table (0 replies)
  31. Re: DTS to Access mdb - updates only (2 replies)
  32. Re: Preparing db for update of 200K records... (3 replies)
  33. Re: historical lookup query (0 replies)
  34. Re: Criteria = Most Recent Date? (3 replies)
  35. sysdtssteplog not updated (0 replies)
  36. MS SQL 2000 Query Help (5 replies)
  37. SELECT question - need help (3 replies)
  38. Sql Query (3 replies)
  39. Subscription error: The report is using user defined parameter va (0 replies)
  40. still problem with image (6 replies)
  41. DTS Connection Properties (0 replies)
  42. random numbers of param (12 replies)
  43. Combining archive tables into a single table (7 replies)
  44. TSQL Debugger Oddity (8 replies)
  45. Re: Is it not possible to use UPDATE within a function? (3 replies)
  46. Re: DB design question. (1 replies)
  47. Re: Update questions (0 replies)
  48. multiple databases for multiple days (8 replies)
  49. Automated Table Updates - Strategy Assistance Requested (1 replies)
  50. CHARINDEX is not working (7 replies)
  51. Re: SQL Server 7 and SQL Server 2000 SQL QUERY (3 replies)
  52. Whats Wrong with the Query? (9 replies)
  53. Same process ID, multiple times (4 replies)
  54. char vs. varchar (4 replies)
  55. explanation needed - DECLARE CURSOR (2 replies)
  56. Syntax error converting datetime from character string. (3 replies)
  57. Login Failure with Linked Server (4 replies)
  58. CREATE VIEW w/ UNION (3 replies)
  59. RE: Script to delete all objects (0 replies)
  60. RE: Date Logic for a DTS package (0 replies)
  61. Status control of SQL Server Agent jobs (7 replies)
  62. Re: How to detect sql servers on the net (3 replies)
  63. Date from datetime ... (7 replies)
  64. Looping Query (7 replies)
  65. SQL Execution Error: Cannot call methods on int (7 replies)
  66. one column causing duplicate rows - wrong join used? (4 replies)
  67. EXISTS with EXEC (2 replies)
  68. Design: multiple columns for primary key (10 replies)
  69. Getting an unused number from a set of numbers? (17 replies)
  70. Database files (VS 2005) - usage? (4 replies)
  71. attach db with a deleted log (1 replies)
  72. I was wondering if.... (0 replies)
  73. SQL Query Help (0 replies)
  74. Design: bit on or off? (3 replies)
  75. WHERE clause 'SET' (4 replies)
  76. compatible ntwdblib.lib FOR ntwlib.dll in SQL Server 2000 SP4 (2 replies)
  77. Connection string for 1 server and 2 databases (1 replies)
  78. Help with value (3 replies)
  79. Determining Roles from Windows Authenticated Login (0 replies)
  80. ReCompileReferences using System SP? (2 replies)
  81. global temporary tables (2 replies)
  82. DEADLOCKS (1 replies)
  83. Size of a row (9 replies)
  84. How to get rowid of uncommitted record (5 replies)
  85. Newbie: Timeout On IN statement (11 replies)
  86. Inserting dummy lines and padding (2 replies)
  87. Connection Problem with Remote Server (1 replies)
  88. CLR Question (BASIC) (3 replies)
  89. Merging tables (3 replies)
  90. Finding the 2005 migration quite challenging (6 replies)
  91. Help developing this project. (15 replies)
  92. IDENTITY and Backup/Restore (4 replies)
  93. Endian problems with converting to varbinary (6 replies)
  94. SQL Agent Mess (1 replies)
  95. query help - "Most Helpful Review" idea (8 replies)
  96. CopyFile in DTS ActiveX Script Task (1 replies)
  97. Transfer Table Relationships (1 replies)
  98. need output where same column has more than one pirce of data (7 replies)
  99. Ole object to illustrate the Enterprise manager VIEW designer in a WORD document (1 replies)
  100. The weirdest SQL problem you'll ever see. (9 replies)
  101. running stored procedures from SQL Agent (12 replies)
  102. Differences between DISTINCT and GROUP BY? (4 replies)
  103. SQL Server index low cardinality columns (10 replies)
  104. weekday or Weekend (2 replies)
  105. Formatting numbers (6 replies)
  106. Excel file import to Sql Server problem (1 replies)
  107. Find SQL solutions with free eBooks. Search the ebooks NOW. (1 replies)
  108. Free MCAD/MCSD ebooks online (0 replies)
  109. SQL Server and Time Zome (12 replies)
  110. Recover the data (2 replies)
  111. Re: store image (8 replies)
  112. order of columns in composite index (4 replies)
  113. SP clause - where (field = @Param or @param is null) is this fast? (20 replies)
  114. unaccountable result for select (4 replies)
  115. Administrative Tasks (2 replies)
  116. queries filling up logfile (3 replies)
  117. Any performance issues if we use BigInt (5 replies)
  118. Help with SQL Function (2 replies)
  119. SP and Triggers: object permissions (4 replies)
  120. Re: Delete invalid Details (0 replies)
  121. Re: Delete Duplicate Record (0 replies)
  122. Debugging CLR Objects (2 replies)
  123. convert a datetime (8 replies)
  124. Can truncate but not delete (11 replies)
  125. Run Dll In Stored Procedure (3 replies)
  126. Re: Select a specific range of results (1 replies)
  127. Query Analyzer.. (5 replies)
  128. How to protect data in table? (1 replies)
  129. views based on parameter view (7 replies)
  130. Table Owners (1 replies)
  131. Trigger needs to join multiple tables to validate entry in table. (7 replies)
  132. dynamic sql string too long (7 replies)
  133. how to save a rtf file into a field (2 replies)
  134. Newbie sqlserver question... (8 replies)
  135. Use of AVG function to update records (4 replies)
  136. Update null records (4 replies)
  137. Visual Basic + SQLServer + CommandTimeout (4 replies)
  138. Problem with order by clause (2 replies)
  139. INSERT - dynamically specifying DEFAULT for a column (6 replies)
  140. Joining multiple tables in a view. (1 replies)
  141. Insert into (leaving certain) fields out (3 replies)
  142. adding column vlaues with one another (4 replies)
  143. Enable/Disable Triggers? (6 replies)
  144. I bet this is simple, -But see if you can help. Hard to come up with Title -Have a look (3 replies)
  145. Query behaviour - (subquery results) (6 replies)
  146. On delete cascade (3 replies)
  147. Speed Up (2 replies)
  148. speed Up (4 replies)
  149. searching large fields (3 replies)
  150. xp_cmdshell (1 replies)
  151. suser_name() (3 replies)
  152. Function to seperate comma delimited db field into new table (3 replies)
  153. SP to write to a Formatted Flat File (7 replies)
  154. Determine Table's PK Columns (3 replies)
  155. SQL 2K, logging procedures execution (5 replies)
  156. How do you force the server to store only the text entered (3 replies)
  157. Call Stored Procedure within a SELECT statement (8 replies)
  158. Restore Database (3 replies)
  159. Order By ignored in query participating in Union All (14 replies)
  160. Insert maximum integer value if it is exceeded (3 replies)
  161. Querying information_schema for check constraints (1 replies)
  162. Are these two statements equivalent? (2 replies)
  163. FOR XML return as a Scalar (7 replies)
  164. Help on the last updated date (5 replies)
  165. SQL Monitoring Tool (5 replies)
  166. Passing Cursor as SP output parameter (4 replies)
  167. xp_smtp_sendmail weird behavior (2 replies)
  168. Excel file import problem (2 replies)
  169. error processing (0 replies)
  170. Filling in date records (3 replies)
  171. Is this an efficient way to return a comma string (2 replies)
  172. Need replacement for sybase list aggregate (4 replies)
  173. Variable not passing parameters (9 replies)
  174. selecting from DBCC SHOWCONTIG (1 replies)
  175. Getting the physical directory that the log file is located (10 replies)
  176. CC and SSN encryption (8 replies)
  177. Loading 150k AD user objects into SQL2005 (0 replies)
  178. maximum column_name length (2 replies)
  179. Accessing Second Record Within Query (1 replies)
  180. SQL Query help. (2 replies)
  181. BCP copies only Integer data (5 replies)
  182. Relationship map using CTEs (1 replies)
  183. size of the resultset (1 replies)
  184. from clause (2 replies)
  185. Multiple Step Stored Procedure (9 replies)
  186. question about dealing with deadlocks (4 replies)
  187. returning counts of different fields when only one has criteria (2 replies)
  188. Configuring SQL Mail (3 replies)
  189. duplicate column data (4 replies)
  190. How to refer to calculated field ? (15 replies)
  191. SSIS Packages (1 replies)
  192. dumb sql mistake or SQL Server error? (9 replies)
  193. what is the best way to update data (5 replies)
  194. Restore - Change Logical Name (8 replies)
  195. joining 2 tables onto one (9 replies)
  196. case statement TSQL (3 replies)
  197. Understand N'___' (3 replies)
  198. Transactional Modification (3 replies)
  199. @@ERROR per connection? (6 replies)
  200. Transactional Modification (4 replies)
  201. [OT] User-Defined string Functions Transact-SQL (0 replies)
  202. help Simple question (1 replies)
  203. Advice on Simple Structured Sql Query (Search) (1 replies)
  204. Query Result in Cache? (2 replies)
  205. How to pull query data from two databases? (5 replies)
  206. Number of lines of code in a SP (6 replies)
  207. distinct query (1 replies)
  208. Create Duplicate of table ? (3 replies)
  209. Auto Commit (7 replies)
  210. deploying CLR objects best practice (1 replies)
  211. Problem With Case Function (3 replies)
  212. SQL Server Agent JOB failed while Query anlayzer success (4 replies)
  213. which is most efficient? variables vs. nested select (8 replies)
  214. code information for unused indexes in sql server (4 replies)
  215. Simple Erntr - Invalid Object (3 replies)
  216. Getting the value of xp_cmdshell (3 replies)
  217. returning counts of all values in joined tables (1 replies)
  218. Re: service manager equivalent in YUkon (1 replies)
  219. Read data Page without using DBCC Page (0 replies)
  220. Join based on MIN DATEDIFF? (1 replies)
  221. client deduping (3 replies)
  222. SQL Server command simular to Oracle's 'DESC' (3 replies)
  223. CLR Integration with Complex Types (8 replies)
  224. Formatting number in sql (2 replies)
  225. How do I handle time-zones? (3 replies)
  226. Year comparison (5 replies)
  227. help on select query (1 replies)
  228. Database locking issue (2 replies)
  229. Sql 2005 maintaining Hierarchy problem (1 replies)
  230. Assigning query output to a variable (1 replies)
  231. SQL Search Query needed (1 replies)
  232. sql server alerts and sql server jobs (0 replies)
  233. Access - SQL 2005 (2 replies)
  234. index question (4 replies)
  235. Syntax to Restore a database renaming the original files (3 replies)
  236. Force a round() when it's below a 5? (0 replies)
  237. Error creating object SQL 7.0 using sp_oaCreate (1 replies)
  238. Table normalization to remove redundant data - Performance problem (2 replies)
  239. import data properly from csv file. (1 replies)
  240. osgl syntax problem (3 replies)
  241. Function to return substring letters only (7 replies)
  242. How can I make SQL Server automatic generate scheme script for backup everyday? (2 replies)
  243. User Privilege problem to Execute SQL Job from query (1 replies)
  244. Generating update statements (1 replies)
  245. Dynamic SQL Problem (5 replies)
  246. Anyone Using 2005? (4 replies)
  247. explicit transaction in sql server 2000 (1 replies)
  248. sql syntax string to execute (7 replies)
  249. The char ' (2 replies)
  250. Saving and Retrieving Binary Files in MSSQL 2005 (3 replies)