For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > May 2006









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

Posts(7)May 31, 2006, 10:06 pmQueries with Dates
Posts(6)May 31, 2006, 10:06 pmAccessing stored proc multiple return values
Posts(2)May 31, 2006, 10:06 pmHow SUSER_SNAME works?
Posts(3)May 31, 2006, 10:06 pmSQL2K & SQL2005, Can they coexist?
Posts(1)May 31, 2006, 7:14 pmRe: using master..sysdatabase return an error message in MSSQL 200
Posts(4)May 31, 2006, 7:14 pmChanging all Int to Bigint
Posts(3)May 31, 2006, 7:14 pmsql question
Posts(3)May 31, 2006, 7:14 pmMOD Equivalent in SQl Server?
Posts(3)May 31, 2006, 7:14 pmSub-Query
Posts(2)May 31, 2006, 7:14 pmusing master..sysdatabase return an error message in MSSQL 2005
Posts(27)May 31, 2006, 7:14 pmSQL99 Question : Why No Boolean Value Columns
Posts(24)May 31, 2006, 7:14 pmHow can I run sp_adduser in a trigger?
Posts(2)May 31, 2006, 7:14 pmPIVOT ISSUE
Posts(8)May 31, 2006, 7:14 pmNeed to select random records from a given query
Posts(4)May 31, 2006, 7:14 pmParameter Queries
Posts(1)May 31, 2006, 7:14 pmSystem.Data.OracleClient
Posts(1)May 31, 2006, 7:14 pmconvert sql express to my sql
Posts(1)May 31, 2006, 7:14 pmRe: SQL inserts random CHR(13) into stored procedures -NEW OBSERVATION
Posts(4)May 31, 2006, 7:14 pmRun Script from drive location
Posts(3)May 31, 2006, 7:14 pmsp_executesql not working
Posts(1)May 31, 2006, 7:14 pmRE: How can I implement error handling within a SQL script that us
Posts(4)May 31, 2006, 7:14 pmCombine two int columns into one bigint column
Posts(5)May 31, 2006, 7:14 pmgenerating DDL
Posts(2)May 31, 2006, 7:14 pmarchitecture question: not representing inheritance in the data model
Posts(5)May 31, 2006, 7:14 pmorder by day
Posts(2)May 31, 2006, 7:14 pmRE: architecture question: not representing inheritance in the data mo
Posts(6)May 31, 2006, 7:14 pmSimple Question - update statment
Posts(1)May 31, 2006, 7:14 pmHow to assign values to multiple fields from Stored proc
Posts(5)May 31, 2006, 8:15 amword suggest
Posts(3)May 31, 2006, 8:15 amHow to add same user to diff DBs on diff Servers?
Posts(4)May 31, 2006, 8:15 amView for accumulate data
Posts(2)May 31, 2006, 8:15 amPass record to user-defined function and create xml
Posts(6)May 31, 2006, 8:15 amSelect - Basic Question
Posts(1)May 31, 2006, 8:15 amMOM SQL Server deadlocks
Posts(4)May 31, 2006, 8:15 amChecking for duplicates
Posts(4)May 31, 2006, 8:15 amlinked server 2005 problems
Posts(10)May 31, 2006, 8:15 amCan we update the table in user defined function
Posts(9)May 31, 2006, 8:15 amData type problem
Posts(7)May 31, 2006, 8:15 amUsing Aggregate functions in joins
Posts(1)May 31, 2006, 8:15 amoracle procedure call from sql server
Posts(4)May 31, 2006, 4:15 amReplicating Table
Posts(4)May 31, 2006, 4:15 amCopying a table form one database to another
Posts(6)May 31, 2006, 4:15 amLeading zero's
Posts(6)May 31, 2006, 4:15 amGlobal Function in 2005
Posts(6)May 31, 2006, 4:15 amStored Procedure input string parameter
Posts(2)May 31, 2006, 4:15 amQuestion for changing results in sql
Posts(3)May 31, 2006, 4:15 amRandom error - Insert Into Table1 Select * From Table2
Posts(1)May 31, 2006, 4:15 amOpenQuery problem
Posts(3)May 30, 2006, 10:05 pmUDFs, Determinism and Constraints in SQL Server 2000
Posts(1)May 30, 2006, 10:05 pmRe: SQL inserts random CHR(13) into stored procedures -NEW OBSERVATION
Posts(10)May 30, 2006, 10:05 pmCross Referencing The Same Table
Posts(9)May 30, 2006, 7:14 pmCmdExec issue
Posts(14)May 30, 2006, 7:14 pmUsing Materialized Path to create a paths table
Posts(5)May 30, 2006, 7:14 pmlock_timeout error
Posts(17)May 30, 2006, 7:14 pmNeed help on database design for serving delayed data
Posts(5)May 30, 2006, 7:14 pmerror-checking all in one place
Posts(8)May 30, 2006, 7:14 pmCount results in colums instead of rows
Posts(3)May 30, 2006, 7:14 pmConversion of Char to SmallDateTime
Posts(3)May 30, 2006, 7:14 pmExtract a character string from a text field
Posts(5)May 30, 2006, 7:14 pmtrailing spaces in columns
Posts(4)May 30, 2006, 7:14 pmwatching a column value
Posts(2)May 30, 2006, 7:14 pm[OT] User-Defined string Functions Transact-SQL
Posts(14)May 30, 2006, 7:14 pmStored Proc Doesn't Run in Shell Script, but gives no errors
Posts(7)May 30, 2006, 7:14 pmquarter date
Posts(1)May 30, 2006, 7:14 pmWindow Application in .Net
Posts(1)May 30, 2006, 7:14 pmSaving Text Information in a column
Posts(11)May 30, 2006, 7:14 pmSelect date range with no minutes
Posts(2)May 30, 2006, 7:14 pmExtra Trailing Whitespace Doesn't Violate Foreign Key Constraint???
Posts(5)May 30, 2006, 7:14 pmSQL help please
Posts(3)May 30, 2006, 7:14 pmFast Query
Posts(1)May 30, 2006, 7:14 pmRe: Does a cursor re-execute the select statement everytime it loo
Posts(4)May 30, 2006, 7:14 pmIIF
Posts(1)May 30, 2006, 7:14 pmRE: Does a cursor re-execute the select statement everytime it loo
Posts(4)May 30, 2006, 7:14 pmDoes a cursor re-execute the select statement everytime it loops?
Posts(2)May 30, 2006, 7:14 pmRE: How do I returned most recently stored record with multiple record
Posts(4)May 30, 2006, 7:14 pmCan SQL search for a .txt document
Posts(2)May 30, 2006, 7:14 pmProblems with ER in msde.
Posts(1)May 30, 2006, 7:14 pmRe: How do I returned most recently stored record with multiple record
Posts(2)May 30, 2006, 7:14 pmParameter transfer over View on linked servers
Posts(2)May 30, 2006, 7:14 pmHelp with error 3274
Posts(2)May 30, 2006, 7:14 pmAlter Table in Stored Procedure
Posts(3)May 30, 2006, 7:14 pmxp_cmdshell in SQL 2005
Posts(2)May 30, 2006, 7:14 pmSSIS task
Posts(7)May 30, 2006, 7:14 pmaverage question
Posts(3)May 30, 2006, 7:14 pmRE: Extra Trailing Whitespace Doesn't Violate Foreign Key Constrai
Posts(3)May 30, 2006, 7:14 pmHelp with Auto Notifications
Posts(1)May 30, 2006, 7:14 pmRE: Extra Trailing Whitespace Doesn't Violate Foreign Key Constraint??
Posts(1)May 30, 2006, 7:14 pmTrigger Help
Posts(2)May 30, 2006, 7:14 pmeditor + VS 2005 ?
Posts(1)May 30, 2006, 7:14 pmRE: How do I returned most recently stored record with multiple record
Posts(1)May 30, 2006, 7:14 pmRE: How do I returned most recently stored record with multiple record
Posts(3)May 30, 2006, 7:14 pmChange Notification needed in .NET
Posts(1)May 30, 2006, 8:08 amRE: Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after
Posts(1)May 30, 2006, 8:08 amHow do I returned most recently stored record with multiple records?
Posts(8)May 30, 2006, 8:08 amUpdate statement for linked server
Posts(2)May 30, 2006, 8:08 amSending simple email from SQL server
Posts(10)May 30, 2006, 8:08 amabout store proc
Posts(1)May 30, 2006, 8:08 amRe: Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100%
Posts(1)May 30, 2006, 8:08 amRe: Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100%
Posts(1)May 30, 2006, 8:08 amRE: Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after chec
Posts(4)May 30, 2006, 8:08 amReturn Last 10 records
Posts(4)May 30, 2006, 4:14 amSQL Server 2005 SMTP and POP3 - Suggested Reading Please...
Posts(1)May 30, 2006, 4:14 amRE: Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after chec
Posts(4)May 30, 2006, 4:14 amHelp Me
Posts(8)May 30, 2006, 4:14 amselect top row from each group w/o using cursor - how?
Posts(9)May 30, 2006, 4:14 amSP NOT INSERTING BUT INCREASING @@IDENTITY
Posts(2)May 30, 2006, 4:14 amerror converting nvarchar to int
Posts(2)May 30, 2006, 4:14 amNeed help design the database for the scheduling task
Posts(1)May 30, 2006, 4:14 amObtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100% pass
Posts(4)May 29, 2006, 7:11 pmHow to call a stored procedure from a function
Posts(22)May 29, 2006, 7:11 pmSQL inserts random CHAR(13) into stored procedures
Posts(4)May 29, 2006, 7:11 pmRe: Recordset Find method vs. direct SELECT SQL statement - which is better performan
Posts(1)May 29, 2006, 7:11 pmRe: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigg
Posts(2)May 29, 2006, 7:11 pmRather Simple Logic - Need some advice
Posts(7)May 29, 2006, 7:11 pmDifferent Query perfromance on different machines
Posts(3)May 29, 2006, 7:11 pmParameter is null, return all?
Posts(3)May 29, 2006, 8:10 amerror-checking on INSERT
Posts(6)May 29, 2006, 8:10 amVariable appending
Posts(2)May 29, 2006, 8:10 amDMO Distribution Question
Posts(1)May 29, 2006, 8:10 amRe: Problems while migrating from MSSQL 2000 to 2005 - select... into fails in a trig
Posts(2)May 29, 2006, 8:10 amRe: transaction log full error - out of space - need help to troub
Posts(4)May 29, 2006, 4:18 amtransaction log full error - out of space - need help to troublesh
Posts(1)May 29, 2006, 4:18 amRe: Problems while migrating from MSSQL 2000 to 2005 - select... into fails in a trig
Posts(3)May 29, 2006, 4:18 amSQL Optimization
Posts(1)May 29, 2006, 4:18 amRe: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigg
Posts(5)May 28, 2006, 10:07 pm'ROW_NUMBER' is not a recognized function name.
Posts(1)May 28, 2006, 10:07 pmCannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger'
Posts(7)May 28, 2006, 7:12 pmMax() across 2 tables in one query?
Posts(4)May 28, 2006, 7:12 pmNeed Help on update trigger
Posts(4)May 28, 2006, 7:12 pmcommand scripts
Posts(4)May 28, 2006, 7:12 pmuse column value subquery
Posts(1)May 28, 2006, 7:12 pmRe: Recordset Find method vs. direct SELECT SQL statement - which is better performan
Posts(1)May 28, 2006, 8:08 amRe: Recordset Find method vs. direct SELECT SQL statement - which is better performan
Posts(1)May 28, 2006, 4:10 amRecordset Find method vs. direct SELECT SQL statement - which is better performance-w
Posts(3)May 27, 2006, 7:05 pmbcp, empty strings and null
Posts(4)May 27, 2006, 7:05 pmSQL query against data on tape...
Posts(3)May 27, 2006, 7:05 pmQuery - perhaps GROUP BY
Posts(7)May 27, 2006, 7:05 pmHelp with user defined function
Posts(2)May 27, 2006, 7:05 pmJoining three Tables in Sql Server
Posts(2)May 27, 2006, 7:05 pmisolation level
Posts(3)May 27, 2006, 7:05 pmTrying to improve Stored Procedure
Posts(9)May 27, 2006, 7:05 pmRe: BCP's /F switch - forposting.txt [1/1]
Posts(117)May 27, 2006, 8:07 aminsert into tbl1 select * from tbl2order by field1 doesnt work!
Posts(2)May 27, 2006, 8:07 amUsing ranges in between operator ?
Posts(3)May 27, 2006, 8:07 amSame query...???
Posts(2)May 27, 2006, 4:16 amTransaction option
Posts(12)May 27, 2006, 4:16 amGet last inserted PK
Posts(2)May 27, 2006, 4:16 amHow to: Dynamic crosstab procedure without aggregate functions for text
Posts(5)May 27, 2006, 4:16 amOPENQUERY vs. sp_executesql which is better?
Posts(3)May 27, 2006, 4:16 amStored Procedure
Posts(3)May 26, 2006, 10:04 pmss2k : maxdop matters with 1 cpu ... huh ?
Posts(3)May 26, 2006, 7:09 pmRe: Create Table In Store Procedure and inserting data with the Kalen user.
Posts(4)May 26, 2006, 7:09 pmBCP in using bcp_sendrow fails, not enough columns bound
Posts(2)May 26, 2006, 7:09 pmUDT in SQL 2005 and IDENTITY
Posts(7)May 26, 2006, 7:09 pmNeed help with poorly performing SPROC
Posts(3)May 26, 2006, 7:09 pmIndex Tuning Wizard is giving error message
Posts(10)May 26, 2006, 7:08 pmtemporary view
Posts(2)May 26, 2006, 7:08 pmTSQL INNER JOIN BETWEEN TWO DATABASES
Posts(4)May 26, 2006, 7:08 pmDatalist update function creates multiple instances of updated record
Posts(3)May 26, 2006, 7:08 pmTRIGGERS and LINKEDSERVER
Posts(2)May 26, 2006, 7:08 pmSSIS Problem
Posts(2)May 26, 2006, 7:08 pmReplication - Replicating the contents from a view to a Table
Posts(5)May 26, 2006, 7:08 pmpermissions needed for trigger
Posts(3)May 26, 2006, 7:08 pmtrouble connecting to a SS2K instance from SEM
Posts(3)May 26, 2006, 7:08 pmWhty backup master ?
Posts(2)May 26, 2006, 7:08 pmRE: How to: Dynamic crosstab procedure without aggregate functions for
Posts(28)May 26, 2006, 7:08 pmSQL Query HELP!!!
Posts(3)May 26, 2006, 7:08 pmUpdate Query Locks-up
Posts(2)May 26, 2006, 7:08 pmStoring User ID and Salted Hash Password
Posts(3)May 26, 2006, 7:08 pmMultiple DECLARE Sections ... why?
Posts(4)May 26, 2006, 7:08 pmstore procdure question
Posts(6)May 26, 2006, 7:08 pmCopying/ Deleting Huge Data from a table
Posts(5)May 26, 2006, 7:08 pmChanging the Recovery model of the database using scripts
Posts(5)May 26, 2006, 7:08 pmSelecting a row by row number
Posts(11)May 26, 2006, 7:08 pmUpdate if Delete fails
Posts(6)May 26, 2006, 7:08 pmConcatenated string as parm value
Posts(12)May 26, 2006, 8:07 amoperation on strings in a request
Posts(5)May 26, 2006, 8:07 amUPDLOCK
Posts(6)May 26, 2006, 8:07 amCopy database from an Sql server to another
Posts(3)May 26, 2006, 8:07 amFor Loop help
Posts(5)May 26, 2006, 4:13 amLinked Server VFP, error OLE DB
Posts(4)May 26, 2006, 4:13 amProblems Using a View of a View
Posts(1)May 26, 2006, 4:13 amFrog Belly Laminate Sexy Arse Wrapping
Posts(6)May 26, 2006, 4:13 amGet the SQL Server Unique ID of the Server
Posts(3)May 26, 2006, 4:13 amAutogenerate data
Posts(1)May 26, 2006, 4:13 amRE: Create Table In Store Procedure and inserting data with the Kalen
Posts(2)May 26, 2006, 4:13 amCursor and dynamic slq
Posts(3)May 26, 2006, 4:13 amDTS task
Posts(9)May 26, 2006, 4:13 amCan we specify the format of the date field in Format file
Posts(10)May 26, 2006, 4:13 amerror handing and IGNORE_DUP_KEY
Posts(11)May 26, 2006, 4:13 amSelect same column multiple times
Posts(4)May 26, 2006, 4:13 amNeed help inserting into row, not adding a row
Posts(2)May 26, 2006, 4:13 amFor Each Loop Container in SSIS
Posts(4)May 26, 2006, 4:13 amusing variable with quotes - do I need to use QuoteName?
Posts(4)May 26, 2006, 4:13 amHow to identify one sql server installation to another
Posts(3)May 26, 2006, 4:13 amLimiting Rows in a Report
Posts(3)May 26, 2006, 4:13 amUnpivot in T-SQL 2005
Posts(1)May 26, 2006, 4:13 amRe: literature for starting SQL users/ book to use SQL server as a backend for a MS A
Posts(2)May 25, 2006, 10:04 pmDebug SProcs
Posts(4)May 25, 2006, 10:04 pmLine 1: Incorrect syntax near 're'.



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

Copyright 2008 codecomments.com