SQL Server, ASP, Technical Articles

// home // advanced search // news // categories // sql build chart // downloads // statistics

Article Search : %

Search phrase:

Search type:	Category:	Updated within:	Order results by:

205 hits for << % >>

Article #2439 How do I use GETDATE() within a User-Defined Function (UDF)? total requests: 20,774 last updated: 2006-06-01
Article #2513 How do I monitor SQL Server performance and uptime? total requests: 4,835 last updated: 2006-06-01
Article #2428 How do I get a list of SQL Server tables and their row counts? total requests: 28,669 last updated: 2006-05-17
Article #2149 Should I store images in the database or the filesystem? total requests: 56,668 last updated: 2006-05-15
Article #2229 Where can I get this 'Books Online' documentation? total requests: 6,522 last updated: 2006-05-15
Article #2527 How do I create a store locator feature? total requests: 5,620 last updated: 2006-05-01
Article #2544 How do I prevent linked server errors? total requests: 25,447 last updated: 2006-04-19
Article #2543 What do I need to know about SQL Server 2000 SP4? total requests: 19,168 last updated: 2006-04-18
Article #2449 How do I recover data from SQL Server's log files? total requests: 18,078 last updated: 2006-04-03
Article #2448 How do I audit changes to SQL Server data? total requests: 16,254 last updated: 2006-04-03
Article #2496 Are there tools available for auditing changes to SQL Server data? total requests: 4,663 last updated: 2006-04-03
Article #2442 How do I manage SQL Server / MSDE? total requests: 50,166 last updated: 2006-04-03
Article #2521 How do I use a variable in a TOP clause in SQL Server? total requests: 11,117 last updated: 2006-03-31
Article #2120 How do I page through a recordset? total requests: 100,970 last updated: 2006-03-27
Article #2423 Where else can I learn about SQL Server? total requests: 13,315 last updated: 2006-03-27
Article #2531 Where is SP4 for SQL Server 2000? total requests: 8,063 last updated: 2006-03-27
Article #2464 What are the valid styles for converting datetime to string? total requests: 16,199 last updated: 2006-02-22
Article #2450 How should I store an IP address in SQL Server? total requests: 6,798 last updated: 2006-02-22
Article #2354 What datatype should I use for my character-based database columns? total requests: 6,541 last updated: 2006-02-07
Article #2445 How do I handle REPLACE() within an NTEXT column in SQL Server? total requests: 17,049 last updated: 2006-02-07
Article #2214 What are the main differences between Access and SQL Server? total requests: 74,954 last updated: 2006-02-07
Article #2009 Why do I get database-related 80004005 errors? total requests: 198,109 last updated: 2006-02-07
Article #2195 What are the limitations of MS Access? total requests: 107,463 last updated: 2005-12-20
Article #2455 Which tool should I use: Enterprise Manager or Query Analyzer? total requests: 26,799 last updated: 2005-10-23
Article #2462 How do I create a cross-tab (or "pivot") query? total requests: 17,876 last updated: 2005-10-07
Article #2105 Schema: How do I show all the triggers in a database? total requests: 7,209 last updated: 2005-10-05
Article #2528 How do I change column order in a table structure? total requests: 4,889 last updated: 2005-10-05
Article #2400 Why do I get 80040E14 errors? total requests: 52,901 last updated: 2005-10-05
Article #2343 What are the limitations of MSDE? total requests: 22,449 last updated: 2005-09-15
Article #2016 How do I temporarily disable a trigger? total requests: 5,488 last updated: 2005-09-14
Article #2293 Why do I get script errors in Enterprise Manager's 'taskpad' view? total requests: 5,694 last updated: 2005-09-12
Article #2431 How do I remove duplicates from a table? total requests: 6,881 last updated: 2005-09-12
Article #2446 Why is tempdb full, and how can I prevent this from happening? total requests: 33,331 last updated: 2005-09-12
Article #2037 How do I find a stored procedure containing <text>? total requests: 20,633 last updated: 2005-09-12
Article #2506 How do I calculate the median in a table? total requests: 7,702 last updated: 2005-09-12
Article #2427 How do I return row numbers with my query? total requests: 15,957 last updated: 2005-08-24
Article #2471 How do I reclaim space in SQL Server? total requests: 32,531 last updated: 2005-08-17
Article #2519 Why should I consider using an auxiliary calendar table? total requests: 16,687 last updated: 2005-08-05
Article #2529 How do I concatenate strings from a column into a single row? total requests: 10,159 last updated: 2005-07-13
Article #2273 How do I get a list of Access tables and their row counts? total requests: 6,763 last updated: 2005-06-29
Article #2280 Should I use BETWEEN in my database queries? total requests: 7,831 last updated: 2005-06-23
Article #2121 Why does ASP give me ActiveX errors when connecting to a database? total requests: 10,289 last updated: 2005-06-17
Article #2328 Why do I get 80040e30 errors? total requests: 2,489 last updated: 2005-06-17
Article #2319 How do I deal with multiple resultsets from a stored procedure? total requests: 4,391 last updated: 2005-06-17
Article #2010 How do I hide system tables in SQL Server's Enterprise Manager? total requests: 11,306 last updated: 2005-06-17
Article #2035 How do I deal with an apostrophe (') in a SQL statement? total requests: 30,396 last updated: 2005-06-17
Article #2259 How do I solve 'Could not find installable ISAM' errors? total requests: 20,345 last updated: 2005-06-17
Article #2165 Why does my DELETE query not work? total requests: 6,146 last updated: 2005-06-16
Article #2138 Why do I get "Login failed for user '\'."? total requests: 12,210 last updated: 2005-06-16
Article #2243 Why does AbsolutePosition return as -1? total requests: 3,197 last updated: 2005-06-16
Article #2241 How do I present one-to-many relationships in my ASP page? total requests: 6,511 last updated: 2005-06-16
Article #2015 How do I determine if a number is odd or even? total requests: 5,895 last updated: 2005-06-16
Article #2155 How do I enable or disable connection pooling? total requests: 8,142 last updated: 2005-06-16
Article #2132 How do I retrieve a random record? total requests: 18,934 last updated: 2005-06-16
Article #2504 What should I choose for my primary key? total requests: 10,378 last updated: 2005-06-01
Article #2530 Can I create an index on a BIT column? total requests: 2,876 last updated: 2005-06-01
Article #2541 Schema: How do I list all the indexes in a database? total requests: 5,520 last updated: 2005-05-25
Article #2126 What should my connection string look like? total requests: 134,698 last updated: 2005-05-23
Article #2440 Why am I having problems with SQL Server 2000 SP3 / SP3a? total requests: 48,395 last updated: 2005-05-10
Article #2260 Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all? total requests: 34,965 last updated: 2005-05-06
Article #2540 Why does sp_spaceused return inaccurate values? total requests: 2,881 last updated: 2005-05-04
Article #2538 What naming convention should I use in my database? total requests: 7,270 last updated: 2005-04-28
Article #2160 How do I know which version of SQL Server I'm running? total requests: 44,331 last updated: 2005-04-22
Article #2209 How do I document / compare my SQL Server database(s)? total requests: 7,246 last updated: 2005-04-21
Article #2533 Could I get some help with JOINs? total requests: 3,735 last updated: 2005-04-19
Article #2537 Should I use a view, a stored procedure, or a user-defined function? total requests: 14,058 last updated: 2005-04-12
Article #2437 How do I find all the available SQL Servers on my network? total requests: 3,244 last updated: 2005-03-24
Article #2190 Can I compact / repair an Access database from ASP code? total requests: 11,043 last updated: 2005-03-24
Article #2307 Why do I get 800A0E78 errors? total requests: 13,529 last updated: 2005-03-24
Article #2057 How can I tell which version of MDAC I'm running? total requests: 16,266 last updated: 2005-03-24
Article #2041 Why do I get 80040E0C errors? total requests: 5,543 last updated: 2005-03-24
Article #2194 How do I prevent my ASP pages from waiting for backend activity? total requests: 11,756 last updated: 2005-03-24
Article #2359 How do I start SQL Server Agent from ASP? total requests: 5,253 last updated: 2005-03-24
Article #2352 How do I handle alphabetic paging? total requests: 5,390 last updated: 2005-03-24
Article #2351 How do I determine if a database exists? total requests: 3,166 last updated: 2005-03-24
Article #2288 What is this 'Multiple-step OLE DB' error? total requests: 24,822 last updated: 2005-03-24
Article #2526 Schema: How do I show the views in a SQL Server database? total requests: 1,964 last updated: 2005-03-24
Article #2340 Why do I get 80040200 / 80040514 / 800A0E7A errors? total requests: 8,465 last updated: 2005-03-24
Article #2188 How do I deal with MEMO, TEXT, HYPERLINK, and CURRENCY columns? total requests: 52,190 last updated: 2005-03-24
Article #2287 Why do I get 80040E31 errors? total requests: 20,734 last updated: 2005-03-24
Article #2197 How do I enumerate through the DSNs on a machine? total requests: 3,436 last updated: 2005-03-24
Article #2314 How do I determine if a column exists in a given table? total requests: 3,918 last updated: 2005-03-24
Article #2327 Why do I get 800A01FB errors? total requests: 10,277 last updated: 2005-03-24
Article #2301 Why do I get 'Not enough space on temporary disk' errors? total requests: 11,863 last updated: 2005-03-24
Article #2159 How do I access MIN, MAX, SUM, COUNT values from SQL statements? total requests: 10,615 last updated: 2005-03-24
Article #2312 Why can't I use LIKE '%datepart%' queries? total requests: 3,228 last updated: 2005-03-24
Article #2306 How do I limit the number of rows returned in my resultset? total requests: 6,815 last updated: 2005-03-24
Article #2104 Schema: How do I show all the primary keys in a database? total requests: 6,618 last updated: 2005-03-24
Article #2520 Schema: How do I find all the foreign keys in a database? total requests: 3,619 last updated: 2005-03-24
Article #2186 How do I connect to SQL Server on a port other than 1433? total requests: 10,548 last updated: 2005-03-24
Article #2130 How do I handle BIT / BOOLEAN columns? total requests: 6,880 last updated: 2005-03-24
Article #2436 Why do I get errors about master..spt_values? total requests: 2,985 last updated: 2005-03-24
Article #2168 Why can't I access a database or text file on another server? total requests: 65,871 last updated: 2005-03-24
Article #2145 How do I debug my SQL statements? total requests: 8,005 last updated: 2005-03-24
Article #2534 What are all these dt_ stored procedures, and can I remove them? total requests: 3,122 last updated: 2005-03-24
Article #2536 Can I implement an input mask in SQL Server? total requests: 5,811 last updated: 2005-03-24
Article #2146 How do I connect to a non-default instance of SQL Server? total requests: 3,648 last updated: 2005-03-23
Article #2244 Schema: How do I show the description property of a column? total requests: 6,348 last updated: 2005-03-20
Article #2038 Which is better, rs(0) or rs("column_name")? total requests: 18,639 last updated: 2005-03-19
Article #2237 Can I start IDENTITY values at a new seed? total requests: 4,280 last updated: 2005-03-18
Article #2097 Why can't I use the * wildcard in a database search? total requests: 12,972 last updated: 2005-03-17
Article #2523 Why are there gaps in my IDENTITY / AUTOINCREMENT column? total requests: 2,980 last updated: 2005-03-12
Article #2516 Why should I consider using an auxiliary numbers table? total requests: 7,927 last updated: 2005-03-12
Article #2118 How do I build a query with optional parameters? total requests: 5,443 last updated: 2005-03-12
Article #2499 Can SQL Server tell me which row was inserted most recently? total requests: 13,024 last updated: 2005-03-12
Article #2174 How do I get the IDENTITY / AUTONUMBER value for the row I inserted? total requests: 57,643 last updated: 2005-03-12
Article #2073 Why should I avoid NULLs in my database? total requests: 18,175 last updated: 2005-03-12
Article #2465 Where can I learn about "Yukon," or SQL Server 2005? total requests: 6,702 last updated: 2005-02-27
Article #2469 Why is Enterprise Manager slow at expanding my database list? total requests: 3,191 last updated: 2005-02-08
Article #2493 Where do I get MSDE? total requests: 2,457 last updated: 2005-01-24
Article #2532 Should I use COALESCE() or ISNULL()? total requests: 6,493 last updated: 2005-01-23
Article #2348 Can I have optional parameters to my stored procedures? total requests: 7,897 last updated: 2005-01-23
Article #2164 Why do I get 80040E37 errors? total requests: 14,885 last updated: 2005-01-22
Article #2470 How do I handle error checking in a stored procedure? total requests: 3,110 last updated: 2005-01-22
Article #2492 How do I get the result of dynamic SQL into a variable? total requests: 4,726 last updated: 2005-01-22
Article #2501 How do I use a variable in an ORDER BY clause? total requests: 13,059 last updated: 2005-01-22
Article #2248 How do I simulate an array inside a stored procedure? total requests: 19,889 last updated: 2005-01-22
Article #2475 Should I use a #temp table or a @table variable? total requests: 39,541 last updated: 2005-01-22
Article #2456 Schema: How do I list the databases on my server? total requests: 8,895 last updated: 2005-01-04
Article #2337 How do I protect my stored procedure code? total requests: 5,239 last updated: 2005-01-03
Article #2082 How do I get rid of Named Pipes / DBNMPNTW errors? total requests: 15,462 last updated: 2004-10-22
Article #2152 How can I make my SQL queries case sensitive? total requests: 12,623 last updated: 2004-08-27
Article #2177 Schema: How do I show the columns for a table? total requests: 22,458 last updated: 2004-08-11
Article #2467 Should I use recordset iteration, or GetRows(), or GetString()? total requests: 18,720 last updated: 2004-07-23
Article #2515 Why does Enterprise Manager return 'Invalid cursor state'? total requests: 5,588 last updated: 2004-07-21
Article #2102 Why do I get 800A0BB9 / 800A1391 errors? total requests: 15,187 last updated: 2004-07-20
Article #2080 What are reserved Access, ODBC and SQL Server keywords? total requests: 37,941 last updated: 2004-07-18
Article #2112 Should I use ADOVBS.inc for declaring constants? total requests: 22,885 last updated: 2004-06-28
Article #2178 Schema: How do I show the tables in a database? total requests: 11,773 last updated: 2004-06-09
Article #2525 Why do I have problems with views after altering the base table? total requests: 5,300 last updated: 2004-06-01
Article #2426 Which database platform should I use for my ASP application? total requests: 4,285 last updated: 2004-05-24
Article #2522 Why do some SQL strings have an 'N' prefix? total requests: 10,358 last updated: 2004-05-18
Article #2284 Why do I get 'object could not be found' or 'invalid object name'? total requests: 8,115 last updated: 2004-05-18
Article #2191 When should I use CreateObject to create my recordset objects? total requests: 65,175 last updated: 2004-05-02
Article #2272 Why is Query Analyzer only returning 255 characters? total requests: 3,111 last updated: 2004-05-02
Article #2463 Schema: How do I show the parameters for a function or stored procedure? total requests: 2,935 last updated: 2004-04-28
Article #2123 Schema: How do I show the stored procedures in a database? total requests: 5,173 last updated: 2004-04-28
Article #2495 How do I manage changes in SQL Server objects? total requests: 3,707 last updated: 2004-04-27
Article #2518 How do I drop a SQL Server database? total requests: 7,387 last updated: 2004-04-13
Article #2142 Why does Access give me 'unspecified error' messages? total requests: 17,252 last updated: 2004-04-10
Article #2062 How do I solve 'Operation must use an updateable query' errors? total requests: 49,366 last updated: 2004-04-10
Article #2182 How do I upsize from Access to SQL Server? total requests: 17,888 last updated: 2004-04-01
Article #2461 Why can't I install SQL Server on Windows Server 2003? total requests: 20,078 last updated: 2004-03-16
Article #2320 Why do I get 800a0cb3 errors? total requests: 6,862 last updated: 2004-02-13
Article #2246 Why do I get 'BOF or EOF' errors? total requests: 17,350 last updated: 2004-01-27
Article #2503 What datatype should I use for numeric columns? total requests: 5,848 last updated: 2004-01-24
Article #2502 How do I ignore common words in a search? total requests: 3,847 last updated: 2004-01-19
Article #2128 Why do I get 80040E10 errors? total requests: 11,915 last updated: 2003-12-17
Article #2148 Why do I get weird results when using both AND and OR in a query? total requests: 3,579 last updated: 2003-12-16
Article #2206 Why doesn't SQL Server allow me to separate DATE and TIME? total requests: 29,499 last updated: 2003-12-16
Article #2342 How do I get the latest version of the JET OLEDB drivers? total requests: 12,061 last updated: 2003-12-15
Article #2245 How do I time my T-SQL code? total requests: 5,355 last updated: 2003-12-15
Article #2512 Schema: How do I show the user-defined functions (UDFs) in a database? total requests: 1,396 last updated: 2003-12-14
Article #2029 How do I create a database from ASP? total requests: 12,271 last updated: 2003-12-14
Article #2447 How do I get the nth row in a SQL Server table? total requests: 11,142 last updated: 2003-12-13
Article #2510 Why do I get 8004D00A errors? total requests: 4,757 last updated: 2003-12-12
Article #2505 How do I rename a column? total requests: 9,661 last updated: 2003-12-11
Article #2509 How do I prevent duplicates in a table? total requests: 19,360 last updated: 2003-12-11
Article #2507 Why do I get 80040E23 errors? total requests: 3,192 last updated: 2003-12-11
Article #2201 Where can I get basic info about using stored procedures? total requests: 67,889 last updated: 2003-12-11
Article #2345 What are the capacities of Access, SQL Server, and MSDE? total requests: 14,478 last updated: 2003-12-07
Article #2494 Why can't I install SQL Server on Windows XP? total requests: 7,369 last updated: 2003-11-29
Article #2193 Why does RecordCount return as -1? total requests: 47,856 last updated: 2003-11-16
Article #2361 Why do I get 80040E21 errors? total requests: 18,677 last updated: 2003-11-14
Article #2285 Why do I get 800A0E7D errors? total requests: 10,717 last updated: 2003-11-09
Article #2438 How do I load text or csv file data into SQL Server? total requests: 16,944 last updated: 2003-11-08
Article #2482 How do I send a database query to a text file? total requests: 7,499 last updated: 2003-11-07
Article #2486 Why do I get 800A0E7C errors? total requests: 3,280 last updated: 2003-11-03
Article #2279 How do I convert columns of values into a single list? total requests: 3,743 last updated: 2003-10-30
Article #2451 How do I convert a SQL Server DATETIME value to a Unix timestamp? total requests: 7,941 last updated: 2003-10-29
Article #2479 How do I use a SELECT list alias in the WHERE or GROUP BY clause? total requests: 3,779 last updated: 2003-10-23
Article #2478 How do I change the order of columns in a table? total requests: 1,726 last updated: 2003-10-23
Article #2458 How do I determine if a table exists in a SQL Server database? total requests: 15,924 last updated: 2003-10-02
Article #2350 How do I determine if a table exists in an Access database? total requests: 5,402 last updated: 2003-10-02
Article #2459 How do I upsize my MSDE database to full-blown SQL Server 2000? total requests: 3,924 last updated: 2003-07-11
Article #2466 How can I learn more about undocumented SQL Server stored procedures? total requests: 2,129 last updated: 2003-07-07
Article #2292 Why can I not 'open a database created with a previous version...'? total requests: 3,254 last updated: 2003-06-26
Article #2460 Can I make SQL Server format dates and times for me? total requests: 36,590 last updated: 2003-06-22
Article #2432 How do I get the correct date/time from the msdb.sysjob* tables? total requests: 3,014 last updated: 2003-06-22
Article #2231 Should I index my database table(s), and if so, how? total requests: 5,111 last updated: 2003-06-16
Article #2154 Why do I get General error Unable to open registry key 'DriverId'? total requests: 27,621 last updated: 2003-06-15
Article #2454 How do I protect my Access database (MDB file)? total requests: 4,561 last updated: 2003-06-14
Article #2096 What is wrong with 'SELECT *'? total requests: 27,398 last updated: 2003-06-14
Article #2441 How do I protect myself against the W32.Slammer worm? total requests: 2,615 last updated: 2003-03-20
Article #2083 How do I solve 'ADO Could Not Find The Specified Provider'? total requests: 4,253 last updated: 2003-02-05
Article #2061 Why do I get 'Argument data type text is invalid for argument [...]'? total requests: 5,801 last updated: 2003-02-04
Article #2434 Why can't I use the TOP keyword? total requests: 2,906 last updated: 2003-01-08
Article #2433 Why is my app slow after upgrading from SQL Server 7 to 2000? total requests: 1,890 last updated: 2003-01-01
Article #2220 Why do I get SQLSetConnectAttr Failed errors? total requests: 10,778 last updated: 2002-09-21
Article #2417 Why do I get 80040E54 errors? total requests: 2,082 last updated: 2002-09-20
Article #2409 Why do I get 80070070 errors? total requests: 4,108 last updated: 2002-09-15
Article #2406 Why do I get 8002000A errors? total requests: 2,542 last updated: 2002-09-15
Article #2289 Why do I get 80040E57 / 80040E07 errors? total requests: 27,767 last updated: 2002-09-14
Article #2282 How do I search for special characters (e.g. %) in SQL Server? total requests: 10,211 last updated: 2002-08-28
Article #2394 Can I use the NZ() function without getting 80040E14 errors? total requests: 4,879 last updated: 2002-08-26
Article #2381 Why do I get 80040E24 errors? total requests: 5,008 last updated: 2002-08-19
Article #2370 Why do I get 80040E2F errors? total requests: 6,991 last updated: 2002-08-18
Article #2275 Why do I get 800A0CC1 errors? total requests: 8,389 last updated: 2002-08-18
Article #2367 Why do I get 800A0C93 errors? total requests: 5,577 last updated: 2002-08-17
Article #2332 Why do I get 80040e4e errors? total requests: 4,446 last updated: 2002-07-18
Article #2326 Why do I get 80040e09 errors? total requests: 12,409 last updated: 2002-07-17
Article #2150 How do I prevent NULLs in my database from mucking up my HTML? total requests: 7,846 last updated: 2002-07-17
Article #2086 Why do I get 'Syntax Error in INSERT INTO Statement' with Access? total requests: 12,376 last updated: 2002-07-08
Article #2256 What does "ambiguous column name" mean? total requests: 7,237 last updated: 2002-02-21
Article #2239 Why does EM crash when I get an error in a stored procedure? total requests: 1,965 last updated: 2002-02-19

// home // advanced search // news // categories // sql build chart // downloads // statistics