A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The...
[more]
A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI / ISO standard.
Next batch for SQL Server 2008 DBA & TSQL programming training starts on January -15th. Please call me @267 718 1533 & enroll in advance. I have 9 years extensive experience in SQL Server 2008/2005/2000 database administration with …
Go here to see the original:
Comprehensive SQL Server 2008 DBA & TSQL programming training … Read Full Story
The SQL Documentation Tool database documentor tool creates technical documentation for Microsoft SQL Server 7.0, 2000, 2005 and 2008 databases. Technical documentation is created in HTML, HTML Help, RTF and plain text formats. The HTML Help format documentation is fully searchable and cross referenced. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, [...] Read Full Story
Book Details Author:Priscilla Walmsley No of Pages: 491 pages Press: O'Reilly Media; illustrated edition Dated:April 1, 2007 Language: English ISBN-10: 0596006349 ISBN-13: 978-0596006341 Book Description With the XQuery 1.0 standard, you finally have a tool that will make it much easier to search, extract and manipulate information from XML content stored in databases. This in-depth tutorial not only walks you through the XQuery specification, but also teaches you how to program with this... Read Full Story
Cursor means memory address where SQL data processed. By using cursor one can process data one by one by looping through all records within a cursor. So when developer thinks that there is no way to accomplish an operation by writing a single query then the alternative solution is cursor. That means cursor ease our life by providing a looping mechanism through all records. But one thing keep in mind that SQL Server cursor performance is very bad than oracle cursor. So think twice when you... Read Full Story
I need a mysql database with front end PHP. The database needs to have 4 user levels. I require a database that will hold the following information: Song Name Song Length Song Genre (More than... (Budget: $250-750, Jobs: .NET, Apache, ASP, Cloud Computing/EC2, PHP) Read Full Story
Book Details Author:Robert D. Schneider and Darril Gibson No of Pages: 768 pages Press: For Dummies Dated:September 29, 2008 Language: English ISBN-10: 0470179546 ISBN-13: 978-0470179543 Book Description If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here... Read Full Story
A business partner is emailing data to us, and I would like to extract it directly from the MS Exchange 2003 store via SQL Server 2005. I have my regular expressions in place to pull the data out of messages, but I still can't get to the messages themselves! I spent all day yesterday chasing down threads of information, but haven't yet put all the pieces together into a viable solution. Here's the pertinent information:
Exchange server: mail01.example.com
SQL Server: sql01.example.com... Read Full Story
This is simple post to implement the pagination in SQL Server using Analytical functions. -- Variable Declaration DECLARE @PageLimit smallint, @CurrentPageNumber smallint SET @PageLimit = 10 -- Setting Page Limit to 10 SET @CurrentPageNumber = 10 -- Current Page Number DECLARE @StartRow INT DECLARE @EndRow INT -- Calculating the starting row SET @StartRow = ((@CurrentPageNumber-1) * @PageLimit) -- Calculation the Ending row SET @EndRow = @StartRow + @PageLimit -- Query to get the actual... Read Full Story
Hello,
I've created a database and I would like to write a query that uses variables from my application and perform calculations on the resulting data.
I'm able to display the results of a simple query within a single table in a listbox, but I'm having trouble figuring out how to attach a sql command to a button press that queries multiple tables.
Once I've been pointed in the right direction for how I can do this, I should be able to figure the sql bit out myself. Read Full Story
char[(n)] - Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character. varchar[(n)] - Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 characters in length. The SQL-92 synonyms for varchar are char vary... Read Full Story
