For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > December 2005









Pages: [1] 2 3 4 5

Posts(4)December 28, 2005, 12:35 pmHow to Send Arabic Text using xp_smtp_sendmail
Posts(1)December 23, 2005, 11:34 amTest Message
Posts(5)December 19, 2005, 4:00 amError executing User Defined function on another server
Posts(3)December 19, 2005, 4:00 amneed some TSQL help
Posts(11)December 19, 2005, 4:00 amIssue when not storing null db values.
Posts(2)December 19, 2005, 4:00 amError
Posts(5)December 19, 2005, 4:00 amWRITETEXT when column value is NULL
Posts(4)December 18, 2005, 9:58 pmtrigger help
Posts(2)December 18, 2005, 7:05 pmRe: Help! Uninstall
Posts(8)December 18, 2005, 7:05 pmHow to Query a nested Hierarchy in TSQL
Posts(4)December 18, 2005, 7:05 pmhow to find duplicate data involving more than one field
Posts(3)December 18, 2005, 7:05 pmViolation of PRIMARY KEY constraint errors.
Posts(3)December 18, 2005, 7:05 pmGetting the corresponding primary key from MAX()??
Posts(2)December 18, 2005, 7:05 pmError 213: Insert Error: Column name or values don't match table definition
Posts(4)December 18, 2005, 7:05 pmPausing-Restarting SQL Server Service
Posts(4)December 18, 2005, 7:05 pmDecimal or Float Type in Percent
Posts(12)December 18, 2005, 7:05 pmHow can I create a unique constraint on 2 columns where one of them allows nulls?
Posts(4)December 18, 2005, 7:05 pmAccess to another database via a stored procedure
Posts(3)December 18, 2005, 7:58 amAdventure Works DB
Posts(6)December 18, 2005, 7:58 amlogin event in sql server ??
Posts(2)December 18, 2005, 3:58 amsql2005express sub, RMO in vb.net, merge agent status messages
Posts(8)December 17, 2005, 9:58 pm==again== constraints with nulls
Posts(5)December 17, 2005, 7:04 pmHow to Group by....
Posts(6)December 17, 2005, 7:04 pmRe: How to speed up a trigger
Posts(4)December 17, 2005, 7:04 pmSQL types
Posts(8)December 17, 2005, 7:04 pmtime problem
Posts(4)December 17, 2005, 7:03 pmabout CTE in SQL 2k5
Posts(7)December 17, 2005, 7:03 pmCreate temp table
Posts(4)December 17, 2005, 7:03 pmSELECT DISTINCT
Posts(6)December 17, 2005, 7:03 pmbest way to log out when running the job
Posts(2)December 17, 2005, 7:03 pmCalling SP2 from SP1
Posts(2)December 17, 2005, 7:57 amSQLDMO:To Change Database file Location path of DBBackup file ( VC
Posts(2)December 17, 2005, 7:57 amProblems Concatenating Columns
Posts(4)December 17, 2005, 7:57 amfn_replprepadbinary8 function
Posts(2)December 17, 2005, 7:57 amMy Cursor Operation - Efficient?
Posts(6)December 17, 2005, 3:59 amRemoving all between [ and ]
Posts(2)December 16, 2005, 9:59 pmComparing to Resultsets
Posts(5)December 16, 2005, 9:59 pmclustered Vs NonClustered indexes
Posts(3)December 16, 2005, 7:09 pmProblem with AddNew on SQL server in c++ 2003
Posts(5)December 16, 2005, 7:09 pmUpdate Stored Procedured question
Posts(4)December 16, 2005, 7:09 pmDoes SQL uses index in the following select statement
Posts(3)December 16, 2005, 7:09 pmTrouble with a computed colume
Posts(3)December 16, 2005, 7:09 pmStored Procedure Cache Question
Posts(9)December 16, 2005, 7:09 pmuse subquery result in Selet statement
Posts(4)December 16, 2005, 7:09 pmcase statements
Posts(3)December 16, 2005, 7:09 pmsession timeouts?
Posts(3)December 16, 2005, 7:09 pmPerformance Question
Posts(5)December 16, 2005, 7:09 pmSQL Server 2005 and GO issue
Posts(7)December 16, 2005, 7:09 pmCounting the number of fields that are populated in row
Posts(3)December 16, 2005, 7:09 pmlog files
Posts(2)December 16, 2005, 7:09 pmRe: SQL2005 & SQL2000 in the same text box ????
Posts(6)December 16, 2005, 7:09 pmSelecting rows with highest count value
Posts(6)December 16, 2005, 7:09 pmIs it possible to get all the column values in a single column?
Posts(6)December 16, 2005, 7:09 pmDynamic pivot of resultset
Posts(9)December 16, 2005, 7:09 pmVery slow when using cursor + IN
Posts(5)December 16, 2005, 7:09 pmTrying to insert a LOT of records
Posts(4)December 16, 2005, 7:09 pmPass text variable to stored proc
Posts(15)December 16, 2005, 7:09 pmModifying sys.sp_MSdbuseraccess in SQL 2005
Posts(5)December 16, 2005, 7:09 pmfind all sps where a field is used
Posts(2)December 16, 2005, 7:09 pmNeed advice on database planning. Thank You.
Posts(4)December 16, 2005, 7:09 pmWill this two SQL statements get the same result?
Posts(4)December 16, 2005, 7:09 pmDeploying a managed code trigger
Posts(2)December 16, 2005, 7:09 pmDisplaying HTML within an Access Report
Posts(1)December 16, 2005, 7:09 pmHelp! Uninstall
Posts(3)December 16, 2005, 7:09 pmChanging the collation
Posts(10)December 16, 2005, 7:09 pmAggregate Function Error
Posts(5)December 16, 2005, 7:09 pmHow To Set a Variable During an Insert Into Select From
Posts(6)December 16, 2005, 7:09 pmhow to represent very long primary key
Posts(4)December 16, 2005, 7:09 pmImporting a XML doc into relational tables.
Posts(3)December 16, 2005, 7:09 pmWorks in SQL 2000 but Fails in SQL 2005??
Posts(4)December 16, 2005, 7:09 pmSELECT does not return all on left of join when right side has lim
Posts(1)December 16, 2005, 7:09 pmRe: SELECT does not return all on left of join when right side has
Posts(1)December 16, 2005, 7:09 pmRe: SELECT does not return all on left of join when right side has
Posts(7)December 16, 2005, 7:09 pmadd working days to a date
Posts(2)December 16, 2005, 7:08 pmCopy data for reports
Posts(3)December 16, 2005, 4:46 pmMerging tables - basic question
Posts(7)December 16, 2005, 7:59 amCompare feilds in seperate databases on seperate servers
Posts(3)December 16, 2005, 7:59 ammapping data types
Posts(6)December 16, 2005, 7:59 amAccess or SQL Server
Posts(6)December 16, 2005, 7:59 amHelp with multiple Left Joins
Posts(1)December 16, 2005, 7:59 amLanguage Converter
Posts(5)December 16, 2005, 3:59 amSelect records based on the given value
Posts(3)December 16, 2005, 3:59 amQuicker Cursor or Table Variable
Posts(7)December 16, 2005, 3:59 amLoop a select statement?
Posts(6)December 16, 2005, 3:59 amfrom sql - checking if a file exists in a given share
Posts(3)December 16, 2005, 3:59 amcreating a function to be used in select query
Posts(7)December 16, 2005, 3:59 amPassing entire SELECT and WHERE clause to a stored procedure
Posts(2)December 16, 2005, 3:59 amSending a report attachment to a dynamic list of recipients
Posts(1)December 16, 2005, 3:59 amRe: SQL Server 2000: How to inject a COLUMN VALUE into an EMAIL???
Posts(14)December 16, 2005, 3:59 amNeed to update all but first record in group by
Posts(5)December 16, 2005, 3:59 amParent-Child Hierarchy Explosion
Posts(3)December 16, 2005, 3:59 amweekday or Weekend
Posts(7)December 16, 2005, 3:59 amFormatting numbers
Posts(4)December 16, 2005, 3:59 amselecting multiple topmost based in ID
Posts(4)December 15, 2005, 9:59 pmStupid stored proc question
Posts(2)December 15, 2005, 9:59 pmOpenQuery using parameters
Posts(2)December 15, 2005, 9:59 pmLog shipping question
Posts(6)December 15, 2005, 9:59 pmunique constraints with nulls
Posts(5)December 15, 2005, 9:59 pmReboot required to revitalize server?
Posts(8)December 15, 2005, 7:06 pmPreload SQL Table Into RAM
Posts(5)December 15, 2005, 7:06 pmSetting Rowcount's in nested select statement
Posts(3)December 15, 2005, 7:06 pmDiscarding an empty result set in a stored proc
Posts(6)December 15, 2005, 7:06 pmSyntax Help!!
Posts(3)December 15, 2005, 7:06 pmremove or ignore one row from DTS
Posts(2)December 15, 2005, 7:06 pmOLE Automation and "global variable"
Posts(5)December 15, 2005, 7:06 pmVery strange with Cursor behavior
Posts(8)December 15, 2005, 7:06 pmperformance in using mutliple vs a single catalog for data
Posts(4)December 15, 2005, 7:06 pmError handling problem
Posts(1)December 15, 2005, 7:06 pmStore SQL BlobColumn as Attachment to MailMessage?
Posts(2)December 15, 2005, 7:06 pmdire help needed
Posts(3)December 15, 2005, 7:06 pmInsert from Select to remove Duplicate rows
Posts(11)December 15, 2005, 7:06 pmSQL query
Posts(3)December 15, 2005, 7:06 pmRow Level Locking
Posts(9)December 15, 2005, 7:06 pmplease check
Posts(5)December 15, 2005, 7:06 pmSQL and Returning unique records
Posts(9)December 15, 2005, 7:06 pmWhy is 1 white space the same as 3 white spaces in a varchar?
Posts(7)December 15, 2005, 7:06 pmRead mail message with Database Mail
Posts(2)December 15, 2005, 7:06 pmI don't remember how did I such thing...
Posts(1)December 15, 2005, 7:06 pmRe: SQL Server 2000: How to inject a COLUMN VALUE into an EMAIL???
Posts(2)December 15, 2005, 7:06 pmDeleting matching records
Posts(6)December 15, 2005, 7:06 pmsql server 8.0 specific
Posts(10)December 15, 2005, 7:06 pmCLR Integration with Complex Types
Posts(4)December 15, 2005, 7:06 pmComma operator in FROM clause - what is this?
Posts(7)December 15, 2005, 7:06 pm[OT] SQL Server "Developers"
Posts(5)December 15, 2005, 7:06 pmList of Database Users
Posts(3)December 15, 2005, 7:06 pmUnion & group by Q
Posts(3)December 15, 2005, 7:06 pmRe: EXISTS (SELECT ... FROM) optional?
Posts(9)December 15, 2005, 7:06 pmTrying to Create a Loop With Two Variables
Posts(1)December 15, 2005, 7:06 pmSQL 2005
Posts(2)December 15, 2005, 7:06 pmRe: EXISTS (SELECT ... FROM) optional?
Posts(9)December 15, 2005, 7:06 pmDatatype for Primary key fields ...
Posts(3)December 15, 2005, 7:06 pmHow to see what Trigger I have in my DB using TSQL?
Posts(1)December 15, 2005, 7:06 pmRE: Programmatically creating a blank password logins in 2005 Expr
Posts(3)December 15, 2005, 7:06 pmlast re-cycle of SQL Server
Posts(3)December 15, 2005, 7:06 pmCan this be simplified?
Posts(3)December 15, 2005, 7:06 pmhow to make an alias here ??
Posts(2)December 15, 2005, 7:06 pmplease check
Posts(4)December 15, 2005, 7:58 amBULK INSERT Performance with format files
Posts(3)December 15, 2005, 7:58 amMSSQL 2005 and XML Interchangeable
Posts(2)December 15, 2005, 7:58 amDate Convertion
Posts(2)December 15, 2005, 7:58 amConverting INT datatype to BIGINT datatype
Posts(2)December 15, 2005, 7:58 amstoring data through select statment into excel file
Posts(1)December 15, 2005, 7:58 amDebugging UDF's in vs
Posts(4)December 15, 2005, 7:58 amabout SAN
Posts(3)December 15, 2005, 7:58 am2005 tray icon
Posts(4)December 15, 2005, 4:00 amsql login
Posts(9)December 15, 2005, 4:00 amImproving a query
Posts(9)December 15, 2005, 4:00 amconvert a datetime
Posts(1)December 15, 2005, 4:00 amRE: how to restore a database (either in sql 2000 or 20005) on sql2005
Posts(1)December 15, 2005, 4:00 amRE: Excel file import to Sql Server problem
Posts(2)December 15, 2005, 4:00 amwhat happen when access deny?
Posts(2)December 15, 2005, 4:00 amExport Table to Text File Using Query Analyzer
Posts(2)December 15, 2005, 4:00 amSQL 2005 CLR Dynamic SQLDataRecord
Posts(1)December 15, 2005, 4:00 amIncome for life
Posts(8)December 14, 2005, 10:02 pmstored procedure causing deadlocks
Posts(11)December 14, 2005, 10:02 pmIndex rename
Posts(2)December 14, 2005, 7:09 pmProgrammatically creating a blank password logins in 2005 Express
Posts(4)December 14, 2005, 7:09 pmSQL Server 2005 Full Text Multi-Column Weight Query
Posts(3)December 14, 2005, 7:09 pmSingle User
Posts(7)December 14, 2005, 7:09 pmAppending columns - horizantal dimention
Posts(4)December 14, 2005, 7:09 pmAny Thoughts!!
Posts(3)December 14, 2005, 7:09 pmAssigning Variables
Posts(3)December 14, 2005, 7:09 pmhelp on multiple column updates - backtracking data for 30 days
Posts(4)December 14, 2005, 7:09 pmHelp with a Query
Posts(8)December 14, 2005, 7:09 pmhelp with table update
Posts(15)December 14, 2005, 7:09 pmDetermine if a temproary Table still exists
Posts(3)December 14, 2005, 7:09 pmUsing the Case Statement
Posts(4)December 14, 2005, 7:09 pminterview questions
Posts(7)December 14, 2005, 7:09 pmIf statement failing, perhaps data comparison problem??
Posts(2)December 14, 2005, 7:09 pmWhy Is @@Error Not Working in a User Defined Function
Posts(3)December 14, 2005, 7:09 pmMulti connection problem
Posts(1)December 14, 2005, 7:09 pmhow to restore a database (either in sql 2000 or 20005) on sql2005?
Posts(1)December 14, 2005, 7:09 pmExport Table to Text File Using Query Analyzer
Posts(3)December 14, 2005, 7:09 pmText Fields - RTF Formatting
Posts(2)December 14, 2005, 7:09 pmPerformance Question
Posts(1)December 14, 2005, 7:09 pmCustomer specific pricing (part2)
Posts(3)December 14, 2005, 7:09 pmAllocate to records, randomize rounded amount
Posts(3)December 14, 2005, 7:09 pmHow to Transfer View only?
Posts(3)December 14, 2005, 7:09 pmsql server 2000 tran log table
Posts(2)December 14, 2005, 7:09 pmMSDE Username/Password
Posts(3)December 14, 2005, 7:09 pmadd index
Posts(5)December 14, 2005, 7:09 pmKey Exists?
Posts(6)December 14, 2005, 7:09 pmcalling sp with datetime parameter from ole db
Posts(5)December 14, 2005, 7:09 pm@@identity
Posts(5)December 14, 2005, 7:09 pmMaintaining a one-to-one match on related tables
Posts(4)December 14, 2005, 7:09 pmInsert - No Logging
Posts(4)December 14, 2005, 7:09 pmProblem with query
Posts(5)December 14, 2005, 7:09 pmchecking for Null value
Posts(3)December 14, 2005, 7:09 pmLinked Servers
Posts(9)December 14, 2005, 7:09 pmA Simple Query Help
Posts(2)December 14, 2005, 7:09 pmCManualAccessor::CreateAccessor()
Posts(7)December 14, 2005, 7:09 pmIndexing
Posts(3)December 14, 2005, 7:09 pmsysobject.status field bit-mapping
Posts(2)December 14, 2005, 7:09 pmHelp with stored procedure
Posts(8)December 14, 2005, 7:09 pmDISTINCT ORDER BY PROBLEM
Posts(3)December 14, 2005, 7:59 amTroubleshooting tips for deadlocks, blocking
Posts(2)December 14, 2005, 7:59 amUK Contracting Rates
Posts(3)December 14, 2005, 7:59 amWhat data type to use in a table
Posts(4)December 14, 2005, 7:59 amDISTINCT Value
Posts(1)December 14, 2005, 7:59 amRe: Need help optimizing a stored procedure - SQL2k



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

Copyright 2008 codecomments.com