For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > July 2006










Posts(2)July 18, 2006, 12:03 ami have datatime,amount,account_nr.how to calculate amount with time properties?
Posts(1)July 13, 2006, 10:55 pmNeed experienced SQL programmer as soon as posible
Posts(1)July 13, 2006, 6:29 amExport tbl to mdb dynamically
Posts(3)July 12, 2006, 10:00 am[DBNETLIB][ConnectionWrite (WrapperWrite()).] General Network error. Check
Posts(1)July 10, 2006, 10:41 pmHelp with sql 2005 varchar(max).
Posts(1)July 10, 2006, 12:56 amCall oracle database
Posts(11)July 4, 2006, 8:02 amSQL/.NET naming convention
Posts(14)July 4, 2006, 8:02 amTemporarily disabling constraints
Posts(2)July 4, 2006, 8:02 amtable permission
Posts(4)July 4, 2006, 8:02 amBlank character in SQL table
Posts(5)July 4, 2006, 8:02 amRandom records based by weight
Posts(2)July 4, 2006, 8:02 amRetrieving excle schema
Posts(3)July 4, 2006, 8:02 amRe: Performance Difference between SELECT * and SELECT col1, col2, ...coln
Posts(3)July 4, 2006, 8:02 amReplication
Posts(2)July 4, 2006, 8:02 amUpdating a stored procedure
Posts(3)July 4, 2006, 8:02 amHow write a sp to return consecutive dates except Sat and Sun?
Posts(2)July 4, 2006, 8:02 amSSMS and Dev Edition
Posts(4)July 4, 2006, 8:02 amconverting datetime for comparison
Posts(1)July 4, 2006, 8:02 amRe: When using the .NET Framework data provider - does connection string style make a
Posts(2)July 4, 2006, 8:02 amTrigger Problem
Posts(1)July 4, 2006, 8:02 amHelp needed to merge a few database - same tables
Posts(11)July 4, 2006, 8:02 amOpposite of union - Stupid question for a common problem
Posts(6)July 4, 2006, 4:05 amAVG by columns not by rows
Posts(9)July 4, 2006, 4:05 amgroup data by time interval
Posts(1)July 4, 2006, 4:05 amUrgent: Concurrency in SQL Server 2005: How to use granularity of Locks in Snapshot i
Posts(4)July 4, 2006, 4:05 amupdate tables with stored procedures
Posts(9)July 4, 2006, 4:05 amSELECT Statement
Posts(4)July 4, 2006, 4:05 amWriting data to database and redirecting to index page
Posts(3)July 4, 2006, 4:05 amUpdate SQL statement with SELECT
Posts(12)July 4, 2006, 4:05 amLock Request time out period exceeded
Posts(3)July 4, 2006, 4:05 amHelp Optimising SP
Posts(3)July 4, 2006, 4:05 amstored procedure precompiled in sql server 2005?
Posts(3)July 4, 2006, 4:05 amsql...... difficult
Posts(3)July 4, 2006, 4:05 amignore table during log shipping
Posts(4)July 4, 2006, 4:05 amHelp with this SQL script.
Posts(5)July 4, 2006, 4:05 amUpdating a column
Posts(3)July 3, 2006, 10:01 pmidentity and rollback
Posts(1)July 3, 2006, 10:01 pmRe: Is there an easy way to synchronize two tables in different databaes
Posts(1)July 3, 2006, 10:01 pmUrgent: Concurrency in SQL Server 2005: How to use granularity of Locks in Snapshot i
Posts(9)July 3, 2006, 10:01 pmPREFIXING COLUMN VALUES WITH 0s
Posts(5)July 3, 2006, 10:01 pmPerformance Difference between SELECT * and SELECT col1, col2, ...coln
Posts(1)July 3, 2006, 10:01 pmRe: Performance Difference between SELECT * and SELECT col1, col2, ...coln
Posts(1)July 3, 2006, 10:01 pmRe: When using the .NET Framework data provider - does connection string style make a
Posts(3)July 3, 2006, 7:05 pmusing the replace function on underscore charaters
Posts(5)July 3, 2006, 7:05 pmJoin DB declared in a variable/parameter
Posts(10)July 3, 2006, 7:05 pmMost recent dependent row only
Posts(3)July 3, 2006, 7:05 pmExec not returning a result
Posts(3)July 3, 2006, 7:05 pmnew commer
Posts(4)July 3, 2006, 7:05 pmremoving decimal points
Posts(1)July 3, 2006, 7:05 pmRe: Performance Difference between SELECT * and SELECT col1, col2, ...coln
Posts(2)July 3, 2006, 7:05 pmLoop through selected value and altering table.
Posts(2)July 3, 2006, 7:05 pmRe: Good books about huge databases ? [OT]
Posts(10)July 3, 2006, 7:05 pmMultipls cursors help
Posts(5)July 3, 2006, 7:05 pmShould you tune against subtree cost, scan count, or logical reads?
Posts(11)July 3, 2006, 7:05 pmI have problem with comparing records in the same table
Posts(3)July 3, 2006, 7:05 pmSQL 2005 versus SQL 2000 Difference - Order By Column qualification
Posts(21)July 3, 2006, 7:05 pmcan a SELECT return this result ?!
Posts(5)July 3, 2006, 7:05 pmDisplaying numbers like 05 instead of 5
Posts(3)July 3, 2006, 7:05 pmsubtracting fields from two records
Posts(3)July 3, 2006, 7:05 pmmigrate sql2k dts packages to sql2k5
Posts(3)July 3, 2006, 7:05 pmCalling a Stored Procedure from inside of a loop..
Posts(1)July 3, 2006, 7:05 pmRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(1)July 3, 2006, 7:05 pmWhen using the .NET Framework data provider - does connection string style make a dif
Posts(7)July 3, 2006, 7:05 pmSimple query question...
Posts(5)July 3, 2006, 7:05 pmTrace textdata truncated
Posts(2)July 3, 2006, 7:05 pmRe: Is there an easy way to synchronize two tables in different databaes using a SQL
Posts(5)July 3, 2006, 7:05 pmtable variable sql 2005
Posts(3)July 3, 2006, 7:05 pmRe: [ database_name . [ schema_name ] . | schema_name . ] table_na
Posts(2)July 3, 2006, 7:05 pmQuestion on correct syntax for stored procedure
Posts(3)July 3, 2006, 7:05 pmHow to convert xs:datetime into sql datetime type?
Posts(6)July 3, 2006, 7:05 pmRe: [ database_name . [ schema_name ] . | schema_name . ] table_na
Posts(1)July 3, 2006, 7:05 pmMultipls cursors help
Posts(2)July 3, 2006, 7:05 pmsync-ing databases over an internet connection
Posts(8)July 3, 2006, 7:05 pmA tricky query
Posts(10)July 3, 2006, 8:03 amconcatenate - maybe?
Posts(7)July 3, 2006, 8:02 amSql query prob
Posts(7)July 3, 2006, 8:02 amConvert 1-column result set to 3 columns
Posts(1)July 3, 2006, 8:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(2)July 3, 2006, 8:02 amArithmetic overflow error converting float to data type numeric.
Posts(4)July 3, 2006, 8:02 amHow to accomplish creating a simple calculated column in a table
Posts(1)July 3, 2006, 8:02 amInternal SQL Server Error using OPENROWSET in SQL Server 2000 SP4
Posts(4)July 3, 2006, 8:02 amComparing two tables
Posts(5)July 3, 2006, 8:02 amUrgent - Aggregated Query
Posts(1)July 3, 2006, 8:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(2)July 3, 2006, 8:02 amStored procedures for updating table
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(3)July 3, 2006, 4:02 amReplication and ReadOnly Database
Posts(1)July 3, 2006, 4:02 amSQL Server 2005 SP1 error: A transport-level error has occurred when receiving result
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(1)July 3, 2006, 4:02 amRe: SQL Server 2005 SP1 error: A transport-level error has occurred when receiving re
Posts(6)July 3, 2006, 4:02 amNeed help with SQL Syntax
Posts(4)July 3, 2006, 4:02 amMigration Meta Data Storage
Posts(5)July 3, 2006, 4:02 amUpdate multiple tables
Posts(3)July 3, 2006, 4:02 amalternative function for to_char in sql server
Posts(2)July 2, 2006, 10:01 pmSS2005 Version Control
Posts(9)July 2, 2006, 10:01 pmselect based on containing only certain characters
Posts(4)July 2, 2006, 10:01 pmGood books about huge databases ?
Posts(9)July 2, 2006, 10:01 pmIteration in a stored procedure
Posts(5)July 2, 2006, 10:01 pmCREATE TABLE [ database . [ schema1 ] . | schema1. ] tableName
Posts(1)July 2, 2006, 10:01 pmMaintenance failing
Posts(1)July 2, 2006, 10:01 pmUpdate multiple tables
Posts(1)July 2, 2006, 10:01 pmUpdate multiple tables
Posts(1)July 2, 2006, 10:01 pmUpdate multiple tables
Posts(3)July 2, 2006, 10:01 pmProgress Versus SQL Server
Posts(2)July 2, 2006, 7:02 pmI downloaded and installed SQLEXPR_ADV.EXE
Posts(2)July 2, 2006, 7:02 pmGuardar y recuperar texto con formato
Posts(5)July 2, 2006, 7:02 pmHow to move a SQL Server 7 (no Service Pack) database to SQL Server 2005???
Posts(8)July 2, 2006, 7:02 pmCannot create new SQL database.....
Posts(2)July 2, 2006, 4:01 amAbout the presence of alter procedure?
Posts(3)July 2, 2006, 4:01 amsql statement
Posts(2)July 2, 2006, 4:01 amSQL 2005 Role Permissions
Posts(16)July 2, 2006, 4:01 amSQL Newbie
Posts(5)July 1, 2006, 7:02 pmConcat key Query Question
Posts(7)July 1, 2006, 7:02 pmSQL question
Posts(5)July 1, 2006, 7:02 pmConsidering blank spaces
Posts(2)July 1, 2006, 7:02 pmRe: Performance Problems Restoring SQL 7 Win2000 DB To SQL 2000 Wi
Posts(1)July 1, 2006, 7:02 pmUNION or other solution?
Posts(7)July 1, 2006, 7:02 pmdb connection jump from 350 to 2000
Posts(13)July 1, 2006, 7:02 pmMore Efficient SQL Statement - Select Count(1)
Posts(1)July 1, 2006, 8:03 amADO and distributed transaction on SQL server 2000
Posts(4)July 1, 2006, 4:02 amsql merge
Posts(2)July 1, 2006, 4:02 amdbcc inputbuffer value
Posts(6)July 1, 2006, 4:02 amquery running slow
Posts(3)July 1, 2006, 4:02 am[ database_name . [ schema_name ] . | schema_name . ] table_name
Posts(2)July 1, 2006, 4:02 amWriteable views
Posts(1)July 1, 2006, 4:02 amSQL Server maintenance fails
Posts(3)July 1, 2006, 4:02 amScheduling of snapshot agent




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

Copyright 2008 codecomments.com