For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > October 2005









Pages: [1] 2 3 4 5 6 7

Posts(3)October 31, 2005, 9:57 pmTSQL help - Case?
Posts(4)October 31, 2005, 9:57 pmif else with WHERE
Posts(4)October 31, 2005, 9:57 pmCreating a date range during runtime in SELECT
Posts(1)October 31, 2005, 7:03 pmChat: The Visual Studio Debugger, November 3rd @ 1pm Pacific Time
Posts(6)October 31, 2005, 7:03 pmIdentifying row with duplicate column entry with different Primary
Posts(3)October 31, 2005, 7:03 pmSelecting the most recent date...
Posts(3)October 31, 2005, 7:03 pmChanging current database during local tx or xa tx
Posts(3)October 31, 2005, 7:03 pmNOT IN....
Posts(13)October 31, 2005, 7:03 pmwhy this date conversion?
Posts(4)October 31, 2005, 7:03 pmInformation Schema Query Question
Posts(4)October 31, 2005, 7:03 pmHow to View Transaction Log...
Posts(3)October 31, 2005, 7:03 pmquery to detemine trigger status
Posts(4)October 31, 2005, 7:03 pmNeed help determining occurences of a specific value
Posts(2)October 31, 2005, 7:03 pmhelp with indexes
Posts(3)October 31, 2005, 7:03 pmSQL system Procedure
Posts(3)October 31, 2005, 7:03 pmRe: Got err: There is already an object named '#TEMP' in the datab
Posts(1)October 31, 2005, 7:03 pmADOX Datatypes confused
Posts(3)October 31, 2005, 7:03 pmAssigning permissions to a table
Posts(2)October 31, 2005, 7:03 pmSQL server character type
Posts(4)October 31, 2005, 7:03 pmQuery a pricelist for price breaks
Posts(5)October 31, 2005, 7:03 pmMost efficient way to poll a table?
Posts(2)October 31, 2005, 7:03 pmBCP/Bulk Insert and Incoming Dates
Posts(2)October 31, 2005, 7:03 pmHow can I optimize this routine
Posts(11)October 31, 2005, 7:03 pmHAVING vs. WHERE
Posts(2)October 31, 2005, 7:03 pmConditional join
Posts(2)October 31, 2005, 7:03 pmT-SQL statement performing quicker than same statement in sproc
Posts(4)October 31, 2005, 7:03 pmNull Column Question
Posts(7)October 31, 2005, 7:03 pmDate/Time formatting
Posts(3)October 31, 2005, 7:03 pmDatabase Security Question - Can this be done?
Posts(3)October 31, 2005, 7:03 pmHow can wrap a case statement around us
Posts(4)October 31, 2005, 7:03 pmsplitting names
Posts(4)October 31, 2005, 7:03 pmuser Associated with a pid
Posts(5)October 31, 2005, 7:03 pmDoubt aboult loop in trigger?
Posts(1)October 31, 2005, 7:03 pmTroubleshooting stored proc performance heisenbug
Posts(4)October 31, 2005, 7:58 amfind missing numbers in a continuous serie
Posts(6)October 31, 2005, 7:58 amWhere to find Unique Value indic of index in sys tables
Posts(7)October 31, 2005, 7:58 amNeed assistance
Posts(1)October 31, 2005, 7:58 amAnda anda,,, me debes una, tu amiga Lydia 58F0
Posts(8)October 31, 2005, 3:57 amsp causing fatal exception
Posts(12)October 31, 2005, 3:57 amTime zones
Posts(4)October 31, 2005, 3:57 amConnection Broken
Posts(4)October 31, 2005, 3:57 amremove duplicate row
Posts(2)October 31, 2005, 3:57 amVersion and SP
Posts(8)October 31, 2005, 3:57 amEditing Data
Posts(2)October 31, 2005, 3:57 amRe: Trasaction in trigger?
Posts(4)October 30, 2005, 9:59 pmETL Tools for EDI to DB Import
Posts(10)October 30, 2005, 9:59 pmDisable Trigger rules
Posts(3)October 30, 2005, 7:01 pmWhere to get Query Analyzer SP3
Posts(13)October 30, 2005, 7:01 pmAnother Newb SQL Question
Posts(3)October 30, 2005, 7:01 pmAggregate Problem
Posts(2)October 30, 2005, 7:01 pmFormat number with 2 decimal places
Posts(6)October 30, 2005, 7:01 pmset @var = (exec stored proc)
Posts(7)October 30, 2005, 7:01 pmHow to find a string?
Posts(4)October 30, 2005, 7:01 pmTrbasaction in trigger?
Posts(3)October 30, 2005, 7:01 pmTrigger rule problem
Posts(2)October 30, 2005, 7:01 pmPercentage calculation in SQL Server
Posts(10)October 30, 2005, 7:01 pmImproving Joins
Posts(2)October 30, 2005, 7:57 amRe: [ODBC SQL Server Driver][SQL Server]Transaction (Process ID X) was deadlocked
Posts(4)October 30, 2005, 7:57 amComputed field with a maximum
Posts(2)October 30, 2005, 7:57 amCheck constraints
Posts(2)October 30, 2005, 7:57 amstored procedure hangs
Posts(2)October 30, 2005, 7:57 am[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID X) was deadloc
Posts(3)October 30, 2005, 7:57 amFinding the latest datetime from SP
Posts(11)October 30, 2005, 3:57 amhelp with Check contraints
Posts(15)October 29, 2005, 7:03 pmunique but allow nulls
Posts(5)October 29, 2005, 7:03 pmPreventing Extended Properties
Posts(4)October 29, 2005, 7:03 pmunique constraint to a column from another table
Posts(2)October 29, 2005, 7:03 pmStored Procedure Variables
Posts(8)October 29, 2005, 7:03 pmModify Multiple Stored Procedures
Posts(18)October 29, 2005, 7:03 pmNaming of temporary tables fro sessions
Posts(7)October 29, 2005, 7:03 pmSyntax Problem
Posts(2)October 29, 2005, 7:03 pmDatabase backup from ADP application
Posts(2)October 29, 2005, 7:57 amQuestion
Posts(6)October 29, 2005, 7:57 amDTS problem
Posts(3)October 29, 2005, 7:57 amerror handling and logging within a trigger - how much of this would work / would be
Posts(6)October 29, 2005, 7:57 amweek number within the month
Posts(2)October 29, 2005, 7:57 amPivoting a one-many relationship into 1 row
Posts(4)October 29, 2005, 4:00 amNeed help with the sequel statement please.
Posts(2)October 28, 2005, 9:57 pmRetrieving Login Name?
Posts(2)October 28, 2005, 7:03 pmBCP Help - Incorrect host-column number found in BCP format-file
Posts(5)October 28, 2005, 7:03 pmhow can i pass dataset to stored procedure
Posts(5)October 28, 2005, 7:03 pmHelp tranlating values and Nulls
Posts(4)October 28, 2005, 7:03 pmLOCK & SELECT Behavior
Posts(4)October 28, 2005, 7:03 pmGot err: There is already an object named '#TEMP' in the database.
Posts(1)October 28, 2005, 7:03 pmSQL 7.0 and VS.NET 2005
Posts(3)October 28, 2005, 7:03 pmrestructure on query
Posts(26)October 28, 2005, 7:03 pmString truncation
Posts(7)October 28, 2005, 7:03 pmORDER BY in UNION
Posts(3)October 28, 2005, 7:03 pmdisplaying found duplicate - both records
Posts(6)October 28, 2005, 7:03 pmScript out "Trigger rules"
Posts(3)October 28, 2005, 7:03 pmHelp with Case Statement
Posts(2)October 28, 2005, 7:03 pmHost_Name & IP address
Posts(9)October 28, 2005, 7:03 pmSort Help
Posts(3)October 28, 2005, 7:03 pmScripting data values
Posts(4)October 28, 2005, 7:03 pmCannot get to work a sentence with NULL results
Posts(1)October 28, 2005, 7:03 pmQuery DTS packages
Posts(7)October 28, 2005, 7:03 pmStored Procedure concurreny
Posts(1)October 28, 2005, 7:03 pmRe: newbie select and update thanks
Posts(1)October 28, 2005, 7:03 pmRe: How to detect SQL server edition
Posts(1)October 28, 2005, 7:03 pmRe: How to detect SQL server edition
Posts(4)October 28, 2005, 7:03 pmCannot register a server
Posts(3)October 28, 2005, 7:03 pmUrgent -- Access QRY to SQL Server QRY
Posts(3)October 28, 2005, 7:03 pmLogin not allowed to do bulkinsert?
Posts(5)October 28, 2005, 7:03 pmUpdate for random sampling featutre
Posts(4)October 28, 2005, 7:03 pmHow to Alter Column to Identity NOT FOR REPLICATION?
Posts(1)October 28, 2005, 7:03 pmARITHABORT problems
Posts(4)October 28, 2005, 7:59 amTimeout when IDataReader.Read()
Posts(2)October 28, 2005, 7:59 amthousand seperator problem
Posts(8)October 28, 2005, 7:59 amconstraint?
Posts(3)October 28, 2005, 7:59 amAbout FILEGROUP
Posts(6)October 28, 2005, 7:59 amComputing Dates
Posts(4)October 28, 2005, 7:59 amhelp with proc
Posts(4)October 28, 2005, 7:59 amSQL Query: Conditionally updating a column
Posts(2)October 28, 2005, 7:59 amHelp with SQL query
Posts(4)October 28, 2005, 7:59 amCursor for dynamic sql
Posts(3)October 28, 2005, 7:59 amHow to do an update only if it will not be blocked by a lock ?
Posts(5)October 28, 2005, 3:58 amCheck if Delete ran in a trigger
Posts(14)October 28, 2005, 3:58 amsORTING ACROSS MULTIPLE COLUMN
Posts(1)October 28, 2005, 3:58 amConnection error "databse foodmart 2000 does not exist."
Posts(2)October 28, 2005, 3:58 amConcept for View
Posts(4)October 28, 2005, 3:58 amDataTypeEnum problem with datetime data type
Posts(4)October 27, 2005, 7:03 pmData Types
Posts(4)October 27, 2005, 7:03 pmdynamic SQL and adding records to a table
Posts(2)October 27, 2005, 7:03 pmnewbie select and update
Posts(3)October 27, 2005, 7:03 pmupdate based on criteria
Posts(5)October 27, 2005, 7:03 pmhow much index are reasonable on a table?
Posts(4)October 27, 2005, 7:03 pmCancel showing output
Posts(4)October 27, 2005, 7:03 pmRe: Bulk Insert Data? Data in Millions
Posts(2)October 27, 2005, 7:03 pmTwo Queries, which one is better?
Posts(5)October 27, 2005, 7:03 pmNEWBIE: DATE Problem
Posts(4)October 27, 2005, 7:03 pmInsert thru a view to a table with an IDENTITY property
Posts(16)October 27, 2005, 7:03 pmPrimary Key Datatypes
Posts(7)October 27, 2005, 7:03 pmPersistence of Time... DateTime bugs, that is
Posts(1)October 27, 2005, 7:03 pmRe: Bulk Insert Data? Data in Millions
Posts(3)October 27, 2005, 7:03 pmReading Long Varchar
Posts(1)October 27, 2005, 7:03 pmusers and the sp_sdidebug
Posts(12)October 27, 2005, 7:03 pmJoe Celko in error?
Posts(4)October 27, 2005, 7:03 pmcheck link server availability in sp
Posts(1)October 27, 2005, 7:03 pmRe: Bulk Insert Data? Data in Millions
Posts(2)October 27, 2005, 7:03 pmUpdate IDENTITY column. have way to do this?
Posts(16)October 27, 2005, 7:03 pmPerformance Problem
Posts(4)October 27, 2005, 7:03 pmEmail ID Validation in SQL Query
Posts(4)October 27, 2005, 7:03 pmhow much index are reasonable on a table?
Posts(5)October 27, 2005, 7:03 pm1st column sequential output
Posts(3)October 27, 2005, 7:03 pmupdate sql server table from dbase IV
Posts(6)October 27, 2005, 7:03 pmTriggle rule change name ?
Posts(5)October 27, 2005, 7:03 pmCan SQL Server do this?
Posts(2)October 27, 2005, 7:03 pmJob Fails when scheduled
Posts(4)October 27, 2005, 7:03 pmAlter a column to allow null or not null values if meets criteria
Posts(4)October 27, 2005, 7:03 pmSimple Count Function help
Posts(2)October 27, 2005, 7:03 pmServer Side Include
Posts(4)October 27, 2005, 7:03 pmProblem with SELECT...WHERE IN procedure
Posts(3)October 27, 2005, 7:03 pmOne Triggle rule or 3 triggle rules ?
Posts(3)October 27, 2005, 7:03 pmEasy Date Problem
Posts(1)October 27, 2005, 7:03 pmADODB Recordset not returned using stored proc
Posts(3)October 27, 2005, 7:03 pmSELECT by DATE (doubt)
Posts(6)October 27, 2005, 7:03 pmInsert not returning Identity
Posts(3)October 27, 2005, 7:59 amProblem with linked servers
Posts(5)October 27, 2005, 7:59 amRunning Store procedures
Posts(3)October 27, 2005, 7:59 amGrouping and counting
Posts(6)October 27, 2005, 7:59 amConvert
Posts(2)October 27, 2005, 7:59 amKeeping track History Maintainance--Design Issue
Posts(5)October 27, 2005, 7:59 amstrange conversion
Posts(4)October 27, 2005, 7:59 amDatabase Design problem
Posts(2)October 27, 2005, 7:59 amNeed Help Regarding SQL Query
Posts(3)October 27, 2005, 3:58 amGrouping problem
Posts(2)October 27, 2005, 3:58 amExport a table data in a script file
Posts(3)October 27, 2005, 3:58 amALTER COLUMN
Posts(5)October 27, 2005, 3:58 amTrigger rule or SP -update & insert question
Posts(7)October 27, 2005, 3:58 amcounting records
Posts(3)October 27, 2005, 3:58 amConsolidate records
Posts(6)October 27, 2005, 3:58 amSelect for lower case
Posts(8)October 27, 2005, 3:58 amHelp with Normalizing table
Posts(4)October 27, 2005, 3:58 amCreate view using UNION
Posts(2)October 26, 2005, 9:57 pmChanging Column Length
Posts(2)October 26, 2005, 9:57 pmToo many tables
Posts(1)October 26, 2005, 7:02 pmConnection problems
Posts(5)October 26, 2005, 7:02 pmuse varible values from subquery in a case
Posts(12)October 26, 2005, 7:02 pmRow numbers in select statements
Posts(6)October 26, 2005, 7:02 pmcast datetime to yyyymm format
Posts(8)October 26, 2005, 7:02 pmHow do I: NOT use Dynamic SQL for this Stored Procedure
Posts(3)October 26, 2005, 7:02 pmCapture Execution Time Then Rollback Transaction
Posts(2)October 26, 2005, 7:02 pmCase statement error
Posts(7)October 26, 2005, 7:02 pmJoining tables
Posts(6)October 26, 2005, 7:02 pmBlocked tables
Posts(5)October 26, 2005, 7:02 pmHow to take data out of table, restructure the table and then put the data back in
Posts(4)October 26, 2005, 7:02 pmADO Performance question
Posts(4)October 26, 2005, 7:02 pmReplace function and remove some string in column
Posts(2)October 26, 2005, 7:02 pmCannot resolve collation conflict for equal to operation.
Posts(5)October 26, 2005, 7:02 pmcreative ideas on problem needed
Posts(4)October 26, 2005, 7:02 pmHelp with INSERT INTO
Posts(8)October 26, 2005, 7:02 pmConvert
Posts(1)October 26, 2005, 7:02 pmThe dreaded General network error
Posts(4)October 26, 2005, 7:02 pmQuery/SQL help
Posts(8)October 26, 2005, 7:02 pmWhat is wrong with this WHERE clause
Posts(3)October 26, 2005, 7:02 pmBest practices for Unicode column supporting mixed languages and searching
Posts(3)October 26, 2005, 7:02 pmAny work around to pass parameters to OPENQUERY
Posts(3)October 26, 2005, 7:02 pmGROUP BY!
Posts(12)October 26, 2005, 7:02 pmMore help with count and group by
Posts(2)October 26, 2005, 7:02 pmHOW DO I: Group by Month



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

Copyright 2008 codecomments.com