For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > May 2005









Pages: 1 2 3 4 [5] 6 7

Posts(10)May 13, 2005, 4:24 pmUsing Cursor variable in dynamic T Sql
Posts(1)May 13, 2005, 4:24 pmRe: UPDATE SET.... ORDER BY? Help!
Posts(10)May 13, 2005, 4:24 pmInvalid buffer received from client.
Posts(5)May 13, 2005, 4:24 pmUPDATE SET.... ORDER BY? Help!
Posts(2)May 13, 2005, 4:24 pmTestCases on Stored procedures
Posts(2)May 13, 2005, 4:24 pmsplit accumulated count into individual record
Posts(3)May 13, 2005, 4:24 pmHelp with a query.
Posts(3)May 13, 2005, 4:24 pmDate Conversion!
Posts(2)May 13, 2005, 4:24 pmxpsql.cpp: Error 87 from LogonUserW on line 260 using xp_cmdshell
Posts(2)May 13, 2005, 4:24 pmSQL Server SP4
Posts(1)May 13, 2005, 4:24 pmRe: Jesus said, "I am the way, the truth and the life: no one can come to the Fa
Posts(2)May 13, 2005, 4:24 pmgetting 100 rows with values from 1 - 100
Posts(7)May 13, 2005, 4:24 pmNaming convention
Posts(5)May 13, 2005, 4:24 pmHow to pull data from stored procedure
Posts(6)May 13, 2005, 4:24 pmSelect Latest visit for each user....
Posts(1)May 13, 2005, 4:24 pmWebDevelpers Needed!
Posts(1)May 13, 2005, 4:24 pmWebDevelpers Needed!
Posts(12)May 13, 2005, 4:24 pmConstraint Question when referencing a Parent-child structured table
Posts(6)May 13, 2005, 4:24 pmcompare text fields
Posts(6)May 13, 2005, 4:24 pmPRIMARY key?
Posts(12)May 13, 2005, 4:24 pmcomparing text fields - Second try
Posts(7)May 13, 2005, 4:24 pmHow to report possible bugs for Yukon
Posts(2)May 13, 2005, 4:24 pmINDEX WITH MORE THAN 16 FIELDS
Posts(7)May 13, 2005, 4:24 pmfinding null in a computed column
Posts(7)May 13, 2005, 4:24 pmPrimary Key Violation
Posts(2)May 13, 2005, 4:24 pmRe: Jesus said, "I am the way, the truth and the life: no one can
Posts(4)May 13, 2005, 4:24 pmGrouping by Time
Posts(1)May 13, 2005, 4:24 pmRe: Jesus said, "I am the way, the truth and the life: no one can come to the Fa
Posts(6)May 13, 2005, 4:24 pmWHILE (skip with 0 records)
Posts(4)May 13, 2005, 4:24 pmsimulating boolean datatype with User-defined data types
Posts(4)May 13, 2005, 4:23 pmCompiling ideas about security
Posts(11)May 13, 2005, 4:23 pmPerformance Q
Posts(1)May 12, 2005, 2:40 amHelp....dbf to sql Migration
Posts(2)May 11, 2005, 4:04 pmHow to move Distributor to another server
Posts(1)May 11, 2005, 4:04 pmRe: Jesus said, "I am the way, the truth and the life: no one can come to the Fa
Posts(5)May 11, 2005, 4:04 pmhow to find a substring in a string
Posts(2)May 11, 2005, 4:04 pmHow to convert binary or hexa to decimal?
Posts(2)May 11, 2005, 4:04 pmTrigger Help Please
Posts(28)May 11, 2005, 4:04 pmDenormalizing Many-To-Many Relations
Posts(4)May 11, 2005, 4:04 pmSPID Growth of TempDB
Posts(2)May 11, 2005, 4:04 pmDBCC Results into a Table Brings Errors!
Posts(4)May 11, 2005, 4:04 pmOrder by question
Posts(1)May 11, 2005, 4:04 pmExcessive READS during SP_CURSORFETCH w/Dynamic Cursors
Posts(4)May 11, 2005, 4:04 pmDTS package
Posts(5)May 11, 2005, 4:04 pmHow can I return RowCount of Dymanic Table from SP - URGENT !!
Posts(3)May 11, 2005, 4:04 pmStored procedure Saving Method
Posts(2)May 11, 2005, 4:04 pmTestcases on storedprocedures
Posts(4)May 11, 2005, 4:04 pmHow to join based on max value in join table ?
Posts(5)May 11, 2005, 4:04 pmDateDiff calculating ages incorrectly.
Posts(6)May 11, 2005, 4:04 pmcreate table from output of select sql
Posts(2)May 11, 2005, 4:04 pmDid I get current source code?
Posts(10)May 11, 2005, 4:04 pmNatural Sorting order
Posts(3)May 11, 2005, 4:04 pmxp_shell with msde
Posts(3)May 11, 2005, 4:04 pm**Restoring a db with size 167049KB**
Posts(9)May 11, 2005, 4:04 pmundo sql
Posts(3)May 11, 2005, 4:04 pmUser-defined property
Posts(8)May 11, 2005, 4:04 pmHelp with Stored procedure
Posts(4)May 11, 2005, 8:59 amusing a SP in a VIEW
Posts(3)May 11, 2005, 8:59 amLinked Server error
Posts(4)May 11, 2005, 8:59 amWHERE Clause in UNION Query
Posts(2)May 11, 2005, 8:59 amUpdate a recordset when opened using a stored procedure in ADO
Posts(4)May 11, 2005, 8:59 am**Restoring just the data part of a DB **
Posts(3)May 11, 2005, 8:59 amCreating temp table in SP - what about indexes ?
Posts(4)May 11, 2005, 8:59 amfind all triggers
Posts(4)May 11, 2005, 4:02 amInserting a dataset into an sql table
Posts(4)May 11, 2005, 4:02 amcode last day of month
Posts(4)May 11, 2005, 4:02 amHow to make the Inner Remote Join work?
Posts(3)May 11, 2005, 4:02 ambcp command
Posts(3)May 11, 2005, 4:02 amScript Help
Posts(1)May 11, 2005, 4:02 amAbout supported by Provider Microsoft.Jet.Oledb.4.0
Posts(1)May 11, 2005, 4:02 ammoving data
Posts(4)May 10, 2005, 9:00 pmxp_Sendmail formatting issue
Posts(4)May 10, 2005, 9:00 pmHow to do these joins
Posts(12)May 10, 2005, 9:00 pmCreating tables from ASP.
Posts(2)May 10, 2005, 9:00 pmHelp with SQLH2!!!
Posts(6)May 10, 2005, 9:00 pmPls help. Cannot index the view...It contains one or more disallowed constructs
Posts(2)May 10, 2005, 9:00 pmRSS & ATOM Database Schema?
Posts(4)May 10, 2005, 9:00 pmSelf Join result sets
Posts(3)May 10, 2005, 9:00 pmcan i make optional OUTPUT paramater?
Posts(7)May 10, 2005, 9:00 pmSelect Statement logic problem
Posts(6)May 10, 2005, 9:00 pmsilly question, sorry
Posts(2)May 10, 2005, 9:00 pmstored procedure debugging
Posts(3)May 10, 2005, 4:02 pmMake XACT_ABORT persist?
Posts(8)May 10, 2005, 4:02 pmIdentifying SPs NOT in another DB
Posts(4)May 10, 2005, 4:02 pmMax in select clause
Posts(2)May 10, 2005, 4:02 pmDisplay only record per member reflecting the last History item
Posts(13)May 10, 2005, 4:02 pmsimple question?
Posts(6)May 10, 2005, 4:02 pminserting new data into an sql table
Posts(8)May 10, 2005, 4:02 pmSP & Progress Bar
Posts(7)May 10, 2005, 4:02 pmdata with apostrophe in it
Posts(3)May 10, 2005, 4:02 pmdate subtraction
Posts(2)May 10, 2005, 4:02 pmGET STORED PROCEDURE RESULT SET TO TEMP TABLE
Posts(16)May 10, 2005, 4:02 pmIF @paramter <> something
Posts(7)May 10, 2005, 4:02 pmFinding null values in left join...
Posts(1)May 10, 2005, 4:02 pmProblems with OLE headers for images (bmp)
Posts(2)May 10, 2005, 4:02 pmGET STORED PROCEDURE RESULT SET TO TEMP TABLE
Posts(2)May 10, 2005, 4:02 pmHow to use cartesian join to get multiple records
Posts(7)May 10, 2005, 4:02 pmconcatenating sql fields and parameters
Posts(1)May 10, 2005, 4:02 pmStatement(s) could not be prepared (Msg 8180)
Posts(7)May 10, 2005, 4:02 pmQuery Help!!
Posts(6)May 10, 2005, 4:02 pmRow and set based ?
Posts(3)May 10, 2005, 4:02 pmTrim: Access->SQL Server
Posts(1)May 10, 2005, 4:02 pmRe: Access->SQL Server
Posts(1)May 10, 2005, 4:02 pmRe: Access->SQL Server
Posts(7)May 10, 2005, 4:02 pmSQL & EXCEL...
Posts(5)May 10, 2005, 4:02 pmCan SQL do this ?
Posts(14)May 10, 2005, 4:02 pmCalculation for FIFO
Posts(5)May 10, 2005, 4:02 pmWays of to reckon how many bytes save on
Posts(8)May 10, 2005, 4:02 pmSQL else if statement
Posts(8)May 10, 2005, 4:02 pmQuery help : Better schema this time (I think)
Posts(2)May 10, 2005, 4:02 pmCollation issue
Posts(5)May 10, 2005, 4:02 pmInserting records that don't already exist
Posts(5)May 10, 2005, 4:02 pmDatabase concurrency
Posts(1)May 10, 2005, 4:02 pmRe: Views: Internal SQL Server error, Msg 8624, Level 16, State 13
Posts(3)May 10, 2005, 4:02 pmOuter Join?
Posts(2)May 10, 2005, 4:01 pmsql server remote connection
Posts(3)May 10, 2005, 4:01 pmview - merge datarows to one row..?
Posts(1)May 10, 2005, 8:59 amsql server remote connection
Posts(2)May 10, 2005, 8:59 amsql server remote connection
Posts(2)May 10, 2005, 8:59 amNew stored procedure call
Posts(5)May 10, 2005, 8:59 amViews: Internal SQL Server error, Msg 8624, Level 16, State 13, Li
Posts(2)May 10, 2005, 8:59 amINNER JOIN
Posts(4)May 10, 2005, 8:59 amStored procedures call
Posts(8)May 10, 2005, 8:59 amIs not Null clause not working for me
Posts(1)May 10, 2005, 8:59 amStored procedures call
Posts(4)May 10, 2005, 8:59 amStored Procedure parameters
Posts(11)May 10, 2005, 8:59 amHelp in Query
Posts(1)May 10, 2005, 8:59 amTest cases.
Posts(11)May 10, 2005, 8:59 amString value passed instead of smallint to stored procedure
Posts(1)May 10, 2005, 8:59 amRe: Count is different on same table? Datetime column error?
Posts(2)May 10, 2005, 8:59 amQuestion on SP_MakeWebTask
Posts(6)May 10, 2005, 8:59 amSelect statement
Posts(3)May 10, 2005, 8:59 amCan I change SQL Server name??
Posts(2)May 10, 2005, 8:59 amDTS help - using look ups
Posts(1)May 10, 2005, 8:59 amRE: The operation could not be performed because the OLE DB provider '
Posts(2)May 10, 2005, 8:59 amPorts
Posts(5)May 10, 2005, 8:59 amsql to change from rows to columns
Posts(3)May 10, 2005, 8:59 amWriting triggers for updating across databases on different servers.
Posts(1)May 10, 2005, 8:59 amRE: Writing triggers for updating across databases on different server
Posts(1)May 10, 2005, 4:03 amThe operation could not be performed because the OLE DB provider 'SQLOLEDB' was unabl
Posts(9)May 10, 2005, 4:03 amUpdate Query Question
Posts(2)May 10, 2005, 4:03 amHow many Jobs ran on a particular database yesterday
Posts(4)May 10, 2005, 4:03 amModeling a Matrix
Posts(4)May 10, 2005, 4:03 amneed help with a sql view
Posts(3)May 10, 2005, 4:03 amqueries
Posts(8)May 10, 2005, 4:03 amContraints
Posts(9)May 10, 2005, 4:03 amChoosing Lesser of Evils
Posts(6)May 9, 2005, 9:00 pmCursor Loop
Posts(6)May 9, 2005, 9:00 pmquery performance
Posts(15)May 9, 2005, 9:00 pmquery
Posts(5)May 9, 2005, 9:00 pmOne parameter too many
Posts(2)May 9, 2005, 9:00 pmStored Procedures and OPENROWSET?
Posts(5)May 9, 2005, 9:00 pmtable spool
Posts(8)May 9, 2005, 9:00 pmregconize update or insert in trigger
Posts(2)May 9, 2005, 9:00 pmUsing Variable in OpenRowSet
Posts(6)May 9, 2005, 9:00 pmStored Procedure executing Trigger failure
Posts(2)May 9, 2005, 9:00 pmhow to config server as a Distributor
Posts(3)May 9, 2005, 9:00 pmNeed help with BCP
Posts(1)May 9, 2005, 9:00 pmRe: Error : "Parallel worker query thread was involved in a deadlo
Posts(3)May 9, 2005, 9:00 pmError : "Parallel worker query thread was involved in a deadlock" in SQL Se
Posts(5)May 9, 2005, 4:02 pmChanging date and keeping time
Posts(5)May 9, 2005, 4:02 pmAcquire NTLM User ID within Trigger or Sproc?
Posts(13)May 9, 2005, 4:02 pmsynchronization
Posts(4)May 9, 2005, 4:02 pmbogus VM error message with Upgrade Wizard
Posts(5)May 9, 2005, 4:02 pmhow many field is rational in one table
Posts(8)May 9, 2005, 4:02 pmtemporary Table
Posts(12)May 9, 2005, 4:02 pmCould not figure out the profiler meaning for SP
Posts(7)May 9, 2005, 4:02 pmselect mycolum from @tablename ??
Posts(4)May 9, 2005, 4:02 pmHow use CRecordset with Rollback?
Posts(3)May 9, 2005, 4:02 pmNewbie: stored procedure stops and exits prematurely
Posts(16)May 9, 2005, 4:02 pmBloated SQL Server 2000 database
Posts(5)May 9, 2005, 4:02 pmQuery Works in QA But not in Code
Posts(2)May 9, 2005, 4:02 pmcdosysmail to SMTP server authenticated with user & password
Posts(6)May 9, 2005, 4:02 pmStored Procedures in SQL Server 2000
Posts(6)May 9, 2005, 4:02 pmvarchar datatype
Posts(3)May 9, 2005, 4:02 pmWindows Authentication and VBScript
Posts(5)May 9, 2005, 2:43 pmSolved: Columns_Updated()
Posts(3)May 9, 2005, 9:00 amNested Stored Proc
Posts(8)May 9, 2005, 9:00 amCompare SP 's content ?
Posts(5)May 9, 2005, 9:00 amCopying from one field to another in the same row
Posts(5)May 9, 2005, 9:00 amRenaming the table
Posts(2)May 9, 2005, 9:00 amComplex Select statement advise needed please
Posts(8)May 9, 2005, 9:00 amReturning Value from stored procedure
Posts(10)May 9, 2005, 3:59 amneed help with fairly simple query
Posts(8)May 9, 2005, 3:59 amConstraint between sysusers table and a user defined table
Posts(3)May 9, 2005, 3:59 amHow do i do ?
Posts(2)May 9, 2005, 3:59 amHow to Run Maintenance Plan immediately?
Posts(6)May 9, 2005, 3:59 amGet first record of multiple
Posts(1)May 8, 2005, 8:58 pmUser-Defined string Functions Transact-SQL
Posts(2)May 8, 2005, 8:58 pmmaximum number of tables in a query (260) was exceeded
Posts(7)May 8, 2005, 3:59 pmDays falling in a certain period
Posts(4)May 8, 2005, 3:59 pmOUTER JOIN on more than two tables
Posts(6)May 8, 2005, 3:59 pmThe name of the disaster is EAV or... is it not?
Posts(8)May 8, 2005, 3:59 pmtest, compare for matching values
Posts(1)May 8, 2005, 3:59 pmRe: INSERT only time in datetime-field
Posts(7)May 8, 2005, 3:59 pmExecute an Oracle procedure from SQL Server
Posts(1)May 8, 2005, 3:59 pmSQL: INSERT only time in datetime-field
Posts(1)May 8, 2005, 3:59 pmRe: INSERT only time in datetime-field
Posts(3)May 8, 2005, 8:57 amCursor With One Row Duped
Posts(4)May 8, 2005, 8:57 amrecursive trigger



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

Copyright 2009 codecomments.com