|
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: tarun_j200181
|
Rating:
|
|
The below query can be used to get the details of OPEN TRANSACTION:...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Dr. James McCaffrey
|
Rating:
|
|
The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Raj Kumar
|
Rating:
|
|
This article will describes you how to use photo viewer in Silverlight using SQL Server 2008 database. I had search many time but could get more samples using SQL Server. So I decided let’s use Silverlight with SQL Server 2008. So here is my first article in Silverlight with SQL Server 2008....
|
|
|
|
Total Hits: 1 | Today: 1
|
Author: Dinesh Beniwal
|
Rating:
|
|
If you are new to database programming and ADO.NET, you may want to look at the ADO.NET section of C# Corner (http://www.c-sharpcorner.com). Plenty of source code samples and tutorials are available for free. You might want to check out my book for ADO.NET beginners: A Programmer's Guide to ADO.NET in C# (published by APress)....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Hiren Solanki
|
Rating:
|
|
You may Have tried to Apply Union All betwenn two CTEs.
For Example,
If you Have two Tables Named TableA and TableB...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: bluechip_asia
|
Rating:
|
|
When we work with small data, our web page look so fine displaying Record. But when the data getting large, we will found Mr. Time Out Coming to say "Sorry Expired".
This method is different than other paging method. By using stored procedure we can get a table result that contain specific row rather than get the entire table....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Ted Neward
|
Rating:
|
|
In keeping with the theme of this issue, it’s time to return to the roots of SQL and relational databases. Naturally, it would thus seem apropos to write something about SQL Server, something about its new feature set or performance improvements or whatnot, but that’s just not my style. Don’t get me wrong, SQL Server is a great database, and highly recommended for those “big iron” enterprise-class scenarios, but not every problem demands (as a friend once put it) a “big honkin’ centralized datab...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Mark Friedman
|
Rating:
|
|
Many applications are designed explicitly to use multiple tiers, where the performance of calls into the data access tier is crucial to the overall responsiveness of the application. The use of multiple tiers increases the flexibility of the application. The n-tiered approach also fosters isolation of key components, which can be used to improve both reliability and scalability. The use of multiple tiers promotes scalability because components that are isolated into distinct tiers can then more ...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Ted Neward
|
Rating:
|
|
In my previous article, MongoDB’s basics took front and center: getting it installed, running and inserting and finding data. However, I covered only the basics—the data objects used were simple name/value pairs. That made sense, because MongoDB’s “sweet spot” includes unstructured and relatively simple data structures. But surely this database can store more than just simple name/value pairs....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Ted Neward
|
Rating:
|
|
Last time, I continued my exploration of MongoDB via the use of exploration tests. I described how to start and stop the server during a test, then showed how to capture cross-document references and discussed some of the reasoning behind the awkwardness of doing so. Now it’s time to explore some more intermediate MongoDB capabilities: predicate queries, aggregate functions and the LINQ support provided by the MongoDB.Linq assembly. I’ll also provide some notes about hosting MongoDB in a product...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Raymund Macaalay
|
Rating:
|
|
This article is about making the best use of the SQL Server Maintenance Plans, I am saying that becuase if you really want to do best practice manitenance on a SQL Server is that you should do it on a script level and trigger it by job schedule as doing this one you can have more control on the objects that realy need maintenance on thier own specified schedule. Now if you are like me whose main function is not a DBA but more of a Developer then the next best thing is making the best use of wha...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: gecka
|
Rating:
|
|
In Choosing a free embedded database I wrote that I searched for an embedded database with Stored Procedure support. At that time, I was all new in SQL and databases in general and viewed Stored Procedures as the best way to work with databases. My opinion has changed over the (almost) two years, however. This post describes my current view on Stored Procedures and their usage in application programming....
|
|
|
|
|
|
