Talk Root - PC Hardware, Software and Web Development forums > System Administration > Database Servers > SQL Server > SQL Server 2

1. Deferred Name Resolution
2. Decimal values to Excel
3. DELETE Statement Question
4. Are you guys sure about '+' in this sp
5. Full-Text indexing 'ResourceUsage'
6. script to copy indexes from one table to another
7. How to search all stored procedures for a table name or column name
8. How can I dump stored procedure results into a temp table?
9. archive snapshot of table record on certain action
10. PWDCOMPARE
11. Cursors... what's the alternative?
12. Count until end of previous month
13. binary file storege
14. what is Microsoft Reporting service
15. Question on OpenQuery
16. querying on a dynamic column
17. Gone from SQL7 to Sql2000
18. How to create table to Linked Server for an Excel file
19. String Query With L'Oreal #2
20. String Qurey With L'Oreal
21. existance testing again....again again..
22. Age as of 15th of Mth
23. Dim as New VS. Set = New
24. Bizare xp_sendmail error
25. Get date range from Week No in a sproc
26. SQL Server 7 Desktop trigger features
27. select rows in A that are not in B?
28. Are Transact-SQL statements atomic?
29. Union by condition
30. Suppress Stored Procedure Return Value
31. Object already exists error
32. to eval() or not to eval()....or maybe sum?
33. Object already exist error
34. ADDA 1.0.2 is released
35. Index - How to?
36. Update query not working
37. Cascading update on primary key
38. Truncate one table
39. Returning a hyperlink in a Stored Procedure
40. .CursorType - Doesn't exist or persist
41. Test email
42. Please advise on table structure
43. trigger looping
44. FK and replication
45. Sproc with temp tables and input parameters causing trouble with dynamic recordsets - a tricky one!
46. SELECT * FROM (exec mystoredproc) as table1
47. Custom Sort Order (DDL included)
48. How do you fake it? - UNION query columns
49. Performance of cross databases queries
50. How can I prevent 2 instances of app running ?
51. number of rows in cursor
52. Insert multiple non-existing records
53. number of rows in cursor
54. how to reserve identity value?
55. Query Problem
56. Finding number of words
57. Merging Data
58. Cannot create index on float view field, but works on table?
59. Retrieve / list members of Sysadmin role without connecting to the SQL-server (API? Please help!)
60. How to query data ?
61. Image storage - db vs filesystem (again)
62. Counting By Previous Month
63. return record with greatest date
64. Encrypt function...
65. Fetching XML metadata.
66. old sysmergesubscriptions records
67. accessing sysobjects is good or bad if not wat is the solution
68. Selecting the last record per group where nulls possible
69. Turn off enforcing relationships on inserts
70. I really need some help here.
71. Transaction Log - suspend for updates
72. More info...
73. parallel processing hangs with CXPACKET wait type
74. Overcoming Transact-SQL ORDER BY limitations
75. Invalid Cursor State Error
76. Backup/Restore question
77. Newbie needs help with BCP out file
78. Efficient Text Storage ?
79. This one could be tough
80. Expire Passwords
81. Select top n query
82. SQL Statements in Dreamweavers MM:Datasets - on the fly...
83. Cursors - Server Side - Only Forward?
84. Running Sum field in select query
85. "Key column information is insufficient or incorrect . . . "
86. Date query
87. SQL Service Stops and Starts
88. Set @var to a single row of data?
89. Question
90. Select Last Row problem
91. Consolidating Code
92. creating a user and then adding the user to a role
93. running a query against 2 SQL servers
94. datapage
95. Paging feature for schedule jobs not working
96. Return Key (identity) on INSERT operation (SQL/ASP)
97. Custom Identity Field
98. error comparing Floats after conversion from varchar
99. Help In Query
100. Optimizer smart enough to recognize "constant" subquery?
101. UNICODE and Encoding
102. data parsing
103. Triggers
104. Year conversion
105. count of maximum value
106. Locking Hint
107. Trigger does not seem to fire from front end or enterprise manager
108. SQL server XML parser
109. solid learning experience
110. Need "On Change Of" aggregate
111. CONVERT
112. oadl (or padr)
113. cross-tabulation, sort of
114. select statement as a column
115. Query help needed
116. Top x Percent for each group
117. How to accomplish this in a query (quite simple probably)....
118. Re: Sort of a loop in SQL ... - Thank you all
119. Operand type clash: varchar is incompatible with void type
120. Convert datatype in function
121. retrieve the most recent row
122. Retrieve column descriptions?
123. Duplicate keys, unique rows.
124. SQL Documentation
125. help needed in database backup
126. Insert statement inside stored procedure failing
127. collection of queries for Northwind
128. Conditional Select... (case, union, subselect?)
129. Assertion: SQL Server 2000 can't issue a SOAP call
130. What is a ROW-ID
131. Need to REALLY understand views
132. schedule job - login in dynamic sql
133. Hello
134. data parsing
135. PLease help with case expression...complex.
136. Automatically rounding
137. Query
138. Hello
139. How to get a Sproc to return both recordset and output parameters
140. Table Design Review wanted
141. unique temp table name
142. How to setup permissions of a Stored Procedure that execute other Stored Procedure
143. What does the sp_sdidebug do?
144. exporting data
145. Derived column names
146. Re: Distributed transaction completed. Either enlist this session in a new transaction or the NULL t
147. Occasional SQL Error
148. Undo a delete
149. Simple statistics question
150. Lower case data
151. How to get two values.
152. How does the SQL Server handle two simoutanious read or write operations?
153. Case Sensitive
154. Error with "Operand type clash"
155. Help with GROUP BY and COUNT with LEFT OUTER JOIN
156. T-SQL error handling practices
157. Image Data - Lost Connection, any Size Limit?
158. need query help please
159. Replace function bug?
160. Retreiving resultset column names from a stored procedure through ADO
161. why doesnt this query work...
162. Retrieving Anniversary Dates within 1 Week from Today?
163. SQL general ole error
164. Turn off the error message
165. IsNumeric function
166. Dynamic Database Name
167. busy with another hstmt - Error
168. Windowsme keep latchingup during surfing.
169. Temp tables or variables?
170. formatting question
171. RE: DECODE - Thanks
172. "NOT IN" (set difference) with compound key
173. Parameters inside a view? On SQL2000
174. Advice on design pattern
175. Error 213: Insert Error: Column name or number of supplied values does not match table definition
176. SQL Mail
177. Date field with year prior to 1753.
178. Deletion of Duplicate Record in table
179. Fully Qualified Names
180. Natural vs. Surrogate key
181. help... statistics on non-index column disappear
182. Convert Characters SQL
183. AlphaNumeric Auto Field
184. Can I query the estimated execution plan?
185. variable and querysting
186. What's wrong with this query
187. Natural vs. Surrogate key
188. How to update a table using Join with other table
189. Index is not used sometimes.
190. N' in queries
191. Another 'case' type of question from a newbie
192. Active Directory Users
193. table OUTPUT parameter of sp
194. SQL92 JOINs
195. true / false return from query
196. Stopping SQL Server Agent Programmatically
197. Can you index table variable fields?
198. How to change owner of user datatype?
199. checking the data in 2 tables
200. Update with Dynamic Field
201. Update data among databases
202. Need pkey data type of 32 < x < 64 bits size.
203. Add Record Number Column to existing table
204. Lock for insert
205. Single or multiple Triggers
206. SELECT syntax
207. AutoNumber ?
208. N' in queries
209. Distributed transaction completed. Either enlist this session in a new transaction or the NULL trans
210. Table lookup query
211. Re: Distributed transaction completed. Either enlist this session in a new transaction or the NULL t
212. use of tempdb by union all
213. raise exception for any error from sql server
214. Trigger with user defined function
215. Average of top n query
216. Analysing Execution plan
217. Row Count
218. specifying date param values in dynamic sql
219. Follow up query from Fresher - Aaron Bertrand
220. Stored Procedures WITH ENCRYPTION
221. Stored Procedure Resultsets?
222. share using SQL Server
223. Probably simple question.
224. Loop for Quantity
225. Copy/move data from TableA in DB1 to TableB in DB2 within the same SQL Server
226. Sort of a loop in SQL - how to do it
227. sybase newsgroup
228. Increment int values
229. Help with SET NOEXEC in a SPROC
230. Sql 7.0 -> 2000 update query hangs
231. Calling SQL SP from VB code
232. Licensing
233. Re: Help with where clause in Stored proc and Qry Analyzer getting
234. Query question. Can be very simple. Please take a look...
235. Help with where clause in Stored proc and Qry Analyzer getting different rec. counts
236. Reporting Services Version
237. bi-directional relations
238. Help constructing View
239. How to store db objects in VSS
240. Adding lines to a table base on a Quanitity
241. Cursors Performance in Multi Processor Environment
242. selecting nested rows
243. Can I output query result to text files in QueryAnalyzer?
244. How to detect if a temporary table has already been created
245. SQL Server 2000 Fresher
246. Delete Based on Join Problem
247. View Partitioned
248. Major Problem - Please Help!!!
249. Database User without login
250. Integer data type -> binary coded decimal
251. Showing all stored procedures in generate script wizard
252. Querying multiple SQL Servers
253. Date change in stored procedure
254. renaming a column using t-sql
255. Distinct Count Problem - MDX
256. hello urgent!!!!!
257. how to use distributed tran
258. problem with sql
259. Inserting the Identity of a master table into a child Table
260. Dynamic SQL and Assigning a Local Variable
261. TOP N__
262. Stored procedure; return calculated values
263. ORDER BY and CASE
264. referencing server with "-"
265. ALTER COLUMN to for INDENTIY?
266. Help with qery
267. Error with linkserver
268. Any API To Interactively Create a Query?
269. Data Model Question Again
270. Select INTO
271. Select INTO
272. DECODE
273. Select help!
274. ERROR line number
275. passing raiserror info from ms sql 2k to ms access 2k
276. update statement - please hlp
277. SQL Error
278. Create Job to dump SP results into a text file.
279. join top 1 ?
280. An 'ORDER BY' based on an input parameter
281. Help on query for report
282. Converting seconds to hh:mm:ss
283. Autonumbers
284. SQL QUERY Question
285. Creating Indexes
286. global function
287. Next Wednesday's SQL Server Chat: The CLR and Yukon
288. how to write this program
289. Converting seconds to hh:mm:ss
290. Bookmark lookup cost factors (SQL Server 7.0)
291. Scripting Database Restore
292. Different Row Counts From Two Virtually Identical Queries
293. Naming Procedures
294. SQL Delete question
295. Converting varchar to money
296. Converting varchar to money
297. Major Problem - Please Help!!!
298. varchar vs char
299. create a global procedure
300. Send info to client?
301. Beginner - Pecent in Calculated Column ???
302. Any One Respond On This? (Major Problem - Please Help!!!)
303. cast / convert / a function to turn for example "manager" to a number
304. Stored Proc Help
305. Beginner's question
306. Reporting Services
307. Large Dataset
308. Trigger trigger?
309. Oooops Quoted_Identifier
310. xp_sendmail in SQL2K
311. Another Question
312. How to perform allocations and other planning functions in T-SQL
313. Data Model Advice Needed
314. Webs sites for T-SQL resources
315. Update lock seems to hang
316. problem with rand() function
317. Major Problem - Please Help!!!
318. wait delay
319. transactions and stored procedures
320. Problem with type NUMERIC(5,2)
321. Copying a table and its content
322. Returning value from sp_OAMethod
323. Group Data with totals
324. How to extrapolate different type of records in one file to different tables while loading
325. BLOB or simple image reference? What's best?
326. Major Problem - Please Help!!!
327. Creating Views
328. Triggers - SQL 2K
329. catching deadlock
330. Changing Funcionality???
331. Performance on parameterized queries vs. stored procedures
332. Modulus 3
333. Optimizer question
334. SQL UNION
335. user sa don't have persmission to read from sysobjects rdo
336. Question on stored proc on functions
337. How to store db objects in VSS
338. Latest data for many objects
339. How to validate a query?
340. YTD Stored Procedure
341. Create a one-to-one-or-many relationship
342. Creating a stored procedure to delete records...
343. dynamic sql with a cursor ?
344. dynamic sql with a cursor ?
345. dynamic sql with a cursor ?
346. Re: Hit maximum number of tables in a query (256)
347. Call a Stored Procedure From HTML page using ADODB.Recordset
348. Question about table variables.
349. Accessing SQL Server in a clustered environment
350. Temporarily Inhibit Trigger
351. date conversion
352. Alerts for SQL Service stoppages
353. Large update statements
354. Update statements
355. SP LOOP
356. Question on stored proc on functions
357. Stored Procedure
358. sql statement quiz
359. list of last 24 months
360. set user fails with migrated user accounts?
361. Question on Query
362. Update records only if changes have been made
363. SQL Server Enterprise Manager Won't Start
364. Float number issue
365. How can I assign ReadText to local variable.
366. determining PK column sort order
367. View Partitioned
368. Efficient programming
369. How to switch databases in a sproc programatically?
370. Using DBCC DBREINDEX...
371. update statement
372. SQL Query ?
373. Double Quotes Fail, Single Succeed
374. calling sproc accross linked server is slooow
375. Insert 40 spaces..
376. Urgent - Restrict
377. problem using function
378. stored proc
379. Data conversion
380. Query to create user-customisable filters/search
381. Junction table or not
382. Is it Safe?
383. Trigger Help
384. Why doesn't this work?
385. help with syntax error
386. Is it Safe?
387. SET TRANSACTION ISOLATION LEVEL
388. Temporary tables with constraints in stored procedures
389. running a DTS Package
390. Exporting query results to file using | (pipe) as a deliminator.
391. getting to the nth record in a table
392. Urgent - Restrict
393. String or binary data would be truncated.
394. Truncate all tables in SQL Server db
395. annoying QA thing
396. Please help with this statement that uses WITH ROLLUP clause
397. Truncate all tables in SQL Server db
398. paging in t-sql
399. Problem with reporting services
400. File Deletion Guidence
401. File Deletion Guidence
402. Does Sql Server cache data on modifications (insert,update) as it does queries.
403. RE: Invalid operator for type (Thanks that worked fine)
404. Partitioned View
405. CmdLine SQL Script Gen
406. Invalid operator for type
407. Changed fields in an Update Trigger
408. dropping columns
409. Database mirroring on same server
410. date selector tool for INSERT / UPDATE form field - VBScript?
411. Arithmetic overflow in SQL-DMO when refreshing databasecollection.
412. ms sql server; linked server; jet; mdw
413. closing connection and setting nothing are necessary
414. SQL Server 2000 speed problems
415. Create indexed view
416. Scripting database diagrams
417. Mysterious Port of SQL Server not shown by netstat
418. Need help with SQL syntax
419. Stored procs pros & cons - any good links ?
420. Re: Date field isn't - familiar format
421. random records - how does it work?
422. Server Name and IP ?
423. Create view with rows from two tables - not by joining
424. Urgent! Complex+Tricky sql query
425. Record number
426. query problem
427. query problem
428. Is my syntax correct for Trigger after update
429. Returning a Range of Rows
430. Stored Procedure speed
431. nVarchar
432. copy table & data
433. When 2 strings are concatenated by +,Is the maxmium string length 256?
434. If Else Logic
435. Alias for a database name?
436. SQL Server log file show 'login succeeded for use sa' more than 1000 times
437. Use Distinct or MAX
438. updating rows
439. Re: Access <-> T-SQL syntax question
440. Outer Join problem...
441. Select without tab...
442. Querying Link Servers
443. trying to insert into 2 tables simultaneously
444. returning same row multiple times
445. Bug in Enterprise Manager when setting the font
446. Problem with second execution of stored procedure
447. Can CHARINDEX Expression2 be a UDF?
448. Inserting XML data into SQL table using OPENXML
449. xp_sendmail, @message, and unicode characters
450. Storage size of smallmoney
451. Could not start MSQSQLSERVER on local computer
452. Database Restore using VBScript
453. recreating spt_ tables
454. Email
455. Backup database to a diff server
456. field types are changing
457. Unique column name
458. Occasional "Timeouts" due to Optimizer?
459. Aggregate on Subselect
460. Leading zeros
461. Leading zeros
462. MSSQL - Invalid attribute/option identifier
463. DB modification tracking
464. Interpreting Sp_lock results
465. Retrieve Server IP and Sql Server Name through Query Analyzer ?
466. Re: different row counts!!??
467. select count(*) slowness
468. SQL recode
469. workaround: Sp_cursor: The Parameter 'Table' Is Invalid with Long Database Names
470. a view based on stored procedure
471. transaction was deadlocke
472. split by a pipe and insert into lookup
473. Problem with MAX function
474. Problem with MAX function
475. sql query with sp_msforeachtable
476. Always use int and never use bit, smallint tinyint ?
477. Scheduled Job Notification Not Working
478. Datetime Minimum Values
479. SQL 2000 adOpenForwardOnly block
480. Views and Variables
481. I thier a way to see if an update occured
482. random select
483. THE DEFINITIVE ANSWER: Import CSV into SQL Server
484. Dynamic update of table
485. connection suddenly fails: mdac? pooling?
486. No DSN
487. Retrieving field properties
488. Init Timestamp after added to table
489. Append One Table To Another
490. Combing two case statements into one
491. Sproc Question
492. Append One Table To Another
493. How to find only updated columns in a trigger.
494. traversing comma seperated values
495. Combing two case statements into one
496. random select
497. Setting up an UDL for OLEDB Connection
498. Rollback
499. FOR XML with multiple joins
500. sql query problem
501. Performance goes down
502. counting with reset at group by? change
503. Select Stmnt
504. Timeout errors for no reason
505. help with query
506. Transact-SQL problem: How can T-SQL accept parameter during execution?
507. Case statements
508. Case statements
509. High CPU Usage
510. Counting with distinct - Optimizer Problems
511. How to replace TableName with variable?
512. DBSERVERENUM function in C++
513. looping through a recordset and updating records creates locks
514. Object Permissions query
515. Money type doesn't display the decimals
516. Backup Question
517. Working with Sheridan Grid
518. getdate() in UDF
519. Using CASE statement to build different where clause
520. NULLS in view
521. Why Do I Get This Error
522. xp_cmdshell path issue
523. Transactions question
524. Check name
525. delete in blocks of 1000
526. Help with Case expression, is this possible?
527. Stripping out unwanted characters
528. Sorry - Correction Re: Data transformation SQL query...
529. using upper
530. 2000 Std. edition physical size limits?
531. Trapping an Error from a Linked Server?
532. Data transformation SQL query...
533. Security by proc
534. Start job from another server
535. Table Structure Question
536. Security by proc
537. stats question
538. How many records were updated?
539. Join in a constraint
540. Month Name
541. Emptying the buffers
542. Using Select Or Set in Stored Procedures
543. Connecting Securely?
544. Statistics....questions
545. Errors when Syncronizing
546. Openrowset Accessing problem
547. Row Level Security
548. SMP Sum(*) slow
549. How To Handle User Defined Fields?
550. Prevent deletion or update of multiple rows
551. What is the maximum SQL statement you can run?
552. Monday and Sunday of current week
553. Newbie question...
554. Get rid of blanks
555. delete locking
556. Use stored proc. results as source for aonther query
557. Select Statement - Please Help
558. Security - Please Help
559. xp_cmdshell
560. BCP utility Skips lines in import...
561. sp_executesql with ntext variable
562. newbie silly question
563. Select Statement - Please Help
564. Restore with a different database name
565. bcp_exec and ASP
566. Oracle linked server problem
567. GETDATE() or CURRENT_DATE
568. Oracle & SQL Server
569. Help with Blocking
570. Security - Please Help
571. Security - Please Help
572. not so random connection error... MDAC??
573. Oracle & SQL Server
574. Server does not exist or access denied
575. Multiple unique constraints
576. IF UPDATE (column) in a trigger
577. FOR XML AUTO - Cutting off XML
578. Optimizer not optimizing?
579. Number of Column inside a "SQL Server 2003" Table
580. Recurring events in a booking system
581. Shrink Logfile
582. space used for each row
583. BCP Nightly Extracts
584. Grant EXEC on Stored Procedure
585. INNER JOIN newbie question
586. How to check a linekd server is available
587. Language problem
588. SQL QUERY
589. ANSI Vs MSSQL Join Style
590. how can i create the cube partiion in mdx
591. How to Calculate Word Days
592. Oh... no....
593. Keeping a Running Tally
594. Union of sets
595. Advice on case statement
596. Applying Changes via SQL
597. Union of sets
598. security and stored procedures
599. Query Timeouts
600. Cocatenating strings where one table value is null
601. 'Where' selection passed as an argument
602. Re: compare columns in 2 rows
603. Re: Version Control?
604. Advice on case statement
605. Re: automate
606. Shrinkfile if DB Transaction Log > 500 MB
607. Update Statement Slowwwwwwwwwww
608. How to identify which SQL Agent job has called an sp.
609. query using linked server
610. Shrinkfile if DB Transaction Log > 500 MB
611. Shrinkfile if DB Transaction Log > 500 MB
612. newbie question. How to embed a .jpg into sql
613. query using linked server
614. Best Practice - Cascade Delete?
615. Query Chalange
616. DISTINCT AND ORDER BY together?
617. How to register sql server database on web site?
618. Query Chalange
619. Openrwoset
620. SELECT on a stored procedure???
621. Monitoring sql server login attempts including IP ?! please help
622. see records of a Group by
623. get some records and then call a stored proc once for each??
624. .wav database
625. Info from SP_SPACEUSED vs. database properties
626. View Combining Fields
627. ADO CommandTimeout on query using linked server
628. Displaying SQL2000 version and service pack.
629. Error 156: Incorrect syntax near the keyword 'ORDER"
630. EXECUTING SP
631. Linked Server Update Problem
632. UNIQUE index - constraint BUG/FEATURE?
633. sql query question (w/ test data)
634. Rename table
635. Complex Script to Disallow Nulls in One Column?
636. Check if column exists
637. re : finding date in data
638. finding date in data
639. Open Sql Server DBA / Replication / DB-Libraries Contract Positions
640. DateTime problem
641. how to back up data
642. c#, DTS and Threads
643. optimisation with extreme sql
644. transferring stored procedures from SQL 2000 to SQL 7.0
645. datetime field
646. error handling
647. datetime field
648. error handling in procedure(sql server2000)
649. Query Analyzer
650. datetime field
651. Send Mail Command
652. Carriage return, line feed and text editors
653. AD
654. Limitations of Scheduled jobs
655. Multi-database access in trigger
656. How to Create and Debug a Setup Program to Update a SQL Server Database
657. managing relation in large DB**
658. maintenance plan
659. Creating a view that uses a sp to retrive data
660. Keylocks and updates
661. using 'sp_' as a naming convention for stored procedures
662. COUNT
663. transaction for dbcc checktable
664. Escaping ' charactors in SQL
665. SQL Server 2K connection is interrupted regularly, why ?
666. How to prevent queries showing up in Profiler?
667. EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm?
668. Query: Which employee had the most orders... for each day
669. T-SQL : Unknown number of input parameters
670. Cursor inside another cursor, or...?
671. use of @@error
672. Case statement
673. Invalid cursor state
674. setting scale parameters
675. SQL Server 2K disconnects the client after reaching a specific amount of query load.
676. Should I use a stored procedure?
677. find non matching records
678. STORED PROC QUESTION?
679. locking questions
680. Names of Week-days
681. derived table query
682. Printing the KEYS of all tables
683. Eroor checking in SPs
684. sqldmo and late-binding
685. MSDE 2000 Setup problem, Reboot
686. Security - Access Rights on DB
687. optimizin queries
688. create the batch file to call the stored procedure
689. two update triggers on same table
690. SQL month riddle - most efficient way?
691. Problems with Table Variable's
692. coding for no blocking or deadlocks.
693. BULK INSERT - tab delimited
694. Either BOF or EOF is True, or the current record has been deleted error makes no sense
695. Need a query
696. string delimiter in bcp/bulk insert
697. How to avoid hardcoded server name in LDAP query in view?
698. Can Not find Stored procedure
699. What's up with Enterprise Manager?
700. SQL Server Community Survey
701. date format
702. passing function result as a function parameter
703. Updating an expiration date based on the next effective date
704. WITH ENCRYPTION
705. Master DB
706. New Article: An XML Eye for the Database Guy (Part I)
707. Autocommit and stored proc
708. Quickway to dump all the user Stored Procs into Visual Source Safe
709. Selecting a Random Record
710. Encrypting & Decrypting Passwords
711. Job Backup ?
712. Counting previous 12 mths form today
713. Select statment
714. insert without log
715. xp_CmdShell and VBScript
716. Need help with Select Statement
717. Comma delimited issues
718. Parsing .TXT file__
719. Need help with Select Statement
720. Row Level Trigger
721. ODBC, alias an SQL Server Login error
722. UDF with GetDate
723. Opening cursor after closing does not seem to requery
724. How can I have multible connections and readers?
725. There is already an object named '#CDList' in the database
726. database collation issue
727. VSS Sql Server Integration using VS.NET 2003
728. VSS SQL Server Integration using VS.NET
729. Matching on a subquery with multiple columns
730. Tricky trigger design - can this be done?
731. Update more than one row
732. lost in locks...
733. Using Stored Procedure in DTS package
734. sql result to horizontal table
735. Is OSQL can return error ?
736. Debugging T-SQL Codes
737. Newbie sql question
738. Query For A Word Containing A Reserved Character
739. Cannot create index on view
740. SQL Mail
741. Where are indexes of views?
742. getting values from inserted table
743. European Dayofweek?
744. uniqueidentifier
745. the fastest join
746. Partitioned View
747. Replacing data ?
748. identiy_insert and data generators
749. Newbie question; Why is my procedure slow when a parameter is used?
750. Re: 400 Linked Server to SQL Server via IBMDA400
751. Query performance on archived data
752. drill odwn on month
753. trigger execution
754. Order By in a View
755. ask for standard sp writing
756. How to call one SQL script from another
757. cube partition will reflect in dts
758. A Query Question
759. executing dts package in stored procedure?
760. errr........'getdate' within a function.
761. Materialized view
762. Batch processing of Stored Procedure
763. In this example, select TOP 3 from emp
764. [Question] select top n in each group
765. Improve This Trigger??
766. How do I create a Stored Precedure if one does not exist?
767. how to cast numeric col as nvarchar in join?
768. how to cast numeric col as nvarchar in join?
769. Help with SUM
770. UDF/SP Editor
771. how to select from a stored proc
772. Query help
773. Text data type in stored procedure
774. Sort NULLs after rows with values
775. A Query Question
776. something is very weird on execution plan
777. Elseif
778. Sequential integer column in view
779. xp_cmdshell output question
780. Transact SQL
781. Short Month Name
782. Audit Trail on SQL Server
783. New record ids from master to child
784. storing time
785. storing time
786. how to use IF Exists in Sql to Drop a Table?
787. SQLDMO: howto obtain logical file names from a BAK file
788. Putting an auto-increment column in my select statement
789. Updating to NULL instead of zero
790. highlight a row in MSFlexGrid
791. Trouble with EXEC
792. DELETE Trigger
793. Indexing bug when used with COUNT(*) ???
794. should i use a loop or a cursor?
795. Replacement of Open Data Service
796. Putting an auto-increment column in my select statement
797. error running sp_OAGetProperty
798. using Case function in SQL2K
799. Login Event!(or something like that...)
800. SQL query error
801. Pb with on delete cascade... HELP!!!
802. Deleted database by mistake
803. update query
804. SQL vs. VFP
805. mssqlserver stopped
806. Trigger Failure and Rollback question
807. SP for a Forum breadcrumb trail
808. select tables permissions and apply to another table
809. Crosstab query in SQL
810. Error on query
811. Good Scripting Resource
812. Persisting temp tables
813. Simple query
814. binding error on function, eh?
815. Selecting variables into temp table
816. Hidden error kills my transaction. Example.
817. LinkedServer and Unique-Key / Error 7319
818. Dynamic check constraint
819. view object
820. LAT /Long Problem
821. pls help!!!
822. using xp_sendmail
823. Program Documenation for Stored Procedure ?
824. Identical record
825. Data tables only linked through programming
826. Report Invalid objs
827. DBCC CHECKTABLE
828. Immediate need for a solid back-end web developer - Guildford, Surrey, UK.
829. experts prasad small prob in proc
830. LAT /Long Problem
831. Re: Select nearby locations using Lat / Long
832. Process Lock
833. hello,experts,prasad. small trouble
834. table variable
835. Unicode Problem
836. Divide by zero
837. SQL Server to Oracle
838. VIEW showing result of a STORED PROCEDURE ?
839. Problem in connecting after service pack 3a installed in MSDE 2000
840. casting into %
841. temp tables
842. Questions about using alternative to SUM()
843. do not generate SET statements
844. Database events - notify an application
845. Update & Delete
846. Prepared Statement vs. Stored Procedure
847. Select records not more that 6 months old
848. Top x Percent
849. Using VBscript to check a file size and then update table.
850. XPSMTP (cross)
851. OPENROWSET___
852. How can I find the command from command prompt?
853. OPENROWSET___
854. Add a autonum column to a view
855. sp_OACreate and Queued Components
856. Help concatenating records to a field
857. dbo user?
858. Update time
859. SQL Query Distinct?
860. SQL Query Distinct?
861. Help creating a trigger
862. Triggers + inserting into other table
863. Triggers + inserting into other table
864. Parsing XML within SQL Server
865. reformat the output
866. Date issues between SQL and IIS servers
867. Parsing XML within SQL Server
868. Error Message Dropping Foreign Key
869. Trigger (for keeping history info) help!
870. OT SQL Users group
871. ASP FormatNumber FAILS
872. Calculating Percentage in a Query
873. How do I get a list of available tables?
874. Updates degradation
875. Help with a query
876. Executing a DTS Package from a Stored Procedure
877. datetime field usage
878. ADO 2.8 help files
879. Stored Procedure Recompiles
880. First day of week
881. T-SQL "division by zero" workaround?
882. VB Programming
883. Repost: job agent problem
884. Help creating a trigger
885. Sharing Tables between Databases
886. Real Column Name, Please Help
887. Re: Nested Cursors.....
888. Need help with Date parameter
889. Datetime help
890. Executing a DTS Package from a Stored Procedure
891. day of week
892. Update a date
893. BCP Fails to Parse Format File If It Has White Space in Column Name
894. backup log <my database> with no_log
895. Query/Update response time concerns
896. SP's
897. Logarithms
898. sp_columns thread safe?
899. Re: Wildcards in REPLACE function?
900. how to calculate recordcount of a ADO recordset that has been created already ?
901. My research project
902. urgent!! stored procedure
903. procedure anybody!!
904. Dynamic distributed SQL query needs ANSI_NULLS & ANSI_WARNINGS but can't set them
905. Parse Objects
906. performance
907. Alias
908. reuse of column_header (alias)
909. How to tell if I can convert a varchar to int
910. character '\' disable CR+LF
911. urgent!!! in stored procedure in sql server
912. SQL statement with Query Analyser
913. Insert many rows using select
914. Advanced Select and Insert
915. Strange Invalid Connection Error
916. rowcount syntax
917. thanx experts,Prasad
918. Error 8646!!! URGENT!!! PLEASE!!!
919. Read column description with ADO OpenSchema, SQL Server 2000
920. SQL result zero - Help
921. Thanx experts..but pls clarify...
922. Hidden error kills my transaction. Help!
923. Timestamp
924. thanku but.
925. How to use 'Check Contraint' on a View ?
926. Unicode with DB-Library
927. stored procedure
928. how to call dts package in sql server stored procedure.
929. Thank you Experts
930. OPENQUERY error
931. TSQL truncated when SP is saved
932. select @@IDENTITY from MyTable
933. command to run sql statement
934. Help for newbie with triggers
935. Command Line & MS SQL Server
936. calculating SUM
937. Run stored procedure from C#
938. Grouping on difference in time
939. Query Problem
940. Grouping on a difference in time
941. Update partial data beween unequal columns
942. strange SP problem
943. Re: Unable to modify table. Invalid cursor state.
944. INSERT variable and select
945. ASP resultset fails if Stored Proc uses Temp tables
946. Date calculation problem - newbie
947. Sub-Query Problem
948. TRIGGER DLL HELP
949. Truly NULL dates
950. Help with SQL query
951. import with counter (DTS package)
952. Query or SP help
953. Using table variable causes error
954. Converting to Date
955. Show number as currency..
956. When exactly we use BEGIN DISTRIBUTED TRANSACTION ???
957. Converting to Date
958. How can I restore a database in SQL2000 server from a SQL6.5 backup file ?
959. Anyone ever done something like this? Need Help!
960. import data from query using DTS
961. RE: SQL Mail 2
962. Linked Servers
963. Using Expression Resuts in Another Expression
964. Re: Access with SQL [ADP?]
965. using sqlmail
966. Global Variables?
967. MSQL Query's Compare to Ms Access
968. Filtering Records With Row Numers
969. Query Help
970. Need good coding Technique.
971. job agent problem
972. Trigger
973. Hide if total column is 0
974. update strategies
975. Import
976. Can DTS wizard handle AUTONUM Field and DEFAULT VALUE property of an Access DB ?
977. Run Scripts
978. Trigger with an Insert statement
979. SQL Statement needed!!!!
980. Debugging
981. Debugging
982. Running SQL Scripts in Visual Studio .NET
983. Select Question
984. URGENT!!!How to turn the results of a row into separate columns??
985. Parse email addresses into SQL server
986. Starting replication with a stored procedure?
987. ASP Code
988. udf in defalut value
989. Home office phone system
990. cast 1.5 into 1%
991. plz send me reply
992. Debugging
993. backups job to tape failed
994. Can I use column(0) in a Stored Procedure?
995. Error 3702: database in use and cannot be deleted
996. Stored Proc help
997. xp_cmdshell problem
998. Data type info
999. ASP Code
1000. Trigger
1001. Update query has syntax error (missing operator)
1002. Conversion Access to SQL Server 2K : DBTIMESTAMP data overflow error
1003. Query help for getting decent logging results
1004. How to: create linked records (or records in linked tables)
1005. merging of development and production db
1006. Trigger status
1007. Alter table alter column
1008. temp db indexing in SQL2k
1009. Delete query
1010. smalldate time column
1011. Net Send Error
1012. auditing
1013. Simplest way to select most recent value?
1014. Get SPID in Job
1015. Get SPID in Job
1016. How to force ANSI_NULLS ON for a user-defined function - AGAIN
1017. searching for unicode (japanese characters)
1018. Aggregating by time period
1019. Multiple Queries in a single line
1020. multiple queries in a single line
1021. Help with query (sorting and grouping fields)
1022. Error trying to use computed column
1023. parsing the store procedure comma delimited parameter
1024. Row number in a query
1025. CASE with aggregate
1026. Does CharIndex have 8k problem?
1027. Append Query to Another Database
1028. Auto alert on database changes
1029. simple question re DELETEing in linked DB
1030. Insert Trigger error
1031. Many-to-many question.
1032. Using UDF in a default constraint
1033. DSN
1034. Trim For Select
1035. build resultset in stored proc
1036. Error 7405
1037. Identity Setting for an Existing Column
1038. counting and grouping
1039. how to use charindex and substring
1040. incrementing a unique value and returning it
1041. Getting external data ODBC connect errors when connecting with Access
1042. Applying the initial snapshot to a merge replicated subscriber
1043. Query Question for the Gurus
1044. linked dBase tables
1045. using "case" in where clause
1046. SQLSERVERAGENT
1047. Output and return from stored procedure
1048. Remove Alpha Characters From Varchar Column
1049. Cursor with dynamic SQL
1050. Don't understand why select distinct so slow
1051. Multirow Operations & Triggers
1052. .tab or .csv
1053. Best strategy on storing files on server
1054. Help with Query
1055. Convert from Float to Varchar
1056. iif statement in a having(where) clause
1057. One or many lookup tables
1058. slow odbc between servers
1059. Help with Query
1060. SQL statement
1061. INSERT TRIGER
1062. General Network Error after database restore
1063. sleep a few seconds
1064. Stored procedure help needed please (Group by and Sum)
1065. ISA log table in nice format
1066. Help with Query please - Pivot
1067. sql mail
1068. the "having" clause
1069. How to force ANSI_NULLS ON for a user-defined function
1070. Nested Cursors...
1071. DatePart
1072. locking a record explicitly
1073. minimize database records
1074. OSQL
1075. How to check for duplicates
1076. Data Insertion Problem
1077. Table Problem
1078. check variable for population
1079. Stored Proc Syntax Question
1080. BULK INSERT (X)
1081. MySQL UPDATE to equivalent TSQL statement
1082. MAT Calculation
1083. IF... ELSE
1084. SET DATESTART
1085. MS JDBC Bug
1086. Help with String Functions
1087. Error 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified
1088. TEXT parameter in stored procedure
1089. insert word document to db
1090. LIKE, CONTAINS and Full Text Indexing
1091. select...
1092. Good Stored Procedure Tutorials
1093. Linked Server
1094. check constraint**
1095. Re: datatype of PK **
1096. caculated field concept**
1097. uniqueidentifier***
1098. filegrowth in database**
1099. vc++ connect
1100. OUTPUT var in SP
1101. Time Intervals
1102. Dynamic Cursor in Stored Proc.
1103. sort
1104. if statement in select clause
1105. RAND() in a TF
1106. join to get all combinations
1107. Slow Query
1108. difference between stored proc and user defined functions
1109. saving tables in MSDE
1110. Executing several batches
1111. Insert multiple csv files into a single sql table
1112. Add new records
1113. table structure question
1114. simple UPDATE statement
1115. MySQL anybody??
1116. use of xp_cmdshell
1117. Sending HTML using xp_sendmail
1118. Tool for comparing database object differences:
1119. 916: Server user '%.*ls' is not a valid
1120. $0.00 VS. NO amount
1121. foxpro
1122. Speciallized locking
1123. Field Encryption
1124. Isolation level, how to determine current level?
1125. connection slow at first
1126. Retrieve the stored procedure script with ADO.NET
1127. Design Question.
1128. How can I GROUP BY a full day?
1129. Dynamic SQL in Stored Procedure
1130. check user exist?
1131. Selecting the Default Value for a Column
1132. sending output to a file
1133. Statement Help
1134. SP Execution Very Slow
1135. Truncated adLongVarChar
1136. Help with SP calling another SP
1137. customize getdate() function
1138. sproc performance
1139. Problem merging two queries
1140. Problems with Getting a Date (range)
1141. restore using wildcard
1142. DB maintenance plan action entry in SQL Server logs
1143. PL SQLSERVER 2000 execute cursoring ORACLE PL
1144. Is it necessary to use RTRIM?
1145. View with Grouped Data.
1146. Failure in sp_detach (even though success is reported)
1147. ADO.begintrans locks the whole TABLE instead of ROW
1148. Web Browser Cell Back Ground Colour Doesn't Print
1149. call user defined fuction using vb.net
1150. NET SEND through xp_cmdshell
1151. Error running stored procedure
1152. Web Browser Cell Back Ground Colour Doesn't Print
1153. Removing triggers
1154. Functions Issue
1155. Select Statement - Please Help
1156. add user to public role
1157. Newbie Question
1158. convert to rows challenge
1159. Using CASE statement
1160. Assign Users to a role
1161. smalldatetime without time in MsSqul Server.
1162. Live process to remind users
1163. Equivalent of LTRIM of Oracle
1164. Security Issue
1165. Error: 'already an object named x in the database'
1166. Cross database granting
1167. A non-deterministic or imprecise User-defined function - Why ?
1168. How to add a database diagram by means of a script
1169. Import + ActiveX (cross)
1170. Cast and + problem
1171. Windows Login Name
1172. Date of Week problem
1173. batch file to create database schema and procedures
1174. String comparison using compatibility collations
1175. DB Restore Problem
1176. How to check if database already exists
1177. Application not showing up in Current Activity window in SQLEM
1178. CASE Statements
1179. Generating a Who's Online list
1180. Counting Characters - a tip
1181. Trimming a field value
1182. Calculated columns in VIEW
1183. Complex calculated columns
1184. nested Insert Exec
1185. Strange Trigger Behavior
1186. UDF Oddity
1187. Adding a record and returning the identity value??
1188. Replication/synchronization in a SQL Server 2K db
1189. Adding a record and returning the identity value??
1190. add user?
1191. Working with large string - over 8000 bytes
1192. DSN or DSNless connection?
1193. looking for an experienced programmer to write a script
1194. Flag the second job not to run
1195. Re: Join working in access but not in sql-server - for me a "strange join" I need help in
1196. Count Records
1197. Join working in access but not in sql-server - for me a "strange join" I need help in tran
1198. Weird Update Trigger Problem
1199. SELECT from two different servers
1200. Converting a varchar value to an integer value...
1201. Trigger for audit log
1202. Converting a Hex Number to Integer Value...
1203. SQL debugger doesn't work in some databases on same server as others that do work??
1204. Effect on cache for prepexec vs. prepare/execute
1205. replace
1206. How to SET Variable from a Select SQLSTATE 42000 ERROR 107
1207. BLOB info
1208. Finding most recent record
1209. Any thoughts on how to do this?
1210. SELECT STATEMENT
1211. Q: How to efficiently connect to a database in ASP.NET for many queries...
1212. How to get a connection id for Connections
1213. Must qualify User Defined Function with owner
1214. tricky stored procedure.. any ideas from SQL gurus?
1215. Yukon:Regress or progress - you decide
1216. SYSFOREIGNKEYS - need more info
1217. View to drop or not?
1218. T-SQL @@Identity
1219. Sum (Subtotal) Across Fields
1220. Visual Basic - Which edition
1221. variable
1222. Please help with this procedure
1223. Recursive Query
1224. List of DB Users
1225. A question about Views
1226. Funky order by ...
1227. Printing
1228. complex sql question (stadistical)
1229. Q: is there a 'BUT NOT' statement for Select statements?
1230. Q: About Replication.
1231. Query Between Dates
1232. Stored Procedure query help
1233. Store procedure receiving data type table paremeters
1234. Faster way than 9 left joins??
1235. Preserving data after structure update
1236. table type - alter
1237. i need a join
1238. check if a table already exist?
1239. debugging DTS custom task written in C#.NET
1240. Condition in select
1241. Indexes and primary keys, from Delaney
1242. Create View on a Remote Database
1243. Table Structure
1244. Help Stored Procedure SQl Statement
1245. Anyone can give me some advice?
1246. ELSE UPDATE
1247. disconnect after starting procedure execution?
1248. Information Message Returned From SQL Server 2000
1249. permissions for db role
1250. DATE TIME FUNTIONS
1251. MSDTC error on Windows 2003
1252. Case When Question...
1253. Dates
1254. Connecting to MS SQL from Linux?
1255. My guess is stored procedures
1256. returning vars from one sp to another
1257. Cursors to Result Set Programming
1258. Export Data Query
1259. TEXTPTR param into extended stored procedure
1260. How to select just first item in a group
1261. SQL statement question
1262. Identifying rows in update trigger when primary key has been updated
1263. OpenQuery with Active Directory
1264. Replication components were not included when SQL server was installed on 'sqlsrv1'
1265. DateName Acts Weird
1266. return table and count with sp_msforeachtable
1267. UNION ALL
1268. Recompile question
1269. parse non-fixed field
1270. Timeout Expired exception
1271. Transactions Roll Back and Commit
1272. #temp table scope and anomolies
1273. getting data in triggers
1274. Cursors to Result Set Programming
1275. Trigger
1276. Is this update possible without using a cursor?
1277. Passing TABLE parameter
1278. dbnet issue accessing numeric fields
1279. Re: Beginner: alter table and update doesn´t work ...
1280. [Server].[dbname].[dbo].[tablname] alias
1281. Stored Procedure Advice needed, can you improve this?
1282. Simple select using calculated column
1283. Re: Beginner: alter table and update doesn´t work ...
1284. SQL and IIS
1285. Starting Date of Week(Week Number Issue)
1286. Removing the IDENTITY property
1287. Performance Creep
1288. Stored Procedure help
1289. Maintain Identity Columns w/o DBO
1290. dateTime
1291. Troubleshooting -2147217871 Timeout Errors
1292. User-defined functions in where clause
1293. How can I handle a stored procedure whose parameter may be more than one value
1294. Stored Procedures
1295. More time series questions
1296. Yukon and 2000 coexistance
1297. Modifying big files
1298. sql server
1299. Scripting Lots of Stored Procedures
1300. Error when calling function
1301. Bulk Insert error
1302. What's Wrong With This Table Name?
1303. HELP: STRING FUNCTION
1304. What's Wrong With This Table Name?
1305. Scheduled job question
1306. Mulitple MAX select
1307. SQLServer Backup makes Server HUNG
1308. Re: Beginner: alter table and update doesn´t work ...
1309. timestamp
1310. SQLServer Backup!
1311. How to assign values to a TEXT datatype in SQL
1312. Compare Triggers/stored procs.
1313. Re: Beginner: alter table and update doesn´t work ...
1314. error while executing this query
1315. lock a record with select statement
1316. Sum on subform
1317. Beginner: alter table and update doesn´t work ...
1318. Shutting down SQL
1319. Truncate table being referenced by a foriegn key
1320. Testing Performance of Queries.
1321. Windows NT domain name
1322. BULK IMPORT out?
1323. Mulitple MAX select
1324. Mulitple MAX select
1325. Check Syntax Issue
1326. handling error on SQL
1327. Error running sp_vupgrade_replication(1)
1328. tricky table modification
1329. Doesn't work - Re: Running text from stored values
1330. Thanks Joji
1331. getdate()
1332. Export data to Excel
1333. Problem with full text search in space separated integer values
1334. Many to many relationships (Design brain teaser)
1335. SQL Query needed
1336. CrossTab SQL
1337. SQL Query needed
1338. Transactions Roll Back and Commit
1339. CrossTab SQL
1340. Use CASE Statement to bring in all records or a particular one
1341. Bulk Insert Error
1342. SQL 2K -- Having Trouble Getting Three Field SUM
1343. SQL 2K - Trouble Getting the Sum of Three Fields
1344. UPDATE and SELECT
1345. debug a sp
1346. stored procedure problem
1347. parameterized Stored Procedure
1348. Help on Query
1349. Capitalizing record values inside sql table for a given field
1350. clustered index scan!!!!
1351. NetDDE problem - from a non-interactive session
1352. SQL web application fails at login. Need help.
1353. Run Dinamic Querys
1354. Searching index server from SQL Server
1355. SQL Server-DTS Package
1356. Execute IF statement to return value with in a function
1357. please help me completing this sql statement
1358. Determining What Objects have Changed
1359. Error converting a text field to a datetime datatype, who can figure this anyone????
1360. Clustered vs NonClustered Indexes
1361. Join Question
1362. Clustered vs NonClustered
1363. Create columns in Select
1364. calling sp problem
1365. Funky Error
1366. can't compare a varchar properly using WHERE
1367. calling Stored Procedures from different DBs
1368. Add multiple criteria in sum query
1369. An Update statement
1370. table join with itself
1371. Joing each byte of a field to another table...?
1372. FAST_FORWARD Cursor Slower than default?
1373. Insert generation utility
1374. Help...How to pass a datetime value to stored procedure using the Debug Procedure dialog box?
1375. To "Go" Or Not To "Go"
1376. FAST_FORWARD Cursor Slower than default?
1377. ERROR: The query processor encountered an unexpected error
1378. ERROR: The query processor encountered an unexpected error
1379. Using ADO Move() and GetRows() to page through large table
1380. Temperory Table Exists?
1381. Running text from stored values
1382. display pevious days data
1383. What's wrong with this?
1384. how to select unique based on record count
1385. T-Sql select question
1386. Collation sequence of a column
1387. SQL Developer Edition features
1388. trying to compare a 'padded' variable via a SQL query
1389. Trouble with EXEC and sp_executesql
1390. Date formatting
1391. What is a "cube"
1392. Condition select query
1393. Transaction Error
1394. thanks
1395. string from column value
1396. Update statement didn't update all the records
1397. Update statement didn't update all the records
1398. Change Only the Year in Datetime
1399. Turn rows into columns
1400. date problem
1401. Assign Line numbers
1402. Computing value with trigger in multi-rows insert
1403. Can you use a temp table inside a trigger
1404. Inserting Null values using Bulk Insert
1405. DBCC Showcontig
1406. Date format with a given formatstring
1407. Update stored procedure without modifying the timestamp
1408. Append Rows?
1409. Copy Column?
1410. test
1411. Event Viewer Messages
1412. Problems with output parameter
1413. select statement
1414. OBJECT Level Permissions
1415. Detect "calling" stored proc?
1416. Executing sql
1417. Reconcilliation
1418. ANN: Advanced Data Generator 1.0.3 released
1419. cant install SP3a
1420. Create a new system table
1421. adding data
1422. Add a word document to table
1423. Locking system tables by SELECT INTO statement on SQL2000
1424. cant install sql 2k :/
1425. fixed count of records
1426. Re: New developer newsletter
1427. Visual Foxpro to SQL-Server
1428. Maybe I didn't explain right
1429. Order, Line Num Problem
1430. Assign value from vb6 to stored procedure
1431. Server busy dialog
1432. Record locking
1433. setting up SQL Server data source
1434. datediff
1435. Literals vs Variables - turns SQL statement to slow death
1436. Time Period Question
1437. Browse Remote Database for Directory for New Database Files?
1438. DB Size
1439. Insert trigger to check duplicates
1440. Cancel Query from ADO
1441. inserted joined to linked server
1442. ASP/SQL Server Problem, INSERT Works, UPDATE Doesn't
1443. sp_renamedb
1444. Using DBLIB to call sp_executesql
1445. Character Conversion
1446. Character Conversion
1447. Help with recursive queries... BIG problem.
1448. Dropping Tables
1449. Hit counters
1450. Re: Problem with INFORMATION_SCHEMA.SHEMATAS
1451. Using a variable to specify database to SELECT from
1452. Permission Deny
1453. Percent of total
1454. Performance with Wildcards Dynamic SQL vs.Variables
1455. date
1456. Problem with INSERT INTO with string literal
1457. concatenate int with varchar arg in Values clause?
1458. Stored procedure;1
1459. ROBUST PLAN
1460. Model for a company, its parents, and its affiliates
1461. delete
1462. Several columns bad, why is last one given in message?
1463. Multiple Select Statements
1464. Identity Columns
1465. Re: the same table in différent files according a rule
1466. Re: the same table in différent files according a rule
1467. statement not allowed within multi-statement transaction (Long)
1468. Change of data source from SQL to Oracle, Unix in DTS packets will
1469. the same table in différent file
1470. collation
1471. Set first day of week
1472. How to detect the SQL Hotfixes installed
1473. Pls Help -- Upsizing from Access
1474. URGENT: Unable to begin a distributed transaction
1475. Storing a distant date for "now" when modeling temporal data
1476. small selectproblem
1477. Check Syntax Issue
1478. Common values
1479. Passing a data structure to a stored procedure
1480. Yet another question about date and time
1481. Using roles with OLAP
1482. Stored Procedure executes very slow, code pasted into query-analyzer executes fast?
1483. Date of today
1484. how can i do paging while using stored procedure?
1485. BULK INSERT how to_
1486. Just the Most Recent, Top or ?
1487. sp_who
1488. Re: Issue in Convert?
1489. Issue in Convert?
1490. Diff between Set & Select ?
1491. ODSOLE Extended Procedure Not enough storage is available to process this command
1492. Select next value from a group
1493. dynamic numbering of results
1494. IDENTITY Problem
1495. Help. I broke an Stored Procedure
1496. stored procedures
1497. Convert to datatype money
1498. Help with vars.
1499. Change user
1500. Convert to DateTime
1501. disappearing foreign key constraints
1502. Run-time error 2191 - inconsistantly appearing
1503. Very Simple Stored Proc with parameter problem when called from simple .net app
1504. architecture problem
1505. i am in a serious trouble...
1506. How to ensure that client connects to server throug the internet instead of LAN
1507. performance consideration
1508. CountrySelector control
1509. Merge Similar rows - Help needed
1510. RAISERROR descriptions
1511. Selecting Nulls
1512. Invalid attempt to read when no data is present...NOT true
1513. Print data directly from a stored procedure?
1514. Any help with tihs would be great....
1515. Specifying criteria as join condition vs WHERE clause
1516. TOAD for SQL-Server
1517. Union Query Problems
1518. char output params : blanks return as nulls ?
1519. find out query history
1520. How can I return a TEXT data type Value ( >8000) from a stored proc?
1521. SQL view
1522. What is wrong with this code please?
1523. select xml value from stored xml column
1524. Column Alias in ORDER BY not work if in function call
1525. Varchar Truncated
1526. Can I use IIF in a SELECT ??
1527. Storing and Retrieving URL's in SQL server database with ASP
1528. SQL serverdown...OLEDB-SQL driver timeout?
1529. 'Shuffling' empty address columns
1530. Create Procedure must be the first statement
1531. Need to UPDATE while conditions change...
1532. Function error
1533. Holidays in SQL Server
1534. survey of the unemployed
1535. URGENT Cannot Start Transaction While in Firehose Mode
1536. Triggering After an update
1537. URGENT Cannot Start Transaction While in Firehose Mode
1538. HELP: String UP TO 255 characters
1539. simulating oracle sequences in MS SQL?
1540. Money datatype
1541. Re: Cannot enter apostrophe (')
1542. decimal rounding issue
1543. Re: Cannot enter apostrophe (‘)
1544. Cannot enter apostrophe (‘)
1545. querying for SPs and dependencies
1546. Problem with select
1547. Named Transactions
1548. Locking problem
1549. Date time convertion
1550. Updateing info in a select
1551. Indexing in sql server tables
1552. Search for #$%^/
1553. Date/Time Conversion
1554. join inserted to database in a linked server
1555. Triggering SQL Code on Date Change
1556. triggers not working
1557. join inserted to database in a linked server
1558. advanced question - 'xlock' hint on record not locking select * from table
1559. Query Help
1560. function for current date
1561. Converting and formatting DATE field
1562. weird sorting
1563. Alphabetizing a Comma Delimited String
1564. Query to display stored procedure?
1565. Insert Script
1566. transaction?
1567. Audit Trail
1568. 'Identical' SPROCS one with an error the other OK???
1569. Transaction Logs
1570. Can I do an UPDATE while doing a sql.read?
1571. Speeding up call to a remote table
1572. pre-installed & custom content
1573. Update statement returns inconsistent results
1574. LEFT OUTER JOIN esoterica
1575. CLUSTERD INDEXES
1576. Insert using a subquery
1577. select top 'n' in stored proc
1578. T SQL Query
1579. partitioned view issue
1580. Oddity with backup
1581. security?
1582. SQL Querry
1583. Damsel in distress!
1584. foreign key relation s
1585. RE: Field Exists
1586. if exists
1587. Date queries
1588. RE: @test = "" <-- worked in 7.5 but not 2000
1589. building a library of snippets
1590. Spaces consume room?
1591. Sending SSL Email From SQL Server
1592. sp_OACreate
1593. Paging
1594. Sql Query Question.
1595. Creating my own extend stored procedures
1596. Non-clustered composite index
1597. Yet another date question....
1598. this one is weird- seems all of them true to me
1599. How do I deleting all but the last 3 records entered
1600. Yet another date question....
1601. sql2000 + win2003 server
1602. Dates
1603. Getting the Date as string yymmddhhmmss
1604. Overflowed int column - Additional info
1605. Overflowed int column
1606. this one is weird- seems all of them true to me
1607. Trigger in System table
1608. Sql Help
1609. VB6 call to SPROC
1610. 2pc
1611. Need help with this
1612. struggling with this
1613. and this too thanks a lot.
1614. Pls help with the answer
1615. Need answer to this
1616. VB6 call to SPROC
1617. Function question
1618. Combining one to many tables into single record with a procedure
1619. different
1620. Understanding non-equity join criteria
1621. Trouble with NULL values
1622. Auto growth question - query timeouts?
1623. SQL Server Error
1624. If I am adding a record to a table using a SP, how can I make the SP return
1625. SELECT TOP X (Pass parameter to X)
1626. Re: Question..Best practices for very large tables..
1627. CASE and UPDATE
1628. TSQL DELETE
1629. Problem with a Temporary Table
1630. bitwise operation questions
1631. sendmail - ssl
1632. exporting sql queries
1633. Script to find out about what database an object belongs to
1634. dilema
1635. Find without a recordset?
1636. More than 255 bytes in Last TSQL Command batch?
1637. Create Custom Error Message
1638. survey of the unemployed
1639. good TSQL site/ class
1640. Get newest entry for each employee
1641. Date format
1642. Changed from ODBC to OLEDB, now stored procedure doesn't work
1643. ROLLBACK TRAN / TRIGGER
1644. Renaming A Column In SQL Server 2000
1645. Trying to get two decimals after converting data type
1646. Help with Select query
1647. Stored Procs when designing databases
1648. Two tables and count
1649. test
1650. Need to read/write an image file (.jpg)
1651. Best Practice to Encapsulate Update to Table
1652. how to create cursor which holds data and then available in layout's data environment ?
1653. Dynamic SQL Performance
1654. Stored procedure/trigger and scripts
1655. Remainder
1656. add new colum to a table from a variable
1657. GetDate(): Bug? Feature? Anomaly?
1658. Ad hoc queries with OPENROWSET
1659. Count number of user logins
1660. Linked server and distributed trans (not loopback!)
1661. Latest from a date range
1662. Nested SELECT possible like this example?
1663. Can`t call CURRENT_TIMESTAMP from within a user-defined function
1664. Error installing MSDE 2k Analysis services
1665. Error when trying to execute an SP for insert data in Oracle with Linked Server
1666. xp_sendmail...@query
1667. ASP and stored procedure
1668. function argument and odbc escape syntax
1669. build where condition
1670. t-sql debugger
1671. Storing the result of a EXEC(something) in a variable
1672. Proc Validation tool
1673. sp_executesql
1674. View Fails upon Underlying table change
1675. User Defined Functions ???
1676. vb.net question
1677. CASE Statement Question
1678. Modifying temporary tables errors
1679. full text search in russian
1680. Catch error on server side or on T-SQL
1681. on delete, on update
1682. Simple UPDATE query?
1683. IF Statement
1684. top 10 gun
1685. Get Job Name in Job Step
1686. Need help on trigger and Visual Studio .NET
1687. IF Statement
1688. View Fails upon Underlying table change
1689. Re: Transaction log growth (more)
1690. SQL 2000 and ADO.Net SqlTransaction Problem
1691. Urgent!! How to recover the deleted table
1692. Retrieve error text from extended stored proc
1693. Manipulate data use TSQL
1694. Proc Validation tool
1695. Do your design(s) violate 2NF (and thus 3NF, etc)?
1696. MAX Function
1697. Re: Why??? Point me to a reference??
1698. Is there an internal reference to primary index column?
1699. converting 0 string to datetime
1700. Extracting Month and Year into one field
1701. Transaction log growth
1702. Null
1703. How can I select 2 row from the table
1704. String Functions
1705. Design question
1706. cast varchar into money
1707. finding the running store proc Input parameters value
1708. Set based SQL instead of Cursor
1709. Help with a query
1710. Date Format
1711. How to Run ASP natively in SQLServer7
1712. Getting maximum character values in a populated column
1713. Exporting data to VFP and Access in TSQL
1714. Sysdepends Query to find out order that stored procedures are created
1715. View Creation Q
1716. ntext field size
1717. Trigger question, using OR with UPDATE
1718. Dynamic Column Headings in SQL
1719. Re: GROUP BY
1720. xp_sendmail...@query
1721. Problems with ntext, nvarchar
1722. Linked Server Issue
1723. Converting IP addresses from decimal to dotted decimal notation and back
1724. how to get the table schema?
1725. BCP utility in a batch file...???
1726. running accumulative value in select statement
1727. Password Encrypt/Decrypt
1728. How to retrieve only the Date from date time field
1729. Underscore Wildcard
1730. group by question
1731. Syntax error converting from a character string to uniqueidentifier
1732. RAISERROR
1733. Question on choosing primary key; real or arbitrary
1734. sp_cursoropen e sp_cursorfetch
1735. Search methods, "fuzzy" logic, duplicate checking, oh my!
1736. INSERT takes ages...
1737. Need a better way to add a record
1738. Sql Query Question
1739. Need help with sp, please
1740. delete duplicate records (problem to update related table)
1741. Transact SQL Question
1742. Error 17883 May Display Message Text That Is Not Correct
1743. HELP..asterisks in data
1744. Timeout Problems
1745. High resoloution DateTime type
1746. Cursor in a trigger
1747. Re: Table Contents Last Changed
1748. Query Analyzer
1749. Windows service
1750. nested triggers
1751. Efficient processing - ASP vs. SQL Server
1752. Serious issue after maintance plan
1753. nested delete triggers
1754. Select from linked server
1755. ADO problems with ntext, nvarchar's
1756. temporary table
1757. Stored procedure into an ASP
1758. Grouping Fileds
1759. A tricky update close to be dangerous
1760. SQL Server 2000 Designing CBT...HOT
1761. from sp output query result to txt file
1762. querry for remove half table random?
1763. DTC on win2003 disabled by default?!
1764. @@ROWCOUNT
1765. Querying Data
1766. SQL Query Needed
1767. sub-query vs dynamic sql, error
1768. SQL query web site!
1769. Splitting a large query up into slices, and handing them off one by one
1770. xp_cmdshell and vb programs and SQL Server 2000
1771. Date comparison
1772. HowTo extract ids like varchar(100) = "5, 33, 229, 1, 22" to a Table ?
1773. HowTo UNION multiple exec GetTables ?
1774. Difference between create table #temp and ##temp ?
1775. DECLARE cur CURSOR FOR EXEC ('SELECT....') does not work. Any solutions?
1776. Datetime Semantics
1777. pre--importing
1778. mark development DB
1779. Stored Procedure vs C++ component
1780. Double-quoted unicode strings
1781. How to compare prev with current rows in the table for each ID?
1782. Dynamic Search Conditions
1783. aba_lockinfo - new version available
1784. osql txt file output problem
1785. Joining Excel Database with MSDE Database Table, & Import
1786. Getting Max for time plus other fields
1787. BCP question
1788. table sequence in a referential integrity chain
1789. Personal SQL Server 2000
1790. Dynamic Search Conditions
1791. Restrict number of connections to a databse.
1792. How to SELECT with "DISTINCT" on only 1 field?
1793. Sorry for repeating my Q but I hardly got any response yesterday
1794. Parameterized Stored Procedures - Complex Search Conditions
1795. How should I store city, state values for addresses, please help.
1796. SYSPERFINFO Table
1797. xp_sendmail
1798. char(9) or char(13) do not work in my query
1799. Backing up and restoring database to remote server
1800. number fieds ( scale) problem
1801. Double.NaN and SQL float data type
1802. need help on stored procedure which can return a text colume
1803. Insert value from a while loop
1804. (design question) non-unique clustered index confuses optimizer
1805. can alter table be used to change a column type?
1806. how to select the current user and current database name?
1807. unable to execute an update command to a table
1808. unable to execute an update command to a table
1809. Re: PART II
1810. User Functions in batch inserts
1811. Summing Field
1812. execute SP at same time??
1813. How to get a grapical documentation of my tables ?
1814. Order by behaviour
1815. How can I improve this code please?
1816. problem using identity column as primary key
1817. Need help with SELECT Query
1818. runtime error -380 invalid property value
1819. Odd Order by behaviour
1820. Time interval
1821. Left outer join fails
1822. INSERT INTO
1823. Date Formatting
1824. How to calculate 25 working days
1825. How to handle hierarchy processing like this
1826. Computing Someone's Age
1827. SQL AND ASP
1828. Automating Script Execution
1829. SP slower then Query
1830. syscacheobjects
1831. DISTINCT vs GROUP BY
1832. Invalid Class string launchimg a DTS
1833. Stringa dell'interfaccia non valida
1834. How to make a 'periodic' website counter?
1835. recommend good book on sql 2000
1836. How to insert non-Unicode CJK string to SQL with DBLIB if SQL default
1837. Trigger update datetime
1838. Keeping a Running Count
1839. Case Statement
1840. Numbers table and groups
1841. Distinct Values
1842. Inner Join SP
1843. T-SQL help
1844. HowTo merge columns from different tables to one table?
1845. select field with datetime data type
1846. How can get random items
1847. HowTo send myid in (1, 2, 3, 4) to a Stored Procedure?
1848. Break a list to four smaller list
1849. Logins after sp_attach_db
1850. Join on the Group By Column
1851. Stored procedure calls multiple stored procedures
1852. join 2 different fields
1853. case statement with datetime column
1854. Duplicated fields
1855. Stored Procedure Performance Help
1856. BCP call to stored procedure - broke during upgrade from SQL 7.0 to 2000
1857. Missing rows in stored procedure results
1858. Problem with SQL Statement
1859. Error 170
1860. bhatt
1861. Query to delete duplicate records in staging table
1862. Syntax error converting from a character string to uniqueidentifier.
1863. Import/export file in DTS
1864. Is_Member function not returning expected results
1865. problem between VB and SQL on data type
1866. VB accessing a text field in a table. - with code
1867. Damsel in distress!
1868. Stored Proc using "like"??
1869. Filtering in an N to N relationship
1870. Stored procedure Parameters
1871. Filtering in an N to N relationship
1872. Stored procedure hung up
1873. Insert ?
1874. Custom-generated SPID
1875. How to use do while or any loop in select statement ?
1876. Query Help
1877. Damsel in distress!
1878. Stored procedure - long execution times
1879. Need help with the OUTPUT Parameters please.
1880. Insert Retrieve
1881. using a sp return value within another sp
1882. How to call Store Procedure from VB6 ?
1883. Collecting data from fill-out/data entry forms
1884. How to call Store Procedure from VB6 ?
1885. How to call Store Procedure from VB6 ?
1886. hexadecimal to int
1887. Allowing Users to change their passwords remotely
1888. Re: New Books Online Update Available.
1889. Backup failed!
1890. Limitation of number of character in one job
1891. Encryption of data
1892. How to perform allocations in T-SQL
1893. How to do a join in a delete
1894. Really need a copy of ver 6.5 to restore backup to 2000 - Any Advice ?
1895. Stored Procedure Help required
1896. Procedure parameters from select
1897. how do I execute an sp ina select statement
1898. datetime functions in SQL Server 2000
1899. Query Analyser
1900. Attaching a 7.0 db?
1901. Auto Exiting Store Procedures
1902. Understanding a function in a SQL Query
1903. Make changes to record
1904. Description in the table
1905. Relations between Tables & SP's
1906. Re: Help needed with IIF syntax - Thank you!!
1907. 'Parameters' question
1908. Help needed with IIF syntax
1909. Security
1910. Make change on record
1911. use of INSERT with Dynamic SQL
1912. string in a query
1913. Problems with date and other countries
1914. Truncating, Deleting or Shrinking Log File
1915. Please help me with this query...thanks
1916. Programming DDL
1917. BCP from a database that has a "." in the database name
1918. Pass SQL function as stored procedure param?
1919. Top Caluse With Variables without SET ROWCOUNT
1920. Reference to more than one table
1921. Query for dropped objects
1922. select column if
1923. Problems trying to delete an SQL Server login with access to 2 different databases
1924. nDoc for sql
1925. Transaction query
1926. Variable list of values in column
1927. How to Execute a Stored Procedure from SQL-DMO ?
1928. AFTER INSERT?
1929. Sound delete-Trigger?
1930. Stored Proc - "Optional" parameters
1931. Dynamic "IN" clause or something better
1932. Should using a cursor be THIS slow?
1933. Using OSQL utility
1934. select from 3 tables, how?
1935. reference a database in SP
1936. SQL with Sybase
1937. numbering my records based on a grouping
1938. Syntex error
1939. SET NOCOUNT ON causes trigger to fail
1940. Wildcharacters and %
1941. MAX from multiple columns?
1942. ODBC failing - Driver outdated
1943. Re: Disable Trigger within a Trigger
1944. Aaron Bertrand - MVP (your message is unavailable)
1945. UDF Passing a Column
1946. disk space low
1947. Re: Grouping Records & Assigning Sequential Number
1948. Insert Select Default Value
1949. SQL Server 7.0 Stored Procedure
1950. Triggers - deleted table
1951. removing duplicates from a table?
1952. Insert Select Default Value
1953. HTTP request from sql server agent scheduled task
1954. Remove or disable primary key on table
1955. SQL Server 7.0 Stored Procuedures
1956. VB accessing a text field in a table on SQL server 2000
1957. Locking design question
1958. max in subquery
1959. Update SQL text field from ASP page using command object
1960. Url
1961. Add autonumber or identifier to query results
1962. Run .sql files from ADODB in vbs
1963. Query for dropped objects
1964. what's the difference
1965. buffer overrun
1966. BCP Query Question
1967. Re: recordset from a temp table /ty (resolved)
1968. dynamic column name in T-SQL?
1969. Need Help with Script output
1970. recordset from a temp table
1971. Re: CreateObject("MSXML.XMLHTTP")
1972. Update SQL text field from ASP page using command object
1973. Linked server from SQL Server to Access db on network share?
1974. Problems in connection with DSO object
1975. Data Types
1976. User defined function of Type aggregate ??
1977. Stored proc issue... Best parameter type to use?
1978. shotening field and right justifying at same time
1979. Order By problem
1980. shotening field and right justifying at same time
1981. Profiler execution warning not document
1982. Row Locking and Transaction
1983. Stored proc issue... Best parameter type to use?
1984. Database Users
1985. SQL 6.5=>2000 Upgrade: ?Lint like tool for identifying potentially problematic
1986. SQL Question
1987. STORED PROCEDURE
1988. Reference to more than one table
1989. How to findout Eliminated record by when use Distinct function
1990. Locking
1991. Preventing Profiler from viewing queries
1992. RE: QueryValue returns wrong value?
1993. Assignment in SELECT-statement with FROM. Number of loops.
1994. STORED PROCEDURE help required PLEASE.....
1995. Exists efficiency query
1996. Convert negative figures to zero
1997. HELP! - UPDATE trigger
1998. can anyone explain this (NOT IN error)
1999. PEAR DB 1.6.0 has been released
2000. How to insert non-Unicode CJK string to SQL with DBLIB if SQL default collate is non-CJK?
2001. Re: Trigger problem
2002. A Query Problem
2003. list subdirectories in linked server?
2004. calculating Truncated Averages... can we create Custom Aggregate Functions?
2005. Dynamic Table Creation for use in Transaction Component
2006. partitioned views
2007. Parameter Query
2008. Script to assign default values
2009. Partitioned View Update
2010. Stored proc recompilation
2011. Passing part of Column name as a parameter
2012. Trigger question
2013. Sort Order
2014. Re: Group and Order By Day Only
2015. Weird results when rounding floats?
2016. BDE conecting to MSDE.
2017. Logical snafu, separate years same query different fields.
2018. Int faster than Money?
2019. Can I do this? Add constraint that uses a table
2020. Is it security?
2021. Next specific day compare
2022. Int faster than Money?
2023. newbie question on SQL Server, ODBC
2024. 2 queries in XP_SENDMAIL
2025. to null or not to null
2026. Audit Trail Functionality
2027. how to use a field in DATEADD for the datepart
2028. Count Function
2029. Transaction Log Delete
2030. rounding money
2031. sql question
2032. Enterprise Manager generated scripts prefer reCREATE a table instead of ALTER the table, why?
2033. I'm Progressing with nested SPs!
2034. Query Plan Differences
2035. Set Database to DBO Use Only after the user transactions completes
2036. REQ: Help in constructing a query...
2037. Multipal rows of data out putted to one row,
2038. Setting for Data Case Sensitivity
2039. Missing/Hidden Templates In QA
2040. Stored Proc - SLOW, Query Analyzer - FAST
2041. Map SPID to User Accounts
2042. Stored procedure returning
2043. Restore using SQL DMO Problem
2044. Create Date in Enterprise Manager not sorted correctly
2045. STORED PROCEDURE HELP NEEDED
2046. use of cursors
2047. Updating with aggregate functions?
2048. BCP missing some tables out
2049. List of Sql Server Registrations
2050. http requests
2051. Automatically Adding DB Objects to VSS 6.0
2052. Error: Could not complete cursor operation because table schema changed....
2053. Is Set based solution available instead of Cursor?
2054. PROBLEMS CONVERTING ACCESS QUERIES TO A STORED PROCEDURE
2055. Dynamic order by
2056. Create index in a table
2057. Converting objects from 6.5 to 2000
2058. SemiPivot structure.
2059. SQL TreeView Versioning
2060. Running Sums
2061. Rounding issue
2062. Top Caluse With Variables
2063. Stored Procedure Advice
2064. DbLib programming question
2065. Table Locking in .NET Transaction
2066. Error: Could not complete cursor operation because table schema changed....
2067. coping roles
2068. Rename My DB
2069. returning a vairable from an sp
2070. Beginner Struggling
2071. Date Format in SQL Server
2072. error with
2073. temp table in function
2074. Stored procedure tuning
2075. Performance problems with complex queries in stored proc.
2076. Locking...
2077. Replace Cursor Procedure with Update Query?
2078. Append vs Make Table - Total Record Limits?
2079. correlated subqueries and general subqueries.
2080. RE: How can I find a record and get it's fields in a string?
2081. concept
2082. Trigger doesn't operate on view?
2083. Help Please -- ADODB.Command does not work correctly in .NET
2084. RE: Disaster recovery options - revised
2085. Joining two tables
2086. RE: Need help with SELECT statement please.
2087. RE: Renaming an Access table
2088. getting a column from an inserted row on trigger event
2089. how to stop raising an error!
2090. RE: please help me
2091. BULK COPY changes row order importing Text file
2092. SQL_Server_does_not_exist_or_access_denied
2093. output file via xp_cmdshell
2094. SP order by
2095. datediff
2096. Re: Cursors in UDF
2097. Bug of Query Analyzer of SQL Server2000?( linked server problem )
2098. Is this a hack?
2099. Is this a hack?
2100. converting datetime to unix datetime
2101. Re: Copy of database
2102. RE: need some quick tips
2103. Nested Model
2104. how to query other microsoft system database with query analyzer?
2105. Trigger - Instead of Update
2106. Convert VarChar to Date
2107. Dynamically drop and create FKs
2108. repost - Triggers and inserting data into of other table
2109. Make an update into one query
2110. How do I post getdate() function in text box (asp.net)
2111. BLOB
2112. triggers
2113. Not exists performance problem...
2114. Dynamically drop and create FKs
2115. Sybase VS M$ SQL
2116. SQL server create table from client fails
2117. delete next to highest value in table?
2118. Count Distinct Items
2119. Pass string of comma seperated values for IN clause
2120. Query performance: order of joins/wheres...
2121. Grouping
2122. Order by clause...
2123. Wrapping Extented Procedure in UDF returns null
2124. DbLib and Oracle (?)
2125. Increasing performance of query using a bit field
2126. retrieve value of output parameter from Stored Procedure
2127. Naming Conventions
2128. Update multiple table columns using subquery
2129. cursors in stored procs
2130. Re: Detecting Implicit data type conversions
2131. question for memory leak?
2132. Linking
2133. Can you use dynamic column names in an update
2134. How to reduce the Log file
2135. simple select statement with case not working
2136. Linking
2137. removing IDENTITY attribute
2138. SQL Server Client
2139. Choosing data types to conserve space
2140. Update
2141. Joining Adjacent Time Intervals
2142. Triggers and Deleted table
2143. Example of stored procedure with OUTPUT parameter of type TEXT
2144. how can i debug a scheduled job ?
2145. Searching tables for matches with other tables
2146. Order By with Union
2147. Making a string XML-Friendly ?
2148. Cursor Type
2149. Query Statment is Fast But Stored Procedure is Slow
2150. Backup Database
2151. Syncronizing SQL Servers in t-sql code
2152. Alert Interegation
2153. Heterogeneous queries error
2154. Heterogeneous queries error
2155. convert varchar to int
2156. StoredProcedure vs. Recordsets
2157. UPDATETEXT on memory tables
2158. REQ: How to create a Sort Order Col on the fly?
2159. User right DB schema suggestion
2160. Problem with precision with decimal value
2161. Copying TEXT columns
2162. Re: Trigger problem when deleting rows
2163. Getting the most recent date
2164. Re: Union Compare [OT]
2165. Create SQL statements based on table fields values
2166. TRANSACTION ERROR
2167. SQL statement with 2 tables
2168. UPDATE statement
2169. Incorrect syntax near the keyword 'where'. Severity 15, State 1, Procedure 'LH30
2170. Using expressions AS a select clause
2171. Incorrect syntax near the keyword 'where'. Severity 15, State 1, Procedure 'LH30
2172. Direct query vs Query in a stored procedure
2173. RE: View interpretation by the query optimizer
2174. Re: Query Builder
2175. SQL and left join
2176. Stored procedure exit without any error message
2177. Joe Celko's work with nested set models - update times??
2178. Error Handling
2179. problem with OSQL in a batch file
2180. Copying Stored Procedures from One Database To Another
2181. Slow performance after restarting
2182. Import Text File with procedure
2183. How do I keep from going over VARCHAR?
2184. Slow but critical SQL query
2185. Re: Read backup header information
2186. Re: Using a network drive to hold databases
2187. Re: can you manage sql server 2000 remotely?
2188. are long lasting connections ok?
2189. order by
2190. Re: Union Compare (Is this Possible?)
2191. How to Update an identity column?
2192. Table copy
2193. PERL and MS SQL Server
2194. PERL and MS SQL Server
2195. problem executing sp_executesql
2196. TSQL Help on removing duplicate rows except first and last row
2197. Still getting invalide column name 'item_itemnumber'...
2198. Populate a field with MAX(column)+1
2199. ATL OLE DB and SQL Server
2200. Problem converting IIF to CASE statement
2201. trigger vs CASCADE
2202. basic Constraint syntax question
2203. How to convert/copy memo field to text ?
2204. Median Value
2205. Max lenght of column_alias, table_alias
2206. Adding up values within a table
2207. max_error in bcp
2208. Carriage returns
2209. Union Compare
2210. Re: date customer first ordered
2211. Appending data to a table
2212. Why do I get Invalid column name?
2213. How to Create Holidays Table?
2214. What Kind of Query / Join
2215. Increment Int Field in Update Statement with objCommand
2216. transaction question
2217. t-sql READTEXT weirdness
2218. Re: checking file existence with sql
2219. Shot in the Dark??
2220. t_sql syntax
2221. Derived Tables
2222. Substitute for Identity
2223. Re: Not been able to get OUTPUT values from stored procedure in Query
2224. Not been able to get OUTPUT values from stored procedure in Query Analyser
2225. Re: Transforming databases...
2226. Cannot resolve collation conflict for equal to operation
2227. RE: Query Analyzer vs. application anomoly
2228. isnumeric-error in result, attn Microsoft
2229. Passing in Parameters to Stored Procedures
2230. store procedure to write multi lines to txt file
2231. break one record into many
2232. SET NOEXEC
2233. Its possible in a stored procedure...
2234. How to create a computed column in a table with enterprise manager
2235. Update from one table to another.
2236. linked server
2237. How to tracking trigger
2238. Recompiling without executing stored procedure
2239. How do I retrieve Stored procedure code from SQL Server?
2240. XML Data Type and Stored Procedures in Yukon
2241. select comparison
2242. foreign key constraint without database diagram
2243. RE: Update procedure
2244. ADO question
2245. About Round Function
2246. Parallelism and Inconsistent Results
2247. break one record into many
2248. Find duplicate records where four or more fields match
2249. How to Rebuild a View in SQL 2000?
2250. foreign key constraints between tables in different databases
2251. sql syntax question - returning 3 test rows - use "VALUES"?
2252. Question for Microsoft guys
2253. sql debugger datetime parameter
2254. Basic Select into query problem
2255. Making Row to Columns
2256. Re: Connection Broken
2257. Re: Error on database Restore and timeout error message
2258. Re: cannot switch from LOOP JOIN to MERGE/HASH JOIN
2259. Replace duplicates with blanks in outer join
2260. NOLOCK/Read Uncommited Question
2261. database login vs. operating system login function
2262. session_user vs. loginname
2263. Reaching columns -in C#.net- in queries with multiple tables with the same column name
2264. How to get the 0 counts in a group by ?
2265. Splitting values from one column into two new columns
2266. Re: Listing all columns with with tables and key status
2267. Test if field is null in stored proc
2268. Select with column name as variable (in cursor)
2269. Re: Help creating a view ?
2270. Re: create row numbers in view
2271. Re: Order by case....
2272. Linked server query error
2273. speeding up a query
2274. generating values
2275. execution plan
2276. Quering a Details table or Full-text indexing?
2277. Adding a counter to each "unique index" by member
2278. Select Distinct problem
2279. Binding a different owner default to a UDT
2280. Odd trigger behavior (according to me)...
2281. Copy of Table
2282. Using expressions in a SELECT Clause
2283. Thai Language insert, Update
2284. if in select
2285. User Search Performance
2286. Splitting one column into two
2287. isnumeric does not recognize decimal
2288. Re: How to write back a SQL Server table from Excel
2289. Using SQLDMO to find all the dependant objects
2290. How to pass an Excel range as an argument to a SQL Server stored Procedure
2291. Error handling in MSSQL - if error during call remote stored prcedure I need SQL code to continue...
2292. Why does this crach??
2293. Renaming an Access table from SQL Server
2294. Its possible make this in a store procedure
2295. Re: Help with query?
2296. Avoid returning resultset from stored procedure
2297. how do I get the return value?
2298. Local Packages vs Meta Packages
2299. Avoid returning resulset from stored procedure
2300. Re: Blocked remote calls with COM+ and MSDTC
2301. testing @@error in SP
2302. Re: performance : successive queries versus join
2303. Re: those params not included get current values
2304. Avoiding circual references - help with algorithm...
2305. QA implicit transactions & creating SPs
2306. RE: temp table cause recompile
2307. Query
2308. New SQL Server Tool
2309. RE: Compiling Stored procedures
2310. triggers
2311. how to scramble data in a table
2312. error systax :156
2313. How to format data in SELECT
2314. create multiple tables
2315. RE: Convert hex string to bigint
2316. RE: Dynamic SQL & Linked Servers
2317. Alter table by adding new column with not null
2318. RE: UNION??
2319. Re: DB-Library: dbopen fails intermittently
2320. Re: Exec a SP within a insert statement using #TmpTable
2321. Logged Actions
2322. Re: Sql Stored Procedure returning null
2323. Re: UPDATE Using Previous Record Value
2324. Re: Date Problems
2325. How to get a value from another column where MAX(field) = TRUE?
2326. Re: New SQL Server tool
2327. Count Query help
2328. Re: sp_MSforeachDB and sp_spaceused
2329. what is the value of a currency format column and....
2330. SELECT DISTINCT?
2331. Solution needed to query linked servers and get results into tables on central server
2332. Query
2333. Delete records with Sp /trigger
2334. Re: Avoid returning resulset from stored procedure
2335. Re: Default database in Query Analyzer
2336. Re: Avoid returning resultset from stored procedure
2337. Re: Nested Stored Procedures - Transaction Problem
2338. Re: select query problem
2339. Re: Help Primary Key violation
2340. Re: Need Help in QUERY
2341. Re: Trying to remove multiple spaces in a string
2342. insert current datetime
2343. Re: Avoiding Rowguid as PrimaryKey, is my idea workable???
2344. Re: How to connect programatically to another server?
2345. Need Complete SQL Queries for the reference
2346. Re: Limit Rows Returned from SQL Stored Procedure
2347. Re: bcp_control hints (-c option equvalent)

vBulletin® v3.8.4, Copyright ©2000-2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0