For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > January 2006









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

Posts(8)January 31, 2006, 10:02 pmupdate AD from SQL?
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmSQL Recursion - navigating parent child records
Posts(20)January 31, 2006, 10:02 pmHow to group on half-hour increments on a datetime field?
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(1)January 31, 2006, 10:02 pmEARN OVER 9850 DOLLAR in 3 WEEKS !!!
Posts(6)January 31, 2006, 7:09 pminserted value on text field gets truncated after 255 chars
Posts(2)January 31, 2006, 7:09 pmproblem with information_schema.Tables
Posts(4)January 31, 2006, 7:09 pmHow to debug "sp_xml_preparedocument" stored procedure
Posts(3)January 31, 2006, 7:09 pmuser definded function with now owner reference
Posts(2)January 31, 2006, 7:09 pmTransact SQL Syntax
Posts(14)January 31, 2006, 7:09 pmSQL delete logic
Posts(4)January 31, 2006, 7:09 pm1 More help with file names from folders
Posts(3)January 31, 2006, 7:09 pmBLOCKING
Posts(3)January 31, 2006, 7:09 pmSQL Server 2005 compatibility question...
Posts(5)January 31, 2006, 7:09 pmCase Statement
Posts(14)January 31, 2006, 7:09 pmOptimizing a query
Posts(7)January 31, 2006, 7:09 pmAgent job hanging on xp_sendmail
Posts(3)January 31, 2006, 7:09 pmTurning a subqueried SELECT into an UPDATE
Posts(3)January 31, 2006, 7:09 pmTriggers
Posts(4)January 31, 2006, 7:09 pmRe: Query that automatically deletes records that are older than 3
Posts(6)January 31, 2006, 7:09 pmin vs. hard coding problem
Posts(5)January 31, 2006, 7:09 pmSQL Server 2000 SP
Posts(2)January 31, 2006, 7:09 pmSQL Server 2005 Security
Posts(2)January 31, 2006, 7:09 pmRe: Display of date time inforamtion - some columns are NULL some
Posts(5)January 31, 2006, 7:09 pmdisplay on duplicate records
Posts(2)January 31, 2006, 7:09 pmIncorrect Results -- is a hotfix available?
Posts(6)January 31, 2006, 7:09 pmData types - using integer as numerator in a percentage calculation
Posts(1)January 31, 2006, 7:09 pmRe: Data types - using integer as numerator in a percentage calcul
Posts(1)January 31, 2006, 7:09 pmRe: Issue with passing a parameter to Stored Procedure using IN ke
Posts(5)January 31, 2006, 7:09 pmRestricting results
Posts(4)January 31, 2006, 7:09 pmCOM object from Store Procedure
Posts(5)January 31, 2006, 7:09 pmIssue with passing a parameter to Stored Procedure using IN keywor
Posts(1)January 31, 2006, 7:09 pmRe: How to implement remote Data Entry then upload to corp. databa
Posts(3)January 31, 2006, 7:09 pmAdd/Drop LinkedServers using SMO
Posts(2)January 31, 2006, 7:09 pmRE: Trying to query AdventureWorks database from Query Analyzer - need
Posts(2)January 31, 2006, 7:09 pmHow to implement remote Data Entry then upload to corp. database?
Posts(4)January 31, 2006, 7:09 pmpercentage values storage and retrieval
Posts(6)January 31, 2006, 7:09 pmCreate table script without drop
Posts(6)January 31, 2006, 7:09 pmReseed identity column in SQL 2000
Posts(4)January 31, 2006, 7:09 pmDynamic sql
Posts(3)January 31, 2006, 7:09 pmSybase trigger
Posts(2)January 31, 2006, 7:09 pmEffects of changing a table name
Posts(2)January 31, 2006, 7:09 pmTrigger for tracking column-by-column changes?
Posts(2)January 31, 2006, 7:09 pmUser Defined Type, Storage Efficiency Questions
Posts(1)January 31, 2006, 7:09 pmRe: Comment créer un nouveau champs dans un fichier SQL ?
Posts(1)January 31, 2006, 7:09 pmRe: Comment créer un nouveau champs dans un fichier SQL ?
Posts(1)January 31, 2006, 7:09 pmRe: Comment créer un nouveau champs dans un fichier SQL ?
Posts(7)January 31, 2006, 7:09 pmInserting rows problem
Posts(1)January 31, 2006, 7:09 pmComment créer un nouveau champs dans un fichier SQL ?
Posts(1)January 31, 2006, 7:09 pmRe: Comment créer un nouveau champs dans un fichier SQL ?
Posts(1)January 31, 2006, 7:09 pmRe: Comment créer un nouveau champs dans un fichier SQL ?
Posts(8)January 31, 2006, 7:09 pmUsing multiple field index when each of the fields already has seperate index
Posts(2)January 31, 2006, 7:09 pmQuery from within Excel
Posts(3)January 31, 2006, 7:09 pmbest approach
Posts(3)January 31, 2006, 7:09 pmTuning in SQL Server
Posts(1)January 31, 2006, 7:09 pmreporting services installation
Posts(8)January 31, 2006, 7:09 pmHow odd, strange behaviour
Posts(2)January 31, 2006, 7:09 pmRE: Display of date time inforamtion - some columns are NULL some are
Posts(2)January 31, 2006, 7:09 pmPerformance and tuning in SQL Server 2000
Posts(10)January 31, 2006, 7:09 pmquick question on pattern matching
Posts(1)January 31, 2006, 7:09 pmWhy I believe C# is better than T-SQL for dynamic SQL calls ..
Posts(1)January 31, 2006, 7:09 pmRe: Mistery with UPDATE statement - Full Run Script Profiler result
Posts(1)January 31, 2006, 7:09 pmDifferent Results!!
Posts(9)January 31, 2006, 8:00 amtrigger - new.value
Posts(4)January 31, 2006, 8:00 amDisplay of date time inforamtion - some columns are NULL some are not
Posts(1)January 31, 2006, 8:00 amRE: Display of date time inforamtion - some columns are NULL some are
Posts(1)January 31, 2006, 8:00 amRe: Display of date time inforamtion - some columns are NULL some are
Posts(1)January 31, 2006, 8:00 amRegistered servers and smo
Posts(1)January 31, 2006, 8:00 amKeeping cursors opened across commits (embedded SQL)
Posts(5)January 31, 2006, 8:00 amAdding commets into every field
Posts(4)January 31, 2006, 8:00 amindestructible Log file.
Posts(3)January 31, 2006, 8:00 amCLR TVF -> Using Datareader...
Posts(3)January 31, 2006, 4:11 amntext, text or image data type
Posts(2)January 31, 2006, 4:11 amDetails on Linked server
Posts(3)January 31, 2006, 4:11 amdynamical tablenames
Posts(8)January 31, 2006, 4:11 amDate functions
Posts(3)January 31, 2006, 4:11 amdisk crash and dwh recover
Posts(2)January 31, 2006, 4:11 amExecute Non Query: Command Text Property has not been initialized
Posts(2)January 31, 2006, 4:11 amSQL Server 2005 + SQL Server 2000
Posts(5)January 31, 2006, 4:11 amWHERE IN Vs INNER JOIN
Posts(5)January 31, 2006, 4:11 amCREATE USER
Posts(4)January 30, 2006, 9:58 pmRqst for Inventory Database Best Practices
Posts(8)January 30, 2006, 9:58 pmParent/child SQL query
Posts(2)January 30, 2006, 9:58 pmCreating ODBC link within SELECT statement
Posts(4)January 30, 2006, 7:06 pmselect rtrim(convert(char(9),getdate(),111),1)
Posts(4)January 30, 2006, 7:06 pmWithout using temporary table....
Posts(6)January 30, 2006, 7:06 pmNumber of records
Posts(2)January 30, 2006, 7:06 pmTrying to query AdventureWorks database from Query Analyzer - need help.
Posts(1)January 30, 2006, 7:06 pmQuery Review
Posts(1)January 30, 2006, 7:06 pmRe: Trying to query AdventureWorks database from Query Analyzer - need
Posts(9)January 30, 2006, 7:06 pmWhy is this nondeterministic?
Posts(3)January 30, 2006, 7:06 pmOdd ASP buffer/cache problem?
Posts(5)January 30, 2006, 7:06 pmscope of local variables
Posts(1)January 30, 2006, 7:06 pmFailed to Notify... Database Mail not sending emails
Posts(32)January 30, 2006, 7:06 pmTracking updated columns
Posts(2)January 30, 2006, 7:06 pmExecuteNonQuery: Command Text Property has not been initialized
Posts(2)January 30, 2006, 7:06 pmpaging w/ sql server 2k
Posts(5)January 30, 2006, 7:06 pmGetting file names from path?
Posts(4)January 30, 2006, 7:06 pmQuery Help
Posts(4)January 30, 2006, 7:06 pmINSERT Statement Error
Posts(4)January 30, 2006, 7:06 pmScalability questions for extended stored procedure
Posts(6)January 30, 2006, 7:06 pmProcedure problem
Posts(2)January 30, 2006, 7:06 pmBackup Up Remote Database
Posts(2)January 30, 2006, 7:06 pmTuning Wizard Quits Spontaneously
Posts(1)January 30, 2006, 7:06 pmRE: How can I send "Arabict Text" message as eMail usnig SMTP server -
Posts(6)January 30, 2006, 7:06 pmSend bulk data to SQL
Posts(2)January 30, 2006, 7:06 pmSELECT INTO
Posts(2)January 30, 2006, 7:06 pmfield mapping
Posts(2)January 30, 2006, 7:06 pmRe: Use formula into text field how field for calculate value into
Posts(3)January 30, 2006, 7:06 pmStored procedure performance issue
Posts(5)January 30, 2006, 7:06 pmRecompile Table Functions?
Posts(10)January 30, 2006, 7:06 pmcalculate base 32 notation from int value?
Posts(4)January 30, 2006, 7:06 pmHelp with File names from folders.
Posts(1)January 30, 2006, 7:06 pmAccess Violation in an Extended Stored procedure
Posts(6)January 30, 2006, 7:06 pmT-SQL IF/ELSE
Posts(2)January 30, 2006, 7:06 pmSQLReport export to Excel
Posts(3)January 30, 2006, 7:06 pmCalling VB dll method: sp_OAMethod Error
Posts(9)January 30, 2006, 7:06 pmHow does engine decide whether to scan or seek index
Posts(5)January 30, 2006, 8:02 amvariable as starting seed
Posts(3)January 30, 2006, 8:02 amTemporary table - what happens if the website is busy?
Posts(1)January 30, 2006, 8:02 amHow to get SQL Server Result set from Http in XML
Posts(2)January 30, 2006, 8:02 amSet NoCoount On
Posts(3)January 30, 2006, 8:02 amUse formula into text field how field for calculate value into SP
Posts(4)January 30, 2006, 8:02 amSQL UPDATE Trigger causing "Connection Busy" in App
Posts(4)January 30, 2006, 8:02 amMySQL Insert Conversion
Posts(6)January 30, 2006, 8:02 amCASE / NULL Problem
Posts(3)January 30, 2006, 8:02 amDistinct problem
Posts(8)January 30, 2006, 3:59 amQuery that automatically deletes records that are older than 365 d
Posts(19)January 30, 2006, 3:59 amOrder By Primary Key
Posts(4)January 30, 2006, 3:59 amhow to configure multiple databases for one asp.net website
Posts(4)January 30, 2006, 3:59 amStored Proc Return/Output value - grhhhh
Posts(1)January 30, 2006, 3:59 amHow can I send "Arabict Text" message as eMail usnig SMTP server - URGENT
Posts(31)January 30, 2006, 3:59 amHow to format a SELECT resultset as a comma separated list?
Posts(9)January 30, 2006, 3:59 amHow to SELECT data among 4 tables?
Posts(2)January 29, 2006, 9:57 pmImproving the Sql environment at our Place ?
Posts(4)January 29, 2006, 9:57 pmremove control codes from database
Posts(9)January 29, 2006, 9:57 pmUsing UNION, User Defined Functions in a VIEW
Posts(3)January 29, 2006, 7:04 pmHelp interpreting DBCC CHECKDB output
Posts(1)January 29, 2006, 7:04 pmRe: Using multiple field index when each of the fields already has seperate index
Posts(3)January 29, 2006, 7:04 pmRe: Using multiple field index when each of the fields already has
Posts(1)January 29, 2006, 7:04 pmRe: Using multiple field index when each of the fields already has seperate index
Posts(9)January 29, 2006, 7:04 pmStored Procedure to Make One Table Match Another
Posts(13)January 29, 2006, 7:04 pmReplacement of C code with C# code
Posts(1)January 29, 2006, 7:04 pmRe: Using multiple field index when each of the fields already has seperate index
Posts(9)January 29, 2006, 7:57 amAdding Serial No in the Query Resultset
Posts(5)January 29, 2006, 7:57 amHelp me
Posts(2)January 29, 2006, 7:57 amKB186133 - dynamically numbering rows needs updating
Posts(3)January 29, 2006, 3:57 amAdv. T-SQL: Finding closest match across multiple columns
Posts(20)January 29, 2006, 3:57 amOptimizing an IN clause
Posts(13)January 29, 2006, 3:57 amRelational Design Question
Posts(5)January 28, 2006, 9:58 pmLooping
Posts(9)January 28, 2006, 7:07 pmWhat's the recommended way for me to keep two databases in sync?
Posts(7)January 28, 2006, 7:07 pmFIND OUT IT IS A NUMBER OR STRINg
Posts(3)January 28, 2006, 7:07 pmProblem with Cursors
Posts(6)January 28, 2006, 7:07 pmenforce update statement order
Posts(9)January 28, 2006, 7:07 pmCOUNT with conditions
Posts(2)January 28, 2006, 7:07 pmtransfer data from remote sql server 2000 to local sql server 2005
Posts(8)January 28, 2006, 7:07 pmCalculating Row Size
Posts(7)January 28, 2006, 7:07 pmInserting into joined tables
Posts(3)January 28, 2006, 7:07 pmSQL Express
Posts(5)January 28, 2006, 7:07 pmQuery Help
Posts(2)January 28, 2006, 3:58 amScript out whole SQL SERVER Database including INSERT
Posts(4)January 28, 2006, 3:58 amSUM
Posts(4)January 28, 2006, 3:58 amA trigger that backups data from several tables...??
Posts(3)January 27, 2006, 9:58 pmHow to perform multi-namespace?
Posts(3)January 27, 2006, 9:58 pmuse UPDATE STATISTICS @table in a cursor
Posts(10)January 27, 2006, 7:04 pmNeed to change a table name from all sp's
Posts(4)January 27, 2006, 7:04 pmvarchar overflow into an int column
Posts(2)January 27, 2006, 7:04 pmNotify Apps When DB is Updated
Posts(5)January 27, 2006, 7:04 pmMaking a term found in a string the subject
Posts(2)January 27, 2006, 7:04 pmSQL SERVER PARSE ERRORS
Posts(12)January 27, 2006, 7:04 pmTable design (search with ranking)
Posts(5)January 27, 2006, 7:04 pmfinding max date
Posts(7)January 27, 2006, 7:04 pmDate problem
Posts(8)January 27, 2006, 7:04 pmNightmare Query
Posts(32)January 27, 2006, 7:04 pmOk, time to start a war
Posts(3)January 27, 2006, 7:04 pmRe-Index Script
Posts(3)January 27, 2006, 7:04 pmJoining to large tables to perfrom update
Posts(5)January 27, 2006, 7:04 pmHelp with a loop to collect database names and tables within those databases.
Posts(1)January 27, 2006, 7:04 pmHosting a Component in SQL Server 2005 & Security
Posts(2)January 27, 2006, 7:04 pmService Broker - Queue Priority
Posts(2)January 27, 2006, 7:04 pmTable Scan Cost: 0%
Posts(3)January 27, 2006, 7:04 pmSlecting from an ordered list Query. Pls help.
Posts(10)January 27, 2006, 7:04 pmQuery returning inconsistent results - please help
Posts(5)January 27, 2006, 7:04 pmOptimizing queries
Posts(2)January 27, 2006, 7:04 pmMaterialized Views
Posts(5)January 27, 2006, 7:04 pmwhere datefld =... vs datefld Between ... not getting same recor
Posts(1)January 27, 2006, 7:04 pmRE: where datefld =... vs datefld Between ... not getting same r
Posts(1)January 27, 2006, 7:04 pmRe: where datefld =... vs datefld Between ... not getting same r
Posts(3)January 27, 2006, 7:04 pmslow accross subnets
Posts(4)January 27, 2006, 7:04 pmsyntax of user-defined function



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

Copyright 2008 codecomments.com