PDA

View Full Version : microsoft.public.sqlserver.programming


Pages : [1] 2 3 4

  1. Re: cursor within function (0 replies)
  2. sql query (6 replies)
  3. Re: CLR - SAFE Mode Error when creating assembly (0 replies)
  4. Re: finding out duplicate customerid (0 replies)
  5. Cursor Speed 2000 vs 2005 (3 replies)
  6. Re: Japanese characters (0 replies)
  7. Re: varchar data type (0 replies)
  8. clustered index's structure question (3 replies)
  9. SQL 2K: Character data > 8000. Text vs Varchar DataType? (0 replies)
  10. Original Excel File gets deleted and temp file gets created. (1 replies)
  11. SQL server and Access update (2 replies)
  12. getting the average (14 replies)
  13. first and last date (1 replies)
  14. Re: Order by [alias] in 2005 issue (0 replies)
  15. Re: split by delimiter (0 replies)
  16. Re: project/solution question (0 replies)
  17. Re: INSERT TRIGGER Code Question (2 replies)
  18. ALTER TABLE using a Variable (4 replies)
  19. Execute a stored proecure with paramaters from a table (1 replies)
  20. For XML Explicit problem (1 replies)
  21. Re: Database name as a parameter for views (1 replies)
  22. Re: upsizing to sql server 2005 from access 2007 (1 replies)
  23. How to shrink temdb data file? (1 replies)
  24. Transforming/Pivoting Query Results? (7 replies)
  25. Selecting Date and time int Columns to Datetime (2 replies)
  26. Re: Poor Cursor Performance in 2005 vs 2000 (7 replies)
  27. Newbie Needs Update Trigger Help (3 replies)
  28. Re: What is wrong with this SP Parameter syntax? (2 replies)
  29. Re: Database Mail (0 replies)
  30. Order by bug? (12 replies)
  31. Intervals for existance (6 replies)
  32. Best way without using a cursor? (1 replies)
  33. Recursive Stored Procedure (2 replies)
  34. Re: count how many "true" (1 replies)
  35. bytes per row (12 replies)
  36. SQL Server 2005 performs ORDER BY before WHERE clause. Is this a bug? (10 replies)
  37. Re: Call Oracle Procedure from SQL Server (0 replies)
  38. Re: SQL 2005 server compatibility (1 replies)
  39. Trigger question : For each thing in Inserted (4 replies)
  40. Re: is there a preferred way (1 replies)
  41. Re: restoring a DB from a network drive SQL 2005 (2 replies)
  42. Re: best way to run multiple scripts (1 replies)
  43. Serious multi-user deadlock problem (11 replies)
  44. cross join vs. using a comma (5 replies)
  45. Re: Max\Min Query (1 replies)
  46. Re: Hopefully quick: Suppress print from linked SP (0 replies)
  47. Re: @@IDENTITY returns null (1 replies)
  48. Text to result set (and vice versa)? (12 replies)
  49. my SQL chooses wrong on Hash join vs. nested loop (7 replies)
  50. Issue with selecting shift of the day after midnight (9 replies)
  51. RE: Comparing data from two tables (0 replies)
  52. SQL server programming (2 replies)
  53. MS, You have got to be kidding! (19 replies)
  54. Connecting nodes and calculating paths (22 replies)
  55. Help needed with Stored Procedure (1 replies)
  56. Stored Procedure Transaction (3 replies)
  57. Help with complex SP (8 replies)
  58. find the past months (2 replies)
  59. I need help with a tricky sum query (4 replies)
  60. Stored Proc Problem Pls Help!!! (3 replies)
  61. backup question (6 replies)
  62. another backup question? (8 replies)
  63. backup database while users are using it (4 replies)
  64. how to store contents of a unicode text file into a ntext field. (1 replies)
  65. counts with union? (2 replies)
  66. SQL? - Import XLS DBTYPE_WSTR to SQL DBTYPE_CY (0 replies)
  67. Passing form parameter to multiple SQL stored procedures (2 replies)
  68. SQL Server 2005 Hanging - Selecting uncommitted data (3 replies)
  69. DELETE Procedure. How to return a value? (2 replies)
  70. Return Single Value (1 replies)
  71. Converting the datetime output (2 replies)
  72. Re: poor stored proc performance.. any tips ... (1 replies)
  73. Database Restore Problem SQL Server 2005 (4 replies)
  74. Create table using procedure. (3 replies)
  75. Exclude HTML tags in my search criteria (2 replies)
  76. Result with just one decimal point (4 replies)
  77. Avoid cursor loop and stored procedure? (4 replies)
  78. create olap cube (0 replies)
  79. Upgrading From SQL 2000 A few questions. (6 replies)
  80. "IS NULL" check applied to a LOB field causes "lob logical reads" (0 replies)
  81. SQL Server Express - Why Two Versions for SP1? (6 replies)
  82. SELECT. Need advice. How should I code this? (6 replies)
  83. SQL encryption (3 replies)
  84. using bit fields (15 replies)
  85. Comma Seperated string (9 replies)
  86. How change columns into rows... (2 replies)
  87. Date Table vs Date Functions (5 replies)
  88. "general" backup strategy (4 replies)
  89. List of Users on Database and there permissions (2 replies)
  90. Creating a month by month lookup table from incomplete data. (2 replies)
  91. Get the date of a file on the network using SQL CMDExec (1 replies)
  92. VB6 project with SQL2000 and SQL2005 (2 replies)
  93. Last Name and Then 1st Query (4 replies)
  94. IF EXISTS & Indexes (4 replies)
  95. normalization question (5 replies)
  96. Retrieving data from text file on Internet (1 replies)
  97. Problems with Stuff function handling binary data... (0 replies)
  98. Duplicating a database (3 replies)
  99. no date values in parameter (7 replies)
  100. Min/Max Query Again? (1 replies)
  101. SQL2K5 XQuery data types (4 replies)
  102. Make a Division in SQL Server (6 replies)
  103. SQL subquery with multiple columns (1 replies)
  104. using s.p. returned table? (4 replies)
  105. Subquery in the Select list - error message Invalid column name (7 replies)
  106. joining a temporary ado datatable with database table? (2 replies)
  107. sql job backup and DBCC CHECKDB (1 replies)
  108. How do we perform upper() , LTrim(), RTrim() on Text Datatype? (7 replies)
  109. Multiple search criteria performance question (0 replies)
  110. Multiple search criteria performance issue, Take 2! (1 replies)
  111. sqlserver really handles memory well, not (10 replies)
  112. SQL-DMO and multithreading (1 replies)
  113. T-SQL SubQuery (2 replies)
  114. IIF functionality (3 replies)
  115. Execute Variable (1 replies)
  116. Row Set to Text? (2 replies)
  117. setfocus (2 replies)
  118. Re: Deadlocks and non-clustered index (3 replies)
  119. Localization of Custom Component Name (0 replies)
  120. Data Validation (3 replies)
  121. Stored Proc - Do a split (1 replies)
  122. Set based solution? (5 replies)
  123. Re: Reinstalling SQL Server and mdfs (2 replies)
  124. Help on Query (4 replies)
  125. Creating a month by month lookup table from incomplete data. (0 replies)
  126. Re: varible length of in parameter (1 replies)
  127. Creating a month by month lookup table from incomplete data. More Help Needed (3 replies)
  128. Auto Increment Number in Select (8 replies)
  129. Re: SQL 2000 vs 2005 problem (2 replies)
  130. A little problem. (3 replies)
  131. Re: last day of last month (6 replies)
  132. How to select 1st 20 characters of a field using T-SQL (15 replies)
  133. how to an autoincrement value (insert ID)? (PEAR::MDB2 & DB_NestedSet) (2 replies)
  134. Re: Deleting all duplicate data (0 replies)
  135. Default date of 1/1/1800 being replaced by 1/1/1900 (14 replies)
  136. SQL Job and multiple notifications (4 replies)
  137. Delete Procedure (3 replies)
  138. Stored Proc - Do a split (3 replies)
  139. Re: Upgrading from standard to Enterprise edition of sql svr2000? (0 replies)
  140. Re: VLDB Table Update (3 replies)
  141. SQL Datetime Conversion (3 replies)
  142. Check if there is more than one record. Thanks. (3 replies)
  143. Any performance issues using cross-database references? (3 replies)
  144. page size in 2005? inserts? (3 replies)
  145. Re: Add description to column (0 replies)
  146. Re: slow down from many repeated selects in Delete? (1 replies)
  147. Re: Change Owner to Tables, Views and Stored Procedures (0 replies)
  148. Materializing Values in Computed Columns (0 replies)
  149. Re: Multiple Database (0 replies)
  150. Sql query help - (5 replies)
  151. Re: Ownership For Views and Stored Procedures (3 replies)
  152. Re: Capturing Stored proc errors in log (0 replies)
  153. Re: Parse Errorlog File Severity (0 replies)
  154. Re: Records that don't contain a specific criteria (5 replies)
  155. datetime rounding up? why? (3 replies)
  156. CASE expression (3 replies)
  157. specifying the column description in CREATE TABLE statement (1 replies)
  158. Re: strange requirement (2 replies)
  159. SSIS Performance Issue (2 replies)
  160. Specifying header in XML format file RECORD (2 replies)
  161. Merge data in two rows into one row (8 replies)
  162. Array list of values int/string in SQL 2000 (2 replies)
  163. Query Help (4 replies)
  164. DTSX import Excel with file name a variable (0 replies)
  165. indexes or indices (22 replies)
  166. Query Help (4 replies)
  167. SSIS Package to Send Emails (1 replies)
  168. Re: Not able to connect to SQL server instance on an another machine (2 replies)
  169. Creating a month by month lookup table from incomplete data. Additional Help needed. (1 replies)
  170. Recursive user defined function (3 replies)
  171. how to capture messages from SMO ExecuteWithResults() (7 replies)
  172. Re: Foreign Key's consideration. (2 replies)
  173. Character range comparison, a bug in SQL Server ? Is anyone else getting the same result ? (2 replies)
  174. Ordering issue (9 replies)
  175. Connection to DB - Difference VS 2003 - 2005 (1 replies)
  176. Formula building -- use cursors??? (9 replies)
  177. comparing data sets question (5 replies)
  178. sql 2005 date issue (8 replies)
  179. index and primary key? (2 replies)
  180. archiving mpg4 video (0 replies)
  181. Re: SqlDependency constructor issues (2 replies)
  182. How to calculate column percentage (12 replies)
  183. Deadlocks appearing on Story Counter (0 replies)
  184. Can I migrate my SQL queries from ASP application to SQL Server 05? (7 replies)
  185. Perfomance of Functions vs Stored Procedures (1 replies)
  186. Re: Replace Character (1 replies)
  187. Between via greater than (5 replies)
  188. Check Constraint Error (1 replies)
  189. Select with one instance of number - help (13 replies)
  190. Getting Server Aliases Information via SQL Query (2 replies)
  191. copy table structure (7 replies)
  192. DTS replacement in MS SQL 2005 ? (3 replies)
  193. Don't know how to do this - way above my pay grade!!! (5 replies)
  194. DBNULL not really equal to VB.NET NOTHING?? (13 replies)
  195. Help with calulating balance based on the last record (3 replies)
  196. Re: Proper clustered index order on partitioned tables (0 replies)
  197. Re: prevent duplicate insert of new data? (1 replies)
  198. Ancestor/descendant hierarchy via CTE/recursive queries (3 replies)
  199. Connection pooling questions (15 replies)
  200. Re: Stored Procedure execution... (4 replies)
  201. Is this stored procedure the right way to return the resultss (0 replies)
  202. Odd behaviour on updating single rows in multi-row resultset (6 replies)
  203. Re: prevent truncate on a table with trigger? (2 replies)
  204. CASE in WHERE clause (2 replies)
  205. datetime conversion (3 replies)
  206. Re: Next Id without Identity (0 replies)
  207. SQL Server 2005 CLR UDF on Itanium Based Systems (1 replies)
  208. Do i need to activate some types in sys.fulltext_document_types (3 replies)
  209. escape characters (7 replies)
  210. Update blocking, no sign of deadlock (4 replies)
  211. copying data from one database to other at frequent basis (1 replies)
  212. Re: urgent query (3 replies)
  213. Re: Help in SQL query (4 replies)
  214. Re: How to calculate time difference? (3 replies)
  215. Comparing two tables. (4 replies)
  216. OPENXML Question (2 replies)
  217. Copying an SQL2000 database (7 replies)
  218. RE: Date get from YearWeekNo (2 replies)
  219. SQL 2000 - changing datatype numeric problem (3 replies)
  220. about OBJECT_ID (1 replies)
  221. Retrieve data coming from different sources (1 replies)
  222. ADO stored procedure output value (0 replies)
  223. relationship question (conceptual) - beginner (3 replies)
  224. Cursors in SQL Query (1 replies)
  225. feature roadmap for Service Broker? (0 replies)
  226. Re: Why should an sProc speed decline w/each exec in a batch? (2 replies)
  227. Re: Index Usage Info (0 replies)
  228. AutoNum in SQL (1 replies)
  229. How to get reverse results (2 replies)
  230. Re: sql server 2k Job error code (0 replies)
  231. db_owner <> dbo ? (6 replies)
  232. concatenating column values without a cursor? (4 replies)
  233. INNER JOIN help (3 replies)
  234. copy stored procedure (4 replies)
  235. Re: Can this be more efficient? (13 replies)
  236. skip a value in an update statement (1 replies)
  237. SQL Server agent (1 replies)
  238. error Missing object type mapping in IxFromObjtype (1 replies)
  239. Re: Edit History Tracking (0 replies)
  240. Share dynamic .NET classes between SQL Server and app business layer? (6 replies)
  241. DataBase name in Sql server (3 replies)
  242. query (2 replies)
  243. question on data structure theory (4 replies)
  244. How to handle insert/update sprocs with common business logic? (2 replies)
  245. ROGUE SQL (5 replies)
  246. Re: Moving a MSDE database on to Sql Server Enterprise (4 replies)
  247. Help with grouping and selection (7 replies)
  248. Traces and tables (0 replies)
  249. in oracle we have a functionality "cursor" ... do we have some replacement of it in sql server (2 replies)
  250. sqlcmd Weird characters (0 replies)