For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > August 2005









Pages: [1] 2 3 4 5 6 7 8

Posts(4)August 31, 2005, 9:57 pmBULK INSERT Query
Posts(4)August 31, 2005, 7:00 pmConvert/Cast from Varchar to decimal
Posts(14)August 31, 2005, 7:00 pmUsing alias in queries
Posts(3)August 31, 2005, 7:00 pmdate parameter in reporting services
Posts(3)August 31, 2005, 7:00 pmExecute dynamic generate SQL with length > 8000
Posts(4)August 31, 2005, 7:00 pmSQL Server EM Space Allocated Total/Used/Free
Posts(6)August 31, 2005, 7:00 pmNeed help with UNION statement
Posts(4)August 31, 2005, 7:00 pmchoice of column for clustered index
Posts(4)August 31, 2005, 7:00 pmGetdate Function
Posts(10)August 31, 2005, 7:00 pmCan Indexes LIve on another server?
Posts(2)August 31, 2005, 7:00 pmTempDB Space
Posts(1)August 31, 2005, 7:00 pmMAXDOP Deadlock
Posts(6)August 31, 2005, 7:00 pmHow to determine if data imported into database table
Posts(3)August 31, 2005, 7:00 pmSimply the query
Posts(3)August 31, 2005, 7:00 pmrecordset open?
Posts(3)August 31, 2005, 7:00 pmGenerate Cross tab temp table
Posts(4)August 31, 2005, 7:00 pmPerformance problems ADODB connection
Posts(17)August 31, 2005, 7:00 pmsorting columns with blanks
Posts(5)August 31, 2005, 7:00 pmHelp please IN Select for SP
Posts(2)August 31, 2005, 7:00 pmCursor or Several Stored Procs
Posts(6)August 31, 2005, 7:00 pmNewbie Entity Relationship Advice
Posts(2)August 31, 2005, 7:00 pmStored Procedure Help
Posts(2)August 31, 2005, 7:00 pmlooking for non similar orders
Posts(1)August 31, 2005, 7:00 pmRE: SQLXMLBulkLoad Provider problem after installing SQL Server 2000 S
Posts(1)August 31, 2005, 7:00 pmSQLXMLBulkLoad Provider problem after installing SQL Server 2000 SP3a and SP4
Posts(7)August 31, 2005, 7:00 pmconvert text to a table
Posts(5)August 31, 2005, 7:00 pmNo Trim Function?
Posts(5)August 31, 2005, 7:00 pmFloating point fun
Posts(4)August 31, 2005, 7:00 pmREPLACE function needed to remove single quotes from an output
Posts(4)August 31, 2005, 7:00 pmSelect Count of Null Values Per field?
Posts(2)August 31, 2005, 7:00 pmUser Dependant Tables
Posts(2)August 31, 2005, 7:00 pmlocal VARCHAR and memory allocation in SP
Posts(2)August 31, 2005, 7:00 pmDetermine SPID is using TempDB disk space
Posts(2)August 31, 2005, 7:00 pmI have a problem with update/insert in a table!
Posts(5)August 31, 2005, 7:00 pmSQL Query Help needed...!!!!
Posts(5)August 31, 2005, 7:00 pmMSDataShape vs Join statement
Posts(5)August 31, 2005, 7:00 pmDefault Parameters
Posts(7)August 31, 2005, 7:00 pmQuery Help
Posts(3)August 31, 2005, 7:00 pmsending output of a stored procedure into a temporary table
Posts(4)August 31, 2005, 7:57 amGetting it right ! - Enterprise manager
Posts(1)August 31, 2005, 7:57 amReport parameter - date format
Posts(5)August 31, 2005, 7:57 amHow to Saving Multiple ID in One Column
Posts(2)August 31, 2005, 7:57 amqueries longer than 5 mins
Posts(2)August 31, 2005, 7:57 amSelect Distinct on a single field
Posts(1)August 31, 2005, 7:57 am[OT] User-Defined string Functions Transact-SQL
Posts(1)August 31, 2005, 7:57 amFree Evaluation of Database Administration Software
Posts(3)August 31, 2005, 7:57 amORDER BY calculated field
Posts(3)August 31, 2005, 7:57 amHelp With SQL statement
Posts(1)August 31, 2005, 7:57 amLarge INSERT SQL Server 2000/C#
Posts(1)August 31, 2005, 7:57 amSQL Error - Database Component Corrupt
Posts(5)August 31, 2005, 3:59 amHow To Dynamically Pull Stored Procedure Arguments
Posts(4)August 31, 2005, 3:59 amDynamic Order By Clause
Posts(2)August 31, 2005, 3:59 amNeed help with SQL statement
Posts(3)August 31, 2005, 3:59 amSQL Script Question
Posts(1)August 31, 2005, 3:59 amInserting data in excell file with multiple sheets
Posts(2)August 30, 2005, 9:57 pmDeleting records
Posts(4)August 30, 2005, 7:03 pmData Dictionary
Posts(5)August 30, 2005, 7:03 pmq
Posts(4)August 30, 2005, 7:03 pmDynamic Where clause
Posts(8)August 30, 2005, 7:03 pmChange default value
Posts(7)August 30, 2005, 7:03 pmNULL Comparison
Posts(13)August 30, 2005, 7:03 pmPlease assist with a query...
Posts(4)August 30, 2005, 7:03 pmDBCC DBREINDEX
Posts(4)August 30, 2005, 7:03 pmNeed to get a date diff between rows
Posts(6)August 30, 2005, 7:03 pmHow to update tables that are not directly related
Posts(7)August 30, 2005, 7:03 pmShrinking the Transaction Log permission
Posts(6)August 30, 2005, 7:03 pmdistinct data in one column
Posts(2)August 30, 2005, 7:02 pmDTSRUN is it available in SQL Server 64-bit
Posts(2)August 30, 2005, 7:02 pmQuestion on repeated query
Posts(9)August 30, 2005, 7:02 pmStored procedures in an n-tiered environment.
Posts(2)August 30, 2005, 7:02 pmScript Stored Procedures based on dependency
Posts(2)August 30, 2005, 7:02 pmHow to change free space?
Posts(3)August 30, 2005, 7:02 pmLEFT OUTER JOIN Question
Posts(3)August 30, 2005, 7:02 pmxp_cmdshell and bcp issue
Posts(6)August 30, 2005, 7:02 pmInsert Question.
Posts(3)August 30, 2005, 7:02 pmTo join or not to join
Posts(4)August 30, 2005, 7:02 pmHow to Send an Email with T-SQL?
Posts(3)August 30, 2005, 7:02 pmencrypt/ decrypt fields or VB function "StrReverse".
Posts(6)August 30, 2005, 7:02 pmReformatting numeric value to zero-filled string
Posts(4)August 30, 2005, 7:02 pmNeed help with SELECT statement please.
Posts(3)August 30, 2005, 7:02 pmRemove identity property of a primary key
Posts(4)August 30, 2005, 7:02 pmset a trace for a specific error
Posts(5)August 30, 2005, 7:02 pmKill a process
Posts(5)August 30, 2005, 7:02 pmMS SQL(2000) table export to excel
Posts(3)August 30, 2005, 7:02 pmWild Card Search
Posts(4)August 30, 2005, 7:02 pmTurning "read-only" off through TSQL script?
Posts(3)August 30, 2005, 7:02 pmquery syntax help
Posts(6)August 30, 2005, 7:02 pmIs this right?
Posts(8)August 30, 2005, 7:02 pmSQL DELETE Follow-Up Question
Posts(6)August 30, 2005, 7:02 pmProblem with stored procedure
Posts(5)August 30, 2005, 7:02 pmSelect Query
Posts(4)August 30, 2005, 7:02 pmUser Defined Data Types in Table Variables
Posts(7)August 30, 2005, 7:58 amSet parameter inside SELECT stored procedure
Posts(2)August 30, 2005, 7:58 amRe: Replication problem(integrity violation) - Cannot Sync up emul
Posts(6)August 30, 2005, 7:58 amClustered Index on Date Field or Identity Field ....
Posts(7)August 30, 2005, 7:58 amoracle's UTL_FILE in SQL server????
Posts(4)August 30, 2005, 7:58 amView access
Posts(5)August 30, 2005, 7:58 amQuickly accessing data from SQL server
Posts(13)August 30, 2005, 7:58 amTroubles pulling binary data into VBScript
Posts(3)August 30, 2005, 3:57 amStep-by-step document for...
Posts(12)August 30, 2005, 3:57 amHelp with trigger
Posts(4)August 30, 2005, 3:57 amFilter Out Duplicate Records
Posts(4)August 30, 2005, 3:57 ambasic trigger ?
Posts(13)August 30, 2005, 3:57 amMultiple select statment inside a stored procedure
Posts(4)August 30, 2005, 3:57 amWeird Result....
Posts(9)August 29, 2005, 9:57 pmSum Value incorrect
Posts(1)August 29, 2005, 9:57 pmRe: Replication problem(integrity violation) - Cannot Sync up emulator
Posts(1)August 29, 2005, 9:57 pmCollaborative Data Objects (CDO)/SQL/HTML Question
Posts(3)August 29, 2005, 9:57 pmJoin / Update Based on Max(Date)
Posts(4)August 29, 2005, 7:03 pmStored Procedure with concatenation
Posts(6)August 29, 2005, 7:03 pmDistributed transaction error
Posts(4)August 29, 2005, 7:03 pmRestoring data from another database
Posts(4)August 29, 2005, 7:03 pmUpdating a view from ADO.net
Posts(1)August 29, 2005, 7:03 pmUpdate from (join) question
Posts(3)August 29, 2005, 7:03 pmTrigger Question
Posts(2)August 29, 2005, 7:03 pmRE: Update from (join) question
Posts(1)August 29, 2005, 7:03 pmRE: xp_cmdshell and bcp issue
Posts(2)August 29, 2005, 7:03 pmxp_cmdshell and bcp issue
Posts(5)August 29, 2005, 7:03 pmbuilt-in functions - owner required? (newbie)
Posts(1)August 29, 2005, 7:03 pmHow to get Windows process id for sqlservr.exe?
Posts(4)August 29, 2005, 7:03 pmInteresting but apparently harmless bug in QA when using [TAB]
Posts(1)August 29, 2005, 7:03 pmCase Function - Please verify if this is correct
Posts(4)August 29, 2005, 7:03 pmIs this a bin packing problem?
Posts(6)August 29, 2005, 7:03 pmSQL DELETE Syntax
Posts(3)August 29, 2005, 7:03 pmCasing
Posts(5)August 29, 2005, 7:03 pmmacro substitution or command @var
Posts(5)August 29, 2005, 7:03 pmdrop constraint?
Posts(3)August 29, 2005, 7:03 pmSQL Query design tool
Posts(2)August 29, 2005, 7:03 pmSelecting orphaned records
Posts(4)August 29, 2005, 7:03 pmchanges to sp's
Posts(6)August 29, 2005, 7:03 pmPlease help with this SP
Posts(3)August 29, 2005, 7:03 pmQUESTION????????????
Posts(1)August 29, 2005, 7:03 pmRe: SQL reader issue - SOLVED
Posts(2)August 29, 2005, 7:03 pmuser functions and group by
Posts(6)August 29, 2005, 7:57 amdangerous or heavy queries faster in front of me
Posts(6)August 29, 2005, 7:57 amnewbie - Display rows with identical values
Posts(2)August 29, 2005, 7:57 amFREE Indian oil for men!
Posts(4)August 29, 2005, 7:57 amselect statement
Posts(1)August 29, 2005, 7:57 amHow I can copy object SMO between DB and servers?
Posts(6)August 29, 2005, 7:57 amstored procedure which inserts new rec and returns the id
Posts(6)August 29, 2005, 7:57 amSet-based Solution for This
Posts(3)August 29, 2005, 7:57 amHAS_DBACCESS for any user name
Posts(4)August 29, 2005, 7:57 amWrong week number!!
Posts(3)August 29, 2005, 3:57 amPlease Help!!!
Posts(3)August 29, 2005, 3:57 amAccess.adp & Stored Procedures
Posts(1)August 29, 2005, 3:57 amRE: Replication problem(integrity violation) - Cannot Sync up emulator
Posts(14)August 29, 2005, 3:57 amDangers of update statement
Posts(5)August 29, 2005, 3:57 amincrementing question
Posts(3)August 29, 2005, 3:57 amSQL stored procedure using LIKE
Posts(1)August 29, 2005, 3:57 amFREE Indian oil for men!
Posts(2)August 28, 2005, 9:57 pmDon't Know How To Explain It
Posts(4)August 28, 2005, 9:57 pmIs there a way to turn logging off for a single table?
Posts(1)August 28, 2005, 9:57 pmReplication problem(integrity violation) - Cannot Sync up emulator -HELP!!
Posts(3)August 28, 2005, 7:00 pmRe: Most efficient way to update/insert order details?!
Posts(4)August 28, 2005, 7:00 pmSQL ERROR - HELP
Posts(4)August 28, 2005, 7:00 pmRe: Most efficient way to update/insert order details?!
Posts(7)August 28, 2005, 7:00 pmincrement ID
Posts(5)August 28, 2005, 7:00 pmIs "Create FUNCTION" a valid command in SQL 7?
Posts(3)August 28, 2005, 7:00 pmSP Recompile option
Posts(1)August 28, 2005, 7:00 pmRe: Most efficient way to update/insert order details?!
Posts(3)August 28, 2005, 7:00 pmQuery set up: Families & Family Members
Posts(2)August 28, 2005, 7:00 pmbcp and invalid character value set
Posts(5)August 28, 2005, 7:57 amFormat
Posts(6)August 28, 2005, 7:57 amModify stored proc (> 8000 chars) in a stored proc?
Posts(2)August 28, 2005, 3:57 amWhy have no perssion to recover
Posts(2)August 27, 2005, 7:00 pmSELECT statement of stock
Posts(2)August 27, 2005, 7:00 pmMax Function - But between a fixed value and a column
Posts(1)August 27, 2005, 7:00 pmNew bug in Access 2003 projects concerning Excel imports
Posts(2)August 27, 2005, 7:00 pmIncreasing the wealth of these newsgroups
Posts(2)August 27, 2005, 7:00 pmSQL AGENT EMail problem
Posts(2)August 27, 2005, 7:00 pmFunction Performance question
Posts(5)August 27, 2005, 7:00 pmSET OF INT
Posts(2)August 27, 2005, 7:00 pm'Login failed for user' on subsequent saves
Posts(2)August 27, 2005, 7:00 pmSeemingly inaccurate COUNT(*)
Posts(6)August 27, 2005, 7:00 pmStartup Parameter
Posts(13)August 27, 2005, 7:57 amTime Difference Calculations
Posts(4)August 27, 2005, 7:57 ambad query executionplan
Posts(6)August 27, 2005, 3:57 amSUM
Posts(2)August 27, 2005, 3:57 amsql server desktop engine and sql server graphic tools
Posts(3)August 27, 2005, 3:57 amSyntax Error
Posts(1)August 27, 2005, 3:57 amRe: Problem with Create Index...
Posts(3)August 26, 2005, 9:57 pmWorking out whats actually happening.
Posts(10)August 26, 2005, 9:57 pmCustomers & Phones
Posts(3)August 26, 2005, 9:57 pmtemp table
Posts(4)August 26, 2005, 7:01 pmMerge apparent duplcate rows into 1 row?
Posts(4)August 26, 2005, 7:01 pmJoining to Derived Tables
Posts(6)August 26, 2005, 7:01 pmUpload/Download to/from a SQL db.
Posts(3)August 26, 2005, 7:01 pmRE: Help..I'm being thrown under the bus...
Posts(9)August 26, 2005, 7:01 pmcan a view of a table imrpove table input performance?
Posts(22)August 26, 2005, 7:01 pmcompute diffrence
Posts(4)August 26, 2005, 7:01 pmLEFT JOINS MULTIPLE TABLE SYNTAX PROBLEMS SQL SERVER 2000
Posts(4)August 26, 2005, 7:01 pmSQL reader issue
Posts(1)August 26, 2005, 7:01 pmRE: Problem with Create Index...
Posts(1)August 26, 2005, 7:01 pmRE: posting 20050826
Posts(2)August 26, 2005, 7:01 pmvalidate nvarchar as integer
Posts(1)August 26, 2005, 7:01 pmRe: Help..I'm being thrown under the bus...
Posts(1)August 26, 2005, 7:01 pmRe: Help..I'm being thrown under the bus...
Posts(1)August 26, 2005, 7:01 pmRe: Help..I'm being thrown under the bus...
Posts(9)August 26, 2005, 7:01 pmNON-DETERMINISTIC?
Posts(1)August 26, 2005, 7:01 pmError deleting using a temp table and a linked server



Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com