For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > November 2005









Pages: [1] 2 3 4 5 6 7

Posts(7)November 30, 2005, 4:01 amBizarre SQL statement
Posts(1)November 30, 2005, 4:01 amSELECT INTO
Posts(4)November 30, 2005, 4:01 amsql - comparing dates when there is a NULL
Posts(2)November 30, 2005, 4:01 amSIMPLE but HOW? - Stored Procedure within Query
Posts(3)November 30, 2005, 4:01 ammultiple parent categories
Posts(2)November 30, 2005, 4:01 amquestion about system tables
Posts(3)November 30, 2005, 4:01 amgetting exclamation sign in message when sent using sql email
Posts(1)November 30, 2005, 4:01 amLinked Server performance varies depending on user
Posts(8)November 30, 2005, 4:01 amExecute Stored Procedure from User Defined Function
Posts(9)November 30, 2005, 4:01 amnow() and datetime: out-of-range
Posts(2)November 30, 2005, 4:01 amSQL...nested transactions
Posts(5)November 30, 2005, 4:01 amGrouping by daterange
Posts(7)November 29, 2005, 9:58 pmSearching through separated list
Posts(4)November 29, 2005, 9:58 pmWhere Claause for Unique Constraint?
Posts(9)November 29, 2005, 7:05 pmReality check...
Posts(3)November 29, 2005, 7:05 pmSELECT DISTINCT help
Posts(2)November 29, 2005, 7:05 pmShared procedure with variable field name + data pairs
Posts(3)November 29, 2005, 7:05 pmSQL Agent Jobs
Posts(2)November 29, 2005, 7:05 pmisql file wrapping
Posts(8)November 29, 2005, 7:05 pmConversion from Access to SQL Server
Posts(8)November 29, 2005, 7:05 pmwith(updlock) - How many times on same table in single update?
Posts(5)November 29, 2005, 7:05 pmSELECT '1' FROM mytable?
Posts(10)November 29, 2005, 7:05 pmDivision in Query - Simple, but Lost...
Posts(5)November 29, 2005, 7:05 pmneed help with crosstab query
Posts(2)November 29, 2005, 7:05 pmoutput param in stored proc is NULL
Posts(1)November 29, 2005, 7:05 pmSQL...forward error recovery
Posts(1)November 29, 2005, 7:05 pmSQL...checkpoint frequency
Posts(1)November 29, 2005, 7:05 pmTARFU: Data Controls
Posts(1)November 29, 2005, 7:05 pmSQL....backup recovery
Posts(1)November 29, 2005, 7:05 pmSQL...update-in-place scheme
Posts(8)November 29, 2005, 7:05 pmRe: SQL 2005: Why has Microsoft taken out the "Object Search" Dial
Posts(2)November 29, 2005, 7:05 pm"Max row" in each group
Posts(3)November 29, 2005, 7:05 pmSQL Server Developer Position
Posts(2)November 29, 2005, 7:05 pmQuery help
Posts(1)November 29, 2005, 7:05 pmhi
Posts(4)November 29, 2005, 7:05 pmHow to run multiple jobs in parallel
Posts(2)November 29, 2005, 7:05 pmhi
Posts(2)November 29, 2005, 7:05 pmBlocking Threshold Exceeded
Posts(1)November 29, 2005, 7:05 pmMerge Replication SQL2005
Posts(1)November 29, 2005, 7:05 pmRe: SQLCLR/Broker etc
Posts(7)November 29, 2005, 7:05 pmSQL 2005 DTS?
Posts(3)November 29, 2005, 7:05 pmArticle on when to use Stored Procs?
Posts(2)November 29, 2005, 7:05 pmjoining a varchar with a int column
Posts(4)November 29, 2005, 7:05 pmCount(*) divide returning 0?
Posts(1)November 29, 2005, 7:05 pmIt worked before - accessing table twice in SqlExpress2005
Posts(2)November 29, 2005, 7:05 pm2005 Pivot Question - Not returning data..not sure what i did.
Posts(7)November 29, 2005, 7:05 pmINSERT many records with one statement
Posts(6)November 29, 2005, 7:05 pmTable Name
Posts(7)November 29, 2005, 7:05 pmCLR problems
Posts(7)November 29, 2005, 7:05 pmSyntax error
Posts(5)November 29, 2005, 7:05 pmNeed help with a query
Posts(1)November 29, 2005, 7:05 pmEnable Logging For Severity Errors Lower Than 19
Posts(3)November 29, 2005, 7:05 pmxml and sql
Posts(7)November 29, 2005, 7:05 pmsimple query
Posts(3)November 29, 2005, 7:05 pmexport data to .xls from stored procedure
Posts(8)November 29, 2005, 7:05 pmJOIN Query Problem
Posts(7)November 29, 2005, 7:05 pmidentity in the resultset
Posts(7)November 29, 2005, 8:00 amImport large xml document into sql server 2005
Posts(3)November 29, 2005, 8:00 amERROR: Must declare the scalar variable (@Date_ID)
Posts(6)November 29, 2005, 8:00 amChange condition if the first doesn't exists
Posts(7)November 29, 2005, 8:00 amHow to write script Update defaults
Posts(3)November 29, 2005, 8:00 amTimestamp Alter Table
Posts(2)November 29, 2005, 8:00 amBULK INSERT with leading/trailing quotes
Posts(3)November 29, 2005, 8:00 amhelp with query
Posts(2)November 29, 2005, 4:00 amWriting code to do a dynamic insert
Posts(2)November 29, 2005, 4:00 amMaintaining a Date/Time Last Updated Value
Posts(2)November 29, 2005, 4:00 amRe: Update requires a valid UpdateCommand when passed DataRow coll
Posts(2)November 29, 2005, 4:00 amusing login name as variable in grant statement
Posts(3)November 29, 2005, 4:00 amGet files from FTP using DTS
Posts(3)November 29, 2005, 4:00 amBatchOptimistic
Posts(2)November 29, 2005, 4:00 amBest practice for remote queries
Posts(4)November 29, 2005, 1:39 amRun Job From TSQL
Posts(9)November 28, 2005, 9:59 pmRe-raising error
Posts(1)November 28, 2005, 9:59 pmRe: Update requires a valid UpdateCommand when passed DataRow collecti
Posts(7)November 28, 2005, 9:59 pmStored Procedures and the GetTime() function
Posts(12)November 28, 2005, 9:59 pmCalculate New 'Unique' Records Each Day
Posts(1)November 28, 2005, 9:59 pmI think I've got it...
Posts(1)November 28, 2005, 9:59 pmHow can I get file list under a special directory on a remote sql server?
Posts(1)November 28, 2005, 9:59 pmNearly...
Posts(3)November 28, 2005, 7:05 pmScript Out T-SQL Code Programmatically
Posts(2)November 28, 2005, 7:05 pmAn INSERT EXEC statement cannot be nested.
Posts(1)November 28, 2005, 7:05 pmANN: AGS SQL Server 2005 Utilities Update
Posts(11)November 28, 2005, 7:05 pmCursors always reads from physical disk (SQL Server 2000)?
Posts(10)November 28, 2005, 7:05 pmReturning row value before deletion
Posts(6)November 28, 2005, 7:05 pmDELETING ROW DATA
Posts(4)November 28, 2005, 7:05 pminsert a random password
Posts(1)November 28, 2005, 7:05 pmBatchOptimistic
Posts(3)November 28, 2005, 7:05 pmChinese character in the field (Sql 7)
Posts(2)November 28, 2005, 7:05 pmQry with "OR" keyword assistance...
Posts(5)November 28, 2005, 7:05 pmCount Varchar
Posts(6)November 28, 2005, 7:05 pmHow Can I Do This
Posts(4)November 28, 2005, 7:05 pmColumn Alias Behavior
Posts(3)November 28, 2005, 7:05 pmUrgent: SQL Help
Posts(3)November 28, 2005, 7:05 pmFastest way to convert scripts to use Linked Server?
Posts(5)November 28, 2005, 7:05 pm> Date
Posts(7)November 28, 2005, 7:05 pmIncrease nvarchar field value like a num
Posts(2)November 28, 2005, 7:05 pmStored Procedure Automation Problem
Posts(5)November 28, 2005, 7:05 pmhowto sp_adduser
Posts(4)November 28, 2005, 7:05 pmCLR Return Types
Posts(2)November 28, 2005, 7:05 pmDTS Error checking
Posts(5)November 28, 2005, 7:05 pmHow to Job on Remote Server
Posts(3)November 28, 2005, 7:05 pmCreating Schema
Posts(5)November 28, 2005, 7:05 pmSelect Query-Urgent
Posts(2)November 28, 2005, 7:05 pmChanging Column Name
Posts(2)November 28, 2005, 7:05 pmGroup by issue for a cross tab report
Posts(1)November 28, 2005, 7:05 pmRe: Is there alternative to T-SQL USE <dbname> where <dbname> is v
Posts(1)November 28, 2005, 7:05 pmRe: Is there alternative to T-SQL USE <dbname> where <dbname> is v
Posts(1)November 28, 2005, 7:05 pmRe: Is there alternative to T-SQL USE <dbname> where <dbname> is v
Posts(4)November 28, 2005, 7:05 pmStored Procedures and Return Codes...
Posts(12)November 28, 2005, 7:59 amQuery help
Posts(5)November 28, 2005, 7:59 amInformation Schema Query on linked server fails.
Posts(5)November 28, 2005, 7:59 amTime Series processing pattern (not data mining)?
Posts(6)November 28, 2005, 7:59 amDynamic calculation
Posts(5)November 28, 2005, 7:59 amSMO SqlExpress Create Database Datafile
Posts(6)November 28, 2005, 7:59 amCan I use the 'IF' clause in a 'WHERE' clause ?
Posts(6)November 28, 2005, 7:59 amNaming checkboxes
Posts(2)November 28, 2005, 7:59 amCASE Syntax
Posts(2)November 28, 2005, 7:59 amdatediff
Posts(3)November 28, 2005, 7:59 amHelp with a Stored Procedure..
Posts(3)November 28, 2005, 7:59 amquery a sorted view by rows
Posts(3)November 28, 2005, 3:58 amInner / Outer Cursors
Posts(2)November 28, 2005, 3:58 amSearching Field Name and Value in Database
Posts(1)November 28, 2005, 3:58 amRE: A floating point exception occurred in the user process.
Posts(7)November 28, 2005, 3:58 amCreating Identity Field
Posts(4)November 28, 2005, 3:58 amHow to use/create triggers in sql server 2000
Posts(2)November 28, 2005, 3:58 amDelete Excel data using OpenRowSet
Posts(9)November 28, 2005, 3:58 amRanking of search results
Posts(4)November 28, 2005, 3:58 amCombine 2 tables
Posts(6)November 28, 2005, 3:58 amSelect statement Help
Posts(12)November 27, 2005, 9:58 pmYet another SQL paging solution
Posts(19)November 27, 2005, 9:58 pmGrouping,Paging Logic
Posts(2)November 27, 2005, 7:03 pmmoney for nothing that works
Posts(6)November 27, 2005, 7:03 pmFind Match Count
Posts(14)November 27, 2005, 7:03 pmindex and query optimization plzzz
Posts(4)November 27, 2005, 7:03 pmWhat is the impact of implementing expected Rollbacks
Posts(4)November 27, 2005, 7:03 pmSaving New Diagrams
Posts(2)November 27, 2005, 7:03 pmschedule
Posts(3)November 27, 2005, 7:03 pmNeed help setting default value of a field
Posts(6)November 27, 2005, 7:03 pmWhat am I doing wrong??
Posts(4)November 27, 2005, 7:03 pmRetrieving grouped data
Posts(5)November 27, 2005, 7:03 pmA cursor performance related question
Posts(1)November 27, 2005, 7:03 pmAnnounce: Win32::SqlServer - access SQL Server from Perl
Posts(3)November 27, 2005, 7:57 amHow to return a set of Data ?
Posts(6)November 27, 2005, 7:57 amquery help
Posts(17)November 26, 2005, 9:58 pmTrasform columns to rows
Posts(4)November 26, 2005, 9:58 pmStored procedure Or View
Posts(10)November 26, 2005, 7:01 pmEnumerating SQL Server database tables rows and sprocs using MFC
Posts(13)November 26, 2005, 7:01 pmDynamic WHERE & Dates
Posts(3)November 26, 2005, 7:01 pmFailing inner join
Posts(3)November 26, 2005, 7:01 pmusing variable with INSERT INTO statement
Posts(3)November 26, 2005, 3:59 amQuery Help
Posts(5)November 26, 2005, 3:59 amDynamic Sql Intermittenetly Slow - Losing Hair Fast
Posts(3)November 26, 2005, 3:59 amHow to get the most new value registered...
Posts(1)November 26, 2005, 3:59 amRe: Delete Query ?
Posts(1)November 26, 2005, 3:59 amRe: Delete Query ?
Posts(8)November 25, 2005, 7:02 pmDISTINCT MonthName for a lot of dates....
Posts(1)November 25, 2005, 7:02 pmCOUNT - a little help please..
Posts(9)November 25, 2005, 7:02 pmStill struggling w/ LAST transaction date!!!
Posts(3)November 25, 2005, 7:02 pmWhat backup files do I need to keep?
Posts(4)November 25, 2005, 7:02 pmSQL dateadd
Posts(4)November 25, 2005, 7:02 pmGetting value from SP
Posts(1)November 25, 2005, 7:02 pmRe: Delete Query ?
Posts(7)November 25, 2005, 7:02 pmUnique pairs
Posts(12)November 25, 2005, 7:02 pmtransactions
Posts(7)November 25, 2005, 7:02 pmSum() And Nulls
Posts(4)November 25, 2005, 7:02 pmUpdate only x records but also depending on a given order.
Posts(2)November 25, 2005, 7:02 pmJAVA Total
Posts(3)November 25, 2005, 7:02 pmExecute SQL based on number rows in two tables
Posts(3)November 25, 2005, 7:02 pmBooks for Yokun
Posts(2)November 25, 2005, 7:02 pmtransfer data from sql on WINNT to SQL on 2000
Posts(2)November 25, 2005, 7:02 pmT-SQL Debugger Proglem.
Posts(2)November 25, 2005, 7:02 pmOLE DB provider name
Posts(7)November 25, 2005, 7:02 pmMSDN SQL 2005 versions
Posts(2)November 25, 2005, 7:02 pmSQL Express 2005
Posts(3)November 25, 2005, 7:02 pmDebug Stored Procedure
Posts(6)November 25, 2005, 7:02 pmReturn value
Posts(3)November 25, 2005, 7:02 pmXML Schema
Posts(8)November 25, 2005, 7:02 pmDynamic Stored Procedure
Posts(7)November 25, 2005, 7:02 pmDatabase design problem
Posts(4)November 25, 2005, 7:02 pmMore Efficient way to Concat Rows
Posts(2)November 25, 2005, 7:02 pmDTS: Transform Data Task with ActiveX
Posts(6)November 25, 2005, 7:02 pmuninstall Sql Server 2005 Beta
Posts(4)November 25, 2005, 7:02 pmUse trigger to check data in another tablw
Posts(2)November 25, 2005, 7:02 pmSearching records with 'like'
Posts(5)November 25, 2005, 7:02 pmTable Hints
Posts(19)November 25, 2005, 7:58 amComposing a date from date parts
Posts(3)November 25, 2005, 7:58 amget fields for Process Info
Posts(6)November 25, 2005, 7:58 amCancel Trigger
Posts(10)November 25, 2005, 7:58 amSELECT statement help needed
Posts(3)November 25, 2005, 7:58 amHow to determine default values of a field during runtime
Posts(11)November 25, 2005, 3:58 amSQL 2005: Table variable problem
Posts(16)November 25, 2005, 3:58 amDebug sp from Business Intelligence Dev Studio?
Posts(3)November 25, 2005, 3:58 amSQL statement help please
Posts(4)November 25, 2005, 3:58 amtransfer data from sql on WINNT to SQL on 2000
Posts(4)November 25, 2005, 3:58 amusing like keyword with variable
Posts(2)November 24, 2005, 9:57 pmdelete BLOB objects
Posts(2)November 24, 2005, 9:57 pmModify data structure
Posts(2)November 24, 2005, 9:57 pmMS SQL Query statement.
Posts(6)November 24, 2005, 7:01 pmselecting from a 6 month date range
Posts(8)November 24, 2005, 7:01 pmDynamic insert into table with datetime and int columns



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

Copyright 2008 codecomments.com