For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > May 2005









Pages: [1] 2 3 4 5 6 7

Posts(6)May 31, 2005, 9:00 pmInsert data between 2 same tables
Posts(2)May 31, 2005, 9:00 pmRelationship across databases
Posts(4)May 31, 2005, 9:00 pmdivide by zero error
Posts(2)May 31, 2005, 9:00 pmcomplex query help - count
Posts(3)May 31, 2005, 9:00 pmError converting data type nvarchar to int (when calling a proc)
Posts(1)May 31, 2005, 9:00 pmRE: Need help with update/select statements please.
Posts(3)May 31, 2005, 9:00 pmLinked Server Error
Posts(1)May 31, 2005, 9:00 pmRE: How can I launch a plain file with DMO?
Posts(1)May 31, 2005, 9:00 pmHow can I launch a plain file with DMO?
Posts(8)May 31, 2005, 9:00 pmCopy data from one MS SQL database to another
Posts(2)May 31, 2005, 9:00 pmQuery help
Posts(4)May 31, 2005, 9:00 pmHow can I launch a plain file with DML instructions inside?
Posts(3)May 31, 2005, 9:00 pmQuery as shortdatetime field
Posts(5)May 31, 2005, 9:00 pmURGENT: Replication via T-SQL
Posts(4)May 31, 2005, 9:00 pmAny command list the tables in the Databsae
Posts(2)May 31, 2005, 9:00 pmForward copying log data
Posts(1)May 31, 2005, 9:00 pmRE: Error converting data type nvarchar to int (when calling a pro
Posts(9)May 31, 2005, 9:00 pmsql server vs express
Posts(2)May 31, 2005, 9:00 pmFTP related
Posts(4)May 31, 2005, 9:00 pmsimple query help
Posts(2)May 31, 2005, 9:00 pmIndexed View Help
Posts(7)May 31, 2005, 9:00 pmDate Syntax
Posts(1)May 31, 2005, 9:00 pmInsert with an XML var in Yukon
Posts(2)May 31, 2005, 9:00 pmAny help on application that works like a profiler
Posts(5)May 31, 2005, 9:00 pmwhat am I doing wrong with the CASE statement?
Posts(3)May 31, 2005, 9:00 pmsum and divide by zero query
Posts(3)May 31, 2005, 4:04 pmAutomatic Date Field
Posts(3)May 31, 2005, 4:04 pmQuery help (repost)
Posts(2)May 31, 2005, 4:04 pmSQL Columns
Posts(1)May 31, 2005, 4:04 pmListAvailableSQLServers - picking up sybase boxes
Posts(1)May 31, 2005, 4:04 pmtest
Posts(2)May 31, 2005, 4:04 pmUpdate procedure help
Posts(3)May 31, 2005, 4:04 pmDISTRIBUTED TRANSACTION with OLE DB Jet
Posts(6)May 31, 2005, 9:12 amFinding the smallest available ID for a row
Posts(4)May 31, 2005, 9:12 amPassing Table data type as Param to a function
Posts(6)May 31, 2005, 9:12 amSELECT Distinct
Posts(3)May 31, 2005, 9:12 amUser-defined function
Posts(4)May 31, 2005, 9:12 amUK Postcode Masks
Posts(3)May 31, 2005, 9:12 aminconsistancy in execution time of SP. Need help.
Posts(2)May 31, 2005, 9:12 amsp_OACreate and DDLHost.exe
Posts(2)May 31, 2005, 9:12 amHow to install vs.net 2005 and sql server 2005 beta 2 on the same
Posts(2)May 31, 2005, 9:12 amParameter passing to a DTS package
Posts(3)May 31, 2005, 9:12 amCrosstab queries in MS SQL
Posts(2)May 31, 2005, 4:02 amquery between 2 dates error
Posts(6)May 31, 2005, 4:02 amSQL QUERY
Posts(5)May 31, 2005, 4:02 amDatabase Design - How do I model a product availability matrix?
Posts(2)May 31, 2005, 4:02 amTimeout expired.
Posts(2)May 31, 2005, 4:02 amUsing locks
Posts(5)May 31, 2005, 4:02 amDrop index error
Posts(13)May 30, 2005, 8:58 pmThe Case For GUID; Surrogate Key Alternatives
Posts(3)May 30, 2005, 8:58 pmHigh volume batch insert
Posts(5)May 30, 2005, 4:01 pmPassing explicit date formats to stored procs
Posts(4)May 30, 2005, 4:01 pmcan Password be hacked?
Posts(1)May 30, 2005, 4:01 pmRe: Passing Table data type as Param to a function
Posts(7)May 30, 2005, 4:01 pmMultiple FK or "TableName" column?
Posts(1)May 30, 2005, 4:01 pmUk Shoppers - Discount Vouchers and Promotional Codes -
Posts(11)May 30, 2005, 4:01 pmHelp with query
Posts(5)May 30, 2005, 4:01 pmDisabling table constraints and Transactions
Posts(6)May 30, 2005, 4:01 pmHow to use DCount function
Posts(10)May 30, 2005, 4:01 pmMigrating from RMS III
Posts(4)May 30, 2005, 4:01 pmHow ?
Posts(2)May 30, 2005, 4:01 pmencrypte strings and numbers
Posts(7)May 30, 2005, 9:00 amHow do I Filter by Current Date
Posts(2)May 30, 2005, 9:00 amgrant to all objects
Posts(8)May 30, 2005, 3:59 amEM can't connect to server
Posts(8)May 30, 2005, 3:59 amDate query
Posts(2)May 30, 2005, 3:59 amshow ???? in datafield
Posts(5)May 30, 2005, 3:59 amOutput prameters sometimes null when they should have values
Posts(5)May 29, 2005, 8:57 pmNeed View to return "NULL" values
Posts(2)May 29, 2005, 3:58 pmSome simple questions
Posts(4)May 29, 2005, 3:58 pmSQL Server EM/Query Analyzer Access
Posts(3)May 29, 2005, 3:58 pmError handling?!
Posts(2)May 29, 2005, 3:58 pmPerformance of "SELECT COUNT(*) FROM X WHERE Y" queries
Posts(8)May 29, 2005, 8:58 amRecursive rows in table and deletion problem
Posts(2)May 29, 2005, 8:58 amError Handling
Posts(1)May 29, 2005, 8:58 amStupid
Posts(1)May 29, 2005, 8:58 amHorny Teen Girls
Posts(2)May 29, 2005, 8:58 amLinked Server and Remote Server
Posts(2)May 29, 2005, 4:01 amcombine values in view?
Posts(5)May 28, 2005, 8:57 pmNo Cursor
Posts(5)May 28, 2005, 8:57 pmSelect best data from a group of related records
Posts(5)May 28, 2005, 8:57 pmSave Table Definitions to Text File?
Posts(2)May 28, 2005, 3:59 pmCan?
Posts(4)May 28, 2005, 3:59 pmDisplay pictures in Northwind on the VB form
Posts(2)May 28, 2005, 3:59 pmchange charset
Posts(8)May 28, 2005, 3:59 pmSend Mail with SQL Server issue
Posts(2)May 28, 2005, 3:59 pmThere's got to be an easy way
Posts(3)May 28, 2005, 3:59 pmfinding the letters
Posts(2)May 28, 2005, 3:59 pmDebugging Stored Proc
Posts(1)May 28, 2005, 3:59 pmTeens4cash
Posts(1)May 28, 2005, 8:58 amClick please
Posts(3)May 28, 2005, 3:59 amcreate procedure for 'search agent'
Posts(6)May 28, 2005, 3:59 amMode and Median functions in SQL 2000
Posts(2)May 28, 2005, 3:59 amextended procedures
Posts(5)May 28, 2005, 3:59 amWhy Output
Posts(3)May 27, 2005, 8:59 pmComplex File Import
Posts(5)May 27, 2005, 8:59 pmImproving performance of SPs
Posts(4)May 27, 2005, 8:59 pmhow to delete distribution database
Posts(13)May 27, 2005, 8:59 pmImplementing natural keys
Posts(4)May 27, 2005, 8:59 pm"Insufficient key column information for updating and refreshing"
Posts(20)May 27, 2005, 8:59 pmProblem with EXEC command
Posts(9)May 27, 2005, 8:59 pmTSQL - data manipulation
Posts(4)May 27, 2005, 8:59 pmPossible to drop IDENTITY from a column?
Posts(7)May 27, 2005, 8:59 pmhow to aduit database access?
Posts(5)May 27, 2005, 8:59 pmNewbie: UPDATE a Table
Posts(2)May 27, 2005, 8:59 pmRE: Centralizing Two Stored Procedure Queries (one using Cursor Ou
Posts(1)May 27, 2005, 8:59 pmUser-Defined string Functions Transact-SQL (new)
Posts(6)May 27, 2005, 8:59 pmDrop all indexes
Posts(1)May 27, 2005, 8:59 pmDTS Export Problem
Posts(3)May 27, 2005, 8:59 pmGetting Strange Execution Plan w/ DBCC
Posts(2)May 27, 2005, 8:59 pmANSI NULLS performance impact
Posts(1)May 27, 2005, 8:59 pmRE: Centralizing Two Stored Procedure Queries (one using Cursor Ou
Posts(1)May 27, 2005, 8:59 pmCentralizing Two Stored Procedure Queries (one using Cursor Output
Posts(2)May 27, 2005, 8:59 pmfile operations
Posts(1)May 27, 2005, 8:59 pmRE: Centralizing Two Stored Procedure Queries (one using Cursor Output
Posts(1)May 27, 2005, 8:59 pmThanks for RE: Multiple FK or "TableName" column?
Posts(8)May 27, 2005, 8:59 pmOuter Joins
Posts(11)May 27, 2005, 8:59 pmdatabase size
Posts(8)May 27, 2005, 8:59 pmGrouping Data By Weeks
Posts(7)May 27, 2005, 8:59 pmProblems with duplicate data
Posts(5)May 27, 2005, 4:03 pmpartitioned view goofiness
Posts(9)May 27, 2005, 4:03 pmConfused over query cost of execution plan
Posts(8)May 27, 2005, 4:03 pmCopy Database
Posts(2)May 27, 2005, 4:03 pmbackup and restore script
Posts(6)May 27, 2005, 4:03 pmSimple Question (I hope)
Posts(2)May 27, 2005, 4:03 pmSubstring with text datatype column in BOL - typo??
Posts(4)May 27, 2005, 4:03 pmLast Function in SQL Server ?
Posts(3)May 27, 2005, 4:03 pmArithmetic overflow error converting numeric to data type numeric
Posts(4)May 27, 2005, 4:03 pmImporting data with leading 0
Posts(3)May 27, 2005, 4:03 pmMSDTC
Posts(4)May 27, 2005, 4:03 pm32 bit SQLDMO code on a 64 bit server
Posts(8)May 27, 2005, 4:03 pmSet Operations in TSQL
Posts(14)May 27, 2005, 4:03 pmSearch multiple columns?
Posts(10)May 27, 2005, 4:03 pmInner join in an Update
Posts(6)May 27, 2005, 4:03 pmORDER BY before UNION syntax error
Posts(4)May 27, 2005, 4:03 pmIndexes on SQL Server
Posts(7)May 27, 2005, 4:03 pmProblems with an INSERT SP
Posts(6)May 27, 2005, 4:03 pmSQL Query with Current date + 30 days
Posts(2)May 27, 2005, 4:03 pmCalling WS from Sproc
Posts(7)May 27, 2005, 4:03 pmadd column to exiting table
Posts(4)May 27, 2005, 4:03 pmRow size increase....
Posts(2)May 27, 2005, 4:03 pmPage Checksums?
Posts(3)May 27, 2005, 8:58 amHow to be quickest
Posts(4)May 27, 2005, 8:58 amDynamic creation of Column Transformations
Posts(3)May 27, 2005, 8:58 amChange Unicode to MBCS
Posts(2)May 27, 2005, 8:58 amattach/detach db by user with no priviliges
Posts(4)May 27, 2005, 8:58 amAudit Trail - getting the current username.
Posts(6)May 27, 2005, 8:58 amView of Joined Tables
Posts(8)May 27, 2005, 8:58 amDelete Duplicate
Posts(1)May 27, 2005, 8:58 amRe: Problems with an INSERT SP - THANKS
Posts(3)May 27, 2005, 4:03 amleft join
Posts(7)May 27, 2005, 4:03 amSmall letter and numeric number in Tabel field
Posts(12)May 26, 2005, 9:02 pmGOOGLE Like search database
Posts(17)May 26, 2005, 9:02 pmHypothetically speaking...
Posts(4)May 26, 2005, 9:02 pmInteger Index -vs- nVarChar(50) index....
Posts(11)May 26, 2005, 9:02 pmSQL Question
Posts(5)May 26, 2005, 9:02 pmT-SQL Question
Posts(4)May 26, 2005, 9:02 pmTemp table permission
Posts(1)May 26, 2005, 9:02 pmRe: Unexpected behaviour from SQL Server SP4 in combination with
Posts(3)May 26, 2005, 9:02 pmConsolidate two UPDATE statements into on
Posts(3)May 26, 2005, 9:02 pmWhy does SqlConnection.Open work when it shouldn't?
Posts(3)May 26, 2005, 9:02 pmalways reporting error to client
Posts(2)May 26, 2005, 9:02 pmInvalid Keyword Color
Posts(19)May 26, 2005, 9:01 pmInserting records in a User-Defined Function
Posts(15)May 26, 2005, 9:01 pmRemoving IDENTITY from existing column
Posts(4)May 26, 2005, 9:01 pmDisplays commas in type FLOAT
Posts(2)May 26, 2005, 9:01 pmquery help needed
Posts(5)May 26, 2005, 9:01 pmProblem with ASP
Posts(13)May 26, 2005, 4:02 pmHierarchical Query
Posts(4)May 26, 2005, 4:02 pmopenrowset question (T-SQL)
Posts(6)May 26, 2005, 4:02 pmhelp with store procedure - getting results from 3 queries
Posts(3)May 26, 2005, 4:02 pmRemove headers in SQL Query analyzer when making a query
Posts(2)May 26, 2005, 4:02 pmauto increase text!
Posts(3)May 26, 2005, 4:02 pmConditionally skip or jump steps in a job
Posts(4)May 26, 2005, 4:02 pmreplication with java
Posts(3)May 26, 2005, 4:02 pmNot For Replication Option
Posts(3)May 26, 2005, 4:02 pmNeed help with SELECT statement Please.
Posts(2)May 26, 2005, 4:02 pmADSI Group Members and SQL
Posts(3)May 26, 2005, 4:02 pmAVOID merge joins
Posts(10)May 26, 2005, 4:02 pmQuery Assistance - Average Days Between Services
Posts(6)May 26, 2005, 4:02 pmDistinct list
Posts(4)May 26, 2005, 4:02 pmduplicates
Posts(2)May 26, 2005, 4:02 pmConversion query
Posts(5)May 26, 2005, 4:01 pmTSQL Case Statement with multiple criteria in SQL 2K
Posts(9)May 26, 2005, 4:01 pmLIKE vs Equals
Posts(1)May 26, 2005, 4:01 pmRe: Convert VB.NET to TSQL PROC & Reference a Proc from another
Posts(3)May 26, 2005, 4:01 pmProc Result
Posts(3)May 26, 2005, 4:01 pmApplying business rules to the database
Posts(3)May 26, 2005, 4:01 pmStart SP on timer
Posts(1)May 26, 2005, 4:01 pmRe: Adjusted and it works now, thank you.
Posts(8)May 26, 2005, 4:01 pmDynamic Column Alias Name...
Posts(3)May 26, 2005, 4:01 pmFind Like Records with similar field data
Posts(16)May 26, 2005, 4:01 pmWhere clause help
Posts(4)May 26, 2005, 4:01 pm1 to (1,2) relationship
Posts(4)May 26, 2005, 4:01 pmAdvanced programming examples ?
Posts(1)May 26, 2005, 4:01 pmRe: multiple table joins, does the "ON" clause determine which two
Posts(3)May 26, 2005, 4:01 pmusing format files for fixed width data source
Posts(4)May 26, 2005, 4:01 pmIf Update AND If Delete sections in one trigger?
Posts(4)May 26, 2005, 9:01 amSQL SUM function return length formatting
Posts(5)May 26, 2005, 9:01 amCONTAINS not working



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

Copyright 2008 codecomments.com