|
|
|
|
|
Total Hits: 505 | Today: 1
|
Author: MSDN
|
Rating:
|
|

Microsoft SQL Server 2005 Express Edition with Advanced Services is a new, free, easy-to use version of SQL Server Express that includes more features and makes it easier than ever to start developing powerful data-driven applications for web or local desktop development....
|
|
|
|
Total Hits: 590 | Today: 0
|
Author: S.S. Ahmed
|
Rating:
|
|

It’s been years now, SharePoint 2007 is about to appear in the market, SharePoint 2003 seems to be something that is history now (Exaggerating …). Many companies have adopted SharePoint during the last one year. Good thing is that I have seen lots of small businesses acquiring SharePoint during the last one year. SharePoint’s popularity is growing day by day and it is considered to be a top level portal product....
|
|
|
|
Total Hits: 764 | Today: 0
|
|
Rating:
|
|

SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDAT...
|
|
|
|
Total Hits: 1322 | Today: 1
|
|
Rating:
|
|

Subjects covered will include the new data types, cascading DRI, user defined functions, INSTEAD OF triggers, XML, distributed views, and new and improved tools such as the TSQL debugger in the Query Analyzer and the Copy Database wizard......
|
|
|
|
Total Hits: 1258 | Today: 0
|
|
Rating:
|
|

One of the most asked questions involves a bit of code like this: Select * From Products Where ProductID in (@SomeCSVString). I've always said the only way to do this was through dynamic SQL. Actually there's a better way in SQL Server 2000. It doesn't involve dynamic SQL and it's really easy to use....
|
|
|
|
Total Hits: 1435 | Today: 0
|
Author: William Pearson
|
Rating:
|
|

Introduction to MSSQL Server 2000 Analysis Services, which I hope will help new users get up to speed quickly on this exciting functionality.The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services (to which I will refer in many cases as simply "Analysis Services" to save time and space); our primary focus will be the creation of simple multi-dimensional OLAP cubes, with each installment progressively adding more features designed to meet...
|
|
|
|
Total Hits: 1277 | Today: 0
|
Author: William Pearson
|
Rating:
|
|

the Dimension Wizard is a helpful tool for rapid cube design,we often come across scenarios where we have to take more direct control of the dimension design process. We accomplish this through the use of the Dimension Editor, which exposes numerous properties of a dimension that are not accessible to us through the use of the Dimension Wizard....
|
|
|
|
Total Hits: 1603 | Today: 1
|
Author: Alex Campbell
|
Rating:
|
|

SQL (structured query language) is the language of databases. In this article, I am not going to conform to convention and waste ink entertaining the fantasy that SQL is standard. There is an ANSI SQL standard, yes. But neither of the major SQL database servers - MS SQL Server and Oracle - conforms to it, and for the purposes of this document, the SQL will be of the Microsoft SQL Server variety....
|
|
|
|
Total Hits: 2281 | Today: 0
|
|
Rating:
|
|

Get easy access to complete SQL Server 2000 documentation by downloading this HTML Help file to your desktop....
|
|
|
|
Total Hits: 1403 | Today: 0
|
|
Rating:
|
|

This is the second article in this series. This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learnt by all beginners....
|
|
|
|
Total Hits: 1446 | Today: 0
|
|
Rating:
|
|

An interactive SQL tutorial. Including online access to SQL engines running MySQL, SQL Server, Oracle and Access....
|
|
|
|
Total Hits: 1741 | Today: 0
|
|
Rating:
|
|

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductor...
|
|
|
|
Total Hits: 274 | Today: 0
|
Author: SeeSharp
|
Rating:
|
|

Sometimes while developing an application we need to enter first name and last name ar anything related to this. While inserting into the database it will be done as it is. but sometimes while retrieving the same need manipulation as was in my case. So in my application it was required to retrieve first letter of two words sentence and generate a report based on that. I initially tried it in code behind but later i realised it can be done in a very simple way with just a ONE LINE QUERY....
|
|
|
|
Total Hits: 542 | Today: 0
|
Author: Ewald Geschwinde, Hans-Juergen Schoenig.
|
Rating:
|
|

Structured Query Language (SQL) is a database query language that was adopted as an industry standard in 1986. A major revision of the SQL standard, SQL2, was released in 1992. Its successor, SQL3, also contains object-oriented components. Currently, ANSI SQL92 is the most important standard. This language enables you to pose complex questions to a database. It also provides a means of modifying databases. SQL is widely used. Many databases support SQL, which means that if you learn how to use S...
|
|
|
|
Total Hits: 673 | Today: 0
|
Author: Juergen Auer
|
Rating:
|
|

The tutorial uses a sample in all lessons and shows not only simple, but also more complex queries like subqueries and Group By, combined with Joins. An Offline-Interface, written in NET, allows to execute Sql-Commands directly, no additional program is required....
|
|
|
|
Total Hits: 1027 | Today: 0
|
|
Rating:
|
|

SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.The article then concentrates on XML support,covering XML data retrieval and manipulation, queries, and HTTP a...
|
|
|
|
Total Hits: 1301 | Today: 1
|
|
Rating:
|
|

This article explains the basics of SQL as a Q&A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful....
|
|
|
|
Total Hits: 775 | Today: 1
|
Author: Art Branch Inc.
|
Rating:
|
|

SQL tutorial featuring comprehensive guide to SQL language concepts and SQL commands....
|
|
|
|
Total Hits: 65 | Today: 0
|
Author: Pinal Dave
|
Rating:
|
|

In short, SQL Azure is simply a Microsoft branding change. SQL Services and SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based services remain intact. SQL Azure will continue to deliver an integrated set of services for relational databases. The reporting, analytics and data synchronization with end-users and partners also remains unchanged. This makes ...
|
|
|
|
Total Hits: 68 | Today: 0
|
Author: Brad McGehee
|
Rating:
|
|

If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?...
|
|
|
|
|
|