For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > January 2005









Pages: [1] 2

Posts(3)January 31, 2005, 9:00 pmLeft Pad
Posts(3)January 31, 2005, 9:00 pmQuery help: What is the best and most efficient way to do this?
Posts(2)January 31, 2005, 9:00 pmxp_cmdshell returns NULL?
Posts(6)January 31, 2005, 9:00 pmselect the last record: better way?
Posts(15)January 31, 2005, 9:00 pmData Type Question
Posts(2)January 31, 2005, 9:00 pmRe: Query help: What is the best and most efficient way to do this
Posts(3)January 31, 2005, 9:00 pmWindows Authentication in SQLDMO
Posts(2)January 31, 2005, 9:00 pmIgnored words
Posts(1)January 31, 2005, 9:00 pmRe: Query help: What is the best and most efficient way to do this
Posts(3)January 31, 2005, 9:00 pmCalculating time elapsed (weekdays only)
Posts(2)January 31, 2005, 9:00 pmRelationships in EM
Posts(6)January 31, 2005, 9:00 pmdate time in WHERE clause
Posts(1)January 31, 2005, 4:01 pmIdeablade
Posts(2)January 31, 2005, 4:01 pmFilegroup Help
Posts(5)January 31, 2005, 4:01 pmThe identifier is too long in SQL 2000
Posts(1)January 31, 2005, 4:01 pmDB
Posts(5)January 31, 2005, 4:01 pmwhere clause
Posts(8)January 31, 2005, 4:01 pmInsert Binary Data with APOSTROPHE
Posts(9)January 31, 2005, 4:01 pmNumber of Columns
Posts(4)January 31, 2005, 4:01 pmQuery Question
Posts(5)January 31, 2005, 4:01 pmAuto fill collumn
Posts(5)January 31, 2005, 4:01 pmQuery help
Posts(10)January 31, 2005, 4:01 pmMore help with Contains
Posts(2)January 31, 2005, 4:01 pmtext data type
Posts(4)January 31, 2005, 4:01 pmStored Procedure -> Recordset
Posts(4)January 31, 2005, 4:01 pmsearching for % in a string
Posts(2)January 31, 2005, 4:01 pmdistributed transaction giving error on win 2003
Posts(2)January 31, 2005, 4:01 pmDTS, Excel, and ActiveX
Posts(3)January 31, 2005, 4:01 pmInstall pb w2k3
Posts(6)January 31, 2005, 9:05 amMerging Stored Proc Result Set
Posts(2)January 31, 2005, 9:05 amAbout OLAP Service
Posts(3)January 31, 2005, 9:05 amwhere statements using variables
Posts(5)January 31, 2005, 9:05 am.trn?
Posts(3)January 31, 2005, 9:05 amInavlid Cursor State
Posts(1)January 31, 2005, 9:05 am** FREE! Laptop, 40GB Photo Ipod, Dell P4 Desktop, Bose Sound Dock, Car Gear, PC Gear
Posts(2)January 31, 2005, 4:00 amPassword hashes for SQL 7.0 & 2000
Posts(2)January 31, 2005, 4:00 amSQLDMO and server.Disconect
Posts(1)January 31, 2005, 4:00 amRe: @@IDENTITY Programming Jitters Thanks
Posts(6)January 31, 2005, 4:00 amLock a row
Posts(2)January 30, 2005, 8:58 pmneed help: new at store procedure
Posts(3)January 30, 2005, 8:58 pmExpressions in queries
Posts(4)January 30, 2005, 8:58 pmAuto Number
Posts(11)January 30, 2005, 3:58 pmProblem scheduling job
Posts(3)January 30, 2005, 3:58 pmCalling external functions from SQL SELECT
Posts(7)January 30, 2005, 3:58 pmEXEC Permission
Posts(3)January 30, 2005, 3:58 pmPrimary Key - Multiple Columns
Posts(2)January 30, 2005, 8:57 amRestore for the transaction files
Posts(3)January 30, 2005, 3:58 amblocking in sysindexes
Posts(3)January 29, 2005, 8:57 pmhow to add new column like existing one?
Posts(7)January 29, 2005, 8:57 pm@@IDENTITY Programming Jitters
Posts(4)January 29, 2005, 8:57 pmQuesion about cursors
Posts(4)January 29, 2005, 8:57 pmDynamic WHERE statement
Posts(5)January 29, 2005, 8:57 pmFunctions in SQL Server7
Posts(2)January 29, 2005, 3:59 pmHow to save the SP result?
Posts(2)January 29, 2005, 3:59 pmDelete Duplicates
Posts(2)January 29, 2005, 3:59 pmprotect overflow of sql data type decimal(9,3)
Posts(6)January 29, 2005, 8:57 amSQL datetime conversion
Posts(4)January 29, 2005, 8:57 amMaster Detail link
Posts(2)January 29, 2005, 3:57 amDBCC ShrinkDatabase
Posts(2)January 29, 2005, 3:57 amIn your opinion: what's the best book on DTS?
Posts(1)January 29, 2005, 3:57 amHow to detect if a merge replication is still running
Posts(5)January 29, 2005, 3:57 amFlattening SQL Query / Table
Posts(2)January 28, 2005, 9:01 pmreturn PK to stored procedure
Posts(2)January 28, 2005, 9:01 pmproblem updating view with instead of trigger
Posts(3)January 28, 2005, 9:01 pmTrace problem
Posts(6)January 28, 2005, 9:01 pmIsnull not working as expected
Posts(5)January 28, 2005, 9:01 pmForms
Posts(17)January 28, 2005, 9:01 pminstead of triggers and blob columns in views
Posts(6)January 28, 2005, 9:01 pmMaking a dynamic table (view)?
Posts(7)January 28, 2005, 9:01 pmShrink transaction log after truncate table?
Posts(7)January 28, 2005, 9:01 pmstored procedure issue
Posts(1)January 28, 2005, 9:01 pmNeed advice w/ LDAP
Posts(2)January 28, 2005, 9:01 pmsql error
Posts(2)January 28, 2005, 9:01 pmFinding duplicates
Posts(4)January 28, 2005, 9:01 pmDisable .Net Connection Pooling thru SQLDMO
Posts(1)January 28, 2005, 5:38 pm!! DOWNLOAD THE MOST POPULAR 2005's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/GIS/PCB/FEA/CNC/
Posts(1)January 28, 2005, 4:02 pmRe: GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLI
Posts(3)January 28, 2005, 4:02 pmPerformance Problem with UNION Query
Posts(5)January 28, 2005, 4:02 pmHelp On query Writting
Posts(2)January 28, 2005, 4:02 pmRe: Error: Contains more than the maximum number of prefixes. The
Posts(7)January 28, 2005, 4:02 pmData structure Internals Question
Posts(5)January 28, 2005, 4:02 pmTriggers and Stored Procedure
Posts(4)January 28, 2005, 4:02 pmdeadlock in agent job
Posts(7)January 28, 2005, 4:02 pmRun SP from UDF?
Posts(7)January 28, 2005, 4:01 pmArithmic Overlflow on division ?
Posts(5)January 28, 2005, 4:01 pmHelp On query Writting
Posts(6)January 28, 2005, 4:01 pmHow can I connect to my server over the internet
Posts(2)January 28, 2005, 4:01 pmTimeout error in SQL server 7
Posts(4)January 28, 2005, 4:01 pminsterting multiple records based on other select query return
Posts(2)January 28, 2005, 4:01 pmselect into proc
Posts(3)January 28, 2005, 4:01 pmSend an Email from s Stored procedure
Posts(4)January 28, 2005, 8:59 amProblem with regional settings I think
Posts(2)January 28, 2005, 8:59 amhow to know space used per column
Posts(7)January 28, 2005, 8:59 amANSI to Unicode(MSSQL) convertions
Posts(1)January 28, 2005, 8:59 amRe(II): Stored Procedure degraded to much slower than direct query
Posts(1)January 28, 2005, 8:59 amDistributed request
Posts(10)January 28, 2005, 8:59 amsql query: query on values that are not there
Posts(1)January 28, 2005, 8:59 amTransfer and sync between view and table
Posts(1)January 28, 2005, 8:59 amSync data between OLTP data tables and OLAP fact tables.
Posts(4)January 28, 2005, 8:59 amExtracting Info From SP
Posts(4)January 28, 2005, 8:59 amHelp with Stored Procedure
Posts(2)January 28, 2005, 8:59 amTrigger
Posts(1)January 28, 2005, 4:00 amHelp On query Writting
Posts(1)January 28, 2005, 4:00 amSync data between OLTP data tables and OLAP fact tables.
Posts(4)January 28, 2005, 4:00 amPOSTED AGAIN- DISTRIBUTED TRANSACTION
Posts(1)January 28, 2005, 4:00 amTrigger
Posts(7)January 28, 2005, 4:00 amusing variables
Posts(8)January 27, 2005, 9:00 pmpermissions gone missing in sysprotects
Posts(1)January 27, 2005, 9:00 pmSQLAllocHandle for SQL_HANDLE_ENV without error
Posts(3)January 27, 2005, 9:00 pmsubquery
Posts(1)January 27, 2005, 9:00 pmXML / ODBC Error
Posts(2)January 27, 2005, 9:00 pmfancy select needed.Thanks for your help!
Posts(2)January 27, 2005, 9:00 pmDTS Help
Posts(4)January 27, 2005, 9:00 pmConcatenate String and Pass to FORMSOF?
Posts(5)January 27, 2005, 9:00 pmspeed up query
Posts(1)January 27, 2005, 4:04 pmRe: DTS buffer size overflow
Posts(1)January 27, 2005, 4:04 pmRE: calling a function that declares a cursor multiple times withi
Posts(3)January 27, 2005, 4:04 pmRe: T-SQL: Using a variable as
Posts(2)January 27, 2005, 4:04 pmcalling a function that declares a cursor multiple times within qu
Posts(10)January 27, 2005, 4:04 pmDate Format
Posts(4)January 27, 2005, 4:04 pmStored Procedure or what...
Posts(1)January 27, 2005, 4:04 pmRe: Puzzle: dateadd workdays only
Posts(7)January 27, 2005, 4:04 pmT-SQL: Using a variable as a column name gives bad results.
Posts(6)January 27, 2005, 4:04 pmQuery for an expert
Posts(3)January 27, 2005, 4:04 pmis this Possible
Posts(2)January 27, 2005, 4:04 pmStored Procedure degraded to much slower than direct query
Posts(9)January 27, 2005, 4:04 pmHelp with SQL Contains clause
Posts(1)January 27, 2005, 4:04 pmDTS Help
Posts(6)January 27, 2005, 4:04 pmcast a date to string
Posts(5)January 27, 2005, 4:04 pmcode Sample
Posts(2)January 27, 2005, 4:04 pmfancy select needed.Thanks for your help!
Posts(2)January 27, 2005, 4:04 pmTransactions comtaining triggers
Posts(1)January 27, 2005, 4:04 pmEmail functionality broken in upsizing from ACCESS to SQL
Posts(1)January 27, 2005, 4:04 pmRe: Determining Last modification date - CONCLUSION
Posts(3)January 27, 2005, 4:04 pmwhat is SQL query length limits??
Posts(3)January 27, 2005, 4:04 pmTable Def's part two
Posts(7)January 27, 2005, 4:04 pmDoes Yucon support set ansi_nulls?
Posts(5)January 27, 2005, 4:04 pmcreate relationship between tables in different databases???
Posts(3)January 27, 2005, 4:04 pmArray parameters in stored procedures in SQL 2005?
Posts(5)January 27, 2005, 8:58 amRe: question on synchronization for Intel Developer Services artic
Posts(2)January 27, 2005, 8:58 amIndex in view
Posts(7)January 27, 2005, 8:58 amTransactions and SQL
Posts(3)January 27, 2005, 8:58 amRe: Space in .paths of DMO backup
Posts(1)January 27, 2005, 8:58 amHow to Call User-defined Function From Other SQL Server
Posts(2)January 27, 2005, 8:58 amControl-of-flow Temp Tables
Posts(3)January 27, 2005, 8:58 amSearching Document
Posts(3)January 27, 2005, 3:59 amAttach database
Posts(3)January 27, 2005, 3:59 amSQL Tools to parse SQL scripts
Posts(3)January 27, 2005, 3:59 amQuery help
Posts(9)January 27, 2005, 3:59 amHelp in solving queries.......
Posts(4)January 27, 2005, 3:59 amDisplaying Auto Sequence Number
Posts(4)January 27, 2005, 3:58 amPls Help!!
Posts(5)January 27, 2005, 3:58 amquery help sorting
Posts(3)January 27, 2005, 3:58 amEliminating rows based on duplicate field values
Posts(2)January 27, 2005, 3:58 amWhat tools and methods should I use to identify SQL problems.
Posts(2)January 27, 2005, 3:58 amUnable to drop the database after dropping the republication using store procedure!!H
Posts(6)January 27, 2005, 3:58 amcontrolling temdb size
Posts(3)January 27, 2005, 3:58 amCrosstab Query
Posts(1)January 27, 2005, 3:58 amRe: Space in .paths of DMO backup
Posts(7)January 27, 2005, 3:58 amBit column with NULL
Posts(6)January 27, 2005, 3:58 amCalling Stored Proc from a Function
Posts(7)January 27, 2005, 3:58 am"Macro" statement
Posts(1)January 27, 2005, 3:58 amRe: Converting NUMBER, DATE and VARCHAR2 database fields from Resultset
Posts(4)January 27, 2005, 3:58 amSending SELECT results to a stored procedure
Posts(2)January 27, 2005, 3:58 amTransactional replication vs. Log shipping
Posts(4)January 27, 2005, 3:58 amURGENT: VSS admin passwd reset
Posts(1)January 26, 2005, 8:59 pmXpath issue between MSSQL 2000 on WinXP and Win2K machines.
Posts(3)January 26, 2005, 8:59 pmForeign Key conflict
Posts(3)January 26, 2005, 8:59 pmReformatting ResultSet
Posts(3)January 26, 2005, 8:59 pmSchedule query results to file...
Posts(13)January 26, 2005, 8:59 pmAdding another step to the following
Posts(3)January 26, 2005, 8:59 pmWhy ADO.NET?
Posts(3)January 26, 2005, 8:59 pmImplied If Statements
Posts(7)January 26, 2005, 8:59 pmDetermining Last modification date
Posts(3)January 26, 2005, 4:01 pminstead of trigger on a UNION view
Posts(1)January 26, 2005, 4:01 pmRE: XML
Posts(5)January 26, 2005, 4:01 pmRe: Ramifications of running SQL Server 2000 and 2005 on the same
Posts(4)January 26, 2005, 4:01 pmDoes increasing indexes inclease the amount of memory that SQL server uses?
Posts(1)January 26, 2005, 4:01 pmRe: strange problem with sql
Posts(4)January 26, 2005, 4:01 pmMisleading LEN function
Posts(4)January 26, 2005, 4:01 pmHelp with SP to check and add new user to database
Posts(2)January 26, 2005, 4:01 pmRamifications of running SQL Server 2000 and 2005 on the same mach
Posts(4)January 26, 2005, 4:01 pmUsing variable within a query
Posts(8)January 26, 2005, 4:01 pmALTER COLUMN
Posts(4)January 26, 2005, 4:01 pmFunctions and Recompile
Posts(4)January 26, 2005, 4:01 pmKeywords
Posts(6)January 26, 2005, 4:01 pmWhat exactly is a query plan (or a SQL plan for that matter)
Posts(4)January 26, 2005, 4:01 pmRe: newbie, querie help/advice
Posts(2)January 26, 2005, 4:01 pmTable Deafinitions
Posts(2)January 26, 2005, 4:01 pmUsing sql script files in ADO
Posts(8)January 26, 2005, 4:01 pmCan you SELECT multiple counts?
Posts(4)January 26, 2005, 4:01 pmSQL Expert
Posts(3)January 26, 2005, 4:01 pmEasy aggregation question
Posts(2)January 26, 2005, 4:01 pmConvert text to number
Posts(4)January 26, 2005, 4:01 pmSyntax checker
Posts(10)January 26, 2005, 4:01 pmIntermittent ORDER BY not functionning
Posts(1)January 26, 2005, 4:01 pmHelp with contains
Posts(3)January 26, 2005, 4:01 pmFind last char index
Posts(2)January 26, 2005, 4:01 pmWhen to connect; when to disconnect?
Posts(2)January 26, 2005, 4:01 pmConvert char(24) to smalldatetime



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

Copyright 2008 codecomments.com