Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Convert BIGINT to DATE format
- Hi..I have a mySQL query like the following:SELECT wo.CREATEDTIME FROM woThe result is supposed to be a list of date in a human-readable date format (i.e. 26 Jul 2006, 13:40:03) instead of a BIGINT value (i.e. 1153896003593).Pls advise how to convert the BIGINT value into a human-readable date format. Tks.I'm...
- Tags: BigInt, Convert BIGINT, joko.santoso@..., MySQL, programming
- Q&A 2006-10-02
Additional Resources
- D Programming Language Library DWin (exe)
- D programming language library DWin is a library for the "D Programming language", Packages included in DWin cover such areas as: Windows COM client programming, Windows Registry module, PCRE Regular Expression, send email, loads an ini style file muliti line supported, BigInt, and create Windows shortcut. This version is the...
- Tags: Programming Language, Programming, Development Tools, Programming Languages, Software Development, Software/Web Development
- Software downloads 2008-03-18
- MyDeveloper Tools for VS.NET (exe)
- MyDeveloper Tools formerly known as MySQL Developer Tools is a powerful add-in designed to simplify the MySQL database application development process. It integrates into Visual Studio, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design...
- Tags: Microsoft Visual Studio.Net, MySQL, SQL, Devart, Databases, Open Source, Storage, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2007-12-14
- Detecting index fragmentation in SQL Server 2005
- When data is inserted, updated, or deleted in a database table, if indexes exist that operate on the table, they must be maintained to reflect the table data changes. The maintenance of these indexes will eventually cause the indexes to become less efficient. This inefficiency is typically due to the...
- Tags: Function, Database, Fragmentation, Workaround, Microsoft SQL Server, Index, Microsoft SQL Server 2005, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2007-12-17
- SQL Server 2000 offers key enhancements
- Microsoft SQL Server 2000 has introduced new datatypes, user-defined counters, and recovery options. Discover how to put these features to work.By Tim BradleyMicrosoft SQL Server 2000 has introduced many new features, including additional datatypes, user-defined counters, and recovery options. Here's an overview of these features and a look at how...
- Tags: Performance management, Databases, Guest Contributor, datatype, Microsoft SQL Server, counter, user-defined counter, v2K, Microsoft SQL Server 2000, transaction log backup, BULK_LOGGED, performance
- Technical articles 2002-03-11
- Insert using data from form transact sql
- I am trying to write a simple query or so I thought that takes data from an Access form and inserts it into the database. as far as I can tell my syntax is right but it doen't seem to be aware of the form. The code is ALTER PROCEDURE...
- Tags: Forms, Microsoft SQL Server Transact-SQL, noel@..., proceedure, programming, syntax
- Q&A 2005-03-18
- Why choosing SQL Server CE over Access CE makes sense
- It's taken a little while, but I’ve finally come to terms with the idea of a relational database on a handheld device. This acceptance required two things: The first was the realization that a current generation Pocket PC has more storage than a 1980s minicomputer; the second was SQL Server...
- Tags: Microsoft Windows, Databases, Enterprise software, Handhelds, Edmond Woychowsky, Microsoft Access, Microsoft SQL Server, SQL Server CE, Microsoft Windows CE
- Technical articles 2004-02-23
- Debugging stored procedures in SQL Server's Query Analyzer
- When Arthur Fuller learned that one of his colleagues was unaware that there was a debugger built into SQL Server's Query Analyzer, he figured that other developers may be in the dark about this great feature. Find out how to get the most benefit out of the debugger. While...
- Tags: Arthur Fuller, Mice, Databases, Programming languages, Microsoft development tools, Microsoft SQL Server, server, debugger, Query Analyzer, Object Browser, stored procedure, SQL Server Newsletter, TechRepublic Inc., Procedure, Enterprise Software, Hardware, Peripherals, Software, Data Management
- Technical articles 2005-07-01
- Using recursion in stored procedures
- The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic's free SQL Server newsletter, delivered each Tuesday, contains hands-on tips that will help you become more adept with this...
- Tags: Recursion, Databases, Arthur Fuller, Programming languages, recursion, SQL Server Newsletter, TechRepublic Inc., Integer, Microsoft SQL Server, Programming, Object, Development Tools, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
- Technical articles 2005-05-09
- Finding dependencies in SQL Server 2005
- Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used. ...
- Tags: Procedure, Microsoft SQL Server, Microsoft SQL Server 2005, Object, SalesHistory, SalePrice, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-02-04
- Avoid future frustration in database design by understanding MySQL data types
- Data stored in a database comes in all shapes and sizes.Some fields store only numbers, some only text, and others a combination of thetwo. Some databases also support specialized types: dates and times, binarystrings and Booleans.Selecting from available data types to find the best matchfor your data is an important...
- Tags: Storing, Value at Risk, Contributor Melonfire, database, integer value, MySQL, integer, precision, RDBMS
- Technical articles 2005-12-02
- Optimize your databases with PostgreSQL data types
- Like all database systems, PostgreSQLlets you store data using a variety of different data types. These data typesallow the database engine to optimize its use of memory and storage, and toperform operations on the stored data more efficiently and with fewer errors. Data type selection plays an important role in...
- Tags: Contributor Melonfire, data type, database, integer, INTEGER, integer value, PostgreSQL, Storing, Value at Risk
- Technical articles 2005-10-24
- Write custom trace files in TSQL
- SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace...
- Tags: Monitor, Event, Microsoft SQL Server, Trace, Microsoft SQL Server 2005, Data Column, Tim Chapman
- Blog posts 2007-08-20
- Indexing SQL Server relational databases for performance
- By Mark StrawmyerIndexing in a relational database creates a performance tradeoff that is often overlooked. The more indexes you have, the more likely you will retrieve data from the system quickly. However, it's equally true that the more indexes you have, the longer it will take to insert new data...
- Tags: Crowe, Chizek and Company LLP, Microsoft SQL Server, database, RDBMS, server, performance
- Technical articles 2004-02-11
- Read about Microsoft's development offerings for 2008
- I spend much of my time knee deep in Microsoft technologies, and I often find it difficult to keep up with the new products and versions. Fortunately, I usually have some time to get up to speed because most organizations are slow to adopt new technologies and upgrade to new...
- Tags: Developer, Microsoft Visual Studio, IDE, Microsoft .NET Framework, Microsoft SQL Server, Microsoft Visual Studio 2008, Microsoft Windows Presentation Foundation, Microsoft Corp., Feature, Tool, .NET Framework 3.5, LINQ, SQL Server 2008, Microsoft Development Tools, .Net, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Tony Patton
- Blog posts 2007-11-27
- 10+ common questions about SQL Server data types
- SQL Server has a variety of data types, and as with anything, the more options you have, the more confusing a choice can be. Most misunderstandings arise from data type limitations rather than functionality. Here are the most common questions I receive about using SQL Server data types. ...
- Tags: Byte, Microsoft SQL Server, Server, Data Type, Datetime2, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-05-15
- << Previous
- page 1 of 1
- Next >>
