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,120

May 3rd, 2005

Announcement: No site advertisements please!

cscgal (The Queen of DaniWeb)

Views: 68,518

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

	Autonumber in a SQL Server table ( 1 2) Madmax (May 17th, 2005)	Sep 14th, 2006 by Zandyke	10	116,156
	Changing the datatype of a Column Letscode (Jul 14th, 2005)	27 Days Ago by munna barik	5	74,220
1	insert multiple rows in database sweetyp (Oct 26th, 2005)	Jun 22nd, 2007 by JacobSteelsmith	5	73,451
	SQL SERVER 2000 Selecting a record based on an aggregate function Slade (Aug 24th, 2004)	Aug 13th, 2009 by manoshailu	9	71,252
	datetime format in ms sql stoefln (Nov 29th, 2005)	Apr 22nd, 2009 by akronymn	3	54,961
	Default current datetime for column dieterm (Jul 26th, 2005)	Dec 26th, 2006 by wieland	5	52,498
	Find table size jamesg (Jun 30th, 2005)	Jun 30th, 2005 by Letscode	1	43,036
	New line Character in column alias manishkaushik (Jul 14th, 2005)	Jan 17th, 2007 by szabogi	8	32,464
	Solved: how to delete duplicate record in a table by using SQL query ( 1 2) g.prabu (Feb 19th, 2007)	27 Days Ago by edgarkuhimbisa	13	26,994
	Converting a string to number Dorothy.Maseko (Nov 30th, 2005)	Dec 2nd, 2005 by campkev	4	25,034
	Join 3 tables malstrom (Jul 21st, 2006)	Sep 14th, 2006 by chmonalisa	1	24,983
	auto increment feature/ help me people gani (Jul 21st, 2006)	Jul 21st, 2006 by gani	2	24,021
	Get table list from SQL 2k server Seba Sama (Aug 2nd, 2006)	Aug 2nd, 2006 by Seba Sama	2	23,273
	mssql server doesn't open port 1433 but open other ports that communicate with the DN rgodfrey1 (Nov 14th, 2006)	Aug 18th, 2007 by CUTELAMBA	6	22,512
	Compare two tables aish (Nov 21st, 2005)	Nov 22nd, 2005 by noman78	1	21,659
	In-line If-Else Block? versatilewt (Apr 20th, 2006)	May 10th, 2006 by eralper	4	21,082
	RPC server unavailable SquirrelProdigy (May 19th, 2005)	Jun 16th, 2005 by jwshepherd	1	20,082
	SQL Server vs MYSQL vs MSQL (i'm stopping now) ( 1 2) AlPhA (Feb 9th, 2002)	Dec 21st, 2004 by mikeSQL	14	19,993
	Incorrect syntax near '='. Qmoto (Dec 6th, 2006)	Dec 14th, 2006 by Qmoto	5	19,248
	INSERT CLAUSE using SUB-QUERY Letscode (Oct 18th, 2005)	Oct 24th, 2005 by Letscode	1	19,205
	Exclude duplicate records in a JOIN Geek-Master (Apr 10th, 2007)	Apr 11th, 2007 by hollystyles	8	18,355
	How does views work in MS SQL tyger (Jun 1st, 2005)	Jun 25th, 2005 by pclfw	2	18,273
	Triggers Loop or Stored Procedures Loop web developer (Apr 18th, 2006)	Apr 19th, 2006 by web developer	3	18,217
	MS SQL data type length michael123 (Jul 14th, 2006)	Jul 21st, 2006 by michael123	4	18,033
	Solved: connecting sql to VB.NET kbal024 (Apr 9th, 2006)	May 10th, 2007 by jbennet	3	16,876
	Solved: Copy a table from one database to another database in another ms sql server using .. serkan sendur (Mar 11th, 2008)	Mar 13th, 2008 by hollystyles	7	16,691
	Default value of a column gymanual (Nov 30th, 2005)	Nov 30th, 2005 by campkev	2	16,173
	DATETIME data type arithmenic in SQL Server 2005 quiptro (Apr 22nd, 2007)	Apr 24th, 2007 by davidcairns	4	15,032
	Can return a Stored Procedure Recordset extofer (Jun 15th, 2006)	Jun 17th, 2006 by pty	1	14,891
	Range of records in Top clause noman78 (Feb 14th, 2006)	Feb 16th, 2006 by Letscode	1	14,117
	datetime format mattjpoole (Jan 16th, 2006)	Jan 19th, 2006 by mattjpoole	2	13,789
	How to Backup database - SQL Server 2000 ( 1 2) cancer10 (Oct 27th, 2006)	Feb 16th, 2007 by BoimSoulPower	11	13,749
	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,599
	Setup and Run MSDE. percent20 (Feb 28th, 2005)	Oct 11th, 2006 by loquin	2	13,423
	How to add not null column in SQL Server 2005 bhavna_816 (Apr 7th, 2008)	Apr 15th, 2008 by plazmo	2	13,408
	How to create a Temporary Table fdtoo (Apr 12th, 2006)	Apr 12th, 2006 by fdtoo	0	13,264
	Must declare the scalar variables in storedprocedure in sql 2005 miaaa00 (Apr 3rd, 2007)	Apr 4th, 2007 by davidcairns	3	12,890
	Ambiguous column name in self join bklurch (Aug 1st, 2006)	Aug 1st, 2006 by bklurch	6	12,791
	Help With SQL Server Agent carey2487 (Jul 26th, 2005)	Aug 3rd, 2005 by carey2487	9	11,915
	about comparison operators, LIKE operator ramy2622 (Sep 28th, 2006)	Sep 30th, 2006 by Inanna	1	11,695