microsoft.public.sqlserver.programming
By Thread
7632 messages sorted by: [ date ]
Starting: 02/29/04
Ending: 03/31/04
- update query problem rocket_at_office (03/31/04)
- Version control Utada P.W. SIU (03/31/04)
- Formatting datetime to MMDDYYYYHHMMSS Jeff Dillon (03/31/04)
- Full text search catalog Murtix Van Basten (03/31/04)
- update query chris (03/31/04)
- Cascade Delete not working Aaron Prohaska (03/31/04)
- @@Error Issue Tuoc (03/31/04)
- Union and Order By problem Guy Brom (03/30/04)
- Using stored procedure as table source in FROM clause AndrewH (03/30/04)
- Help with constraint Star (03/30/04)
- problem with loop chris (03/30/04)
- VBScript and an INT column - how to "show all"? Nathon Jones (03/30/04)
- using defaults for constants Guy Brom (03/30/04)
- Convert to Varbinary Sammy (03/30/04)
- What is the max number of columns in a table of a SQLXMLBulkLoad James Chin (03/30/04)
- Table/Pky in separate filegroups Simon (03/30/04)
- Good Third party tools to replace SQL Query Analyzer? Mark Andrews (03/30/04)
- linkserver error SQL Apprentice (03/30/04)
- 3 column Order By clause in an S-Proc Gary D. Rezek (03/30/04)
- Table design with nullable columns Dwight Trumbower (03/30/04)
- I know I have asked before but.... sh0t2bts (03/30/04)
- order by? Richard G (03/30/04)
- Conversion Edmund (03/30/04)
- large nvarchar index consideration Guy Brom (03/30/04)
- - Logical Scan Fragmentation - Dan - (03/30/04)
- Can't Figure This Out Wayne Wengert (03/30/04)
- SQL 2000 new features Ata John (03/30/04)
- trigger problem chris (03/30/04)
- ISNULL in WHERE clause Gerard (03/30/04)
- Dynamic Sql A.M (03/30/04)
- Re: temp store Eric Sabine (03/30/04)
- How do I read a binary(16) field in VC6.0 using an ADO recordset? Jim Cutler (03/30/04)
- Running dynamoc SQL code Eric D. (03/30/04)
- Logical File Names JI (03/30/04)
- Repost: Possible SQL Query Analyzer memory leak or other problem Baolin Ren (03/30/04)
- Trigger with aggregate possible ? Mark M (03/30/04)
- Syntax Error near Louis (03/30/04)
- connection specific variable Rob Balcer (03/30/04)
- find a value in database joe (03/30/04)
- simple delete statement runs forever Mike Kanski (03/30/04)
- Stored Procedure Monopolizing SQL Server Resources faels (03/30/04)
- Stored procedure question Jason Hurder (03/30/04)
- Call User-Defined Function within a User-Defined Function? Lawrence (03/30/04)
- EXEC in UDF Eric D. (03/30/04)
- Writing a .Net app to controll DTS packages Jim Covington (03/30/04)
- Removing commas johnduran (03/30/04)
- xp_sendmail and excel column formats Tim (03/30/04)
- Passing parameter set to StoredProc CJM (03/30/04)
- IN statement with variable Fredrik Melin (03/30/04)
- Combining updates Hugo Kornelis (03/30/04)
- localization issue and defaults Guy Brom (03/30/04)
- Split function in SQL? obakush_at_osfi-bsif.gc.ca (03/30/04)
- Execution of stored procedure hangs Ernie Gregory (03/30/04)
- isnumeric Rob (03/30/04)
- Table Information James Proctor (03/30/04)
- Simple question (?) Knut Lissen (03/30/04)
- Select top records simon (03/30/04)
- Help in UPDATE and JOIN Prabhat (03/30/04)
- Validate File Upload Duplication ranji abraham (03/30/04)
- Views Puneet (03/30/04)
- Updating Table with Info From Another One Johns (03/30/04)
- How to store parameters of a stored procedure. Gopinath Munisifreddy (03/30/04)
- DPV works incorrectly with smalldatetime (part 2) Dmitry Sorokin (03/30/04)
- Small SQL-Puzzle Lasse Edsvik (03/30/04)
- test if multiple cols all non-null, non-whitespace ... John A Grandy (03/30/04)
- Converting hex number to integer Francois Piette (03/30/04)
- NVARCHAR and SP_EXECUTESQL paul reed (03/30/04)
- Compare empty string !!! Fred (03/30/04)
- What locking hints must I use to ensure the max(id) is not modified? _at_Ariel (03/30/04)
- join queries with uniqueidentifier William Ortenberg (03/30/04)
- Understanding bizarre sp_cursorfetch performance James Bradley (03/30/04)
- Updating >8000 char Ntext Gives me a Lock:Timeout Lucas Tam (03/30/04)
- Stop Changing My Original Data Vaues CLARK BAKER (03/30/04)
- next version of SQLServer Frank Dulk (03/30/04)
- Padding with Left Zeros ? msnews.microsoft.com (03/30/04)
- backup restore database into different filegroup arrangement JJ Wang (03/30/04)
- Help with Stored proc's speed Terry Howard (03/30/04)
- How to read/write binary data from/to SQL server? Kevin Dai (03/30/04)
- Case in Where clause? JDP_at_Work (03/30/04)
- are functions that slow? Guy Brom (03/30/04)
- Audit John Smith (03/29/04)
- Programming Schema Updates Lee Gillie (03/29/04)
- Replacing existing records with new information KrisL (03/29/04)
- Split the field. obakush_at_osfi-bsif.gc.ca (03/29/04)
- Deadlock error Seal (03/29/04)
- nvarchar+bit constraint Oleg Ogurok (03/29/04)
- Creating relationships between different databases paulo (03/29/04)
- Inc Chris (03/29/04)
- ip to country function Guy Brom (03/29/04)
- rules mathomp (03/29/04)
- possible to group stored procedures? Adda (03/29/04)
- Count function with Null values Bruce Thornbury (03/29/04)
- uniqueidentifier sharad (03/29/04)
- Block Other process when run Stored Procedure Avnish Sharma (03/29/04)
- Text/Ntext Field and Updates/Deletes Lucas Tam (03/29/04)
- Passing a username and password to a remote server sh0t2bts (03/29/04)
- Transferring files across servers Andrew Banks (03/29/04)
- Enterprise Manager Shortcut missing Anil (03/29/04)
- Extracting time from Datetime Kayda (03/29/04)
- Sending query results to a text file TM (03/29/04)
- Is there anyway just to select the date portion of a datetime field? KJ (03/29/04)
- Error assigning result to variable Chris (03/29/04)
- Joining 2 timestamps in one row Mounir (03/29/04)
- can a UDF return a table? Stephen Russell (03/29/04)
- Table has identity field Seal (03/29/04)
- Incorrect Delete statement in a stored procedure Louis (03/29/04)
- Problems with querying date field Eddie (03/29/04)
- How to covert a text data type to ntext data type in MSSQL SHEKARS (03/29/04)
- RDC User Info Sabri AKIN (03/29/04)
- BCP from multiple tables Kevin (03/29/04)
- SP Question Chris (03/29/04)
- strange sql results on sysobjects Jay (03/29/04)
- Why is this slow Dwight (03/29/04)
- Windows Authentication Greg Chang (03/29/04)
- Error using a derived table James Rowland-Jones (03/29/04)
- Job start/stop event Jure (03/29/04)
- use output paratmeters from an SP Carstephun (03/29/04)
- Does sp_MSdependencies Backups Tran Log??? Konstantinos Michas (03/29/04)
- Enumerate user stored procedure olig (03/29/04)
- .NET dataset request from a complex SP <returns many tables> Stephen Russell (03/29/04)
- How to get one record using Max() Brandon (03/29/04)
- openrowset with trusted connection anonymous_at_discussions.microsoft.com (03/29/04)
- JDBC batch error message without executeBatch() call Johannes Lebek (03/29/04)
- IF Statement causes Invalid Column Name Donmn (03/29/04)
- Latest entry... NH (03/29/04)
- Calling UDFs.... Mario Splivalo (03/29/04)
- SQL Query or View Object Prabhat (03/29/04)
- DPV works incorrectly with smalldatetime Dmitry Sorokin (03/29/04)
- Group by on Maximum Count Gary (03/29/04)
- Re: Want to add a timestamp when select a table! _at_Ariel (03/29/04)
- Left outer join or Subquery Selva Balaji B (03/29/04)
- Ftp in C3 Vishnu (03/29/04)
- Encapsulate stored procedure in View (SQL7) Jochen Daum (03/29/04)
- Table Naming and Keywords Brad (03/29/04)
- sql server 2000 - slow record retrieval byron (03/29/04)
- Help with returning variable column in SP Kent Ogletree (03/29/04)
- How do I: "Build a DOS Path" - My table is using adjacency model - ParentID Russell Mangel (03/29/04)
- begin Frank Dulk (03/29/04)
- Problem in WHERE Expression mj (03/28/04)
- Best practice for storing email like text Charlie Dison (03/28/04)
- Can't quite get my head round this Keith (03/28/04)
- query syntax y (03/28/04)
- 'Create' User Forms From the Database? CSDunn (03/28/04)
- How to use VFP OLEDB Provider in openrowset ? Luqman (03/28/04)
- Distinguish User Objects and System objects Arr S (03/28/04)
- SQL Server 2000 - Hierarchical data - Versus - Post Relational Databases Russell Mangel (03/28/04)
- executing urgent! oliv (03/28/04)
- Can anyone please help me with this sql? Hyper X (03/28/04)
- Error Handling Roy Goldhammer (03/27/04)
- Erro on datatyp Text Guoqi Zheng (03/27/04)
- help on joins jerry (03/27/04)
- Windows authentication Akz (03/27/04)
- xp_sendmail attachments using unc Joe Reiss (03/27/04)
- Sq: 2003 and ASP and Images Bugsy (03/27/04)
- Index Problem? Kostas (03/27/04)
- Variable Column Name (Conditional Sum)!! Fouad (03/27/04)
- How do I: Update/Insert from Table to Table - Advice Appreciated Russell Mangel (03/27/04)
- Re: 'not in' and 'not exist' Learner (03/27/04)
- RE: Getting Data From Exchange Eria Tlov (03/27/04)
- Temp TABLE Ramesh (03/27/04)
- Temp Tables. Ramesh (03/27/04)
- Fractional values dropped in insert into decimal column type Dean Slindee (03/27/04)
- Transact SQL DIFFERENCE function - what were they thinking? Kevin Davidson (03/26/04)
- Trigger invoking VB passing parameters Louis (03/26/04)
- Joins & Cursors Enos (03/26/04)
- Date Field and Replication Emma (03/26/04)
- Delete trigger failing Cathy Finnegan (03/26/04)
- initialze multiple variables with one select statement John Cobb (03/26/04)
- Re: initialze multiple variables with one select statement Trey Walpole (03/26/04)
- Re: initialze multiple variables with one select statement Adam Machanic (03/26/04)
- Re: initialze multiple variables with one select statement Quentin Ran (03/26/04)
- Re: initialze multiple variables with one select statement John Cobb (03/26/04)
- Re: initialze multiple variables with one select statement Joe Celko (03/27/04)
- Cannot locate Registry Entry Error while using VFP OLEDB ? Luqman (03/26/04)
- Query timing out Chris (03/26/04)
- newbie: how to inherit permissions? lover (03/26/04)
- Return only last dataset from involved SP? Stephen Russell (03/26/04)
- query problem Ben C (03/26/04)
- Table Data Type in SP Arun (03/26/04)
- Backing up and restoring the mdf file only using SQLDMO Danny Mansour (03/26/04)
- Returning large data from an sp Alex (03/26/04)
- Use variables with CREATE and DROP RR_SPSCC (03/26/04)
- SQL Server Performance Issue M.B (03/26/04)
- DELETE rows from Table lists Michael Tissington (03/26/04)
- determine case of value Jims (03/26/04)
- suppress message box display Cathy B (03/26/04)
- execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Prasad Koukuntla (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Dan Guzman (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Prasad Koukuntla (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Dan Guzman (03/26/04)
- Re: execution permission on procedures Prasad Koukuntla (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Sampangi (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures joe (03/26/04)
- Re: execution permission on procedures Prasad Koukuntla (03/26/04)
- Got one more question Chris (03/26/04)
- Inconsistent results from SQLserver rooster575 (03/26/04)
- Order By in Dynamic Union Query hdsjunk (03/26/04)
- How can I force a pause in program execution? Ken Sturgeon (03/26/04)
- Return a #t1 from a SP? Stephen Russell (03/26/04)
- storing an html file Mark (03/26/04)
- Stored Procedure question rob (03/26/04)
- How to: If a row doesn't exist return a null as that field in a select statement Sam (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Prasad Koukuntla (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Roji. P. Thomas (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Eric Sabine (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Quentin Ran (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Joe Celko (03/26/04)
- Re: How to: If a row doesn't exist return a null as that field in a select statement Sam (03/26/04)
- select count(*) runs slow - db design problem Mike Kanski (03/26/04)
- Is this a feature? Ilya Margolin (03/26/04)
- Executing SQL Jobs from command line? Dedrick Winston (03/26/04)
- FAQ Adam Machanic (03/26/04)
- UDF returns table to 'feed' a call back to itself ... how? (cross post) Natalya (03/26/04)
- 6.5 DB Compare Immy (03/26/04)
- Using openrowset to select foxpro table data through odbc ? Luqman (03/26/04)
- Cascaded updates/deletes via SQL-DMO Key? Dick (03/26/04)
- How to? Jack (03/26/04)
- Help with query Kostas (03/26/04)
- insert record after select @@identity rocket_at_office (03/26/04)
- write results to file Otto Miros (03/26/04)
- SQL Server Date Ibrahim Shameeque (03/26/04)
- Slow select from remote server Dave (03/26/04)
- ASPState performance - blocking Chuck (03/26/04)
- Nutrilize Identity Roy Goldhammer (03/26/04)
- Unicode datatypes and the 'N' Martin Hellat (03/26/04)
- How do I track changes on stored procedures? Mogens Olesen (03/26/04)
- Transaction simon (03/26/04)
- Using error handler Roy Goldhammer (03/26/04)
- Searching the similar records in database sajid (03/26/04)
- Identity Gaps Shail (03/26/04)
- Complex T-SQL Query Mark Fox (03/26/04)
- Duplicates Error Len (03/26/04)
- SQL Design CBT SqlJunkies User (03/26/04)
- SQL Design CBT SqlJunkies User (03/26/04)
- Table Design for Addresses Aaron Prohaska (03/26/04)
- Help with select into Chris (03/26/04)
- Relationsip question using UNION clause in a View... Murphy (03/26/04)
- SQL Utilizes 100% CPU David N (03/26/04)
- Varchar aggregation Jason Zhou (03/25/04)
- case question culam (03/25/04)
- SQL Statement or Cursor Paul Ilacqua (03/25/04)
- Are stored procedures slower than the same statements run in Query analyzer.. Jyothi (03/25/04)
- While loop does not break Ravinder (03/25/04)
- better way to make tran LiFo (03/25/04)
- Do you think my code is good to go? joe (03/25/04)
- encrypted procedure joe (03/25/04)
- Problem when execute a stored procedure Richard Pettersen (03/25/04)
- Return the number of rows in all tables in a database JT Lovell (03/25/04)
- Unable to add new rows... Murphy (03/25/04)
- How to return column data as a single string? Bish (03/25/04)
- How to delete duplicate from the table ? mac (03/25/04)
- handling xml stored as ntext Brad Back (03/25/04)
- How to Force all Stored Procedures to "recompile"? blg (03/25/04)
- accessing column data using local variable Russ (03/25/04)
- join for tables Wanda (03/25/04)
- Foreign Keys to the same table mitra fatolahi (03/25/04)
- String Manipulation Leo (03/25/04)
- Can you have a variable in a View? REB (03/25/04)
- Getting Just The Date Atley (03/25/04)
- Temp Table & DTS Bruce Thornbury (03/25/04)
- passing an array to stored procedure dario casubolo (03/25/04)
- revoke execution permission on procedure joe (03/25/04)
- Incorrect Query Results w/ Wildcard hdsjunk (03/25/04)
- Adam and others this is what I am talking about Chris (03/25/04)
- Group By Earliest Date mj (03/25/04)
- Re: Group By Earliest Date Prasad Koukuntla (03/25/04)
- Re: Group By Earliest Date mj (03/25/04)
- Re: Group By Earliest Date Prasad Koukuntla (03/25/04)
- Re: Group By Earliest Date mj (03/25/04)
- Re: Group By Earliest Date mj (03/25/04)
- B.Course Location mj (03/25/04)
- Re: B.Course Location Joe Celko (03/25/04)
- Not Done Yet :( mj (03/25/04)
- Re: Not Done Yet :( Prasad Koukuntla (03/25/04)
- Got it in the FROM Clause mj (03/25/04)
- Re: Group By Earliest Date Joe Celko (03/25/04)
- Re: Group By Earliest Date mj (03/25/04)
- Re: Group By Earliest Date Anith Sen (03/25/04)
- Re: Group By Earliest Date Prasad Koukuntla (03/25/04)
- Weird Order by Question Jonathan Haddad (03/25/04)
- Locks Andres (03/25/04)
- Web Application simo sentissi (03/25/04)
- FETCH CURSOR Newbie06 (03/25/04)
- Calculate daily balance Christian Perthen (03/25/04)
- Obtaining set of column names Russ (03/25/04)
- Users and Groups Schema for DB Khurram Chaudhary (03/25/04)
- Ship SQL with Data Bryan Harrington (03/25/04)
- Re: Key Generation Jonathan Haddad (03/25/04)
- 6.5 SQL - Help! - Change column type? William (03/25/04)
- Problem converting to a date... Atley (03/25/04)
- using variables in WHERE clause Gary (03/25/04)
- Using temp table fields with Insert statement John Cobb (03/25/04)
- call SP from another server kriste (03/25/04)
- ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- Re: ConnectionCheckForData, General network error oj (03/25/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- Re: ConnectionCheckForData, General network error oj (03/26/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/26/04)
- Re: ConnectionCheckForData, General network error oj (03/26/04)
- Re: ConnectionCheckForData, General network error Steve Kass (03/26/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/26/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/26/04)
- Re: ConnectionCheckForData, General network error oj (03/25/04)
- Re: ConnectionCheckForData, General network error Stijn Verrept (03/25/04)
- BCP, Bulk Insert Anand (03/25/04)
- 2 storedprocedure questions. Fred (03/25/04)
- Trigger question simon (03/25/04)
- dependencies Joe (03/25/04)
- Help with Grouping for a query... Alejandro K. (03/25/04)
- update Mikey (03/25/04)
- Possible SQL Analyser memory leak or other problem? Baolin Ren (03/25/04)
- yes an update Mikey (03/25/04)
- Store Procedure - Profile Peter (03/25/04)
- zip code to standardise Mikey (03/25/04)
- 6.5 DB Compare Immy (03/25/04)
- Sending Mail Jonathan Crawford (03/25/04)
- Standards Klaus L Jensen (03/25/04)
- Database-wide trigger? Roland Dick (03/25/04)
- How to convert outer join from Oracle8i to SQLSever ? nguyenstruong_at_hotmail.com (03/25/04)
- Deleting all data Roy Goldhammer (03/25/04)
- Replication via DMO Nigel (03/25/04)
- Data Type 'int' and AutoNumber Stephen Cairns (03/25/04)
- Insert Datetime StefanVo (03/25/04)
- sp_renamedb Unmesh (03/25/04)
- Err while trying to set AppRole Stephen J Bement (03/25/04)
- removing spaces from string Jaco Bregman (03/25/04)
- Select other fields in Group By? Jason Sayles (03/25/04)
- mdx urgent reven (03/25/04)
- T-SQL to write a BLOB to disk alex_at_didg.com (03/25/04)
- Can I refer to a local recordset or client-side table after the FROM clause ? Oscar (03/25/04)
- New User error... Chris Marsh (03/25/04)
- Recommended Procedure for Importing From Access Across LAN Stefan Berglund (03/25/04)
- How can I get the database name from the bakup file Bruce Lee (03/25/04)
- Don't see better performance with stored procedures than inline VB SQL statements, why ? Oscar (03/25/04)
- Re: Don't see better performance with stored procedures than inline VB SQL statements, why ? Aaron Bertrand [MVP] (03/25/04)
- Re: Don't see better performance with stored procedures than inline VB SQL statements, why ? Steve Kass (03/25/04)
- Re: Don't see better performance with stored procedures than inline VB SQL statements, why ? Dan Guzman (03/25/04)
- Fetch Into Within a User Defined Function paul reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Delbert Glass (03/24/04)
- Re: Fetch Into Within a User Defined Function Paul Reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Delbert Glass (03/25/04)
- Re: Fetch Into Within a User Defined Function Paul Reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Steve Kass (03/25/04)
- Re: Fetch Into Within a User Defined Function Paul Reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Paul Reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Paul Reed (03/25/04)
- Re: Fetch Into Within a User Defined Function Delbert Glass (03/24/04)
- retrieving a range of values Troy (03/25/04)
- number of rows in cursor Min J.Deng (03/25/04)
- number of rows in cursor Min J.Deng (03/25/04)
- sql connection error saying "Provider" is not a valid keyword ??? Chumley the Walrus (03/25/04)
- Perfomance question. ntext and varchar Star (03/24/04)
- column names smk2 (03/24/04)
- How to insert row into T1 from T2 only if it doesn't exist in T1? Carl Imthurn (03/24/04)
- Question about the IN keyword Joe (03/24/04)
- Re: how to select with this condition Tibor Karaszi (03/24/04)
- Dependencies are lost when alter an object Catalin (03/24/04)
- extra index scans on update Scott (03/24/04)
- grant permission question joe (03/24/04)
- SubQuery Null-Result JJ (03/24/04)
- Scripting data import by query Ray at <%=sLocation%> [MVP] (03/24/04)
- Deferred Name Resolution Brian (03/24/04)
- Decimal values to Excel JJ (03/24/04)
- DELETE Statement Question John Barr (03/24/04)
- Are you guys sure about '+' in this sp Chris (03/24/04)
- Re: Are you guys sure about '+' in this sp Anith Sen (03/24/04)
- Re: Are you guys sure about '+' in this sp Hugo Kornelis (03/25/04)
- Full-Text indexing 'ResourceUsage' sbauer (03/24/04)
- script to copy indexes from one table to another Mike Kanski (03/24/04)
- How to search all stored procedures for a table name or column name blg (03/24/04)
- Re: How to search all stored procedures for a table name or column name Aaron Bertrand [MVP] (03/24/04)
- Re: How to search all stored procedures for a table name or column name Xavier Lazard (03/24/04)
- Re: How to search all stored procedures for a table name or column name Aaron Bertrand [MVP] (03/24/04)
- Re: How to search all stored procedures for a table name or column name Xavier Lazard (03/24/04)
- Re: How to search all stored procedures for a table name or column name Aaron Bertrand [MVP] (03/24/04)
- Re: How to search all stored procedures for a table name or column name Xavier Lazard (03/24/04)
- Re: How to search all stored procedures for a table name or column name Raymond D'Anjou \(raydan\) (03/24/04)
- Re: How to search all stored procedures for a table name or column name Aaron Bertrand [MVP] (03/24/04)
- Re: How to search all stored procedures for a table name or column name Raymond D'Anjou \(raydan\) (03/24/04)
- Re: How to search all stored procedures for a table name or column name Xavier Lazard (03/24/04)
- Re: How to search all stored procedures for a table name or column name Xavier Lazard (03/24/04)
- Re: How to search all stored procedures for a table name or column name Aaron Bertrand [MVP] (03/24/04)
- How can I dump stored procedure results into a temp table? Ken Sturgeon (03/24/04)
- archive snapshot of table record on certain action John A Grandy (03/24/04)
- PWDCOMPARE Yaheya Quazi (03/24/04)
- Cursors... what's the alternative? BobMcClellan (03/24/04)
- RE: Cursors... what's the alternative? Richard J (03/24/04)
- Re: Cursors... what's the alternative? Joe Celko (03/24/04)
- Re: Cursors... what's the alternative? David Portas (03/24/04)
- Re: Cursors... what's the alternative? BobMcClellan (03/24/04)
- Re: Cursors... what's the alternative? Joe Celko (03/24/04)
- Re: Cursors... what's the alternative? Dan (03/25/04)
- Re: Cursors... what's the alternative? oj (03/25/04)
- Re: Cursors... what's the alternative? Joe Celko (03/25/04)
- Re: Cursors... what's the alternative? John Saunders (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/25/04)
- Re: Cursors... what's the alternative? John Saunders (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/25/04)
- Re: Cursors... what's the alternative? John Saunders (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/25/04)
- Re: Cursors... what's the alternative? John Saunders (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/25/04)
- Re: Cursors... what's the alternative? Steve Kass (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/25/04)
- Re: Cursors... what's the alternative? Rickard Axne (03/26/04)
- Re: Cursors... what's the alternative? BobMcClellan (03/25/04)
- Re: Cursors... what's the alternative? David Portas (03/24/04)
- Re: Cursors... what's the alternative? Joe Celko (03/24/04)
- Count until end of previous month J. Joshi (03/24/04)
- binary file storege Brian Henry (03/24/04)
- what is Microsoft Reporting service Sharad (03/24/04)
- Question on OpenQuery Chris (03/24/04)
- querying on a dynamic column andy smith (03/24/04)
- Gone from SQL7 to Sql2000 CD (03/24/04)
- How to create table to Linked Server for an Excel file Daniele (03/24/04)
- String Query With L'Oreal #2 Gjones (03/24/04)
- String Qurey With L'Oreal GJones (03/24/04)
- existance testing again....again again.. steveo (03/24/04)
- Age as of 15th of Mth J. Joshi (03/24/04)
- Dim as New VS. Set = New Gerard (03/24/04)
- Bizare xp_sendmail error Scott Riehl (03/24/04)
- Get date range from Week No in a sproc Maryam (03/24/04)
- SQL Server 7 Desktop trigger features Russ (03/24/04)
- select rows in A that are not in B? Rick Charnes (03/24/04)
- Are Transact-SQL statements atomic? Len (03/24/04)
- Union by condition Anon (03/24/04)
- Suppress Stored Procedure Return Value SMK (03/24/04)
- Object already exists error Dwight (03/24/04)
- to eval() or not to eval()....or maybe sum? steveo (03/24/04)
- Object already exist error Dwight (03/24/04)
- ADDA 1.0.2 is released Vadim Berman (03/24/04)
- Index - How to? \ (03/24/04)
- Update query not working Chris (03/24/04)
- Cascading update on primary key pmcguire (03/24/04)
- Truncate one table Jaygo (03/24/04)
- Returning a hyperlink in a Stored Procedure Matt (03/24/04)
- .CursorType - Doesn't exist or persist Gerard (03/24/04)
- Test email Dwight (03/24/04)
- Please advise on table structure Paul (03/24/04)
- trigger looping Russ (03/24/04)
- FK and replication middletree (03/24/04)
- Sproc with temp tables and input parameters causing trouble with dynamic recordsets - a tricky one! John Hoge (03/24/04)
- SELECT * FROM (exec mystoredproc) as table1 MikeL (03/24/04)
- Custom Sort Order (DDL included) Kevin Munro (03/24/04)
- How do you fake it? - UNION query columns steveo (03/24/04)
- Performance of cross databases queries Nicolas Mayoraz (03/24/04)
- How can I prevent 2 instances of app running ? iain (03/24/04)
- Insert multiple non-existing records Steve (03/24/04)
- how to reserve identity value? Zarko Jovanovic (03/24/04)
- Query Problem Jac (03/24/04)
- Finding number of words Amit (03/24/04)
- Merging Data Roy Goldhammer (03/24/04)
- Cannot create index on float view field, but works on table? Marian Stary Zgred (03/24/04)
- Retrieve / list members of Sysadmin role without connecting to the SQL-server (API? Please help!) Tim Gorgs (03/24/04)
- How to query data ? Sasavat (03/24/04)
- Image storage - db vs filesystem (again) Gary McPherson (03/24/04)
- Counting By Previous Month J. Joshi (03/24/04)
- return record with greatest date Shay (03/24/04)
- Encrypt function... Yaheya Quazi (03/24/04)
- Fetching XML metadata. Girish (03/23/04)
- old sysmergesubscriptions records will (03/23/04)
- accessing sysobjects is good or bad if not wat is the solution Venkata (03/23/04)
- Selecting the last record per group where nulls possible humble (03/23/04)
- Re: Selecting the last record per group where nulls possible Delbert Glass (03/23/04)
- Re: Selecting the last record per group where nulls possible Adam Machanic (03/23/04)
- Re: Selecting the last record per group where nulls possible David Portas (03/23/04)
- Re: Selecting the last record per group where nulls possible Joe Celko (03/24/04)
- Turn off enforcing relationships on inserts Lynn (03/23/04)
- I really need some help here. Chris (03/23/04)
- Transaction Log - suspend for updates JayS (03/23/04)
- parallel processing hangs with CXPACKET wait type Steph (03/23/04)
- Overcoming Transact-SQL ORDER BY limitations news.microsoft.com (03/23/04)
- Invalid Cursor State Error Yaheya Quazi (03/23/04)
- how to select with this condition Ray at <%=sLocation%> [MVP] (03/23/04)
- Backup/Restore question SStory (03/23/04)
- Newbie needs help with BCP out file ajmister (03/23/04)
- Efficient Text Storage ? Mark C (03/23/04)
- This one could be tough joe (03/23/04)
- Expire Passwords Tim (03/23/04)
- Select top n query Sunanda (03/23/04)
- SQL Statements in Dreamweavers MM:Datasets - on the fly... Chumley the Walrus (03/23/04)
- Cursors - Server Side - Only Forward? Gerard (03/23/04)
- Re: Cursors - Server Side - Only Forward? Adam Machanic (03/23/04)
- Re: Cursors - Server Side - Only Forward? Tom Moreau (03/23/04)
- Re: Cursors - Server Side - Only Forward? anonymous_at_discussions.microsoft.com (03/23/04)
- Re: Cursors - Server Side - Only Forward? Karl Gram (03/23/04)
- Re: Cursors - Server Side - Only Forward? Gerard (03/24/04)
- Re: Cursors - Server Side - Only Forward? Karl Gram (03/24/04)
- Re: Cursors - Server Side - Only Forward? Gerard (03/24/04)
- Re: Cursors - Server Side - Only Forward? Tom Moreau (03/23/04)
- Re: Cursors - Server Side - Only Forward? anonymous_at_discussions.microsoft.com (03/23/04)
- Running Sum field in select query Ashley (03/23/04)
- "Key column information is insufficient or incorrect . . . " Steve Renier (03/23/04)
- Date query J Griffiths (03/23/04)
- SQL Service Stops and Starts Andre (03/23/04)
- trigger question.... anonymous_at_discussions.microsoft.com (03/23/04)
- Set @var to a single row of data? Stephen Russell (03/23/04)
- Question Chris (03/23/04)
- Select Last Row problem Vlad (03/23/04)
- Consolidating Code Anin (03/23/04)
- creating a user and then adding the user to a role nishantd (03/23/04)
- running a query against 2 SQL servers sh0t2bts (03/23/04)
- datapage tom brady (03/23/04)
- Paging feature for schedule jobs not working Andre (03/23/04)
- Re: Paging feature for schedule jobs not working oj (03/23/04)
- Re: Paging feature for schedule jobs not working Tibor Karaszi (03/23/04)
- Re: Paging feature for schedule jobs not working Andre (03/23/04)
- Re: Paging feature for schedule jobs not working Tibor Karaszi (03/23/04)
- Re: Paging feature for schedule jobs not working Andre (03/23/04)
- Re: Paging feature for schedule jobs not working Tibor Karaszi (03/23/04)
- Re: Paging feature for schedule jobs not working Andre (03/23/04)
- Re: Paging feature for schedule jobs not working Tibor Karaszi (03/23/04)
- Re: Paging feature for schedule jobs not working Andre (03/23/04)
- Return Key (identity) on INSERT operation (SQL/ASP) CJM (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tibor Karaszi (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Aaron Bertrand [MVP] (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Aaron Bertrand [MVP] (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tibor Karaszi (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Aaron Bertrand [MVP] (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Bob Barrows [MVP] (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/24/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) Tom Moreau (03/23/04)
- Re: Return Key (identity) on INSERT operation (SQL/ASP) CJM (03/24/04)
- Custom Identity Field Yaheya Quazi (03/23/04)
- Re: Custom Identity Field Adam Machanic (03/23/04)
- Re: Custom Identity Field Tenaya (03/23/04)
- Re: Custom Identity Field Yaheya Quazi (03/23/04)
- Re: Custom Identity Field Adam Machanic (03/23/04)
- Re: Custom Identity Field Yaheya Quazi (03/23/04)
- Re: Custom Identity Field Aaron Bertrand [MVP] (03/23/04)
- Re: Custom Identity Field Adam Machanic (03/23/04)
- Re: Custom Identity Field Aaron Bertrand [MVP] (03/23/04)
- Re: Custom Identity Field Adam Machanic (03/23/04)
- Re: Custom Identity Field Tenaya (03/23/04)
- Re: Custom Identity Field Adam Machanic (03/23/04)
- Re: Custom Identity Field Tenaya (03/23/04)
- Re: Custom Identity Field Yaheya Quazi (03/23/04)
- error comparing Floats after conversion from varchar Sean G. (03/23/04)
- Help In Query Prabhat (03/23/04)
- Optimizer smart enough to recognize "constant" subquery? R Baker (03/23/04)
- UNICODE and Encoding KP (03/23/04)
- data parsing kamya (03/23/04)
- Triggers Brian (03/23/04)
- Year conversion Ruslan Shlain (03/23/04)
- count of maximum value chris (03/23/04)
- Locking Hint TVODBA (03/23/04)
- Trigger does not seem to fire from front end or enterprise manager Keith G Hicks (03/23/04)
- SQL server XML parser J. Zhang (03/23/04)
- solid learning experience Alok (03/23/04)
- Need "On Change Of" aggregate Hotmail (03/23/04)
- CONVERT Jaco (03/23/04)
- oadl (or padr) toylet (03/23/04)
- cross-tabulation, sort of toylet (03/23/04)
- select statement as a column SFRATTURA (03/23/04)
- Query help needed Tom Furness (03/23/04)
- Top x Percent for each group Ryan (03/23/04)
- How to accomplish this in a query (quite simple probably).... Johan Andersson (03/23/04)
- Operand type clash: varchar is incompatible with void type Johnny Silvestre (03/23/04)
- Convert datatype in function Chris (03/23/04)
- retrieve the most recent row toylet (03/23/04)
- Retrieve column descriptions? Rob Meade (03/23/04)
- Duplicate keys, unique rows. Jan (03/23/04)
- SQL Documentation Papanii Okai (03/23/04)
- help needed in database backup sunil (03/23/04)
- Insert statement inside stored procedure failing Puneet Mittal (03/23/04)
- collection of queries for Northwind ciemcio (03/23/04)
- Conditional Select... (case, union, subselect?) Mike W. (03/23/04)
- Assertion: SQL Server 2000 can't issue a SOAP call Rob Hindman (03/23/04)
- What is a ROW-ID Abhishek Srivastava (03/23/04)
- Need to REALLY understand views Learner (03/23/04)
- Re: schedule job - login in dynamic sql Greg Obleshchuk (03/23/04)
- data parsing kamya (03/23/04)
- PLease help with case expression...complex. Magy (03/23/04)
- Automatically rounding Benny (03/23/04)
- Query Peri (03/23/04)
- Hello I Need you Help!! (03/23/04)
- How to get a Sproc to return both recordset and output parameters John Hoge (03/23/04)
- Table Design Review wanted Aaron Prohaska (03/23/04)
- Re: Table Design Review wanted Louis Davidson (03/23/04)
- Re: Table Design Review wanted Joe Celko (03/24/04)
- Re: Table Design Review wanted Aaron Prohaska (03/24/04)
- Re: Table Design Review wanted Joe Celko (03/24/04)
- Re: Table Design Review wanted Aaron Prohaska (03/25/04)
- Re: Table Design Review wanted Anith Sen (03/25/04)
- Re: Table Design Review wanted Aaron Prohaska (03/25/04)
- Re: Table Design Review wanted Aaron Prohaska (03/25/04)
- Re: Table Design Review wanted Raymond D'Anjou \(raydan\) (03/25/04)
- Re: Table Design Review wanted Aaron Prohaska (03/25/04)
- Re: Table Design Review wanted Aaron Prohaska (03/24/04)
- unique temp table name toylet (03/23/04)
- How to setup permissions of a Stored Procedure that execute other Stored Procedure Craig Kenisston (03/23/04)
- What does the sp_sdidebug do? MFRASER (03/23/04)
- exporting data aleksandr (03/22/04)
- Derived column names Mike (03/22/04)
- Occasional SQL Error scorpion53061 (03/22/04)
- Re: Occasional SQL Error William Ryan eMVP (03/22/04)
- Re: Occasional SQL Error Karl Gram (03/22/04)
- Re: Occasional SQL Error Jay B. Harlow [MVP - Outlook] (03/22/04)
- Re: Occasional SQL Error William \(Bill\) Vaughn (03/22/04)
- Re: Occasional SQL Error scorpion53061 (03/22/04)
- Re: Occasional SQL Error Alex B (03/22/04)
- Re: Occasional SQL Error scorpion53061 (03/22/04)
- Re: Occasional SQL Error Alex B (03/23/04)
- Re: Occasional SQL Error William Ryan eMVP (03/22/04)
- Re: Occasional SQL Error scorpion53061 (03/22/04)
- Re: Occasional SQL Error William Ryan eMVP (03/22/04)
- Re: Occasional SQL Error scorpion53061 (03/23/04)
- Re: Occasional SQL Error William Ryan eMVP (03/23/04)
- Re: Occasional SQL Error Jay B. Harlow [MVP - Outlook] (03/24/04)
- Re: Occasional SQL Error scorpion53061 (03/24/04)
- Re: Occasional SQL Error scorpion53061 (03/24/04)
- Re: Occasional SQL Error scorpion53061 (03/22/04)
- Re: Occasional SQL Error Charlie Smith (03/23/04)
- Re: Occasional SQL Error Bernie Yaeger (03/23/04)
- Undo a delete Scott Good (03/22/04)
- Simple statistics question Simon (03/22/04)
- Lower case data Amy Snyder (03/22/04)
- How to get two values. Mark (03/22/04)
- How does the SQL Server handle two simoutanious read or write operations? Quentin Huo (03/22/04)
- Re: How does the SQL Server handle two simoutanious read or write operations? Adam Machanic (03/22/04)
- Re: How does the SQL Server handle two simoutanious read or write operations? Greg Linwood (03/22/04)
- Re: How does the SQL Server handle two simoutanious read or write operations? Louis Davidson (03/22/04)
- Case Sensitive Atley (03/22/04)
- Error with "Operand type clash" johnny_silvestre_at_yahoo.de (03/22/04)
- Help with GROUP BY and COUNT with LEFT OUTER JOIN Nicolas Verhaeghe (03/22/04)
- Re: Help with GROUP BY and COUNT with LEFT OUTER JOIN Prasad Koukuntla (03/22/04)
- Re: Help with GROUP BY and COUNT with LEFT OUTER JOIN David Portas (03/22/04)
- Re: Help with GROUP BY and COUNT with LEFT OUTER JOIN Karl Gram (03/22/04)
- T-SQL error handling practices Lee Schipper (03/22/04)
- Image Data - Lost Connection, any Size Limit? Greg Chang (03/22/04)
- need query help please mike (03/22/04)
- Replace function bug? bob (03/22/04)
- Retreiving resultset column names from a stored procedure through ADO CAO (03/22/04)
- why doesnt this query work... Brian Henry (03/22/04)
- Retrieving Anniversary Dates within 1 Week from Today? Todd M. Taylor (03/22/04)
- SQL general ole error metoonyc (03/22/04)
- Turn off the error message Baolin Ren (03/22/04)
- IsNumeric function Ji (03/22/04)
- Dynamic Database Name David Torrej?n (03/22/04)
- busy with another hstmt - Error Gerard (03/22/04)
- Windowsme keep latchingup during surfing. Dan-Harry (03/22/04)
- Temp tables or variables? John Hoge (03/22/04)
- formatting question Holden (03/22/04)
- "NOT IN" (set difference) with compound key Allan Cady (03/22/04)
- Parameters inside a view? On SQL2000 Filippo Bettinaglio (03/22/04)
- Advice on design pattern Mark (03/22/04)
- Error 213: Insert Error: Column name or number of supplied values does not match table definition RichW (03/22/04)
- SQL Mail Vai2000 (03/22/04)
- Date field with year prior to 1753. David (03/22/04)
- Deletion of Duplicate Record in table Newbie67 (03/22/04)
- Fully Qualified Names Kevin L (03/22/04)
- help... statistics on non-index column disappear Simon (03/22/04)
- Convert Characters SQL Maik Richter (03/22/04)
- AlphaNumeric Auto Field Khurram Chaudhary (03/22/04)
- Can I query the estimated execution plan? Bryan (03/22/04)
- variable and querysting fred (03/22/04)
- What's wrong with this query Mamun (03/22/04)
- Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Adam Machanic (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Jaxon (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Jaxon (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Adam Machanic (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Adam Machanic (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Natural vs. Surrogate key Julie (03/22/04)
- Re: Natural vs. Surrogate key Aaron Bertrand [MVP] (03/22/04)
- Re: Natural vs. Surrogate key Anith Sen (03/22/04)
- Re: Natural vs. Surrogate key Daniel P. (03/22/04)
- Re: Natural vs. Surrogate key Adam Machanic (03/22/04)
- How to update a table using Join with other table Prabhat (03/22/04)
- Index is not used sometimes. Cam Nguyen (03/22/04)
- Another 'case' type of question from a newbie Jack (03/22/04)
- Active Directory Users Gerry (03/22/04)
- table OUTPUT parameter of sp Joachim Hofmann (03/22/04)
- SQL92 JOINs Anon (03/22/04)
- true / false return from query Sharon (03/22/04)
- Stopping SQL Server Agent Programmatically Joe Saliba (03/22/04)
- Can you index table variable fields? Freddie (03/22/04)
- How to change owner of user datatype? Miroo_news (03/22/04)
- checking the data in 2 tables Rahul Chatterjee (03/22/04)
- Update with Dynamic Field hngo01 (03/22/04)
- Update data among databases Tom (03/22/04)
- Need pkey data type of 32 < x < 64 bits size. jan (03/22/04)
- Add Record Number Column to existing table David Andrews (03/22/04)
- Lock for insert Anoo S (03/22/04)
- Single or multiple Triggers Rich (03/22/04)
- SELECT syntax John Austin (03/22/04)
- Re: SELECT syntax David Portas (03/22/04)
- Re: SELECT syntax David Portas (03/22/04)
- Re: SELECT syntax Uri Dimant (03/22/04)
- Re: SELECT syntax David Portas (03/22/04)
- Re: SELECT syntax Uri Dimant (03/22/04)
- Re: SELECT syntax David Portas (03/22/04)
- Re: SELECT syntax Uri Dimant (03/22/04)
- Re: SELECT syntax John Austin (03/22/04)
- Re: SELECT syntax John Austin (03/25/04)
- Re: SELECT syntax Baisong Wei[MSFT] (03/26/04)
- Re: SELECT syntax John Austin (03/26/04)
- Re: SELECT syntax Baisong Wei[MSFT] (03/29/04)
- Re: SELECT syntax Uri Dimant (03/22/04)
- Re: SELECT syntax Uri Dimant (03/22/04)
- AutoNumber ? Peter Newman (03/22/04)
- N' in queries Peter (03/22/04)
- Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction Ahmad Rizvi (03/22/04)
- Table lookup query Yiaz (03/22/04)
- Re: Table lookup query Hugo Kornelis (03/22/04)
- Re: Table lookup query Yiaz (03/22/04)
- Re: Table lookup query Stefan Delmarco [MSFT] (03/22/04)
- Re: Table lookup query Yiaz (03/22/04)
- Re: Table lookup query Stefan Delmarco [MSFT] (03/22/04)
- Re: Table lookup query Yiaz (03/22/04)
- Re: Table lookup query Stefan Delmarco [MSFT] (03/22/04)
- Re: Table lookup query Yiaz (03/23/04)
- Re: Table lookup query Stefan Delmarco [MSFT] (03/23/04)
- Re: Table lookup query Yiaz (03/23/04)
- Re: Table lookup query Stefan Delmarco [MSFT] (03/23/04)
- Re: Table lookup query Hugo Kornelis (03/22/04)
- use of tempdb by union all simo (03/22/04)
- Re: use of tempdb by union all Bojidar Alexandrov (03/22/04)
- Re: use of tempdb by union all Andrew J. Kelly (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Andrew J. Kelly (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Anon (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Bojidar Alexandrov (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Bojidar Alexandrov (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Andrew J. Kelly (03/23/04)
- Re: use of tempdb by union all Tenaya (03/23/04)
- Re: use of tempdb by union all Tibor Karaszi (03/22/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- Re: use of tempdb by union all Tenaya (03/23/04)
- Re: use of tempdb by union all Tibor Karaszi (03/23/04)
- Re: use of tempdb by union all Tenaya (03/23/04)
- Re: use of tempdb by union all Tenaya (03/22/04)
- raise exception for any error from sql server Ganesh (03/22/04)
- Trigger with user defined function xyz12 (03/22/04)
- Average of top n query haode (03/22/04)
- Analysing Execution plan Ramnadh (03/22/04)
- Row Count Itzik (03/22/04)
- specifying date param values in dynamic sql John A Grandy (03/22/04)
- Re: specifying date param values in dynamic sql Aaron Bertrand [MVP] (03/22/04)
- Re: specifying date param values in dynamic sql Andrew John (03/22/04)
- Re: specifying date param values in dynamic sql Tibor Karaszi (03/22/04)
- Re: specifying date param values in dynamic sql Erland Sommarskog (03/22/04)
- Follow up query from Fresher - Aaron Bertrand Alok (03/22/04)
- Stored Procedures WITH ENCRYPTION Chip (03/22/04)
- Stored Procedure Resultsets? SMK (03/22/04)
- share using SQL Server Frank Dulk (03/21/04)
- Probably simple question. Vlad (03/21/04)
- Loop for Quantity Mike (03/21/04)
- Copy/move data from TableA in DB1 to TableB in DB2 within the same SQL Server omooba (03/21/04)
- Sort of a loop in SQL - how to do it Franz Haberl (03/21/04)
- Re: Sort of a loop in SQL - how to do it Anith Sen (03/21/04)
- Re: Sort of a loop in SQL - how to do it Steve Kass (03/21/04)
- Re: Sort of a loop in SQL - how to do it Goran Vukusic (03/22/04)
- Re: Sort of a loop in SQL - how to do it Hugo Kornelis (03/22/04)
- Re: Sort of a loop in SQL - how to do it Goran Vukusic (03/22/04)
- Re: Sort of a loop in SQL - how to do it Uri Dimant (03/22/04)
- Re: Sort of a loop in SQL - how to do it Uri Dimant (03/22/04)
- Re: Sort of a loop in SQL - how to do it Steve Kass (03/22/04)
- Re: Sort of a loop in SQL - how to do it Goran Vukusic (03/22/04)
- Re: Sort of a loop in SQL - how to do it Hugo Kornelis (03/21/04)
- Re: Sort of a loop in SQL ... - Thank you all Goran Vukusic (03/23/04)
- sybase newsgroup sam (03/21/04)
- Help with SET NOEXEC in a SPROC paul reed (03/21/04)
- Increment int values Andrew Banks (03/21/04)
- Re: checking file existence with sql Jacky (03/21/04)
- Sql 7.0 -> 2000 update query hangs Dave (03/21/04)
- Calling SQL SP from VB code Mario Splivalo (03/21/04)
- Licensing Lino (03/21/04)
- Re: disk space low Rick (03/21/04)
- Query question. Can be very simple. Please take a look... TomTom (03/21/04)
- Help with where clause in Stored proc and Qry Analyzer getting different rec. counts Stacey Howard (03/21/04)
- Reporting Services Version Lawrence (03/21/04)
- bi-directional relations Christian Kuendig (03/20/04)
- Help constructing View rob (03/20/04)
- Adding lines to a table base on a Quanitity Mike (03/20/04)
- Cursors Performance in Multi Processor Environment Raja (03/20/04)
- selecting nested rows Blue Man (03/20/04)
- Can I output query result to text files in QueryAnalyzer? TomTom (03/20/04)
- How to detect if a temporary table has already been created Kurt (03/20/04)
- SQL Server 2000 Fresher Alok (03/20/04)
- Delete Based on Join Problem Wayne Wengert (03/20/04)
- View Partitioned Carrasco (03/20/04)
- Database User without login Mark Goldin (03/20/04)
- Integer data type -> binary coded decimal Ali Cox (03/20/04)
- Showing all stored procedures in generate script wizard neu (03/20/04)
- Querying multiple SQL Servers Prashant PC (03/20/04)
- Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure David Portas (03/20/04)
- Re: Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure David Portas (03/20/04)
- Re: Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure David Portas (03/20/04)
- Re: Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure Chris (03/20/04)
- Re: Date change in stored procedure David Portas (03/20/04)
- Re: Date change in stored procedure David Portas (03/20/04)
- renaming a column using t-sql toylet (03/20/04)
- Distinct Count Problem - MDX frog (03/20/04)
- hello urgent!!!!! kumarj (03/20/04)
- how to use distributed tran Russell (03/20/04)
- problem with sql fred (03/19/04)
- Inserting the Identity of a master table into a child Table Ototofioto (03/19/04)
- Dynamic SQL and Assigning a Local Variable Khurram Chaudhary (03/19/04)
- TOP N__ Lynn Pennington (03/19/04)
- Stored procedure; return calculated values Roy Lawson (03/19/04)
- ORDER BY and CASE shank (03/19/04)
- referencing server with "-" Lawrence (03/19/04)
- ALTER COLUMN to for INDENTIY? dwa (03/19/04)
- Help with qery Chris (03/19/04)
- Error with linkserver Chris (03/19/04)
- Any API To Interactively Create a Query? John Saunders (03/19/04)
- Data Model Question Again Jason MacKenzie (03/19/04)
- Select INTO Chris (03/19/04)
- DECODE Tony ICW Group (03/19/04)
- Select help! Chris (03/19/04)
- ERROR line number Katie (03/19/04)
- passing raiserror info from ms sql 2k to ms access 2k Keith G Hicks (03/19/04)
- update statement - please hlp hngo01 (03/19/04)
- SQL Error Lawrence (03/19/04)
- Create Job to dump SP results into a text file. moondaddy (03/19/04)
- Re: Create Job to dump SP results into a text file. Hari Prasad (03/19/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/22/04)
- Re: Create Job to dump SP results into a text file. Baisong Wei[MSFT] (03/23/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/23/04)
- Re: Create Job to dump SP results into a text file. Baisong Wei[MSFT] (03/23/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/23/04)
- Re: Create Job to dump SP results into a text file. Baisong Wei[MSFT] (03/23/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/23/04)
- Re: Create Job to dump SP results into a text file. Baisong Wei[MSFT] (03/24/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/24/04)
- Re: Create Job to dump SP results into a text file. moondaddy (03/22/04)
- Re:Create Job to dump SP results into a text file. keene (03/19/04)
- Re: Create Job to dump SP results into a text file. Hari Prasad (03/19/04)
- join top 1 ? Rene (03/19/04)
- An 'ORDER BY' based on an input parameter Carl (03/19/04)
- Help on query for report dan (03/19/04)
- Autonumbers A.M (03/19/04)
- SQL QUERY Question metoonyc (03/19/04)
- Creating Indexes Chris T. (03/19/04)
- global function joe (03/19/04)
- Next Wednesday's SQL Server Chat: The CLR and Yukon Stephen Dybing [MSFT] (03/19/04)
- how to write this program C#User (03/19/04)
- Converting seconds to hh:mm:ss Jeff Dillon (03/19/04)
- Bookmark lookup cost factors (SQL Server 7.0) Dennis Forbes (03/19/04)
- Scripting Database Restore John Barr (03/19/04)
- Different Row Counts From Two Virtually Identical Queries Bruce Rose (03/19/04)
- Re: Different Row Counts From Two Virtually Identical Queries Adam Machanic (03/19/04)
- Re: Different Row Counts From Two Virtually Identical Queries Aaron Bertrand [MVP] (03/19/04)
- RE: Different Row Counts From Two Virtually Identical Queries Xavier Lazard (03/19/04)
- RE: Different Row Counts From Two Virtually Identical Queries Xavier Lazard (03/19/04)
- Re: Different Row Counts From Two Virtually Identical Queries Bruce Rose (03/19/04)
- Naming Procedures Chris (03/19/04)
- SQL Delete question Ivan Demkovitch (03/19/04)
- Converting varchar to money Andy (03/19/04)
- Converting varchar to money Andy (03/19/04)
- varchar vs char toylet (03/19/04)
- create a global procedure joe (03/19/04)
- Re: create a global procedure Adam Machanic (03/19/04)
- Re: create a global procedure Aaron Weiker (03/19/04)
- Re:create a global procedure anonymous_at_discussions.microsoft.com (03/19/04)
- Re: create a global procedure Tibor Karaszi (03/19/04)
- Re: create a global procedure Eric Sabine (03/19/04)
- Re: create a global procedure joe (03/19/04)
- Send info to client? Subodh123 (03/19/04)
- Beginner - Pecent in Calculated Column ??? Jayson (03/19/04)
- Any One Respond On This? (Major Problem - Please Help!!!) Konstantinos Michas (03/19/04)
- cast / convert / a function to turn for example "manager" to a number koho (03/19/04)
- Stored Proc Help Chris (03/19/04)
- Beginner's question Vlad (03/19/04)
- Reporting Services george r smith (03/19/04)
- Large Dataset Ruslan Shlain (03/19/04)
- Trigger trigger? nomenklatura (03/19/04)
- Oooops Quoted_Identifier Giacomo (03/19/04)
- xp_sendmail in SQL2K snide (03/19/04)
- Re: Data Model Advice Needed David Portas (03/19/04)
- Another Question Wayne Wengert (03/19/04)
- How to perform allocations and other planning functions in T-SQL Simon Lenn (03/19/04)
- Webs sites for T-SQL resources Simon Lenn (03/19/04)
- Update lock seems to hang Jan (03/19/04)
- problem with rand() function GK (03/19/04)
- wait delay toylet (03/19/04)
- transactions and stored procedures toylet (03/19/04)
- Problem with type NUMERIC(5,2) RADl0PASlV (03/19/04)
- Copying a table and its content Marie-Eve Racicot (03/19/04)
- Returning value from sp_OAMethod Kerr (03/19/04)
- Group Data with totals Kevin Lorimer (03/19/04)
- How to extrapolate different type of records in one file to different tables while loading Simon Lenn (03/19/04)
- Re: How to extrapolate different type of records in one file to different tables while loading Aaron Bertrand [MVP] (03/19/04)
- Re: How to extrapolate different type of records in one file to different tables while loading John Bell (03/19/04)
- Re: How to extrapolate different type of records in one file to different tables while loading Joe Celko (03/19/04)
- BLOB or simple image reference? What's best? tradmusic (03/19/04)
- Major Problem - Please Help!!! Konstantinos Michas (03/19/04)
- Creating Views CHRISTOPHER MEEK (03/19/04)
- Triggers - SQL 2K Dave Cook (03/19/04)
- catching deadlock Alexandru Savescu (03/19/04)
- Changing Funcionality??? Reg Besseling (03/19/04)
- Performance on parameterized queries vs. stored procedures Klaus Jensen (03/19/04)
- Modulus 3 Karen Comber (03/19/04)
- Optimizer question Hugo Kornelis (03/19/04)
- SQL UNION Dejan Markic (03/19/04)
- user sa don't have persmission to read from sysobjects rdo elie chucrallah (03/19/04)
- How to store db objects in VSS Brian (03/19/04)
- Latest data for many objects David Lloyd-Williams (03/19/04)
- How to validate a query? paul reed (03/19/04)
- YTD Stored Procedure Gee (03/19/04)
- Create a one-to-one-or-many relationship David Slinn (03/19/04)
- Creating a stored procedure to delete records... Elton Wong (03/19/04)
- dynamic sql with a cursor ? Aruna Tennakoon (03/19/04)
- dynamic sql with a cursor ? Aruna Tennakoon (03/19/04)
- dynamic sql with a cursor ? Aruna Tennakoon (03/19/04)
- dynamic sql with a cursor ? Aruna Tennakoon (03/19/04)
- Re: Hit maximum number of tables in a query (256) Barbara Neame (03/19/04)
- Call a Stored Procedure From HTML page using ADODB.Recordset Evan Kontos (03/19/04)
- Re: Call a Stored Procedure From HTML page using ADODB.Recordset Evan Kontos (03/19/04)
- Re: Call a Stored Procedure From HTML page using ADODB.Recordset Aaron Bertrand [MVP] (03/19/04)
- Re: Call a Stored Procedure From HTML page using ADODB.Recordset Tim (03/19/04)
- RE: Call a Stored Procedure From HTML page using ADODB.Recordset Baisong Wei[MSFT] (03/23/04)
- Question about table variables. Terry Howard (03/19/04)
- Accessing SQL Server in a clustered environment Irishmaninusa (03/19/04)
- Temporarily Inhibit Trigger Stefan Berglund (03/19/04)
- date conversion Ashish Sharma (03/19/04)
- Alerts for SQL Service stoppages Andre (03/19/04)
- Large update statements Gary (03/19/04)
- Update statements Gary (03/19/04)
- SP LOOP Chris (03/18/04)
- Question on stored proc on functions Chris (03/18/04)
- Stored Procedure Chris (03/18/04)
- sql statement quiz Oscar (03/18/04)
- list of last 24 months joe (03/18/04)
- set user fails with migrated user accounts? Jims (03/18/04)
- Question on Query Wayne Wengert (03/18/04)
- Update records only if changes have been made Chris Ennis (03/18/04)
- SQL Server Enterprise Manager Won't Start Fanghua (03/18/04)
- Float number issue Mike (03/18/04)
- Re: Float number issue Adam Machanic (03/18/04)
- Re: Float number issue Mike Sherrill (03/20/04)
- Re: Float number issue Aaron Bertrand [MVP] (03/20/04)
- Re: Float number issue Steve Kass (03/21/04)
- Re: Float number issue Aaron Bertrand [MVP] (03/21/04)
- Re: Float number issue Mike Sherrill (03/27/04)
- Re: Float number issue Aaron Bertrand [MVP] (03/28/04)
- Re: Float number issue Mike Sherrill (03/29/04)
- Re: Float number issue Mike Sherrill (03/20/04)
- Re: Float number issue Aaron Bertrand [MVP] (03/18/04)
- Re: Float number issue Joe Celko (03/18/04)
- Re: Float number issue Adam Machanic (03/18/04)
- How can I assign ReadText to local variable. Hiren (03/18/04)
- determining PK column sort order BruceH (03/18/04)
- View Partitioned Carrasco (03/18/04)
- Efficient programming Robert Goodwin (03/18/04)
- How to switch databases in a sproc programatically? Craig Cormier (03/18/04)
- Using DBCC DBREINDEX... Brett (03/18/04)
- update statement hngo01 (03/18/04)
- SQL Query ? Problem (03/18/04)
- Double Quotes Fail, Single Succeed RGondzur (03/18/04)
- calling sproc accross linked server is slooow Eddie Kramer (03/18/04)
- Insert 40 spaces.. Yaheya Quazi (03/18/04)
- problem using function Nikhil Patel (03/18/04)
- stored proc Chris (03/18/04)
- Data conversion PorkyJr (03/18/04)
- Query to create user-customisable filters/search Alex (03/18/04)
- Junction table or not Bjarn (03/18/04)
- Trigger Help Robert Muir (03/18/04)
- Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Steve Kass (03/18/04)
- Re: Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Aaron Bertrand [MVP] (03/18/04)
- Re: Why doesn't this work? YONg (03/18/04)
- Re: Why doesn't this work? Delbert Glass (03/18/04)
- Re: Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Delbert Glass (03/18/04)
- Re: Why doesn't this work? Steve Kass (03/19/04)
- Re: Why doesn't this work? Darren (03/18/04)
- Re: Why doesn't this work? Steve Kass (03/18/04)
- help with syntax error Stacey Howard (03/18/04)
- Is it Safe? Konstantinos Michas (03/18/04)
- SET TRANSACTION ISOLATION LEVEL Marlon R (03/18/04)
- Temporary tables with constraints in stored procedures Alastair Bell (03/18/04)
- running a DTS Package shank (03/18/04)
- Exporting query results to file using | (pipe) as a deliminator. dpearson (03/18/04)
- getting to the nth record in a table eja (03/18/04)
- Re: getting to the nth record in a table Adam Machanic (03/18/04)
- Re: getting to the nth record in a table Rohtash Kapoor (03/18/04)
- Re: getting to the nth record in a table Joe Celko (03/18/04)
- Re: getting to the nth record in a table Aaron Bertrand [MVP] (03/18/04)
- Re: getting to the nth record in a table Aaron Bertrand [MVP] (03/18/04)
- Urgent - Restrict K.M. (03/18/04)
- String or binary data would be truncated. Greg Chang (03/18/04)
- annoying QA thing Lasse Edsvik (03/18/04)
- Please help with this statement that uses WITH ROLLUP clause Subodh123 (03/18/04)
- Truncate all tables in SQL Server db Vlad (03/18/04)
- paging in t-sql Sabri AKIN (03/18/04)
- Problem with reporting services swedelong (03/18/04)
- File Deletion Guidence Julie (03/18/04)
- Does Sql Server cache data on modifications (insert,update) as it does queries. Acorum1 (03/18/04)
- Partitioned View Carrasco (03/18/04)
- CmdLine SQL Script Gen Stephen J Bement (03/18/04)
- Re: Arithmetic overflow in SQL-DMO when refreshing databasecollection. Tibor Karaszi (03/18/04)
- Invalid operator for type Lou (03/18/04)
- Changed fields in an Update Trigger Bryan A. Jackson (03/18/04)
- dropping columns toylet (03/18/04)
- Database mirroring on same server Brian Henry (03/18/04)
- date selector tool for INSERT / UPDATE form field - VBScript? tradmusic (03/18/04)
- ms sql server; linked server; jet; mdw Ryszard Halski (03/18/04)
- closing connection and setting nothing are necessary Sabri AKIN (03/18/04)
- SQL Server 2000 speed problems DPM (03/18/04)
- Create indexed view Dejan Markic (03/18/04)
- Scripting database diagrams Peter Strřiman (03/18/04)
- Need help with SQL syntax VC (03/18/04)
- Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/18/04)
- Re: Mysterious Port of SQL Server not shown by netstat Jacco Schalkwijk (03/18/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Tibor Karaszi (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Tibor Karaszi (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Stefan Delmarco [MSFT] (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Tibor Karaszi (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Tibor Karaszi (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Abhishek Srivastava (03/19/04)
- Re: Mysterious Port of SQL Server not shown by netstat Tibor Karaszi (03/18/04)
- Re: Mysterious Port of SQL Server not shown by netstat Jacco Schalkwijk (03/18/04)
- Stored procs pros & cons - any good links ? Andy Mackie (03/18/04)
- random records - how does it work? JB (03/18/04)
- Server Name and IP ? Luqman (03/18/04)
- Create view with rows from two tables - not by joining Mike Walsh (03/18/04)
- Re: Create view with rows from two tables - not by joining Andrew John (03/18/04)
- Re: Create view with rows from two tables - not by joining Greg O (03/18/04)
- Re: Create view with rows from two tables - not by joining David Portas (03/18/04)
- Re: Create view with rows from two tables - not by joining Mike Walsh (03/18/04)
- Re: Create view with rows from two tables - not by joining Tibor Karaszi (03/18/04)
- Re: Create view with rows from two tables - not by joining Mike Walsh (03/18/04)
- Re: Create view with rows from two tables - not by joining Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Mike Walsh (03/18/04)
- Re: Date field isn't - familiar format Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Mike Walsh (03/18/04)
- Re: Date field isn't - familiar format Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Mike Walsh (03/18/04)
- Re: Date field isn't - familiar format Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Mike Walsh (03/18/04)
- Re: Date field isn't - familiar format Tibor Karaszi (03/18/04)
- Re: Date field isn't - familiar format Mike Walsh (03/18/04)
- Re: Create view with rows from two tables - not by joining Mike Walsh (03/18/04)
- Re: Create view with rows from two tables - not by joining Mike Walsh (03/18/04)
- Urgent! Complex+Tricky sql query postmaster (03/18/04)
- Record number Sharon (03/18/04)
- query problem kurt cobain (03/18/04)
- query problem kurt (03/18/04)
- Is my syntax correct for Trigger after update Lasse (03/18/04)
- Returning a Range of Rows Khurram Chaudhary (03/18/04)
- random select Be Learning (03/18/04)
- Stored Procedure speed Derek (03/18/04)
- nVarchar Andrew (03/18/04)
- copy table & data John A Grandy (03/18/04)
- When 2 strings are concatenated by +,Is the maxmium string length 256? wangyang (03/18/04)
- If Else Logic Scott (03/18/04)
- Alias for a database name? David Sworder (03/18/04)
- SQL Server log file show 'login succeeded for use sa' more than 1000 times Oscar (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Tibor Karaszi (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Oscar (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Tibor Karaszi (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Tibor Karaszi (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Oscar (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Tibor Karaszi (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Oscar (03/18/04)
- Re: SQL Server log file show 'login succeeded for use sa' more than 1000 times Tibor Karaszi (03/18/04)
- Use Distinct or MAX newbie67 (03/18/04)
- updating rows Alan Zhong (03/18/04)
- Can CHARINDEX Expression2 be a UDF? paul reed (03/18/04)
- Re: Access <-> T-SQL syntax question Vishal Parkar (03/18/04)
- Outer Join problem... Scott Meddows (03/18/04)
- Select without tab... Yaheya Quazi (03/17/04)
- Querying Link Servers Chris (03/17/04)
- trying to insert into 2 tables simultaneously Chumley the Walrus (03/17/04)
- returning same row multiple times msnews.microsoft.com (03/17/04)
- Bug in Enterprise Manager when setting the font Jim Dandy (03/17/04)
- Problem with second execution of stored procedure Mirko (03/17/04)
- Inserting XML data into SQL table using OPENXML Rahul Chatterjee (03/17/04)
- xp_sendmail, @message, and unicode characters snclown (03/17/04)
- Storage size of smallmoney ddowell_at_qci.com (03/17/04)
- Could not start MSQSQLSERVER on local computer noahsarkive (03/17/04)
- Database Restore using VBScript John Barr (03/17/04)
- recreating spt_ tables David Reckner (03/17/04)
- Email HartA (03/17/04)
- Backup database to a diff server kunj (03/17/04)
- field types are changing shank (03/17/04)
- Unique column name Marina (03/17/04)
- Occasional "Timeouts" due to Optimizer? ITFred (03/17/04)
- Aggregate on Subselect Ryan (03/17/04)
- Leading zeros Chris (03/17/04)
- MSSQL - Invalid attribute/option identifier Bhavin Patel (03/17/04)
- DB modification tracking Russ (03/17/04)
- Interpreting Sp_lock results Todd (03/17/04)
- Retrieve Server IP and Sql Server Name through Query Analyzer ? Luqman (03/17/04)
- Re: Retrieve Server IP and Sql Server Name through Query Analyzer ? keene (03/17/04)
- Re: Retrieve Server IP and Sql Server Name through Query Analyzer ? Eric Sabine (03/17/04)
- Re: Retrieve Server IP and Sql Server Name through Query Analyzer ? Tibor Karaszi (03/17/04)
- Re: different row counts!!?? Delbert Glass (03/17/04)
- select count(*) slowness ryan (03/17/04)
- SQL recode Rus Kehoe (03/17/04)
- workaround: Sp_cursor: The Parameter 'Table' Is Invalid with Long Database Names Google Mike (03/17/04)
- a view based on stored procedure Biva (03/17/04)
- Re: a view based on stored procedure Tom Moreau (03/17/04)
- Re: a view based on stored procedure sqlgirl (03/17/04)
- Re: a view based on stored procedure Tom Moreau (03/17/04)
- Re: a view based on stored procedure sqlgirl (03/17/04)
- Re: a view based on stored procedure Tom Moreau (03/18/04)
- Re: a view based on stored procedure Baisong Wei[MSFT] (03/18/04)
- Re: a view based on stored procedure Tom Moreau (03/18/04)
- Re: a view based on stored procedure sqlgirl (03/18/04)
- Re: a view based on stored procedure Tom Moreau (03/18/04)
- Re: a view based on stored procedure sqlgirl (03/22/04)
- Re: a view based on stored procedure Tom Moreau (03/22/04)
- Re: a view based on stored procedure sqlgirl (03/17/04)
- Re: a view based on stored procedure Tom Moreau (03/17/04)
- transaction was deadlocke Jen (03/17/04)
- split by a pipe and insert into lookup Richard Wilde (03/17/04)
- Problem with MAX function Chris (03/17/04)
- Re: Problem with MAX function Aaron Bertrand [MVP] (03/17/04)
- Re: Problem with MAX function Daran Johnson (03/17/04)
- Re: Problem with MAX function oj (03/17/04)
- Re: Problem with MAX function Adam Machanic (03/17/04)
- Re: Problem with MAX function Roji. P. Thomas (03/17/04)
- Problem with MAX function keene (03/17/04)
- RE: Problem with MAX function Chris (03/17/04)
- RE: Problem with MAX function Chris (03/17/04)
- sql query with sp_msforeachtable SQL Apprentice (03/17/04)
- Always use int and never use bit, smallint tinyint ? YoYo Pa (03/17/04)
- Scheduled Job Notification Not Working Andre (03/17/04)
- Datetime Minimum Values Roger B. (03/17/04)
- SQL 2000 adOpenForwardOnly block Wayde Wyatt (03/17/04)
- Views and Variables SQL_stuck (03/17/04)
- I thier a way to see if an update occured Marc Oliver (03/17/04)
- THE DEFINITIVE ANSWER: Import CSV into SQL Server Andrew J Gray (03/17/04)
- Dynamic update of table dw (03/17/04)
- connection suddenly fails: mdac? pooling? Hernán Castelo (03/17/04)
- No DSN anonymous_at_coolgroups.com (03/17/04)
- Retrieving field properties Vik (03/17/04)
- Init Timestamp after added to table mklap (03/17/04)
- Sproc Question liz (03/17/04)
- Append One Table To Another Johnmichael Monteith (03/17/04)
- How to find only updated columns in a trigger. Gopinath Munisifreddy (03/17/04)
- traversing comma seperated values LIN (03/17/04)
- Combing two case statements into one Tony (03/17/04)
- Re: Combing two case statements into one Adam Machanic (03/17/04)
- Re: Combing two case statements into one Tony (03/17/04)
- Re: Combing two case statements into one Adam Machanic (03/17/04)
- Re: Combing two case statements into one Tony (03/17/04)
- Re: Combing two case statements into one Delbert Glass (03/17/04)
- Re: Combing two case statements into one Delbert Glass (03/17/04)
- Re: Combing two case statements into one Tony (03/17/04)
- Re: Combing two case statements into one Tony (03/17/04)
- Re: Combing two case statements into one Delbert Glass (03/18/04)
- Re: Combing two case statements into one Tony (03/17/04)
- Combing two case statements into one keene (03/17/04)
- Re: Combing two case statements into one Joe Celko (03/18/04)
- Re: Combing two case statements into one Adam Machanic (03/17/04)
- Setting up an UDL for OLEDB Connection Oscar (03/17/04)
- Rollback Kostas Michas (03/17/04)
- FOR XML with multiple joins fixitdik (03/17/04)
- sql query problem Ben (03/17/04)
- Performance goes down Mansoor Azam (03/17/04)
- counting with reset at group by? change CCA Dave (03/17/04)
- Select Stmnt Kostas Michas (03/17/04)
- Timeout errors for no reason Suzy Shipman (03/17/04)
- help with query SqlJunkies User (03/17/04)
- Transact-SQL problem: How can T-SQL accept parameter during execution? Grace (03/17/04)
- Case statements MBurns (03/17/04)
- High CPU Usage Satya Rao (03/17/04)
- Counting with distinct - Optimizer Problems Shawn Meyer (03/17/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/17/04)
- Re: Counting with distinct - Optimizer Problems Steve Kass (03/17/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/17/04)
- Re: Counting with distinct - Optimizer Problems oj (03/17/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/17/04)
- Re: Counting with distinct - Optimizer Problems Steve Kass (03/17/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/17/04)
- Re: Counting with distinct - Optimizer Problems Steve Kass (03/17/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/18/04)
- Re: Counting with distinct - Optimizer Problems Delbert Glass (03/18/04)
- Re: Counting with distinct - Optimizer Problems Shawn Meyer (03/18/04)
- Re: Counting with distinct - Optimizer Problems Steve Kass (03/17/04)
- Re: Counting with distinct - Optimizer Problems Gert-Jan Strik (03/17/04)
- Re: Counting with distinct - Optimizer Problems Delbert Glass (03/18/04)
- Re: Counting with distinct - Optimizer Problems Uri Dimant (03/17/04)
- How to replace TableName with variable? FineMa (03/17/04)
- DBSERVERENUM function in C++ Allan (03/17/04)
- looping through a recordset and updating records creates locks Michael (03/17/04)
- Object Permissions query brian (03/17/04)
- Money type doesn't display the decimals Jeroen de Graaff (03/17/04)
- Backup Question SStory (03/16/04)
- Working with Sheridan Grid Vlad (03/16/04)
- getdate() in UDF EdAk (03/16/04)
- Re: getdate() in UDF Erland Sommarskog (03/16/04)
- Re: getdate() in UDF Tom Moreau (03/16/04)
- Re: getdate() in UDF Kris Kirk (03/17/04)
- Re: getdate() in UDF Tibor Karaszi (03/17/04)
- Re: getdate() in UDF Kris Kirk (03/23/04)
- Re: getdate() in UDF Tibor Karaszi (03/23/04)
- Re: getdate() in UDF Delbert Glass (03/23/04)
- Re: getdate() in UDF Tibor Karaszi (03/23/04)
- Re: getdate() in UDF Delbert Glass (03/23/04)
- Re: getdate() in UDF Erland Sommarskog (03/23/04)
- Re: getdate() in UDF Tibor Karaszi (03/23/04)
- Re: getdate() in UDF Erland Sommarskog (03/24/04)
- Re: getdate() in UDF Tibor Karaszi (03/24/04)
- Re: getdate() in UDF Tibor Karaszi (03/17/04)
- Re: getdate() in UDF Kris Kirk (03/23/04)
- Re: getdate() in UDF Delbert Glass (03/23/04)
- Re: getdate() in UDF Tibor Karaszi (03/23/04)
- Re: getdate() in UDF Kris Kirk (03/24/04)
- Re: getdate() in UDF Erland Sommarskog (03/23/04)
- Re: getdate() in UDF Kris Kirk (03/24/04)
- Re: getdate() in UDF Erland Sommarskog (03/24/04)
- Re: getdate() in UDF Kris Kirk (03/24/04)
- Re: getdate() in UDF Erland Sommarskog (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Steve Kass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Steve Kass (03/25/04)
- Re: getdate() in UDF Steve Kass (03/25/04)
- Re: getdate() in UDF Delbert Glass (03/25/04)
- Re: getdate() in UDF Steve Kass (03/25/04)
- Re: getdate() in UDF Kris Kirk (03/25/04)
- Re: getdate() in UDF Erland Sommarskog (03/26/04)
- Re: getdate() in UDF Delbert Glass (03/26/04)
- Re: getdate() in UDF Delbert Glass (03/26/04)
- Re: getdate() in UDF Delbert Glass (03/26/04)
- Re: getdate() in UDF Delbert Glass (03/26/04)
- Re: getdate() in UDF Erland Sommarskog (03/28/04)
- Re: getdate() in UDF Kris Kirk (03/29/04)
- Re: getdate() in UDF Erland Sommarskog (03/29/04)
- Re: getdate() in UDF Kris Kirk (03/30/04)
- Re: getdate() in UDF Erland Sommarskog (03/30/04)
- Re: getdate() in UDF Delbert Glass (03/24/04)
- Re: getdate() in UDF Delbert Glass (03/26/04)
- Re: getdate() in UDF Kris Kirk (03/17/04)
- Re: getdate() in UDF Ray Higdon (03/17/04)
- Using CASE statement to build different where clause NWx (03/16/04)
- Re: Using CASE statement to build different where clause Greg Obleshchuk (03/16/04)
- Re: Using CASE statement to build different where clause Hugo Kornelis (03/16/04)
- Re: Using CASE statement to build different where clause Erland Sommarskog (03/16/04)
- Re: Using CASE statement to build different where clause NWx (03/17/04)
- Re: Using CASE statement to build different where clause Joe Celko (03/17/04)
- NULLS in view David Chase (03/16/04)
- Why Do I Get This Error EdAk (03/16/04)
- how I combine two case statement into one under same heading anonymous_at_discussions.microsoft.com (03/16/04)
- Re: how I combine two case statement into one under same heading Falik Sher (03/16/04)
- Re: how I combine two case statement into one under same heading Adam Machanic (03/16/04)
- Re: how I combine two case statement into one under same heading Delbert Glass (03/17/04)
- Re: how I combine two case statement into one under same heading Joe Celko (03/17/04)
- xp_cmdshell path issue David Potter (03/16/04)
- Transactions question Saga (03/16/04)
- Check name J. Hays (03/16/04)
- delete in blocks of 1000 chris (03/16/04)
- Help with Case expression, is this possible? Freddie (03/16/04)
- Stripping out unwanted characters Robert Wilder (03/16/04)
- using upper Melounjan (03/16/04)
- 2000 Std. edition physical size limits? Chris (03/16/04)
- Trapping an Error from a Linked Server? Mark (03/16/04)
- Data transformation SQL query... GB (03/16/04)
- Start job from another server Ray (03/16/04)
- Table Structure Question Dennis K. (03/16/04)
- Security by proc Url Onz (03/16/04)
- stats question Simon (03/16/04)
- How many records were updated? bruce (03/16/04)
- Join in a constraint ploppy (03/16/04)
- Month Name Jason (03/16/04)
- Emptying the buffers Jonathan Derbyshire (03/16/04)
- Using Select Or Set in Stored Procedures Todd (03/16/04)
- Connecting Securely? Richard Morey (03/16/04)
- Statistics....questions Simon (03/16/04)
- Errors when Syncronizing Atley (03/16/04)
- Openrowset Accessing problem Alex Wei (03/16/04)
- Row Level Security Jeff Dillon (03/16/04)
- SMP Sum(*) slow R-D-C (03/16/04)
- How To Handle User Defined Fields? ANTHONY (03/16/04)
- Prevent deletion or update of multiple rows steve cabello (03/16/04)
- Re: Prevent deletion or update of multiple rows Tibor Karaszi (03/16/04)
- Re: Prevent deletion or update of multiple rows Stephen Hendricks (03/16/04)
- Re: Prevent deletion or update of multiple rows Harman Sahni (03/16/04)
- Re: Prevent deletion or update of multiple rows Kalen Delaney (03/16/04)
- Re: Prevent deletion or update of multiple rows Itzik Ben-Gan (03/16/04)
- What is the maximum SQL statement you can run? Nick (03/16/04)
- Monday and Sunday of current week Edgard Riba (03/16/04)
- Newbie question... crowbird (03/16/04)
- Get rid of blanks Tommy D (03/16/04)
- delete locking chris (03/16/04)
- Use stored proc. results as source for aonther query maka (03/16/04)
- xp_cmdshell Mike A (03/16/04)
- BCP utility Skips lines in import... Timm (03/16/04)
- sp_executesql with ntext variable Patrick (03/16/04)
- newbie silly question djc (03/16/04)
- Select Statement - Please Help hngo01 (03/16/04)
- Restore with a different database name Gord (03/16/04)
- bcp_exec and ASP Dmitriy Shapiro (03/16/04)
- Oracle linked server problem Jimmy (03/16/04)
- GETDATE() or CURRENT_DATE Tim (03/16/04)
- Help with Blocking John Faris (03/16/04)
- Re: Help with Blocking Tom Moreau (03/16/04)
- Re: Help with Blocking John Faris (03/16/04)
- Re: Help with Blocking Tom Moreau (03/16/04)
- Re: Help with Blocking Tom Moreau (03/16/04)
- Re: Help with Blocking John Faris (03/17/04)
- Re: Help with Blocking Tom Moreau (03/17/04)
- Re: Help with Blocking John Faris (03/17/04)
- Re: Help with Blocking Tom Moreau (03/17/04)
- Re: Help with Blocking John Faris (03/19/04)
- Re: Help with Blocking Tom Moreau (03/19/04)
- Re: Help with Blocking John Faris (03/16/04)
- Re: Help with Blocking Keene (03/16/04)
- Re: Help with Blocking Quentin Ran (03/16/04)
- Re: Help with Blocking Tom Moreau (03/16/04)
- Security - Please Help Kostas (03/16/04)
- not so random connection error... MDAC?? Hernán Castelo (03/16/04)
- Oracle & SQL Server Nils Magnus Englund (03/16/04)
- Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Uri Dimant (03/16/04)
- Re: Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Uri Dimant (03/16/04)
- Re: Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Uri Dimant (03/16/04)
- Re: Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Uri Dimant (03/16/04)
- Re: Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Buzby (03/16/04)
- Re: Server does not exist or access denied Uri Dimant (03/16/04)
- Multiple unique constraints Ron Langereis (03/16/04)
- IF UPDATE (column) in a trigger Anand (03/16/04)
- FOR XML AUTO - Cutting off XML Andrew Banks (03/16/04)
- Optimizer not optimizing? Hugo Kornelis (03/16/04)
- Number of Column inside a "SQL Server 2003" Table vikash.verma (03/16/04)
- Recurring events in a booking system Nils Magnus Englund (03/16/04)
- Shrink Logfile rikesh (03/16/04)
- space used for each row JB (03/16/04)
- BCP Nightly Extracts bc (03/16/04)
- Grant EXEC on Stored Procedure gtaz21 (03/16/04)
- INNER JOIN newbie question francois (03/16/04)
- How to check a linekd server is available Franck (03/16/04)
- Language problem simon (03/16/04)
- SQL QUERY Arvind P Rangan (03/16/04)
- ANSI Vs MSSQL Join Style MrBug (03/16/04)
- how can i create the cube partiion in mdx steve (03/16/04)
- How to Calculate Word Days Lily (03/16/04)
- Oh... no.... Utada P.W. SIU (03/16/04)
- Keeping a Running Tally Khurram Chaudhary (03/16/04)
- Union of sets Tore G. (03/16/04)
- security and stored procedures toylet (03/16/04)
- Query Timeouts Darren M (03/15/04)
- Cocatenating strings where one table value is null Bob Dufour (03/15/04)
- Re: Cocatenating strings where one table value is null Vishal Parkar (03/15/04)
- Re: Cocatenating strings where one table value is null Jonathan Blitz (03/15/04)
- Re: Cocatenating strings where one table value is null Rohtash Kapoor (03/15/04)
- Re: Cocatenating strings where one table value is null Joe Celko (03/15/04)
- 'Where' selection passed as an argument gordon (03/15/04)
- Re: Version Control? Darren Fuller (03/15/04)
- Re: compare columns in 2 rows Darren Fuller (03/15/04)
- Advice on case statement Freddie (03/15/04)
- Re: automate Darren Fuller (03/15/04)
- Shrinkfile if DB Transaction Log > 500 MB Dan (03/15/04)
- Update Statement Slowwwwwwwwwww Marlene A. Roman (03/15/04)
- How to identify which SQL Agent job has called an sp. Richard R (03/15/04)
- Shrinkfile if DB Transaction Log > 500 MB Dan (03/15/04)
- newbie question. How to embed a .jpg into sql jake (03/15/04)
- query using linked server Jen (03/15/04)
- Best Practice - Cascade Delete? Bill Cohagan (03/15/04)
- DISTINCT AND ORDER BY together? SStory (03/15/04)
- How to register sql server database on web site? Luqman (03/15/04)
- Re: How to register sql server database on web site? Eric Sabine (03/15/04)
- Re: How to register sql server database on web site? Luqman (03/15/04)
- Re: How to register sql server database on web site? Adam Machanic (03/15/04)
- Re: How to register sql server database on web site? Eric Sabine (03/15/04)
- Re: How to register sql server database on web site? Luqman (03/16/04)
- Re: How to register sql server database on web site? Eric Sabine (03/17/04)
- Re: How to register sql server database on web site? Luqman (03/15/04)
- Re: How to register sql server database on web site? Eric Sabine (03/15/04)
- Query Chalange Patrick (03/15/04)
- Openrwoset Jason Zhou (03/15/04)
- SELECT on a stored procedure??? C Bloomberg (03/15/04)
- Monitoring sql server login attempts including IP ?! please help simo sentissi (03/15/04)
- see records of a Group by Jaco (03/15/04)
- get some records and then call a stored proc once for each?? SStory (03/15/04)
- Re: get some records and then call a stored proc once for each?? Keith Kratochvil (03/15/04)
- Re: get some records and then call a stored proc once for each?? SStory (03/15/04)
- Re: get some records and then call a stored proc once for each?? Keith Kratochvil (03/15/04)
- Re: get some records and then call a stored proc once for each?? SStory (03/15/04)
- Re: get some records and then call a stored proc once for each?? Keith Kratochvil (03/15/04)
- Re: get some records and then call a stored proc once for each?? Louis Davidson (03/16/04)
- Re: get some records and then call a stored proc once for each?? SStory (03/16/04)
- Re: get some records and then call a stored proc once for each?? SStory (03/15/04)
- Re: get some records and then call a stored proc once for each?? Joe Celko (03/15/04)
- Re: get some records and then call a stored proc once for each?? SStory (03/16/04)
- Re: get some records and then call a stored proc once for each?? Keith Kratochvil (03/15/04)
- .wav database Pachy (03/15/04)
- Info from SP_SPACEUSED vs. database properties Steven Wong (03/15/04)
- View Combining Fields Ford Prefect (03/15/04)
- ADO CommandTimeout on query using linked server Scott (03/15/04)
- Displaying SQL2000 version and service pack. Geir Holme (03/15/04)
- Error 156: Incorrect syntax near the keyword 'ORDER" shank (03/15/04)
- EXECUTING SP simon (03/15/04)
- Linked Server Update Problem Gary (03/15/04)
- UNIQUE index - constraint BUG/FEATURE? Mario Splivalo (03/15/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Adam Machanic (03/15/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Jacco Schalkwijk (03/15/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Joe Celko (03/15/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Mario Splivalo (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Adam Machanic (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Mario Splivalo (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Adam Machanic (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Joe Celko (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Anith Sen (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? John Saunders (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Adam Machanic (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? John Saunders (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Mario Splivalo (03/17/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Anith Sen (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Hugo Kornelis (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Adam Machanic (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Hugo Kornelis (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Anith Sen (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Tibor Karaszi (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Anith Sen (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Steve Kass (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? --CELKO-- (03/16/04)
- Re: UNIQUE index - constraint BUG/FEATURE? Mario Splivalo (03/16/04)
- sql query question (w/ test data) Jack (03/15/04)
- Rename table GeoWorks (03/15/04)
- Complex Script to Disallow Nulls in One Column? Don Miller (03/15/04)
- Check if column exists Ryan vd Merwe (03/15/04)
- re : finding date in data BH (03/15/04)
- finding date in data Selen (03/15/04)
- Open Sql Server DBA / Replication / DB-Libraries Contract Positions Axiom Sources (03/15/04)
- DateTime problem Blue Man (03/15/04)
- how to back up data sunil (03/15/04)
- c#, DTS and Threads Markus Heid (03/15/04)
- optimisation with extreme sql Jeho (03/15/04)
- Re: optimisation with extreme sql Uri Dimant (03/15/04)
- Re: optimisation with extreme sql Adam Machanic (03/15/04)
- Re: optimisation with extreme sql Brian Moran (03/15/04)
- Re: optimisation with extreme sql Adam Machanic (03/15/04)
- Re: optimisation with extreme sql Jeho (03/16/04)
- Re: optimisation with extreme sql Adam Machanic (03/16/04)
- Re: optimisation with extreme sql Jeho (03/16/04)
- Re: optimisation with extreme sql Karl Gram (03/16/04)
- Re: optimisation with extreme sql Jeho (03/17/04)
- Re: optimisation with extreme sql Brian Moran (03/15/04)
- transferring stored procedures from SQL 2000 to SQL 7.0 Nithya (03/15/04)
- error handling jeevan (03/15/04)
- error handling in procedure(sql server2000) jeevan (03/15/04)
- Query Analyzer Luke Ward (03/15/04)
- datetime field Selen (03/15/04)
- Send Mail Command Clement (03/15/04)
- Carriage return, line feed and text editors Martin Hellat (03/15/04)
- Limitations of Scheduled jobs Nonnie (03/15/04)
- Multi-database access in trigger CYTAY (03/15/04)
- How to Create and Debug a Setup Program to Update a SQL Server Database Johann Blake (03/15/04)
- managing relation in large DB** RM (03/15/04)
- maintenance plan Frank Dulk (03/15/04)
- Creating a view that uses a sp to retrive data Glenn Wilson (03/15/04)
- Re: Creating a view that uses a sp to retrive data Ryan Simpson (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Ryan Simpson [MSFT] (03/15/04)
- Re: Creating a view that uses a sp to retrive data Steve Kass (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data Uri Dimant (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data oj (03/15/04)
- Re: Creating a view that uses a sp to retrive data Ryan Simpson (03/15/04)
- Keylocks and updates Max Spectrum (03/14/04)
- Re: Keylocks and updates Andrew John (03/15/04)
- Re: Keylocks and updates Andrew J. Kelly (03/15/04)
- Re: Keylocks and updates Max Spectrum (03/15/04)
- Re: Keylocks and updates Andrew J. Kelly (03/15/04)
- Re: Keylocks and updates Max Spectrum (03/15/04)
- Re: Keylocks and updates Steve Kass (03/15/04)
- Re: Keylocks and updates Andrew J. Kelly (03/15/04)
- Re: Keylocks and updates Max Spectrum (03/15/04)
- Re: Keylocks and updates Andrew John (03/15/04)
- Re: Keylocks and updates Steve Kass (03/15/04)
- Re: Keylocks and updates Max Spectrum (03/15/04)
- Re: Keylocks and updates Ray Higdon (03/15/04)
- using 'sp_' as a naming convention for stored procedures Scott (03/14/04)
- COUNT shank (03/14/04)
- transaction for dbcc checktable EG (03/14/04)
- Escaping ' charactors in SQL Andrew Banks (03/14/04)
- SQL Server 2K connection is interrupted regularly, why ? Oscar (03/14/04)
- How to prevent queries showing up in Profiler? Ben Fidge (03/14/04)
- EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? David F (03/14/04)
- Re: EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? Tibor Karaszi (03/14/04)
- Re: EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? Aaron Bertrand [MVP] (03/14/04)
- Re: EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? Chandra A (03/15/04)
- Re: EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? Joe Celko (03/15/04)
- Query: Which employee had the most orders... for each day Bill (03/14/04)
- T-SQL : Unknown number of input parameters Jaco (03/14/04)
- Cursor inside another cursor, or...? \ (03/14/04)
- use of @@error John Brown (03/14/04)
- Case statement ajmiester (03/14/04)
- Invalid cursor state Dean Slindee (03/14/04)
- setting scale parameters shank (03/14/04)
- SQL Server 2K disconnects the client after reaching a specific amount of query load. Oscar (03/13/04)
- Should I use a stored procedure? Martin (03/13/04)
- find non matching records shank (03/13/04)
- STORED PROC QUESTION? billb (03/13/04)
- locking questions John Brown (03/13/04)
- Names of Week-days J. Joshi (03/13/04)
- derived table query shank (03/13/04)
- Printing the KEYS of all tables !!bogus (03/13/04)
- Re: Printing the KEYS of all tables Grant Case (03/13/04)
- Re: Printing the KEYS of all tables Erland Sommarskog (03/13/04)
- Re: Printing the KEYS of all tables !!bogus (03/14/04)
- Re: Printing the KEYS of all tables Grant Case (03/14/04)
- Re: Printing the KEYS of all tables Erland Sommarskog (03/14/04)
- Re: Printing the KEYS of all tables Grant Case (03/14/04)
- Re: Printing the KEYS of all tables Erland Sommarskog (03/14/04)
- Re: Printing the KEYS of all tables Grant Case (03/15/04)
- Re: Printing the KEYS of all tables Erland Sommarskog (03/15/04)
- Re: Printing the KEYS of all tables Erland Sommarskog (03/13/04)
- Re: Printing the KEYS of all tables Karl Gram (03/13/04)
- Re: Printing the KEYS of all tables Grant Case (03/13/04)
- Eroor checking in SPs A Ratcliffe (03/13/04)
- sqldmo and late-binding Amicus (03/13/04)
- MSDE 2000 Setup problem, Reboot Geoffrey Cohen (03/13/04)
- Security - Access Rights on DB Michas Konstantinos (03/13/04)
- optimizin queries maysa (03/13/04)
- create the batch file to call the stored procedure vanil (03/13/04)
- two update triggers on same table Mullin Yu (03/13/04)
- SQL month riddle - most efficient way? Nathon Jones (03/13/04)
- Re: SQL month riddle - most efficient way? David Portas (03/13/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/13/04)
- Re: SQL month riddle - most efficient way? David Portas (03/13/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/13/04)
- Re: SQL month riddle - most efficient way? David Portas (03/13/04)
- Re: SQL month riddle - most efficient way? Joe Celko (03/13/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/14/04)
- Re: SQL month riddle - most efficient way? Erland Sommarskog (03/14/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? Joe Celko (03/15/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? Hugo Kornelis (03/15/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/13/04)
- Re: SQL month riddle - most efficient way? David Portas (03/13/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? David Portas (03/15/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/15/04)
- Re: SQL month riddle - most efficient way? David Portas (03/16/04)
- Re: SQL month riddle - most efficient way? Nathon Jones (03/16/04)
- Re: SQL month riddle - most efficient way? David Portas (03/16/04)
- Re: SQL month riddle - most efficient way? Hugo Kornelis (03/16/04)
- Re: SQL month riddle - most efficient way? David Portas (03/13/04)
- Problems with Table Variable's Susan (03/13/04)
- coding for no blocking or deadlocks. mannie (03/13/04)
- Re: coding for no blocking or deadlocks. Steve Kass (03/13/04)
- Re: coding for no blocking or deadlocks. John Bell (03/13/04)
- Re: coding for no blocking or deadlocks. Andrew John (03/13/04)
- Re: coding for no blocking or deadlocks. Jaxon (03/13/04)
- Re: coding for no blocking or deadlocks. Ryan Simpson [MSFT] (03/15/04)
- BULK INSERT - tab delimited AT (03/13/04)
- Either BOF or EOF is True, or the current record has been deleted error makes no sense Chumley the Walrus (03/12/04)
- Need a query Mehran (03/12/04)
- Re: Query Plan Differences Yolanda (03/12/04)
- string delimiter in bcp/bulk insert Invalidlastname (03/12/04)
- How to avoid hardcoded server name in LDAP query in view? Vadim Rapp (03/12/04)
- Can Not find Stored procedure Joel (03/12/04)
- What's up with Enterprise Manager? Raterus (03/12/04)
- SQL Server Community Survey MS SQL Survey Admin. (03/12/04)
- Re: SQL Server Community Survey Brandon Lilly (03/12/04)
- Re: SQL Server Community Survey Adam Machanic (03/12/04)
- Re: SQL Server Community Survey Scott Morris (03/12/04)
- Re: SQL Server Community Survey oj (03/12/04)
- Re: SQL Server Community Survey Brandon Lilly (03/12/04)
- Re: SQL Server Community Survey Jacco Schalkwijk (03/12/04)
- Re: SQL Server Community Survey Roji. P. Thomas (03/12/04)
- Re: SQL Server Community Survey Adam Machanic (03/12/04)
- Re: SQL Server Community Survey Steve Kass (03/12/04)
- Re: SQL Server Community Survey Ed Lehman [MSFT] (03/12/04)
- Re: SQL Server Community Survey Roji. P. Thomas (03/12/04)
- Re: SQL Server Community Survey Ed Lehman [MSFT] (03/12/04)
- Re: SQL Server Community Survey oj (03/12/04)
- Re: SQL Server Community Survey Ed Lehman [MSFT] (03/12/04)
- Re: SQL Server Community Survey oj (03/12/04)
- Re: SQL Server Community Survey Adam Machanic (03/12/04)
- Re: SQL Server Community Survey JT Lovell (03/12/04)
- Re: SQL Server Community Survey Roji. P. Thomas (03/12/04)
- RE: SQL Server Community Survey MS SQL Survey Admin. (03/12/04)
- Re: SQL Server Community Survey Brandon Lilly (03/12/04)
- date format Tomas Mudrak (03/12/04)
- passing function result as a function parameter dan i (03/12/04)
- Updating an expiration date based on the next effective date Drew (03/12/04)
- WITH ENCRYPTION Sam Davis (03/12/04)
- Master DB brian (03/12/04)
- New Article: An XML Eye for the Database Guy (Part I) SqlJunkies User (03/12/04)
- Autocommit and stored proc mannie (03/12/04)
- Quickway to dump all the user Stored Procs into Visual Source Safe Suresh Kumar (03/12/04)
- Selecting a Random Record Jeff Dillon (03/12/04)
- Encrypting & Decrypting Passwords Chipsin (03/12/04)
- Job Backup ? Patrick (03/12/04)
- Counting previous 12 mths form today J. Joshi (03/12/04)
- Select statment Lee (03/12/04)
- insert without log Al (03/12/04)
- xp_CmdShell and VBScript Scott Elgram (03/12/04)
- Need help with Select Statement ajmister (03/12/04)
- Comma delimited issues johnduran (03/12/04)
- Parsing .TXT file__ Lynn Pennington (03/12/04)
- Need help with Select Statement ajmister (03/12/04)
- Row Level Trigger kara (03/12/04)
- ODBC, alias an SQL Server Login error Dave (03/12/04)
- UDF with GetDate RR SPSCC (03/12/04)
- Opening cursor after closing does not seem to requery mberry (03/12/04)
- How can I have multible connections and readers? Trint Smith (03/12/04)
- There is already an object named '#CDList' in the database Mark (03/12/04)
- database collation issue ChrisB (03/12/04)
- VSS Sql Server Integration using VS.NET 2003 Chad (03/12/04)
- VSS SQL Server Integration using VS.NET Chad (03/12/04)
- Matching on a subquery with multiple columns JT Lovell (03/12/04)
- Tricky trigger design - can this be done? Richard Dixson (03/12/04)
- Update more than one row corinne (03/12/04)
- lost in locks... mannie (03/12/04)
- Using Stored Procedure in DTS package hngo01 (03/12/04)
- sql result to horizontal table vitaliyk (03/12/04)
- Is OSQL can return error ? Ravinder (03/12/04)
- Debugging T-SQL Codes Amin Sobati (03/12/04)
- Newbie sql question Jack (03/12/04)
- Query For A Word Containing A Reserved Character Kevin W. Miller (03/12/04)
- Cannot create index on view Amin Sobati (03/12/04)
- SQL Mail brian (03/12/04)
- Where are indexes of views? Amin Sobati (03/12/04)
- getting values from inserted table Brian Henry (03/12/04)
- European Dayofweek? Lasse Edsvik (03/12/04)
- uniqueidentifier Hutch (03/12/04)
- the fastest join Raider (03/12/04)
- Partitioned View Carrasco (03/12/04)
- Replacing data ? Peter Newman (03/12/04)
- identiy_insert and data generators Martin Hellat (03/12/04)
- Newbie question; Why is my procedure slow when a parameter is used? Paul (03/12/04)
- Re: 400 Linked Server to SQL Server via IBMDA400 Christophe Niel (03/12/04)
- Query performance on archived data DBA72 (03/12/04)
- drill odwn on month Willa (03/12/04)
- trigger execution Con (03/12/04)
- Order By in a View Wayne (03/12/04)
- ask for standard sp writing Mullin Yu (03/12/04)
- How to call one SQL script from another Boaz Ben-Porat (03/12/04)
- cube partition will reflect in dts sleek (03/12/04)
- executing dts package in stored procedure? sleek (03/12/04)
- errr........'getdate' within a function. Kishor Pise (03/12/04)
- Materialized view Thomas (03/12/04)
- Batch processing of Stored Procedure Kong Li (03/12/04)
- [Question] select top n in each group kenneth (03/12/04)
- Improve This Trigger?? MSanchez13 (03/12/04)
- How do I create a Stored Precedure if one does not exist? Russell Mangel (03/12/04)
- how to cast numeric col as nvarchar in join? Rich (03/11/04)
- Help with SUM Biva (03/11/04)
- UDF/SP Editor EDAK (03/11/04)
- how to select from a stored proc Patrick (03/11/04)
- Query help abc_at_helloall.com (03/11/04)
- Text data type in stored procedure DC (03/11/04)
- Sort NULLs after rows with values Bob Franklin (03/11/04)
- A Query Question Tomas (03/11/04)
- something is very weird on execution plan joe (03/11/04)
- Elseif Yaheya Quazi (03/11/04)
- Sequential integer column in view alien2_51 (03/11/04)
- Re: Sequential integer column in view Karl Gram (03/11/04)
- Re: Sequential integer column in view alien2_51 (03/11/04)
- Re: Sequential integer column in view alien2_51 (03/11/04)
- Re: Sequential integer column in view Louis Davidson (03/11/04)
- Re: Sequential integer column in view alien2_51 (03/11/04)
- Re: Sequential integer column in view Aaron Bertrand [MVP] (03/11/04)
- Re: Sequential integer column in view alien2_51 (03/15/04)
- Re: Sequential integer column in view alien2_51 (03/11/04)
- Re: Sequential integer column in view Karl Gram (03/11/04)
- xp_cmdshell output question Matthew Speed (03/11/04)
- Transact SQL Michael (03/11/04)
- Short Month Name Amy Snyder (03/11/04)
- Audit Trail on SQL Server Thierry Marneffe (03/11/04)
- New record ids from master to child Mark Goldin (03/11/04)
- storing time Mike Kanski (03/11/04)
- how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tom Moreau (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tom Moreau (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? keene (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tibor Karaszi (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tom Moreau (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tom Moreau (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Rich (03/11/04)
- Re: how to use IF Exists in Sql to Drop a Table? Tom Moreau (03/11/04)
- SQLDMO: howto obtain logical file names from a BAK file Rocio (03/11/04)
- Updating to NULL instead of zero RobertS (03/11/04)
- highlight a row in MSFlexGrid Bruce Gilbert (03/11/04)
- Trouble with EXEC Khurram Chaudhary (03/11/04)
- DELETE Trigger Scott Elgram (03/11/04)
- Indexing bug when used with COUNT(*) ??? R-D-C (03/11/04)
- should i use a loop or a cursor? Loic (03/11/04)
- Replacement of Open Data Service Prashant (03/11/04)
- Putting an auto-increment column in my select statement Jim Bancroft (03/11/04)
- error running sp_OAGetProperty Guru (03/11/04)
- using Case function in SQL2K hngo01 (03/11/04)
- Login Event!(or something like that...) Amin Sobati (03/11/04)
- SQL query error Stephen Cairns (03/11/04)
- Pb with on delete cascade... HELP!!! Ni***zzz (03/11/04)
- Re: Pb with on delete cascade... HELP!!! Louis Davidson (03/11/04)
- Re: Pb with on delete cascade... HELP!!! Ni***zzz (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Tibor Karaszi (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Ni***zzz (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Roji. P. Thomas (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Ni***zzz (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Tibor Karaszi (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Ni***zzz (03/12/04)
- Re: Pb with on delete cascade... HELP!!! Louis Davidson (03/11/04)
- Deleted database by mistake Zwi2000 (03/11/04)
- update query nic (03/11/04)
- SQL vs. VFP john Smith (03/11/04)
- mssqlserver stopped Sabri AKIN (03/11/04)
- Trigger Failure and Rollback question FlyingTigerB25 (03/11/04)
- SP for a Forum breadcrumb trail A Ratcliffe (03/11/04)
- select tables permissions and apply to another table Hutch (03/11/04)
- Crosstab query in SQL Rahul Chatterjee (03/11/04)
- Re: Crosstab query in SQL Dr. StrangeLove (03/11/04)
- Re: Crosstab query in SQL Rahul Chatterjee (03/11/04)
- Re: Crosstab query in SQL mike (03/11/04)
- Re: Crosstab query in SQL Dr. StrangeLove (03/11/04)
- Re: Crosstab query in SQL Roji. P. Thomas (03/11/04)
- Re: Crosstab query in SQL Dr. StrangeLove (03/11/04)
- Re: Crosstab query in SQL Roji. P. Thomas (03/12/04)
- Re: Crosstab query in SQL oj (03/12/04)
- Re: Crosstab query in SQL Adam Machanic (03/11/04)
- Re: Crosstab query in SQL Joe Celko (03/11/04)
- Re: Crosstab query in SQL Rahul Chatterjee (03/11/04)
- Re: Crosstab query in SQL Greg O (03/11/04)
- Re: Crosstab query in SQL Dr. StrangeLove (03/11/04)
- Error on query Pedro Semedo (03/11/04)
- Good Scripting Resource Erin Peterson (03/11/04)
- Persisting temp tables Dodger (03/11/04)
- Simple query Robert Chapman (03/11/04)
- binding error on function, eh? Peter Row (03/11/04)
- Selecting variables into temp table Paul Bull (03/11/04)
- LinkedServer and Unique-Key / Error 7319 SB (03/11/04)
- Dynamic check constraint Amit (03/11/04)
- view object ip (03/11/04)
- pls help!!! madhu (03/11/04)
- using xp_sendmail simon whale (03/11/04)
- Program Documenation for Stored Procedure ? tristant (03/11/04)
- Identical record Vlado (03/11/04)
- Data tables only linked through programming jamie (03/11/04)
- Report Invalid objs Konstantinos Michas (03/11/04)
- DBCC CHECKTABLE Konstantinos Michas (03/11/04)
- experts prasad small prob in proc madhu (03/11/04)
- LAT /Long Problem jack (03/11/04)
- Re: Select nearby locations using Lat / Long jack (03/11/04)
- Process Lock Mullin Yu (03/11/04)
- table variable wd1153 (03/11/04)
- Unicode Problem Blue Man (03/11/04)
- Divide by zero btl (03/11/04)
- SQL Server to Oracle bclegg (03/11/04)
- VIEW showing result of a STORED PROCEDURE ? Lisa Pearlson (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? oj (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? Lisa Pearlson (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? oj (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? Steve Kass (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? Uri Dimant (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? oj (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? oj (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? Lisa Pearlson (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? Lisa Pearlson (03/11/04)
- Re: VIEW showing result of a STORED PROCEDURE ? oj (03/11/04)
- Problem in connecting after service pack 3a installed in MSDE 2000 chellam (03/11/04)
- casting into % dk (03/11/04)
- temp tables shank (03/11/04)
- Questions about using alternative to SUM() EricT (03/11/04)
- do not generate SET statements John A Grandy (03/11/04)
- Database events - notify an application Mike Hildner (03/11/04)
- Update & Delete Jason Williams (03/10/04)
- Prepared Statement vs. Stored Procedure Christopher Campbell (03/10/04)
- Re: Prepared Statement vs. Stored Procedure Jaxon (03/10/04)
- RE: Prepared Statement vs. Stored Procedure Baisong Wei[MSFT] (03/15/04)
- Re: Prepared Statement vs. Stored Procedure Christopher Campbell (03/15/04)
- Re: Prepared Statement vs. Stored Procedure Jaxon (03/16/04)
- Re: Prepared Statement vs. Stored Procedure Jaxon (03/16/04)
- Re: Prepared Statement vs. Stored Procedure Kevin Yu [MSFT] (03/16/04)
- Re: Prepared Statement vs. Stored Procedure Baisong Wei[MSFT] (03/16/04)
- Re: Prepared Statement vs. Stored Procedure Baisong Wei[MSFT] (03/18/04)
- Re: Prepared Statement vs. Stored Procedure Christopher Campbell (03/15/04)
- Select records not more that 6 months old James Cooke (03/10/04)
- Top x Percent Rush (03/10/04)
- RE: how to get the table schema? Farooq Mahmud [MS] (03/10/04)
- Using VBscript to check a file size and then update table. Jonesgj (03/10/04)
- XPSMTP (cross) \ (03/10/04)
- How can I find the command from command prompt? Quentin Huo (03/10/04)
- OPENROWSET___ Lynn Pennington (03/10/04)
- Add a autonum column to a view Frank (03/10/04)
- sp_OACreate and Queued Components Steve (03/10/04)
- Help concatenating records to a field Dan (03/10/04)
- Re: Help concatenating records to a field Dr. StrangeLove (03/10/04)
- Re: Help concatenating records to a field Quentin Ran (03/10/04)
- Re: Help concatenating records to a field Joe Celko (03/10/04)
- Re: Help concatenating records to a field David Portas (03/10/04)
- Re: Help concatenating records to a field Mike M (03/10/04)
- dbo user? John Brown (03/10/04)
- Update time Derik (03/10/04)
- SQL Query Distinct? Laura (03/10/04)
- Triggers + inserting into other table Brian Henry (03/10/04)
- reformat the output joe (03/10/04)
- Date issues between SQL and IIS servers Randy F. (03/10/04)
- Parsing XML within SQL Server r.goodwin_at_cablelabs.com (03/10/04)
- Error Message Dropping Foreign Key Erin Peterson (03/10/04)
- Trigger (for keeping history info) help! F HS (03/10/04)
- OT SQL Users group Pat Wright (03/10/04)
- ASP FormatNumber FAILS Steve (03/10/04)
- Calculating Percentage in a Query J. Joshi (03/10/04)
- How do I get a list of available tables? James C (03/10/04)
- Updates degradation Mario Pleitez (03/10/04)
- Help with a query Mamun (03/10/04)
- datetime field usage FCI (03/10/04)
- ADO 2.8 help files Mario Splivalo (03/10/04)
- Stored Procedure Recompiles Steve (03/10/04)
- First day of week Immy (03/10/04)
- T-SQL "division by zero" workaround? Graham Blandford (03/10/04)
- Re: T-SQL "division by zero" workaround? Roji. P. Thomas (03/10/04)
- Re: T-SQL "division by zero" workaround? Microsoft (03/10/04)
- Re: T-SQL "division by zero" workaround? Anith Sen (03/10/04)
- Re: T-SQL "division by zero" workaround? Uri Dimant (03/10/04)
- Re: T-SQL "division by zero" workaround? Gert-Jan Strik (03/10/04)
- VB Programming WaterGirl (03/10/04)
- Repost: job agent problem Quentin Ran (03/10/04)
- Help creating a trigger Mark (03/10/04)
- Sharing Tables between Databases Microsoft (03/10/04)
- Real Column Name, Please Help Kostas (03/10/04)
- Re: Real Column Name, Please Help Anith Sen (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Anith Sen (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Tibor Karaszi (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Tibor Karaszi (03/10/04)
- Re: Real Column Name, Please Help Kostas (03/10/04)
- Re: Real Column Name, Please Help Anith Sen (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Kostas (03/10/04)
- Re: Real Column Name, Please Help Anith Sen (03/10/04)
- Re: Real Column Name, Please Help Kostas Michas (03/10/04)
- Re: Real Column Name, Please Help Anith Sen (03/10/04)
- Need help with Date parameter ajmister (03/10/04)
- Datetime help Steve K. (03/10/04)
- Executing a DTS Package from a Stored Procedure Brennan (03/10/04)
- day of week Tomas Mudrak (03/10/04)
- Update a date Robert Batt (03/10/04)
- BCP Fails to Parse Format File If It Has White Space in Column Name Steve D?sy (03/10/04)
- backup log <my database> with no_log myoav (03/10/04)
- Query/Update response time concerns Martin (03/10/04)
- Re: Query/Update response time concerns Karl Gram (03/10/04)
- Re: Query/Update response time concerns Martin (03/10/04)
- Re: Query/Update response time concerns Karl Gram (03/10/04)
- Re: Query/Update response time concerns Martin (03/10/04)
- Re: Query/Update response time concerns Tibor Karaszi (03/10/04)
- Re: Query/Update response time concerns Karl Gram (03/10/04)
- Re: Query/Update response time concerns Martin (03/10/04)
- Re: Query/Update response time concerns Tibor Karaszi (03/10/04)
- Re: Query/Update response time concerns Martin (03/10/04)
- Re: Query/Update response time concerns Karl Gram (03/10/04)
- SP's brian (03/10/04)
- Logarithms Carlitos (03/10/04)
- sp_columns thread safe? Jesper (03/10/04)
- Re: Wildcards in REPLACE function? Dennis Hancy (03/10/04)
- how to calculate recordcount of a ADO recordset that has been created already ? Oscar (03/10/04)
- Re: how to calculate recordcount of a ADO recordset that has been created already ? Brian Moran (03/10/04)
- Re: how to calculate recordcount of a ADO recordset that has been created already ? Wayne Snyder (03/10/04)
- Re: how to calculate recordcount of a ADO recordset that has been created already ? Uri Dimant (03/10/04)
- Re: how to calculate recordcount of a ADO recordset that has been created already ? Jacco Schalkwijk (03/10/04)
- My research project Evelyn (03/10/04)
- urgent!! stored procedure madhu (03/10/04)
- Dynamic distributed SQL query needs ANSI_NULLS & ANSI_WARNINGS but can't set them Laurence Neville (03/10/04)
- Parse Objects Michas Konstantinos (03/10/04)
- performance Dominique Vandensteen (03/10/04)
- Alias Michas Konstantinos (03/10/04)
- reuse of column_header (alias) marc (03/10/04)
- How to tell if I can convert a varchar to int Chris Lacey (03/10/04)
- character '\' disable CR+LF Jefferson Valim (03/10/04)
- urgent!!! in stored procedure in sql server madhu (03/10/04)
- SQL statement with Query Analyser NH (03/10/04)
- Insert many rows using select Paul (03/10/04)
- Advanced Select and Insert Marcus (03/10/04)
- Strange Invalid Connection Error Neil Penn (03/10/04)
- rowcount syntax NH (03/10/04)
- thanx experts,Prasad madhu (03/10/04)
- Error 8646!!! URGENT!!! PLEASE!!! Volhv (03/10/04)
- Read column description with ADO OpenSchema, SQL Server 2000 Asko Telinen (03/10/04)
- SQL result zero - Help Nikolami (03/10/04)
- Thanx experts..but pls clarify... madhu (03/10/04)
- Hidden error kills my transaction. Help! Miroo_news (03/10/04)
- Timestamp simon (03/10/04)
- How to use 'Check Contraint' on a View ? Krist Lioe (03/10/04)
- Unicode with DB-Library Dan (03/10/04)
- stored procedure madhu (03/10/04)
- how to call dts package in sql server stored procedure. madhu (03/10/04)
- Thank you Experts DRM (03/10/04)
- OPENQUERY error Chad (03/10/04)
- TSQL truncated when SP is saved DRM (03/10/04)
- select @@IDENTITY from MyTable Matt (03/10/04)
- command to run sql statement Matt (03/10/04)
- Help for newbie with triggers Richard Dixson (03/10/04)
- Re: Grouping on a difference in time Brian Moran (03/10/04)
- Command Line & MS SQL Server Noori (03/10/04)
- calculating SUM shank (03/10/04)
- Run stored procedure from C# Mark Goldin (03/10/04)
- Grouping on difference in time Stijn Verrept (03/10/04)
- Query Problem Wayne Wengert (03/10/04)
- Update partial data beween unequal columns DRM (03/09/04)
- strange SP problem fatmanlittleboy (03/09/04)
- Re: Unable to modify table. Invalid cursor state. james (03/09/04)
- INSERT variable and select David Chase (03/09/04)
- ASP resultset fails if Stored Proc uses Temp tables Steve (03/09/04)
- Date calculation problem - newbie Den (03/09/04)
- Sub-Query Problem J. Joshi (03/09/04)
- TRIGGER DLL HELP PalJoey (03/09/04)
- Truly NULL dates Fred Nelson (03/09/04)
- Help with SQL query ajmister (03/09/04)
- import with counter (DTS package) \ (03/09/04)
- Query or SP help Mamun (03/09/04)
- Using table variable causes error EricT (03/09/04)
- Show number as currency.. Yaheya Quazi (03/09/04)
- When exactly we use BEGIN DISTRIBUTED TRANSACTION ??? Sai (03/09/04)
- Converting to Date Atley (03/09/04)
- Re: Converting to Date Gerry O'Brien [MVP] (03/09/04)
- Re: Converting to Date Adam Machanic (03/09/04)
- Converting to Date anonymous_at_discussions.microsoft.com (03/09/04)
- Re: Converting to Date Alex Feinman [MVP] (03/09/04)
- Re: Converting to Date Ginny Caughey [MVP] (03/09/04)
- Converting to Date Suresh (03/09/04)
- Re: Converting to Date Keith Kratochvil (03/10/04)
- Re: How can I restore a database in SQL2000 server from a SQL6.5 backup file ? Anith Sen (03/09/04)
- Anyone ever done something like this? Need Help! zubby01 (03/09/04)
- import data from query using DTS hngo01 (03/09/04)
- RE: SQL Mail 2 troubled w/mail (03/09/04)
- Linked Servers Vlamir (03/09/04)
- Using Expression Resuts in Another Expression Dean (03/09/04)
- Re: Using Expression Resuts in Another Expression Adam Machanic (03/09/04)
- Re: Using Expression Resuts in Another Expression Tom Moreau (03/09/04)
- Re: Using Expression Resuts in Another Expression Tom Moreau (03/09/04)
- Re: Access with SQL [ADP?] dp (03/09/04)
- using sqlmail Mark (03/09/04)
- Global Variables? kb (03/09/04)
- MSQL Query's Compare to Ms Access Patrick (03/09/04)
- Filtering Records With Row Numers kamal (03/09/04)
- Query Help Mamun (03/09/04)
- Need good coding Technique. Raj (03/09/04)
- job agent problem Quentin Ran (03/09/04)
- Hide if total column is 0 Yaheya Quazi (03/09/04)
- update strategies PA (03/09/04)
- Import Rog (03/09/04)
- Can DTS wizard handle AUTONUM Field and DEFAULT VALUE property of an Access DB ? Oscar (03/09/04)
- Run Scripts Tunji (03/09/04)
- Trigger with an Insert statement Stewart Saathoff (03/09/04)
- SQL Statement needed!!!! Vincent Jones (03/09/04)
- Running SQL Scripts in Visual Studio .NET Steve (03/09/04)
- Select Question Brandon (03/09/04)
- URGENT!!!How to turn the results of a row into separate columns?? Georgia (03/09/04)
- Re: URGENT!!!How to turn the results of a row into separate columns?? Adam Machanic (03/09/04)
- Re: URGENT!!!How to turn the results of a row into separate columns?? Uri Dimant (03/09/04)
- Re: URGENT!!!How to turn the results of a row into separate columns?? Delbert Glass (03/09/04)
- Re: URGENT!!!How to turn the results of a row into separate columns?? Dr. StrangeLove (03/09/04)
- Parse email addresses into SQL server Jongog (03/09/04)
- Starting replication with a stored procedure? Uenal (03/09/04)
- udf in defalut value Dolphin (03/09/04)
- Home office phone system JT Lovell (03/09/04)
- cast 1.5 into 1% dk (03/09/04)
- plz send me reply Kamal (03/09/04)
- Debugging Emma (03/09/04)
- backups job to tape failed ravi reddy (03/09/04)
- Can I use column(0) in a Stored Procedure? Brandon (03/09/04)
- Error 3702: database in use and cannot be deleted Hartmut Schroth (03/09/04)
- Stored Proc help Tim Vernon (03/09/04)
- xp_cmdshell problem Mark Roberts (03/09/04)
- Data type info Joe (03/09/04)
- ASP Code Stephen Cairns (03/09/04)
- Trigger Laszlo Csabi (03/09/04)
- Update query has syntax error (missing operator) Robert Chapman (03/09/04)
- Re: Update query has syntax error (missing operator) Jacco Schalkwijk (03/09/04)
- Re: Update query has syntax error (missing operator) Uri Dimant (03/09/04)
- Re: Update query has syntax error (missing operator) Niko Vrdoljak (03/09/04)
- Re: Update query has syntax error (missing operator) David Portas (03/09/04)
- Re: Update query has syntax error (missing operator) Louis Davidson (03/09/04)
- Conversion Access to SQL Server 2K : DBTIMESTAMP data overflow error Oscar (03/09/04)
- Query help for getting decent logging results Stijn Verrept (03/09/04)
- How to: create linked records (or records in linked tables) Grant Ord (03/09/04)
- merging of development and production db Christian Kuendig (03/09/04)
- Trigger status Steve (03/09/04)
- Alter table alter column khanhbui (03/09/04)
- temp db indexing in SQL2k MSNews (03/09/04)
- Delete query simon (03/09/04)
- smalldate time column Jerry (03/09/04)
- Net Send Error Peter (03/09/04)
- auditing John A Grandy (03/09/04)
- Simplest way to select most recent value? Al Blake (03/09/04)
- Get SPID in Job Manfred Schopf (03/09/04)
- Get SPID in Job Manfred Schopf (03/09/04)
- How to force ANSI_NULLS ON for a user-defined function - AGAIN Boaz Ben-Porat (03/09/04)
- searching for unicode (japanese characters) PEACEMAKER (03/09/04)
- Aggregating by time period David F (03/09/04)
- Multiple Queries in a single line qAnand (03/09/04)
- multiple queries in a single line qAnand (03/09/04)
- Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) Vishal Parkar (03/09/04)
- Re: Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) oj (03/09/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/09/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/09/04)
- Re: Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/09/04)
- Re: Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/09/04)
- Re: Help with query (sorting and grouping fields) oj (03/09/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/09/04)
- Re: Help with query (sorting and grouping fields) Star (03/10/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/10/04)
- Re: Help with query (sorting and grouping fields) Star (03/10/04)
- Re: Help with query (sorting and grouping fields) Delbert Glass (03/10/04)
- Re: Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) oj (03/09/04)
- Re: Help with query (sorting and grouping fields) Star (03/09/04)
- Re: Help with query (sorting and grouping fields) Steve Kass (03/09/04)
- Re: Help with query (sorting and grouping fields) Vishal Parkar (03/09/04)
- Error trying to use computed column Alex (03/09/04)
- parsing the store procedure comma delimited parameter Jen (03/09/04)
- Row number in a query Miguel Ramirez (03/09/04)
- CASE with aggregate Alex (03/08/04)
- Does CharIndex have 8k problem? Bill (03/08/04)
- slow odbc between servers Guy Brom (03/08/04)
- Append Query to Another Database Robert Brown (03/08/04)
- Auto alert on database changes Ed (03/08/04)
- simple question re DELETEing in linked DB gerry (03/08/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/08/04)
- Re: simple question re DELETEing in linked DB gerry (03/09/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/09/04)
- Re: simple question re DELETEing in linked DB Uri Dimant (03/09/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/09/04)
- Re: simple question re DELETEing in linked DB gerry (03/09/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/09/04)
- Re: simple question re DELETEing in linked DB oj (03/09/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/09/04)
- Re: simple question re DELETEing in linked DB gerry (03/09/04)
- RE: simple question re DELETEing in linked DB Baisong Wei[MSFT] (03/15/04)
- Re: simple question re DELETEing in linked DB Steve Kass (03/08/04)
- Insert Trigger error Ron Hinds (03/08/04)
- Many-to-many question. imani_technology_spam_at_yahoo.com (03/08/04)
- Using UDF in a default constraint Michael MacGregor (03/08/04)
- DSN anonymous_at_coolgroups.com (03/08/04)
- Trim For Select Scott (03/08/04)
- Re: Question for Microsoft guys Nikerz Inc (03/08/04)
- build resultset in stored proc Steve (03/08/04)
- Error 7405 Merwin12 (03/08/04)
- Identity Setting for an Existing Column Kayode Yusuf (03/08/04)
- counting and grouping Bryan Harrington (03/08/04)
- how to use charindex and substring SQL Apprentice (03/08/04)
- incrementing a unique value and returning it J (03/08/04)
- Getting external data ODBC connect errors when connecting with Access bc (03/08/04)
- Applying the initial snapshot to a merge replicated subscriber Pete Ocasio (03/08/04)
- Query Question for the Gurus Dan (03/08/04)
- Re: Query Question for the Gurus Wayne Snyder (03/08/04)
- Re: Query Question for the Gurus Steve Kass (03/08/04)
- Re: Query Question for the Gurus David Browne (03/08/04)
- Re: Query Question for the Gurus David Browne (03/08/04)
- RE: Query Question for the Gurus Sarav (03/08/04)
- Re: Query Question for the Gurus Joe Celko (03/09/04)
- linked dBase tables Vilmos (03/08/04)
- using "case" in where clause TJS (03/08/04)
- SQLSERVERAGENT js (03/08/04)
- Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Prasad Koukuntla (03/08/04)
- Re: Output and return from stored procedure Armando (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Prasad Koukuntla (03/08/04)
- Re: Output and return from stored procedure Armando (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Armando (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Armando (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Armando (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Re: Output and return from stored procedure Ian (03/08/04)
- Remove Alpha Characters From Varchar Column Steve Beach (03/08/04)
- Cursor with dynamic SQL Anup (03/08/04)
- Re: Linked server from SQL Server to Access db on network share? Steve Thompson (03/08/04)
- Don't understand why select distinct so slow Marcus (03/08/04)
- Multirow Operations & Triggers JLS (03/08/04)
- .tab or .csv johnduran (03/08/04)
- J# and Yukon anonymous_at_discussions.microsoft.com (03/08/04)
- Best strategy on storing files on server NWx (03/08/04)
- Convert from Float to Varchar PaulaC (03/08/04)
- iif statement in a having(where) clause Stephen Matthews (03/08/04)
- One or many lookup tables Blake (03/08/04)
- Help with Query Mike (03/08/04)
- SQL statement Nikolami (03/08/04)
- INSERT TRIGER simon (03/08/04)
- General Network Error after database restore Boris Wehrle (03/08/04)
- sleep a few seconds toylet (03/08/04)
- Stored procedure help needed please (Group by and Sum) Stephen Cairns (03/08/04)
- ISA log table in nice format Stijn Verrept (03/08/04)
- Help with Query please - Pivot Matt (03/08/04)
- sql mail kriste (03/08/04)
- the "having" clause toylet (03/08/04)
- How to force ANSI_NULLS ON for a user-defined function Boaz Ben-Porat (03/08/04)
- Nested Cursors... Russ (03/08/04)
- DatePart Kjell Brandes (03/08/04)
- locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Roji. P. Thomas (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Uri Dimant (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Tibor Karaszi (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Uri Dimant (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Tibor Karaszi (03/08/04)
- Re: locking a record explicitly Uri Dimant (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly toylet (03/08/04)
- Re: locking a record explicitly Roji. P. Thomas (03/08/04)
- minimize database records Leon (03/08/04)
- OSQL Anand (03/08/04)
- How to check for duplicates Lasse (03/08/04)
- Data Insertion Problem Aimmee (03/08/04)
- Table Problem Brent (03/08/04)
- Re: Stored Proc Syntax Question Steve Kass (03/08/04)
- check variable for population shank (03/08/04)
- BULK INSERT (X) \ (03/08/04)
- MySQL UPDATE to equivalent TSQL statement DRM (03/07/04)
- MAT Calculation Rush (03/07/04)
- IF... ELSE shank (03/07/04)
- SET DATESTART Muhammed Fawzy (03/07/04)
- MS JDBC Bug Kim Albee (03/07/04)
- Help with String Functions Khurram Chaudhary (03/07/04)
- Error 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified shank (03/07/04)
- Re: Error 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified Jacco Schalkwijk (03/07/04)
- Re: Error 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified Anith Sen (03/07/04)
- Re: Error 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified Joe Celko (03/08/04)
- TEXT parameter in stored procedure Paulo Morgado [MVP] (03/07/04)
- insert word document to db caldera (03/07/04)
- LIKE, CONTAINS and Full Text Indexing michael (03/07/04)
- select... Dmitry Gorodetsky (03/07/04)
- Good Stored Procedure Tutorials Buzby (03/07/04)
- OUTPUT var in SP Guy Brom (03/07/04)
- Linked Server Dima (03/07/04)
- check constraint** RM (03/07/04)
- Re: datatype of PK ** RM (03/07/04)
- caculated field concept** RM (03/07/04)
- uniqueidentifier*** RM (03/07/04)
- filegrowth in database** RM (03/07/04)
- vc++ connect anonymous_at_coolgroups.com (03/07/04)
- Time Intervals MikeM (03/06/04)
- Dynamic Cursor in Stored Proc. Larry Pensil (03/06/04)
- sort CSharp \( ILM \) (03/06/04)
- if statement in select clause ben (03/06/04)
- RAND() in a TF Stephen J Bement (03/06/04)
- join to get all combinations Joe Ross (03/06/04)
- Slow Query Eyad (03/06/04)
- difference between stored proc and user defined functions dk (03/06/04)
- saving tables in MSDE Vic (03/06/04)
- Executing several batches Maryam Teimourian (03/06/04)
- Insert multiple csv files into a single sql table Paul (03/06/04)
- Re: syscacheobjects Maryam Teimourian (03/06/04)
- Add new records HartA (03/06/04)
- Re: Need help on trigger and Visual Studio .NET Srinivas Kanakapally [MSFT] (03/06/04)
- table structure question smk2 (03/06/04)
- simple UPDATE statement shank (03/05/04)
- MySQL anybody?? Pachy (03/05/04)
- use of xp_cmdshell anonymus (03/05/04)
- Sending HTML using xp_sendmail john Smith (03/05/04)
- Tool for comparing database object differences: chuck (03/05/04)
- 916: Server user '%.*ls' is not a valid SQL Server Error (03/05/04)
- $0.00 VS. NO amount Olivia (03/05/04)
- foxpro shank (03/05/04)
- Speciallized locking Andy (03/05/04)
- Field Encryption Will T (03/05/04)
- Isolation level, how to determine current level? Jim (03/05/04)
- connection slow at first common (03/05/04)
- Retrieve the stored procedure script with ADO.NET Bill (03/05/04)
- Design Question. Amy (03/05/04)
- How can I GROUP BY a full day? Dave (03/05/04)
- Dynamic SQL in Stored Procedure Helen Stein (03/05/04)
- check user exist? js (03/05/04)
- Selecting the Default Value for a Column Nathan Holmes (03/05/04)
- sending output to a file anonymus (03/05/04)
- Statement Help Tony (03/05/04)
- SP Execution Very Slow n S (03/05/04)
- Truncated adLongVarChar Craig M (03/05/04)
- Help with SP calling another SP Bob (03/05/04)
- customize getdate() function joe (03/05/04)
- sproc performance Andre (03/05/04)
- Problem merging two queries Tim Vernon (03/05/04)
- Problems with Getting a Date (range) Atley (03/05/04)
- restore using wildcard JT (03/05/04)
- DB maintenance plan action entry in SQL Server logs Quentin Ran (03/05/04)
- PL SQLSERVER 2000 execute cursoring ORACLE PL Raul Mendoza (03/05/04)
- Is it necessary to use RTRIM? Subodh123 (03/05/04)
- View with Grouped Data. Kev (03/05/04)
- Failure in sp_detach (even though success is reported) Mark Brittingham (03/05/04)
- ADO.begintrans locks the whole TABLE instead of ROW chantal (03/05/04)
- Re: Slow performance after restarting Tom Moreau (03/05/04)
- call user defined fuction using vb.net muiruri kamau (03/05/04)
- NET SEND through xp_cmdshell Michas Konstantinos (03/05/04)
- Error running stored procedure Bhupesh Saini (03/05/04)
- Web Browser Cell Back Ground Colour Doesn't Print Carl (03/05/04)
- Removing triggers Sam Moayedi (03/05/04)
- Functions Issue Michas Konstantinos (03/05/04)
- Select Statement - Please Help hngo01 (03/05/04)
- add user to public role Abhishek Srivastava (03/05/04)
- Newbie Question Jeremy Byrski (03/05/04)
- convert to rows challenge khanhbui (03/05/04)
- Using CASE statement Steve (03/05/04)
- Assign Users to a role Abhishek Srivastava (03/05/04)
- smalldatetime without time in MsSqul Server. Sang Leen (03/05/04)
- Live process to remind users Bjorn (03/05/04)
- Equivalent of LTRIM of Oracle Aimmee (03/05/04)
- Security Issue Stephen Cairns (03/05/04)
- Re: A non-deterministic or imprecise User-defined function - Why ? Jacco Schalkwijk (03/05/04)
- Error: 'already an object named x in the database' jamieuk (03/05/04)
- Cross database granting Chris Buys (03/05/04)
- How to add a database diagram by means of a script Abhishek Srivastava (03/05/04)
- Import + ActiveX (cross) \ (03/05/04)
- Cast and + problem Grace (03/05/04)
- Windows Login Name Michas Konstantinos (03/05/04)
- Date of Week problem David Sumlin (03/05/04)
- batch file to create database schema and procedures Abhishek Srivastava (03/05/04)
- String comparison using compatibility collations Elyo Ravuna (03/05/04)
- DB Restore Problem Falik Sher (03/05/04)
- How to check if database already exists Abhishek Srivastava (03/05/04)
- Application not showing up in Current Activity window in SQLEM Brad M. (03/05/04)
- CASE Statements Khurram Chaudhary (03/05/04)
- Generating a Who's Online list Brad M. (03/05/04)
- Counting Characters - a tip Thomas (03/05/04)
- Trimming a field value Jason T (03/05/04)
- Calculated columns in VIEW Alex (03/05/04)
- Complex calculated columns Alex (03/05/04)
- nested Insert Exec Bob (03/04/04)
- Strange Trigger Behavior MarkS (03/04/04)
- UDF Oddity Largo SQL Tools (03/04/04)
- Replication/synchronization in a SQL Server 2K db Oscar (03/04/04)
- Adding a record and returning the identity value?? Bruce Duncan (03/04/04)
- add user? js (03/04/04)
- Working with large string - over 8000 bytes RJE (03/04/04)
- DSN or DSNless connection? Vlad (03/04/04)
- looking for an experienced programmer to write a script AndrewM (03/04/04)
- Flag the second job not to run Shah (03/04/04)
- Count Records mj (03/04/04)
- Join working in access but not in sql-server - for me a "strange join" I need help in translating - thanks in advance Kim (03/04/04)
- Weird Update Trigger Problem John Palazzo (03/04/04)
- SELECT from two different servers Robert A. DiFrancesco (03/04/04)
- Converting a varchar value to an integer value... Brett (03/04/04)
- Trigger for audit log E Sullivan (03/04/04)
- Converting a Hex Number to Integer Value... Brett (03/04/04)
- SQL debugger doesn't work in some databases on same server as others that do work?? R Baker (03/04/04)
- Effect on cache for prepexec vs. prepare/execute Jean G. (03/04/04)
- replace JT (03/04/04)
- How to SET Variable from a Select SQLSTATE 42000 ERROR 107 Nicolas (03/04/04)
- BLOB info Pachy (03/04/04)
- Finding most recent record Mark (03/04/04)
- Any thoughts on how to do this? Jim Fusich (03/04/04)
- SELECT STATEMENT hngo01 (03/04/04)
- Q: How to efficiently connect to a database in ASP.NET for many queries... Sky (03/04/04)
- How to get a connection id for Connections Star (03/04/04)
- Must qualify User Defined Function with owner Boaz Ben-Porat (03/04/04)
- tricky stored procedure.. any ideas from SQL gurus? Dan Heskett (03/04/04)
- Yukon:Regress or progress - you decide Dr. StrangeLove (03/04/04)
- Re: Yukon:Regress or progress - you decide Adam Machanic (03/04/04)
- Re: Yukon:Regress or progress - you decide Dave (03/04/04)
- Re: Yukon:Regress or progress - you decide Delbert Glass (03/04/04)
- Re: Yukon:Regress or progress - you decide Joe Celko (03/04/04)
- Re: Yukon:Regress or progress - you decide Louis Davidson (03/04/04)
- Re: Yukon:Regress or progress - you decide Tibor Karaszi (03/05/04)
- Re: Yukon:Regress or progress - you decide Adam Machanic (03/05/04)
- Re: Yukon:Regress or progress - you decide Dr. StrangeLove (03/05/04)
- Re: Yukon:Regress or progress - you decide Adam Machanic (03/05/04)
- Re: Yukon:Regress or progress - you decide Dr. StrangeLove (03/05/04)
- Re: Yukon:Regress or progress - you decide Louis Davidson (03/04/04)
- SYSFOREIGNKEYS - need more info Heather Homeniuk (03/04/04)
- View to drop or not? Shaleen Chugh (03/04/04)
- T-SQL @@Identity Scott F (03/04/04)
- Sum (Subtotal) Across Fields Dawn (03/04/04)
- Visual Basic - Which edition Chris Strug (03/04/04)
- variable Mikalai Beliashou (03/04/04)
- Please help with this procedure Newsgroups (03/04/04)
- Recursive Query Vasanth (03/04/04)
- List of DB Users Eric D. (03/04/04)
- A question about Views Rob Meade (03/04/04)
- Re: A question about Views Brian Moran (03/04/04)
- Re: A question about Views Rob Meade (03/04/04)
- Re: A question about Views Karl Gram (03/04/04)
- Re: A question about Views Rob Meade (03/04/04)
- Re: A question about Views Joe Celko (03/04/04)
- Re: A question about Views Kirk Graves (03/04/04)
- Re: A question about Views Rob Meade (03/04/04)
- Re: A question about Views Kirk Graves (03/04/04)
- Re: A question about Views Tibor Karaszi (03/04/04)
- Re: A question about Views Joe Celko (03/04/04)
- Re: A question about Views Joe Celko (03/04/04)
- Re: A question about Views Kirk Graves (03/04/04)
- Re: A question about Views Rob Meade (03/04/04)
- Re: A question about Views Brian Moran (03/04/04)
- Funky order by ... TJ (03/04/04)
- Printing RG (03/04/04)
- complex sql question (stadistical) msnews.microsoft.com (03/04/04)
- Q: is there a 'BUT NOT' statement for Select statements? Sky (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Tibor Karaszi (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Sky (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Eric Sabine (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Tibor Karaszi (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Adam Machanic (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Sky (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Sky (03/04/04)
- Re: is there a 'BUT NOT' statement for Select statements? Tibor Karaszi (03/04/04)
- Q: About Replication. Sky (03/04/04)
- Query Between Dates Peter Newman (03/04/04)
- Stored Procedure query help patrick delifer (03/04/04)
- Store procedure receiving data type table paremeters Daniel Caetano (03/04/04)
- Faster way than 9 left joins?? NevH2001 (03/04/04)
- Preserving data after structure update NWx (03/04/04)
- table type - alter Stefan Turalski \(stic\) (03/04/04)
- i need a join Carlo (03/04/04)
- check if a table already exist? msnews.microsoft.com (03/04/04)
- debugging DTS custom task written in C#.NET Severian (03/04/04)
- Condition in select Mikalai Beliashou (03/04/04)
- Indexes and primary keys, from Delaney DW (03/04/04)
- Re: Indexes and primary keys, from Delaney DW (03/04/04)
- Re: Indexes and primary keys, from Delaney Uri Dimant (03/04/04)
- Re: Indexes and primary keys, from Delaney David Browne (03/04/04)
- Re: Indexes and primary keys, from Delaney Ray Higdon (03/04/04)
- Re: Indexes and primary keys, from Delaney Kalen Delaney (03/04/04)
- Create View on a Remote Database Tim M (03/04/04)
- Table Structure Khurram Chaudhary (03/04/04)
- Help Stored Procedure SQl Statement Bud Dean (03/04/04)
- Anyone can give me some advice? Utada P.W. SIU (03/04/04)
- ELSE UPDATE Alex Ting (03/04/04)
- disconnect after starting procedure execution? Subodh (03/04/04)
- Information Message Returned From SQL Server 2000 Pete (03/04/04)
- permissions for db role Hassan (03/04/04)
- DATE TIME FUNTIONS Carlos Lee (03/04/04)
- MSDTC error on Windows 2003 Gary (03/04/04)
- Case When Question... Yaheya Quazi (03/04/04)
- Dates Kevin Rickey (03/04/04)
- Connecting to MS SQL from Linux? george d lake (03/03/04)
- My guess is stored procedures Patrice (03/03/04)
- returning vars from one sp to another Lee (03/03/04)
- Export Data Query Lontae Jones (03/03/04)
- TEXTPTR param into extended stored procedure Vitaliy Rukhmakov (03/03/04)
- How to select just first item in a group abc_at_helloall.com (03/03/04)
- SQL statement question Leon Lien (03/03/04)
- Identifying rows in update trigger when primary key has been updated Ellis Horowitz (03/03/04)
- OpenQuery with Active Directory JI (03/03/04)
- Replication components were not included when SQL server was installed on 'sqlsrv1' Patrick (03/03/04)
- DateName Acts Weird Paul Muller (03/03/04)
- return table and count with sp_msforeachtable SQL Apprentice (03/03/04)
- UNION ALL JMNUSS (03/03/04)
- Recompile question Doug Fish (03/03/04)
- parse non-fixed field John Wilheim (03/03/04)
- Timeout Expired exception Guogang (03/03/04)
- Transactions Roll Back and Commit Aaron Bertrand [MVP] (03/03/04)
- #temp table scope and anomolies JT Lovell (03/03/04)
- getting data in triggers Scott Elgram (03/03/04)
- Cursors to Result Set Programming Chris (03/03/04)
- Re: Cursors to Result Set Programming Armando (03/03/04)
- Re: Cursors to Result Set Programming Jacco Schalkwijk (03/03/04)
- Re: Cursors to Result Set Programming oj (03/03/04)
- Cursors to Result Set Programming Chris (03/03/04)
- Re: Cursors to Result Set Programming Joe Celko (03/03/04)
- Re: Cursors to Result Set Programming lindawie (03/04/04)
- Re: Cursors to Result Set Programming Roji. P. Thomas (03/04/04)
- Re: Cursors to Result Set Programming Jacco Schalkwijk (03/04/04)
- Re: Cursors to Result Set Programming Roji. P. Thomas (03/04/04)
- Re: Cursors to Result Set Programming Joe Celko (03/04/04)
- Re: Cursors to Result Set Programming lindawie (03/04/04)
- Re: Cursors to Result Set Programming Joe Celko (03/04/04)
- Re: Cursors to Result Set Programming lindawie (03/04/04)
- Re: Cursors to Result Set Programming Roji. P. Thomas (03/05/04)
- Re: Cursors to Result Set Programming lindawie (03/05/04)
- Re: Cursors to Result Set Programming Joe Celko (03/03/04)
- Re: Cursors to Result Set Programming Joe Celko (03/03/04)
- Trigger Jeff (03/03/04)
- Is this update possible without using a cursor? Leo (03/03/04)
- Passing TABLE parameter Eric D. (03/03/04)
- dbnet issue accessing numeric fields Michael Julson (03/03/04)
- [Server].[dbname].[dbo].[tablname] alias Edward (03/03/04)
- Stored Procedure Advice needed, can you improve this? Russell Mangel (03/03/04)
- Re: Stored Procedure Advice needed, can you improve this? Anith Sen (03/03/04)
- RE: Stored Procedure Advice needed, can you improve this? Rohan (03/03/04)
- Re: Stored Procedure Advice needed, can you improve this? David Browne (03/03/04)
- Re: Stored Procedure Advice needed, can you improve this? Delbert Glass (03/03/04)
- Re: Stored Procedure Advice needed, can you improve this? Joe Celko (03/04/04)
- Simple select using calculated column Earl Teigrob (03/03/04)
- SQL and IIS brian (03/03/04)
- Starting Date of Week(Week Number Issue) Ben Arthur (03/03/04)
- Removing the IDENTITY property Jeff (03/03/04)
- Performance Creep David Anderson (03/03/04)
- Stored Procedure help patrick delifer (03/03/04)
- Maintain Identity Columns w/o DBO Zaphy Ryder (03/03/04)
- dateTime simon (03/03/04)
- Troubleshooting -2147217871 Timeout Errors Christopher Campbell (03/03/04)
- User-defined functions in where clause Jeff Langston (03/03/04)
- How can I handle a stored procedure whose parameter may be more than one value Sam (03/03/04)
- Re: How can I handle a stored procedure whose parameter may be more than one value Brian Lawton (03/03/04)
- Re: How can I handle a stored procedure whose parameter may be more than one value Roji. P. Thomas (03/03/04)
- Re: How can I handle a stored procedure whose parameter may be more than one value Armando (03/03/04)
- Re: How can I handle a stored procedure whose parameter may be more than one value Alejandro Mesa (03/03/04)
- Stored Procedures rob (03/03/04)
- More time series questions Brandon Lilly (03/03/04)
- RE: Error installing MSDE 2k Analysis services M K (03/03/04)
- Yukon and 2000 coexistance Terry Wilson (03/03/04)
- Modifying big files Microsoft (03/03/04)
- sql server Selen (03/03/04)
- Scripting Lots of Stored Procedures Dave K (03/03/04)
- Error when calling function dw (03/03/04)
- Bulk Insert error Mohan (03/03/04)
- HELP: STRING FUNCTION Carlos Lee (03/03/04)
- What's Wrong With This Table Name? Erin Peterson (03/03/04)
- Scheduled job question JOE (03/03/04)
- SQLServer Backup makes Server HUNG Klaus L Jensen (03/03/04)
- timestamp simon (03/03/04)
- SQLServer Backup! Klaus L Jensen (03/03/04)
- How to assign values to a TEXT datatype in SQL newbie (03/03/04)
- Compare Triggers/stored procs. Dolphin (03/03/04)
- error while executing this query Shaleen Chugh (03/03/04)
- lock a record with select statement Ganesh (03/03/04)
- Sum on subform warway (03/03/04)
- RE: Blocked remote calls with COM+ and MSDTC Piers Lawson (03/03/04)
- Beginner: alter table and update doesn´t work ... Christian Uhlig (03/03/04)
- Shutting down SQL RichK (03/03/04)
- Truncate table being referenced by a foriegn key Abhishek Srivastava (03/03/04)
- Re: Truncate table being referenced by a foriegn key Roji. P. Thomas (03/03/04)
- Re: Truncate table being referenced by a foriegn key Roji. P. Thomas (03/03/04)
- Re: Truncate table being referenced by a foriegn key Tibor Karaszi (03/03/04)
- Re: Truncate table being referenced by a foriegn key Uri Dimant (03/03/04)
- Testing Performance of Queries. Michas Konstantinos (03/03/04)
- Windows NT domain name Windows Domain Name (03/03/04)
- BULK IMPORT out? Duncan Welch (03/03/04)
- Mulitple MAX select Slai (03/03/04)
- Mulitple MAX select Slai (03/03/04)
- In addition to "Export data to Excel" anonymous_at_discussions.microsoft.com (03/03/04)
- Re: Updating with aggregate functions? Mark Hanford (03/03/04)
- Check Syntax Issue Michas Konstantinos (03/03/04)
- handling error on SQL Carlo (03/03/04)
- Error running sp_vupgrade_replication(1) Lasse Edsvik (03/03/04)
- tricky table modification simax (03/03/04)
- Thanks Joji Anand (03/03/04)
- getdate() Dmitri Shvetsov (03/03/04)
- Export data to Excel MR.T (03/03/04)
- Problem with full text search in space separated integer values Amit Srivastava (03/03/04)
- Many to many relationships (Design brain teaser) Tom Cole (03/03/04)
- SQL Query needed Anand (03/03/04)
- Re: Transactions Roll Back and Commit Greg Linwood (03/03/04)
- CrossTab SQL Anand (03/03/04)
- Use CASE Statement to bring in all records or a particular one Marco Napoli (03/03/04)
- Bulk Insert Error MikeO (03/03/04)
- SQL 2K -- Having Trouble Getting Three Field SUM bill b (03/03/04)
- SQL 2K - Trouble Getting the Sum of Three Fields bill b (03/03/04)
- UPDATE and SELECT Khurram Chaudhary (03/03/04)
- debug a sp eric (03/03/04)
- stored procedure problem Stanley (03/03/04)
- parameterized Stored Procedure culam (03/03/04)
- Help on Query Wayne Wengert (03/03/04)
- Capitalizing record values inside sql table for a given field J. Muenchbourg (03/03/04)
- clustered index scan!!!! tony (03/03/04)
- NetDDE problem - from a non-interactive session Diego Zeballos Fraigne (03/02/04)
- SQL web application fails at login. Need help. Miklos (03/02/04)
- Run Dinamic Querys Carlos Lee (03/02/04)
- Re: xp_cmdshell and vb programs and SQL Server 2000 Alex (03/02/04)
- Searching index server from SQL Server Tony Lorentzen (03/02/04)
- SQL Server-DTS Package M (03/02/04)
- Execute IF statement to return value with in a function Russ (03/02/04)
- please help me completing this sql statement Keyur (03/02/04)
- Insert generation utility paul reed (03/02/04)
- Determining What Objects have Changed paul reed (03/02/04)
- Error converting a text field to a datetime datatype, who can figure this anyone???? Sd (03/02/04)
- Clustered vs NonClustered Indexes Jim Sibley (03/02/04)
- Join Question Raterus (03/02/04)
- Re: Question on choosing primary key; real or arbitrary Eric Sabine (03/02/04)
- Clustered vs NonClustered Jim Sibley (03/02/04)
- Re: Clustered vs NonClustered Eric Sabine (03/02/04)
- Re: Clustered vs NonClustered Ray Higdon (03/03/04)
- Re: Clustered vs NonClustered Uri Dimant (03/03/04)
- Re: Clustered vs NonClustered Ray Higdon (03/03/04)
- Re: Clustered vs NonClustered Eric Sabine (03/03/04)
- Re: Clustered vs NonClustered Uri Dimant (03/03/04)
- Re: Clustered vs NonClustered Ray Higdon (03/04/04)
- Re: Clustered vs NonClustered Ray Higdon (03/04/04)
- Re: Clustered vs NonClustered Eric Sabine (03/04/04)
- Re: Clustered vs NonClustered Ray Higdon (03/03/04)
- Re: Clustered vs NonClustered Eric Sabine (03/02/04)
- Create columns in Select dw (03/02/04)
- calling sp problem Lee (03/02/04)
- Funky Error Darrick (03/02/04)
- can't compare a varchar properly using WHERE darrel (03/02/04)
- calling Stored Procedures from different DBs ZeBerg (03/02/04)
- Add multiple criteria in sum query Yaheya Quazi (03/02/04)
- An Update statement Ed (03/02/04)
- table join with itself milmus (03/02/04)
- Joing each byte of a field to another table...? Darrick (03/02/04)
- Re: Joing each byte of a field to another table...? Adam Machanic (03/02/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/02/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/02/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/02/04)
- Re: Joing each byte of a field to another table...? anonymous_at_discussions.microsoft.com (03/03/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/03/04)
- Re: Joing each byte of a field to another table...? Darrick (03/03/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/03/04)
- Re: Joing each byte of a field to another table...? Steve Kass (03/03/04)
- Re: Joing each byte of a field to another table...? Darrick (03/04/04)
- Re: Joing each byte of a field to another table...? Delbert Glass (03/02/04)