For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > February 2006









Pages: [1] 2 3 4 5 6 7

Posts(5)February 28, 2006, 9:58 pmHow to sync data in multiple instances of a database?
Posts(8)February 28, 2006, 7:07 pmRe: problem creating Self Join query - is this the correct approac
Posts(2)February 28, 2006, 7:07 pmDROP ot TRUNCATE a table
Posts(3)February 28, 2006, 7:07 pmProgrammatically altering object code
Posts(3)February 28, 2006, 7:06 pmHow access 6.5 database using SQL 2005?
Posts(3)February 28, 2006, 7:06 pmAttaching Database does not name database correctly
Posts(3)February 28, 2006, 7:06 pmUpdate trigger with multiple rows in inserted and deleted
Posts(2)February 28, 2006, 7:06 pmPerformance -- Plan Cost and Scan
Posts(9)February 28, 2006, 7:06 pmGet Results into one table
Posts(5)February 28, 2006, 7:06 pmUpdate Query
Posts(4)February 28, 2006, 7:06 pmQuery all tables containing a certain field
Posts(5)February 28, 2006, 7:06 pm-- Comment disables code?
Posts(4)February 28, 2006, 7:06 pmBringing text into a database
Posts(2)February 28, 2006, 7:06 pmSQL Error -30108
Posts(2)February 28, 2006, 7:06 pmSQL programming
Posts(5)February 28, 2006, 7:06 pmFormat a number to '00'
Posts(5)February 28, 2006, 7:06 pmreturn a predifined value in a select if the record did not exist
Posts(9)February 28, 2006, 7:06 pmCoalesce increasing performance but Why?
Posts(6)February 28, 2006, 7:06 pm[SQL2000] permissions to use view based on tables from many databases
Posts(5)February 28, 2006, 7:06 pmIn clause efficency.
Posts(11)February 28, 2006, 7:06 pmindexed view
Posts(3)February 28, 2006, 7:06 pmASP 3.0 Error on SQL Server 2005
Posts(4)February 28, 2006, 7:06 pmproblem creating Self Join query - is this the correct approach?
Posts(2)February 28, 2006, 7:06 pmUsing an "IN" sub-query in an ADODB.Recordset Filter
Posts(6)February 28, 2006, 7:06 pmOracle SQL *Plus
Posts(2)February 28, 2006, 7:06 pmsql query to excel file question
Posts(8)February 28, 2006, 7:06 pmHow to maintain the history of information in a table?
Posts(3)February 28, 2006, 7:06 pmerror connecting to sql 2k from an app
Posts(5)February 28, 2006, 7:06 pmProblem Deleting Rows
Posts(1)February 28, 2006, 7:06 pmScheduled export
Posts(4)February 28, 2006, 7:06 pmSQL automation
Posts(4)February 28, 2006, 7:06 pmReturning a value from a stored proc...I'm not getting it
Posts(2)February 28, 2006, 7:06 pmSaving a word Doc to a SQL table
Posts(4)February 28, 2006, 7:06 pmCOUNT(*) or COUNT(0)?
Posts(5)February 28, 2006, 7:06 pmCDO mail attachment is not working
Posts(9)February 28, 2006, 7:06 pmnot equal join?
Posts(1)February 28, 2006, 7:06 pmcapturing messages
Posts(1)February 28, 2006, 7:06 pmUsing DMO ExecuteWithResults
Posts(1)February 28, 2006, 7:06 pm.Newline converts to LineFeed
Posts(7)February 28, 2006, 7:06 pmBulk insert and vb.net - URGENT
Posts(1)February 28, 2006, 7:59 amAny way to find out who deleted my reports
Posts(9)February 28, 2006, 7:59 amdeleting records older than 180 days
Posts(3)February 28, 2006, 7:59 amOpinons on using Delete then BULK INSERT
Posts(1)February 28, 2006, 7:59 amwhat requirements needed to develop the mobile applications
Posts(1)February 28, 2006, 7:59 amWeird Stored Procedure Problem - stopping without any errormessage
Posts(7)February 28, 2006, 7:59 amuser permissions in a database.
Posts(3)February 28, 2006, 7:59 amto upload image in visual web developer express 2005
Posts(2)February 28, 2006, 7:59 amhow to list perissions
Posts(1)February 28, 2006, 7:59 amRe: return a predifined value in a select if the record did not ex
Posts(3)February 28, 2006, 7:59 amQuick Question on Transactions
Posts(7)February 28, 2006, 4:02 amCheck Constraint Expression
Posts(1)February 28, 2006, 4:02 amExecuting Integration Services Packages Through SMO
Posts(2)February 28, 2006, 4:01 amConnectivity in between SQL Server and DB2
Posts(3)February 28, 2006, 4:01 amScripting Profiler Traces
Posts(2)February 28, 2006, 4:01 amwhat date is missing from a range of dates
Posts(3)February 28, 2006, 4:01 amtroubles with triggers
Posts(5)February 27, 2006, 9:58 pmbehavior of command in the 'SQL Query Analyzer'
Posts(18)February 27, 2006, 9:58 pmI need HEEEEEEELP !!!!
Posts(4)February 27, 2006, 9:58 pmHelp with an Update/Insert procedure
Posts(2)February 27, 2006, 9:58 pmreset next identity value
Posts(19)February 27, 2006, 7:13 pmExcel to SQL
Posts(4)February 27, 2006, 7:13 pmsubquery with invalid column not returning errors
Posts(3)February 27, 2006, 7:13 pmInterview a Database Administer for MBA Class
Posts(2)February 27, 2006, 7:13 pmRE: Problem with AddNew on SQL server in c++ 2003
Posts(3)February 27, 2006, 7:13 pmNeed help writing query
Posts(44)February 27, 2006, 7:13 pmHow to compare strings for equality in Transact SQL
Posts(5)February 27, 2006, 7:13 pmhow to only select rows with a given max(date)?
Posts(7)February 27, 2006, 7:13 pmISNULL? COALESCE? etc?
Posts(5)February 27, 2006, 7:13 pmpassing values to a Trigger
Posts(3)February 27, 2006, 7:13 pmUnable to locate table
Posts(3)February 27, 2006, 7:13 pmHow do I update/insert entire tables
Posts(7)February 27, 2006, 7:13 pmbigint or uniqueidentifer performance metrics?
Posts(3)February 27, 2006, 7:13 pmAccessing database from User Defined Aggregate
Posts(6)February 27, 2006, 7:13 pmSQL Server Query Question
Posts(2)February 27, 2006, 7:13 pmRE: select with a column depending on the value of a other column(
Posts(3)February 27, 2006, 7:12 pmselecting rows from a table excluding rows that are in inserted
Posts(6)February 27, 2006, 7:12 pmLook-UP
Posts(3)February 27, 2006, 7:12 pmincrement in a sql query
Posts(5)February 27, 2006, 7:12 pmupdate stored procedure help
Posts(5)February 27, 2006, 7:12 pmServer: Msg 207 when querying against table with reserved names for column names
Posts(8)February 27, 2006, 7:12 pmHelp with de-duplication problem
Posts(2)February 27, 2006, 7:12 pmselect with a column depending on the value of a other column(sum)
Posts(12)February 27, 2006, 7:12 pmTrigger performance (inserted/deleted)
Posts(7)February 27, 2006, 7:12 pmInsert Image File
Posts(3)February 27, 2006, 7:12 pmAttachment using extendet store procedures
Posts(1)February 27, 2006, 7:12 pm2005 foreign key query performance issue
Posts(6)February 27, 2006, 7:12 pmHow to Create an XSD/XML Schema file?
Posts(5)February 27, 2006, 7:12 pmUse database, based on servername
Posts(3)February 27, 2006, 7:12 pmUnfamiliar date format
Posts(8)February 27, 2006, 7:57 amKeeping DB schemas synched
Posts(4)February 27, 2006, 7:57 amSumming debits and credits
Posts(5)February 27, 2006, 7:57 amCreate a Table dynamically
Posts(2)February 27, 2006, 7:57 amwhere can i get SQL Server 2000 Reporting Serices
Posts(4)February 27, 2006, 7:57 amListCompatibilityLevels (DMO) Problem in Yukon
Posts(4)February 27, 2006, 7:57 amSql Server 2000 and VB 6
Posts(5)February 27, 2006, 7:57 amComparing all fields of two rows in few tables.
Posts(2)February 27, 2006, 7:57 amRe: INSTEAD OF trigger
Posts(2)February 27, 2006, 7:57 amMove Data from DB's
Posts(5)February 27, 2006, 7:57 amFree tool to compare two databases
Posts(3)February 27, 2006, 7:57 amQustion about join 2 tables???
Posts(1)February 27, 2006, 7:57 amImport/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over
Posts(6)February 27, 2006, 7:57 amcollation error
Posts(3)February 27, 2006, 7:57 amgetting rows from a table using single select query
Posts(2)February 27, 2006, 7:57 am[newbie] INSTEAD OF trigger
Posts(4)February 27, 2006, 4:09 amUDF to determine if string is a uniqueidentifier ?
Posts(4)February 27, 2006, 4:09 amSelect query - all distinct from one column, highest for another - please help
Posts(3)February 27, 2006, 4:09 amEfficiency with INNER JOINs
Posts(7)February 27, 2006, 4:09 amalter table problem?
Posts(2)February 27, 2006, 4:08 amGetting Top Rows
Posts(1)February 27, 2006, 4:08 amis my earlier post not clear or difficult to solve ?
Posts(2)February 27, 2006, 4:08 amdebugging stored procedure
Posts(2)February 26, 2006, 9:59 pmMerging rows based on common key
Posts(6)February 26, 2006, 9:59 pmdelete a text file
Posts(8)February 26, 2006, 7:06 pmAccessing Different Servers
Posts(7)February 26, 2006, 7:06 pmdelete trigger for multiple row deletes
Posts(13)February 26, 2006, 7:06 pmThe mystery of
Posts(13)February 26, 2006, 7:06 pmPls, help: Bill of Materials and SQL 2005 recursion problem
Posts(4)February 26, 2006, 7:06 pmselect top problem
Posts(8)February 26, 2006, 7:06 pmReally large integer constants - confused
Posts(3)February 26, 2006, 7:06 pmGroup By problem, how to?
Posts(5)February 26, 2006, 7:06 pmAltering column with index
Posts(2)February 26, 2006, 7:06 pmChange collation on entire database
Posts(3)February 26, 2006, 7:06 pmUsing sp_ExecuteSQL
Posts(5)February 26, 2006, 7:06 pmTSQL syntax
Posts(3)February 26, 2006, 7:06 pmcannot insert data from one table to another
Posts(3)February 26, 2006, 7:06 pmselecting a range of rows using a single select query
Posts(3)February 26, 2006, 7:06 pmChecking if column exists
Posts(6)February 26, 2006, 7:06 pmnewbie question on select
Posts(18)February 26, 2006, 7:05 pmSQL Query - Is this possible?
Posts(8)February 26, 2006, 7:05 pmDubious SQL Login?
Posts(5)February 26, 2006, 7:57 am.Net <-> SqlServer admin actions
Posts(5)February 26, 2006, 7:57 amInsert Line Feed in Function Return Value
Posts(3)February 26, 2006, 7:57 amCannot Connect to SQL on Win2003 Server
Posts(2)February 26, 2006, 3:57 amleft outer join multi-user problem when handling user editing conflicts
Posts(3)February 26, 2006, 3:57 amIs this syntax correct: (',' + @country_code + ',' like '%,' + rtrim(member_country)
Posts(11)February 25, 2006, 9:57 pmMSSQL Mistake
Posts(3)February 25, 2006, 9:57 pmTRY.CATCH question
Posts(8)February 25, 2006, 9:57 pmAssign ID to distinct names
Posts(4)February 25, 2006, 7:00 pmDatabase patching.
Posts(3)February 25, 2006, 7:00 pmServer Properties
Posts(2)February 25, 2006, 7:00 pmclr references
Posts(1)February 25, 2006, 7:00 pmEventLog: SuperSockets
Posts(2)February 25, 2006, 7:00 pmSQL Query - Select
Posts(4)February 25, 2006, 7:00 pmSql Timeout
Posts(2)February 25, 2006, 7:00 pmTrigger and what caused the table change.
Posts(3)February 25, 2006, 7:00 pmusing alias column in a select statement
Posts(9)February 25, 2006, 7:00 pmManually determine execution plan?
Posts(4)February 25, 2006, 7:00 pmCannot Debug SQL 2005 Stored Procedures in VS 2005
Posts(5)February 24, 2006, 9:57 pmSQLCLR crashes unexpectedly while debugging
Posts(9)February 24, 2006, 9:57 pmsum() in a select statement
Posts(2)February 24, 2006, 7:02 pmStored Procedure Differences
Posts(6)February 24, 2006, 7:02 pmmultiple selects
Posts(2)February 24, 2006, 7:02 pmJoin Condition <> problem
Posts(3)February 24, 2006, 7:02 pmhow to return name of day 'Monday' from a date?
Posts(11)February 24, 2006, 7:02 pmquery performance question regarding ISNULL
Posts(7)February 24, 2006, 7:02 pmDesigning a Code Table
Posts(4)February 24, 2006, 7:02 pmQuestion about GroupBY and Aggregate functions.
Posts(1)February 24, 2006, 7:02 pmDTS / Trigger / Transaction Transaction
Posts(2)February 24, 2006, 7:02 pmsecurity exception while trying to determine if a file exists
Posts(1)February 24, 2006, 7:02 pmRe: Assign variables from table variables in UDF - NEVER MIND
Posts(1)February 24, 2006, 7:02 pmNeed help with CDONTS or other object to receive mail in a specific way
Posts(15)February 24, 2006, 7:02 pmOptimization with ORs
Posts(3)February 24, 2006, 7:02 pmDetermining last time a table was used?
Posts(2)February 24, 2006, 7:02 pmFind the first day the account passes a threshold
Posts(1)February 24, 2006, 7:02 pmLook UP
Posts(1)February 24, 2006, 7:02 pmNew transaction is not allowed because there are other threads run
Posts(4)February 24, 2006, 7:02 pmAre cursors extremely expensive?
Posts(2)February 24, 2006, 7:02 pmReturning a success or fail value from a stored proc
Posts(3)February 24, 2006, 7:02 pmSELECT Query Help Needed
Posts(5)February 24, 2006, 7:02 pmsubstring
Posts(3)February 24, 2006, 7:02 pm.NET Assembly, sql 2005 + sp_oaCreate
Posts(2)February 24, 2006, 7:02 pmTurn Off Defered Name Resolution ?
Posts(3)February 24, 2006, 7:02 pmPerformance issue with joining the text field
Posts(6)February 24, 2006, 7:02 pmGraphical representation of database
Posts(5)February 24, 2006, 7:02 pmDELETE rows involving auto-increment fields
Posts(2)February 24, 2006, 7:02 pmAdd indexed view will suppress the after trigger to get fired.
Posts(6)February 24, 2006, 7:02 pmDisplay result in hours, weeks and month
Posts(3)February 24, 2006, 7:02 pmNOLOCK SQL Query Safety
Posts(3)February 24, 2006, 7:02 pmCannot get "LIKE" to Work in My Query
Posts(1)February 24, 2006, 7:02 pmAssign variables from table variables in UDF
Posts(26)February 24, 2006, 7:02 pmList() Function
Posts(2)February 24, 2006, 7:02 pmRe: Select query - all distinct from one column, highest for anoth
Posts(6)February 24, 2006, 7:02 pmRe: CLR access to File Info
Posts(4)February 24, 2006, 7:02 pmList Dates Between Min & Max Dates
Posts(2)February 24, 2006, 7:02 pmDetermin if this is Standard or Ent edition
Posts(3)February 24, 2006, 7:02 pmProper way to IF THEN in a dynamic SQL Stored Proc
Posts(22)February 24, 2006, 7:02 pmADO VB/SQL help
Posts(2)February 24, 2006, 7:02 pmBlocking 101
Posts(2)February 24, 2006, 7:02 pmDTS in SQL Server 2005
Posts(8)February 24, 2006, 7:02 pm2005 slower than 2000?
Posts(1)February 24, 2006, 7:02 pmsp_fkeys performance diff in SQL 2005 and SQL 2000
Posts(7)February 24, 2006, 7:02 pmKilling active connections before detaching a database
Posts(2)February 24, 2006, 7:02 pmdelete multi records
Posts(3)February 24, 2006, 7:02 pmgroup by clause
Posts(1)February 24, 2006, 7:02 pmSystem Error: -2147217871 - Timeout expired
Posts(5)February 24, 2006, 7:02 pmNonclustered index question
Posts(3)February 24, 2006, 7:02 pmquestion about looping through a record set
Posts(5)February 24, 2006, 7:02 pmListing permissions on Stored Procedures via query.
Posts(1)February 24, 2006, 7:02 pmHow do I get Role information from SQL Server 2005 using SMO?
Posts(3)February 24, 2006, 7:02 pmHTML in SQL



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

Copyright 2008 codecomments.com