|
Solution Search:
columns as you would any type of column, or you can return all values by using the basic SELECT * in your SELECT clause:
SELECT * FROM Products If you run the query, you'll find a... More... Jun 2, 2009
for the query that returns the total for all sales, these results are very similar to a basic GROUP BY clause. If you were to drop the total set from the GROUPING SETS option, as...
More...
May 5, 2009
launched.
Although Report Builder 1.0 can access Report Models built with Visual Studio 2008 and the Report Manager, it cannot be used to create reports using those... More... May 1, 2009
In my previous look at Visual Studio Team System 2008 Database Edition (VSDB), I gave an overview of VSDB and its...
More...
Apr 27, 2009
the FROM clause of your SELECT statement. The following syntax shows the function's basic elements:
OPENROWSET('provider', 'connection string', target) As you can see, the... More... Apr 16, 2009
many DBAs are not taking advantage. This is frequently because they lack a basic understanding of consolidation and even harbor a lot of misconceptions about it...
More...
Apr 3, 2009
order, the column delimiters vary or there are anomalies in the data format. For a basic BULK INSERT operation, however, the examples above should provide many of the...
More...
Mar 11, 2009
MS SQL database or SQL Server. The synchronizer also copies and synchronizes MS Visual FoxPro database and MS Visual FoxPro separate tables with another MS Visual...
More...
Mar 6, 2009
functionality gaps that exist in both Microsoft's SQL Server Management Studio and Visual Studio within a single tool set.
Quest Software Inc.'s Toad for SQL Server 4.0 compares... More... Feb 23, 2009
lines. All the examples, however, should be run as a single command.
In addition to these basic arguments, the bcp utility supports several switches that control the utility's... More... Feb 18, 2009
to parse the XML document and use it as necessary. In this case, the XML document is very basic:
The OPENXML code necessary to read this data from the temporary table should look... More... Feb 16, 2009
Microsoft's Visual Studio for database professionals was originally designed to fill a gap in...
More...
Feb 11, 2009
Figure 1
Using a LIKE predicate offers specificity but limits you to only the most basic search capabilities, such as exact matches of the word or phrase. Searching columns... More... Feb 4, 2009
demonstrate how easy it is to create and use PowerShell scripts, this tip explains a basic script that retrieves information about the databases on a specific SQL Server...
More...
Jan 14, 2009
In the absence of a debugging tool, their only option was to debug in Microsoft Visual Studio. But with SSMS 2008, a debugging tool has finally been integrated into the SQL...
More...
Jan 5, 2009
SSAS, train the model and provide the results of the data mining to you using the SSAS visual tools found in SQL Server BI Development Studio (Visual Studio). These user...
More...
Dec 23, 2008
to it, you can never go back. If I recall correctly, this feature goes all the way back to Visual Basic 5.0 and has been included in every version of Visual Studio. But for some reason, the...
More...
Dec 9, 2008
table names in the examples as appropriate. Also, the article assumes that you have a basic understanding of foreign key relationships. If you're unfamiliar with foreign...
More...
Dec 3, 2008
Discover how to improve overall SQL Server 2000 performance and better understand basic database indexing with these tricks for using the Index Tuning Wizard. ... More... Dec 3, 2008
extensively is the SQL Server Service Broker, a message queue system with the same basic concept as the Microsoft Message Queue (MSMQ). Whether you are a newcomer to the...
More...
Dec 1, 2008
When designing high write database systems, you should look to some of the same basic techniques as a normal database server – with a few tweaks. You will still want...
More...
Nov 25, 2008
extend any SSIS package.
Export SQL Server data to an Excel file using SSIS and Visual Studio Learn how to design an SSIS package using Visual Studio and export data from... More... Nov 17, 2008
on topics from security to performance. This reference provides the SQL Server basic help you need in areas such as how to configure tempdb, use SQL Profiler, grant...
More...
Nov 6, 2008
for Reporting Services and the Business Intelligence Analyzer? It sounds like the Visual Studio environment hosts these tools, but what version of Visual Studio is...
More...
Nov 3, 2008
Scalar Operators
Scalar operators are used for operations with scalar values. Transact-SQL supports numeric and Boolean operators as well as... More... Oct 15, 2008
|
Server Clustering Solutions
Server Clustering Whitepapers
|