Databases

MS SQL

Please support our MS SQL advertiser: Intel Parallel Studio Home

Our Web Development forum category encompasses everything related to building a website from the ground up. Topics include serverside scripting, clientside scripting, databases, and web / graphic design. When posting programming code, encase it in [code], [code=syntax], or [icode] bbcode tags. Please only link to your website if it is necessary to demonstrate how something isn't working.

Our Databases sub-category encompasses everything related to data storage, both for the web and other uses.

Our MS SQL forum is the place for Q&A-style discussions related to Microsoft SQL Server. Note we have an ASP.NET forum to use in tandem to MS SQL. Additionally, there is a Windows Servers and IIS forum within the Networking sub-forum of the Hardware and Software category.

Forum Tools

•

Views: 63,098

May 3rd, 2005

Announcement: No site advertisements please!

cscgal (The Queen of DaniWeb)

Views: 68,504

Jun 8th, 2004

Announcement: Please use BB Code and Inlinecode tags

cscgal (The Queen of DaniWeb)

Last »

Last Post / Replies

/ Views

Votes / Thread / Poster / Start Date

Installing SQL Server Express on Vista Home Premium ( 1 2 3 4) Hers2keep (Sep 6th, 2008)	Sep 10th, 2008 by dickersonka	33	6,409
Solved: sql 2005 server error ( 1 2 3) pace59 (Jan 26th, 2009)	Jan 28th, 2009 by Ramy Mahrous	27	1,782
Solved: formatting in sql server ( 1 2 3) kischi (Dec 22nd, 2008)	Dec 26th, 2008 by Ramy Mahrous	22	2,083
Solved: Need help with SQL update query ( 1 2) chad_jensen71 (Apr 2nd, 2009)	Apr 3rd, 2009 by chad_jensen71	19	1,253
Solved: Insert multiple records using stored procedure ( 1 2) phuynh77 (Oct 28th, 2008)	Nov 3rd, 2008 by phuynh77	19	6,857
help ( 1 2) pace59 (Feb 17th, 2009)	Feb 19th, 2009 by pace59	16	1,371
Solved: SQL 2000 performance problem ( 1 2) rockdays (Feb 24th, 2009)	Feb 26th, 2009 by sknake	16	1,238
Solved: Copying only the records that don't already exist in destination table. ( 1 2) dron (Jan 22nd, 2009)	Jan 24th, 2009 by johnny.g	16	1,378
Simple query I cannot figure out ( 1 2) LAMDB (Jul 6th, 2009)	Jul 7th, 2009 by cgyrob	15	715
Solved: Get data out of excel file stored as an image ( 1 2) M_K_Higa (Sep 22nd, 2006)	Nov 2nd, 2007 by M_K_Higa	15	13,592
Solved: Sql server 2005 ( 1 2) safealloys (Jun 11th, 2008)	Jun 25th, 2008 by arupa	15	2,256
SQL Server vs MYSQL vs MSQL (i'm stopping now) ( 1 2) AlPhA (Feb 9th, 2002)	Dec 21st, 2004 by mikeSQL	14	19,993
help with an sql statement ( 1 2) lebanese007 (Jan 29th, 2008)	Jan 31st, 2008 by Zadj	13	2,433
Solved: Problem in Calculating Total Score in a Quiz Database ( 1 2) KushKashyap (Feb 7th, 2009)	Jul 27th, 2009 by Sakthimeenakshi	13	1,548
Count/Sum distinct problem ( 1 2) 2eXtreme (Jun 10th, 2008)	Dec 7th, 2008 by petrhorak	13	5,907
duplicate rows ( 1 2) lorraine1000 (Aug 2nd, 2006)	Aug 2nd, 2006 by lorraine1000	13	6,667
Solved: how to delete duplicate record in a table by using SQL query ( 1 2) g.prabu (Feb 19th, 2007)	26 Days Ago by edgarkuhimbisa	13	26,980
Solved: Removing duplicates from INNER JOIN of two tables ( 1 2) rgothard (Apr 9th, 2009)	Apr 14th, 2009 by rgothard	12	2,280
Get All Rows In Column In A Where Statment ( 1 2) blackraven (Nov 28th, 2005)	Nov 30th, 2005 by blackraven	12	9,326
query problems ( 1 2) vampke (Apr 10th, 2009)	May 1st, 2009 by vampke	11	1,250
alter table stored procedure...???... ( 1 2) GLT (May 23rd, 2008)	Jun 23rd, 2009 by safacon	11	6,854
Creating a function ( 1 2) paxmaster (Jan 11th, 2009)	Jan 19th, 2009 by Ramy Mahrous	11	2,029
Solved: Counting/Summation within dataset ( 1 2) Link82 (Jul 13th, 2009)	Jul 13th, 2009 by sknake	11	500
How to Backup database - SQL Server 2000 ( 1 2) cancer10 (Oct 27th, 2006)	Feb 16th, 2007 by BoimSoulPower	11	13,747
Solved: Get records from current year ( 1 2) 21KristianN (21 Days Ago)	19 Days Ago by kplcjl	11	772
Need help ordering records ( 1 2) 2eXtreme (May 21st, 2008)	May 27th, 2008 by 2eXtreme	11	1,532
Solved: 'CITY' is not a recognized optimizer lock hints option ( 1 2) bajanpoet (Jan 27th, 2009)	Jan 27th, 2009 by bajanpoet	10	1,720
Solved: sql - how to ( 1 2) Tara423 (Mar 12th, 2008)	Mar 13th, 2008 by Tara423	10	1,411
Solved: How to get the result for smaller number divide larger number? ( 1 2) 330m (Jun 10th, 2005)	Jun 17th, 2008 by peter_budo	10	11,173
Importing csv to MS SQL ( 1 2) oddvalue (Jun 16th, 2009)	Aug 11th, 2009 by cgyrob	10	1,197
Autonumber in a SQL Server table ( 1 2) Madmax (May 17th, 2005)	Sep 14th, 2006 by Zandyke	10	116,106
Meeting at least n criteria from given criteria ( 1 2) coolick81 (Sep 9th, 2008)	Sep 10th, 2008 by dickersonka	10	1,259
Solved: restrict field to alpha only ( 1 2) hkansal (Mar 4th, 2009)	Mar 9th, 2009 by hkansal	10	1,625
Basic SQL made Hard ( 1 2) Paul.Esson (Feb 15th, 2005)	Feb 1st, 2007 by shadowrider	10	6,675
Crazy CrossTab problems ( 1 2) muek (Dec 29th, 2008)	Jan 1st, 2009 by muek	10	1,036
Unable to delete SQL records JohnC (Mar 27th, 2006)	Apr 2nd, 2006 by campkev	9	5,329
Finding the nth row (SQL)...debative question deostroll (Mar 6th, 2007)	Aug 25th, 2009 by huangzhi	9	8,116
SQL SERVER 2000 Selecting a record based on an aggregate function Slade (Aug 24th, 2004)	Aug 13th, 2009 by manoshailu	9	71,238
Help With SQL Server Agent carey2487 (Jul 26th, 2005)	Aug 3rd, 2005 by carey2487	9	11,914
Solved: Problem with SQL statement in Microsoft Access HB25 (Jun 4th, 2008)	Jun 6th, 2008 by HB25	9	2,297