For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > September 2005









Pages: [1] 2 3 4 5 6 7

Posts(5)September 30, 2005, 7:01 pmviewing index info in query analyzer
Posts(2)September 30, 2005, 7:01 pmCursor question
Posts(6)September 30, 2005, 7:01 pmReturn Variable In Resultset!
Posts(2)September 30, 2005, 7:01 pmINSTEAD OF trigger on a VIEW ignore (sometimes) IDENTITY columns
Posts(8)September 30, 2005, 7:01 pmCan someone explain why this is not an error?
Posts(3)September 30, 2005, 7:01 pmMore not in issue
Posts(2)September 30, 2005, 7:01 pmIs this a bug, CURSOR_STATUS() always return -3 ?
Posts(9)September 30, 2005, 7:01 pmSplitting an address field in address and zip code
Posts(17)September 30, 2005, 7:01 pminline update?
Posts(4)September 30, 2005, 7:01 pmPercent Range for a list of numbers
Posts(4)September 30, 2005, 7:01 pmIncorrect syntax near 'COLLATE'
Posts(8)September 30, 2005, 7:01 pmscramble password
Posts(5)September 30, 2005, 7:01 pmPartitioning - Execution Plan
Posts(7)September 30, 2005, 7:01 pmNon-deterministic UDF's?
Posts(14)September 30, 2005, 7:01 pmselect only first row
Posts(2)September 30, 2005, 7:01 pmDistributed Transactions fail
Posts(1)September 30, 2005, 7:01 pmRe: Problem with SQL Server and odbc, please help me! - Solved!
Posts(3)September 30, 2005, 7:01 pmTrigger on Insert for existing data
Posts(2)September 30, 2005, 7:01 pmQA Reserved/Keyword 'HELP'
Posts(3)September 30, 2005, 7:01 pmProblem with SQL Server and odbc, please help me!
Posts(5)September 30, 2005, 7:01 pmCount with Group By
Posts(2)September 30, 2005, 7:01 pmUser Roles and Permission
Posts(2)September 30, 2005, 7:01 pmGroup By OR ?
Posts(18)September 30, 2005, 7:01 pmDoes the order matter
Posts(5)September 30, 2005, 7:01 pmHow to check Backup of SQL Server Database
Posts(3)September 30, 2005, 7:01 pmVPN and EM timeout problem
Posts(3)September 30, 2005, 7:01 pmSQL 2000 UserID & Password Question
Posts(3)September 30, 2005, 7:01 pmfile backup
Posts(3)September 30, 2005, 8:02 ambook recommendations: ETL
Posts(3)September 30, 2005, 8:02 amTable Manipulation Issue
Posts(5)September 30, 2005, 8:02 amError in GroupBy
Posts(8)September 30, 2005, 8:02 amEnsure Allowing Nested Triggers = True
Posts(7)September 30, 2005, 8:02 amplease tell me how to know when a deadlock occurs in sp
Posts(5)September 30, 2005, 8:02 amWHILE Loop with parameters from a varchar parameter
Posts(2)September 30, 2005, 8:02 amdatediff comparison to previous row in select statement
Posts(3)September 30, 2005, 3:58 amCount Attempts!
Posts(3)September 30, 2005, 3:58 amno recovery option
Posts(2)September 30, 2005, 3:58 amproblem with xp_sendmail
Posts(2)September 30, 2005, 3:58 amUpgrading our system
Posts(6)September 30, 2005, 3:58 amHow to retrieve schema bound to a Query?
Posts(6)September 30, 2005, 3:58 amStored procedures, permissions, table names
Posts(4)September 30, 2005, 3:58 amHow to select all values for stock, which match certain condition
Posts(3)September 30, 2005, 3:58 amdesign help
Posts(6)September 30, 2005, 3:53 amDefragment all indexes in a database?
Posts(9)September 29, 2005, 9:58 pmequivalent of FOREACH in TSQL?
Posts(5)September 29, 2005, 9:58 pmserver registeration problem...
Posts(2)September 29, 2005, 9:58 pmBulk Loading: TempFilePath security question
Posts(7)September 29, 2005, 9:58 pmorder by
Posts(8)September 29, 2005, 7:03 pmFunctions vs StoredProcedures
Posts(4)September 29, 2005, 7:03 pmUsing a Filename as a variable in Bulk Insert
Posts(5)September 29, 2005, 7:03 pmxp_cmdshell to open/close file
Posts(9)September 29, 2005, 7:03 pmadding 140,000 records requires index rebuild. make sense?
Posts(5)September 29, 2005, 7:03 pmSQL Statement
Posts(7)September 29, 2005, 7:02 pmUnexpected NULL value returned for column
Posts(3)September 29, 2005, 7:02 pmexecuting sp_changeownerdb
Posts(2)September 29, 2005, 7:02 pmcopy tuples from table tsql?
Posts(8)September 29, 2005, 7:02 pmCasting char to int but not causing error
Posts(9)September 29, 2005, 7:02 pmIndex Tuning Wizard
Posts(2)September 29, 2005, 7:02 pmRe: SET IDENTITY INSERT... BEGIN TRAN OR BEGIN TRAN... SET IDENTIT
Posts(4)September 29, 2005, 7:02 pmColumn to Search in DB
Posts(2)September 29, 2005, 7:02 pmExtracting image column to the file
Posts(5)September 29, 2005, 7:02 pmUpdating an Access table from a SQL table
Posts(15)September 29, 2005, 7:02 pmNeed advice with a query
Posts(3)September 29, 2005, 7:02 pmCursor variable not declared issue
Posts(11)September 29, 2005, 7:02 pmSimple query?
Posts(10)September 29, 2005, 7:02 pmScale not correct in query
Posts(5)September 29, 2005, 7:02 pmSelect statement on multiple values
Posts(4)September 29, 2005, 7:02 pmSP returning multiple resultsets
Posts(4)September 29, 2005, 7:02 pmDatabase size entry?
Posts(10)September 29, 2005, 7:02 pmQuery From Excel
Posts(5)September 29, 2005, 7:02 pmkeyword color problem
Posts(10)September 29, 2005, 7:02 pmHelp with subquery
Posts(5)September 29, 2005, 7:02 pmPermission confusion
Posts(3)September 29, 2005, 7:02 pmreturn results of lastest date
Posts(4)September 29, 2005, 7:02 pmImage data type, doesn't return the data on selected
Posts(3)September 29, 2005, 7:02 pmbcp
Posts(5)September 29, 2005, 7:02 pmGet Value of IDENTITY
Posts(5)September 29, 2005, 7:02 pmEXEC or EXECUTE, SET or SELECT
Posts(5)September 29, 2005, 7:02 pmAdd field to multiple tables
Posts(4)September 29, 2005, 7:02 pmclearing connection with SQLDMO
Posts(3)September 29, 2005, 7:02 pmToo Slow to add new record.
Posts(3)September 29, 2005, 7:02 pmquery
Posts(5)September 29, 2005, 7:02 pmInner join in an update
Posts(3)September 29, 2005, 7:02 pmAutoincrement
Posts(2)September 29, 2005, 7:02 pmXML insert
Posts(3)September 29, 2005, 7:02 pmTrapping fatal error
Posts(4)September 29, 2005, 7:58 am"Net Send" from SQL2000 on Windows 2003.
Posts(7)September 29, 2005, 7:58 amUsing variables for tablenames in Select Statement
Posts(7)September 29, 2005, 7:58 amSchema Comparision
Posts(3)September 29, 2005, 7:58 amsolve this query
Posts(3)September 29, 2005, 7:58 amQuerying all users on different database on each server
Posts(3)September 29, 2005, 7:58 amQuery From ACCCESS to MSDE
Posts(2)September 29, 2005, 3:58 amWhat are 'ignored' words for CONTAINS(*)
Posts(12)September 29, 2005, 3:58 amUpdate Trigger
Posts(2)September 29, 2005, 3:58 amIN Clause!
Posts(3)September 29, 2005, 3:58 amusing triggers to log changes
Posts(4)September 29, 2005, 3:58 amJob NextRunDate using DMO always 0
Posts(4)September 29, 2005, 3:58 amDTS
Posts(4)September 29, 2005, 3:58 amupdate balance
Posts(4)September 29, 2005, 3:58 amSproc output
Posts(3)September 29, 2005, 3:58 amplease solve this deadlock problem
Posts(4)September 29, 2005, 3:58 amupdate balance
Posts(5)September 29, 2005, 3:58 amassigning Select results to local vars in SP
Posts(6)September 29, 2005, 3:58 amRetriieve table names
Posts(2)September 29, 2005, 3:58 amdatabase question
Posts(3)September 29, 2005, 3:58 amQuestion about OLEDB providers
Posts(2)September 29, 2005, 3:58 amquestion about optimistic locking
Posts(4)September 29, 2005, 3:58 amAny book on SQL
Posts(5)September 28, 2005, 9:57 pmGeneral Database/Query and Form Design question
Posts(4)September 28, 2005, 9:57 pmError: Only text pointers are allowed in work tables
Posts(3)September 28, 2005, 9:57 pmhow to modify-update an Image column?
Posts(1)September 28, 2005, 9:57 pmHELP NAMED SET !
Posts(3)September 28, 2005, 7:02 pmError 229: Permissions problem with sysobjects and sysindexes
Posts(2)September 28, 2005, 7:02 pmWebservices vs Stored Procedures
Posts(6)September 28, 2005, 7:02 pmRe: Exclusive or
Posts(2)September 28, 2005, 7:02 pmquerying horizontal partition using parameter in where clause fail
Posts(4)September 28, 2005, 7:02 pmUnicode in varchar
Posts(7)September 28, 2005, 7:02 pmFormat data in a column
Posts(3)September 28, 2005, 7:02 pmExec replacement
Posts(6)September 28, 2005, 7:02 pmSQL Script works but fail as Stored Procedure - Why?
Posts(3)September 28, 2005, 7:02 pmHardware general question about sql
Posts(5)September 28, 2005, 7:02 pmTo Import a fixed-width file format to SQL 2003 table
Posts(3)September 28, 2005, 7:02 pmFind top 10 tables which have worst statistics
Posts(1)September 28, 2005, 7:02 pmSQL stored proc with text input parameter
Posts(2)September 28, 2005, 7:02 pmNewbie trigger question
Posts(2)September 28, 2005, 7:02 pmTable Size
Posts(2)September 28, 2005, 7:02 pmSET IDENTITY INSERT... BEGIN TRAN OR BEGIN TRAN... SET IDENTITY IN
Posts(2)September 28, 2005, 7:02 pmLog File Size - Sudden Growth
Posts(8)September 28, 2005, 7:02 pmhow to read a resultset from a procedure calling a procedure
Posts(2)September 28, 2005, 7:02 pmDay of year
Posts(13)September 28, 2005, 7:02 pmData Migration
Posts(3)September 28, 2005, 7:02 pmAccess connection to SQL Server
Posts(6)September 28, 2005, 7:02 pmproduct deadlock scenario
Posts(2)September 28, 2005, 7:02 pmIs it possible to retrieve SP calls using CLR (like profiler)
Posts(1)September 28, 2005, 7:02 pmRe: Match Email then Delete Question
Posts(3)September 28, 2005, 7:02 pmMore Bytes returned from Image Data Type
Posts(7)September 28, 2005, 7:02 pmnot in
Posts(7)September 28, 2005, 7:02 pmDeleting Indexes from a table
Posts(2)September 28, 2005, 7:02 pmDBCC DBREINDEX - Update with FULLSCAN or without?
Posts(11)September 28, 2005, 7:02 pmis a UNION the answer?
Posts(1)September 28, 2005, 7:02 pmError 8629 - updating clustring key & text, ntext or image
Posts(3)September 28, 2005, 7:02 pmJoin takes too long to execute
Posts(8)September 28, 2005, 7:02 pmDTS Problem
Posts(4)September 28, 2005, 7:02 pmusing the timestamp data type
Posts(3)September 28, 2005, 7:02 pmHow to determine compiled proc size?
Posts(4)September 28, 2005, 7:02 pmLinked Servers Issues
Posts(3)September 28, 2005, 7:02 pmHelp please on forum discussion
Posts(2)September 28, 2005, 7:02 pmISOLATION LEVEL READ UNCOMMITTED
Posts(7)September 28, 2005, 7:02 pmleft join left join?
Posts(3)September 28, 2005, 7:02 pmwho i Can Catch a Message from sql server
Posts(2)September 28, 2005, 7:02 pmA problem with "DTSTransferObjectsTask"
Posts(5)September 28, 2005, 7:02 pmDate format
Posts(4)September 28, 2005, 7:02 pmUndocumented datetime conversion styles
Posts(4)September 28, 2005, 7:02 pmMaint. plans
Posts(8)September 28, 2005, 7:02 pmonly sftp is allowed how to sftp from windows
Posts(4)September 28, 2005, 7:02 pmvarchar data overflow
Posts(3)September 28, 2005, 7:02 pmsend batch of sql statements to sql server
Posts(3)September 28, 2005, 7:02 pmSP Name Resolution
Posts(2)September 28, 2005, 7:02 pmUDF Question
Posts(6)September 28, 2005, 7:02 pmstring maniupation question
Posts(2)September 28, 2005, 7:02 pmquery cannot return any results
Posts(4)September 28, 2005, 7:02 pmClient app needs to know when data has changed
Posts(3)September 28, 2005, 7:02 pmupdate statement using select
Posts(2)September 28, 2005, 7:02 pmLogin failure for job
Posts(5)September 28, 2005, 7:02 pmTrying to call UpdateBatch is giving error -2147467259
Posts(4)September 28, 2005, 7:02 pmTools for design recovery (reengineering) of C# source code with embedded sql stateme
Posts(14)September 28, 2005, 7:02 pmSimple primary key question
Posts(2)September 28, 2005, 7:02 pmStored procedure database size report?
Posts(7)September 28, 2005, 7:02 pmselecting rows with null values
Posts(1)September 28, 2005, 7:02 pmRe: Is there a line feed bug in QA? - I think that's it
Posts(2)September 28, 2005, 1:07 pmI keep getting this error when i send a large document into sql server with ADO.NET S
Posts(3)September 28, 2005, 8:07 amSql 2005 - Reporting Servcies?
Posts(4)September 28, 2005, 8:07 amSequential number generator
Posts(2)September 28, 2005, 8:07 amDatabases have a dot (.) in their name
Posts(6)September 28, 2005, 8:07 amTracking Moved Computers with SQL
Posts(8)September 28, 2005, 8:07 amRandomise Issue!!
Posts(3)September 28, 2005, 8:07 amSelect Distinct Order by
Posts(1)September 28, 2005, 8:07 amProblem with: "open table -> query" in Enterprise Manager
Posts(1)September 28, 2005, 4:00 amHelpful Material for Programmers
Posts(4)September 28, 2005, 4:00 ammax number of triggers on a table
Posts(10)September 28, 2005, 4:00 amClient app needs to know when data has changed
Posts(2)September 28, 2005, 4:00 amHow to FTP
Posts(4)September 28, 2005, 4:00 amIs there a line feed bug in QA?
Posts(2)September 28, 2005, 4:00 amExpects Parameters When It Should Not
Posts(3)September 28, 2005, 4:00 ammulti-column primary keys and nullability
Posts(6)September 28, 2005, 4:00 amRe: OLEDB Provider for SQL Server Errors
Posts(13)September 28, 2005, 4:00 amwhat statement/function to return first non-null value?
Posts(5)September 28, 2005, 4:00 amConditional UNION!!
Posts(3)September 28, 2005, 4:00 amWeb Based Front End to SQL Sever
Posts(5)September 27, 2005, 7:05 pmGROUP BY / HAVING clauses problem
Posts(6)September 27, 2005, 7:05 pmLIKE Operator
Posts(2)September 27, 2005, 7:05 pmSQL Server 7.0 to SQL Server 2000 Upgrade Question
Posts(2)September 27, 2005, 7:05 pmA view that include a table from a database in another sql server
Posts(2)September 27, 2005, 7:05 pmJoin Question
Posts(7)September 27, 2005, 7:05 pmSelect fields vs select *
Posts(4)September 27, 2005, 7:05 pmHOWTO: Transpose n Rows X 2 Columns to n Rows X 10 Columns
Posts(7)September 27, 2005, 7:05 pmProgrammatically deleting Indexes
Posts(6)September 27, 2005, 7:05 pmWhat's the best way to write this query?
Posts(2)September 27, 2005, 7:05 pmAny one used Application Role before?
Posts(1)September 27, 2005, 7:05 pmRe: Match Email then Delete Question



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

Copyright 2008 codecomments.com