For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > March 2005









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

Posts(5)March 31, 2005, 8:59 pmround date
Posts(2)March 31, 2005, 8:59 pmBCP in stored procedure
Posts(6)March 31, 2005, 8:59 pmQuery hangs during a seperate write
Posts(3)March 31, 2005, 8:59 pmCombine Add/Edit SP's?
Posts(5)March 31, 2005, 8:59 pmColumn Name
Posts(4)March 31, 2005, 8:59 pmUpdateable query
Posts(6)March 31, 2005, 8:59 pmtrigger after insert
Posts(4)March 31, 2005, 8:59 pmwill the money data type ever change?
Posts(7)March 31, 2005, 8:59 pmNewbie: date-time help
Posts(3)March 31, 2005, 8:59 pmIncorrect syntax near the keyword IF
Posts(5)March 31, 2005, 8:59 pmAdapting data from one format to another
Posts(2)March 31, 2005, 8:59 pmsp trace is not outputing any data
Posts(6)March 31, 2005, 4:04 pmSave Excel file in the text field
Posts(3)March 31, 2005, 4:04 pmErrors trying to retrieve large excerpts
Posts(4)March 31, 2005, 4:03 pmJust a request
Posts(1)March 31, 2005, 4:03 pmcast or convert varchar to money/datetime
Posts(10)March 31, 2005, 4:03 pmUsing inline aggregates - is this possible?
Posts(2)March 31, 2005, 4:03 pmHelp in creating xsd file
Posts(4)March 31, 2005, 4:03 pm2 very general questions
Posts(5)March 31, 2005, 4:03 pmDisplay Estimated Execution Plan
Posts(6)March 31, 2005, 4:03 pmabout xp_cmdshell..
Posts(4)March 31, 2005, 4:03 pmcast or convert varchar to money/datetime
Posts(7)March 31, 2005, 4:03 pmSuspect ?
Posts(3)March 31, 2005, 4:03 pmQuery Question
Posts(5)March 31, 2005, 4:03 pmWhen 2005 version will be released?
Posts(1)March 31, 2005, 4:03 pmRe: HELP...Need to create query to place multiple databases offlin
Posts(1)March 31, 2005, 4:03 pmRE: HELP...Need to create query to place multiple databases offlin
Posts(3)March 31, 2005, 4:03 pmHELP...Need to create query to place multiple databases offline
Posts(7)March 31, 2005, 4:03 pmpossible Scope_Identity() problem
Posts(3)March 31, 2005, 4:03 pma
Posts(2)March 31, 2005, 4:03 pmSQL Query
Posts(3)March 31, 2005, 4:03 pmexecute SQL file from SQL Server
Posts(28)March 31, 2005, 4:03 pmWhy doesn't MSSQL have regular expressions?
Posts(5)March 31, 2005, 4:03 pmDate conversion.
Posts(2)March 31, 2005, 4:03 pmIncrease field size AND linked tables
Posts(1)March 31, 2005, 4:03 pmRe: Need to Improve:Don't worry
Posts(1)March 31, 2005, 4:03 pmRe: Need to Improve:Don't worry
Posts(6)March 31, 2005, 4:03 pmHow do you Convert Varchar to Decimal
Posts(5)March 31, 2005, 4:03 pmTo Write a SQL Query if possible
Posts(5)March 31, 2005, 4:03 pmCollation conflict
Posts(5)March 31, 2005, 4:03 pmHow transacction works?
Posts(3)March 31, 2005, 4:03 pmSubquery evaluation!
Posts(5)March 31, 2005, 9:00 amhavinx max data problem
Posts(6)March 31, 2005, 9:00 amdeleting all rows in table which references itself
Posts(6)March 31, 2005, 9:00 amcalculate date difference exclusding weekend
Posts(1)March 31, 2005, 9:00 amPartitioned view doesn't allow to query itself while insertion
Posts(8)March 31, 2005, 9:00 am_wcsupr () with german characters
Posts(4)March 31, 2005, 9:00 amDATEADD
Posts(4)March 31, 2005, 9:00 amDTS
Posts(3)March 31, 2005, 9:00 amI know this is not the right newsgroup but...
Posts(2)March 31, 2005, 9:00 amCALL STORED PROCEDURE IN MY QUERY
Posts(3)March 31, 2005, 4:02 amSQL: A problematic exists query (again)
Posts(4)March 31, 2005, 4:01 amHow can i export SP/Table through my SP ?
Posts(1)March 31, 2005, 4:01 amRe: Exporting Diagram
Posts(11)March 31, 2005, 4:01 amconcatenating multiple results to a string?
Posts(6)March 31, 2005, 4:01 amNot Returning Records From a TempTable sp that works on ISQL
Posts(7)March 31, 2005, 4:01 amsp in a view
Posts(4)March 31, 2005, 4:01 amExporting Diagram
Posts(3)March 31, 2005, 4:01 amProblem with left join
Posts(2)March 31, 2005, 4:01 amProblem with query
Posts(4)March 31, 2005, 4:01 amControlling Trigger actions based on user
Posts(1)March 31, 2005, 4:01 amMultiple process ID from Terminal Service connection...
Posts(10)March 30, 2005, 9:00 pmRe: How to get identity from parent Table and insert it into the c
Posts(2)March 30, 2005, 9:00 pmunwanted EM messages
Posts(5)March 30, 2005, 9:00 pmquery on view
Posts(2)March 30, 2005, 9:00 pmListing jobs that ran last hour
Posts(8)March 30, 2005, 9:00 pmFunction to return week number
Posts(4)March 30, 2005, 9:00 pmReasons to use BETWEEN
Posts(3)March 30, 2005, 9:00 pmskip error
Posts(2)March 30, 2005, 9:00 pmfind right database for stored procedure
Posts(4)March 30, 2005, 9:00 pmEquivalent of ROWNUM in MS-SQL
Posts(19)March 30, 2005, 9:00 pmPerformance - tweaking possible?
Posts(8)March 30, 2005, 9:00 pmProb with Case in Crosstab Query
Posts(2)March 30, 2005, 9:00 pmReliabily retreiving accurate stored procedure definitions
Posts(6)March 30, 2005, 9:00 pminner join update based on sum
Posts(5)March 30, 2005, 9:00 pmfinding missing number
Posts(8)March 30, 2005, 9:00 pmNeed help with SQL statement
Posts(3)March 30, 2005, 9:00 pmView updatable in EM - not updatable in ADP (2003)
Posts(3)March 30, 2005, 4:01 pmperformance issue regarding views/correlated subqueries
Posts(5)March 30, 2005, 4:01 pmIdentity Column Rollover
Posts(2)March 30, 2005, 4:01 pmADO=CHAR, ADOX=VARCHAR?
Posts(8)March 30, 2005, 4:01 pmFOR/NEXT/LOOP structure??
Posts(5)March 30, 2005, 4:01 pmalter column statement doesn't work, trying to change datatype
Posts(2)March 30, 2005, 4:01 pmHelp creating a DELETE trigger.
Posts(4)March 30, 2005, 4:01 pmPaging (SQL) without the datagrid in ASP.NET?
Posts(2)March 30, 2005, 4:01 pmTrim Characters
Posts(3)March 30, 2005, 4:01 pmClear the transaction log
Posts(7)March 30, 2005, 4:01 pmOrder By items not in the select list
Posts(83)March 30, 2005, 4:01 pmPrimary key
Posts(3)March 30, 2005, 4:01 pmSample code
Posts(6)March 30, 2005, 4:01 pmWhat would happen in this situation? Stop DELETE process
Posts(2)March 30, 2005, 4:01 pmRe: Mismatch in result-sets between QueryAnalyser and ADO.Net Data
Posts(8)March 30, 2005, 4:01 pmSQL Format?
Posts(10)March 30, 2005, 4:01 pmforeign keys and relationships
Posts(3)March 30, 2005, 4:01 pmInsert <NULL> via Enterprise Manager
Posts(4)March 30, 2005, 4:01 pma simple insert/update trigger
Posts(4)March 30, 2005, 4:01 pmList user-defined objects
Posts(4)March 30, 2005, 4:01 pmDecimal value
Posts(2)March 30, 2005, 4:01 pmunique clustered index on a partitioned view
Posts(7)March 30, 2005, 4:01 pmreturning 1/1/1900
Posts(4)March 30, 2005, 4:01 pmHow pictures are stored in database ?
Posts(2)March 30, 2005, 4:01 pmupdating date field based on another field value
Posts(2)March 30, 2005, 4:01 pmMismatch in result-sets between QueryAnalyser and ADO.Net DataSet
Posts(3)March 30, 2005, 4:01 pmselect "subset" of data?
Posts(4)March 30, 2005, 4:01 pmOptimize SQL
Posts(2)March 30, 2005, 9:02 amfinding sql server code page
Posts(5)March 30, 2005, 9:02 amWhat sequence?
Posts(2)March 30, 2005, 9:02 amDISTINCT not returning data in sorted order after specific no. of
Posts(4)March 30, 2005, 9:02 amSelecting sub hirearcy
Posts(2)March 30, 2005, 9:02 ambackup database
Posts(3)March 30, 2005, 9:02 amDifferent Execution Plan using COM+ of Query Analyzer.
Posts(5)March 30, 2005, 9:02 amupdate sproc fixed (but how?)
Posts(2)March 30, 2005, 9:02 amBulk Insert of XML of two level of hierarchy
Posts(2)March 30, 2005, 9:02 amSQL course for Access programmers
Posts(2)March 30, 2005, 9:02 amcomparison on text field
Posts(11)March 30, 2005, 4:03 amSQL query...
Posts(4)March 30, 2005, 4:03 amDrop Table permissions...
Posts(6)March 30, 2005, 4:03 amselect date problem
Posts(4)March 30, 2005, 4:03 amRe: Convert EXISTS to JOIN or? Reformulated!
Posts(2)March 30, 2005, 4:03 amT-SQL question
Posts(4)March 30, 2005, 4:03 amxp_cmdshell
Posts(3)March 29, 2005, 9:01 pmsyntax to use var as ColumName in Tsql?
Posts(5)March 29, 2005, 9:00 pmYukon UDT Help
Posts(3)March 29, 2005, 9:00 pmmanipulating binary data
Posts(6)March 29, 2005, 9:00 pmRE: How to get identity from parent Table and insert it into the child
Posts(11)March 29, 2005, 9:00 pmFind minimum value in a list
Posts(2)March 29, 2005, 9:00 pmRE: How to get identity from parent Table and insert it into the child
Posts(3)March 29, 2005, 9:00 pmERR_SYSERR(104):PRM:SQLExecDirect failed (trigger)
Posts(5)March 29, 2005, 9:00 pmtrying to return 2 decimal places (getting errors)
Posts(2)March 29, 2005, 9:00 pmRestore MSDB
Posts(3)March 29, 2005, 9:00 pmDTS error
Posts(4)March 29, 2005, 9:00 pmOpenDataSource
Posts(13)March 29, 2005, 9:00 pmQuery
Posts(2)March 29, 2005, 9:00 pmHELP(!): Possible corrupted DB
Posts(3)March 29, 2005, 9:00 pmHow to get identity from parent Table and insert it into the child table
Posts(10)March 29, 2005, 9:00 pmordering temp table data upon insert
Posts(37)March 29, 2005, 9:00 pmDear All,
Posts(1)March 29, 2005, 9:00 pmproblem using xp_sendmail with Outlook2003
Posts(1)March 29, 2005, 4:01 pmXML Load
Posts(3)March 29, 2005, 4:01 pmRead of XML File
Posts(1)March 29, 2005, 4:01 pmsyntax to use var as ColumName in Tsql?
Posts(1)March 29, 2005, 4:01 pma new SQL tool to help maintain SQL code is now out
Posts(6)March 29, 2005, 4:01 pmtrying to show results in percentages
Posts(1)March 29, 2005, 4:01 pmSQL SERVER 2000 REPLICATION
Posts(3)March 29, 2005, 4:01 pmsyntax to use var as ColumName in Tsql?
Posts(5)March 29, 2005, 4:01 pmsplit address field into Addr1 and Addr2?
Posts(3)March 29, 2005, 4:01 pmTransactions across databases.
Posts(4)March 29, 2005, 4:01 pmHow can I see if a SQL database is modify
Posts(7)March 29, 2005, 4:01 pmConverting Profiles to Stored Procedures
Posts(10)March 29, 2005, 4:01 pmSP_EXECUTE SQL procedure
Posts(5)March 29, 2005, 4:01 pmaccess project front end and SPs
Posts(8)March 29, 2005, 4:01 pmComplicated join query - how is this done?
Posts(6)March 29, 2005, 4:01 pmCombining Time with a Date
Posts(2)March 29, 2005, 4:01 pmRestoring from Backup and Fulltext Catelog
Posts(9)March 29, 2005, 4:01 pmDetermine sequence in log
Posts(3)March 29, 2005, 4:01 pmTimeout problem...
Posts(7)March 29, 2005, 4:01 pmhelp needed with sp_executesql
Posts(3)March 29, 2005, 4:01 pmData in one column contains column name of other table
Posts(3)March 29, 2005, 4:01 pmcreate table question
Posts(3)March 29, 2005, 4:01 pmtable owner
Posts(5)March 29, 2005, 4:01 pmTransact SQL - Compare Sales Query
Posts(1)March 29, 2005, 4:01 pmbulk insert null
Posts(3)March 29, 2005, 4:01 pmbulk insert
Posts(3)March 29, 2005, 4:01 pmCollaion problem
Posts(10)March 29, 2005, 4:01 pmsort porblem
Posts(7)March 29, 2005, 4:01 pmsubtracting dates
Posts(3)March 29, 2005, 4:01 pmNet Send
Posts(11)March 29, 2005, 4:01 pmWhen to commit/rollback transaction
Posts(4)March 29, 2005, 4:01 pmConvert EXISTS to JOIN or?
Posts(5)March 29, 2005, 9:01 amcase in HAVING statement
Posts(2)March 29, 2005, 9:01 amosql utility dependency
Posts(8)March 29, 2005, 9:01 amDatetime only time needed
Posts(5)March 29, 2005, 9:01 amWhat kind of Errors the SELECT statement can raise??
Posts(3)March 29, 2005, 9:01 amLook up a code table to alter a table's column name...
Posts(1)March 29, 2005, 4:02 amRe: Naming conventions
Posts(2)March 29, 2005, 4:02 amloop through informationSchema.Columns table
Posts(3)March 29, 2005, 4:02 amSQL statement vs stored procedure
Posts(6)March 29, 2005, 4:02 amForeign Key can be from Multiple Tables
Posts(2)March 29, 2005, 4:02 amset AD password from a SQL proc?
Posts(1)March 29, 2005, 4:02 amloop through informationSchema.Columns table
Posts(6)March 29, 2005, 4:02 amMulti-Step Transaction fails, but reports success
Posts(5)March 29, 2005, 4:02 amMysterious truncation
Posts(4)March 29, 2005, 4:02 amTriggers and the query that fired them
Posts(2)March 29, 2005, 4:02 amRe: Linked server OPENQUERY, error 'The name <> is not a valid ide
Posts(4)March 29, 2005, 4:02 amCache Problem - URGENT HELP !!!
Posts(6)March 29, 2005, 4:02 amUse of NULL
Posts(7)March 29, 2005, 4:02 amtriggers, locks & concurrency concerns
Posts(1)March 29, 2005, 4:02 amUDT problems
Posts(3)March 28, 2005, 9:00 pmShadow table
Posts(1)March 28, 2005, 9:00 pmRe: Linked server OPENQUERY, error 'The name <> is not a valid ide
Posts(3)March 28, 2005, 9:00 pmAdding locationID's to detail records using SQL syntax
Posts(2)March 28, 2005, 9:00 pmFOR INSERT Trigger
Posts(3)March 28, 2005, 9:00 pmLinked server OPENQUERY, error 'The name <> is not a valid identif
Posts(2)March 28, 2005, 9:00 pmCONVERT Float to char
Posts(1)March 28, 2005, 9:00 pmThanks. That did it.
Posts(2)March 28, 2005, 9:00 pmRE: Updating a record if it is found otherwise Inserting a new one, an
Posts(3)March 28, 2005, 9:00 pmOrder By- CREATIVITY NEEDED!
Posts(1)March 28, 2005, 9:00 pmloop through informationSchema.Columns table
Posts(3)March 28, 2005, 9:00 pmDesign Opinions Please
Posts(3)March 28, 2005, 9:00 pmIdeas to Update DATA received from the client



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

Copyright 2008 codecomments.com