News in the Category: SQL Subscribe to the rss of this category.

Total posts: 7775 | Sort by Views | Sort by Hits

The Technology Post for July 6th, 2009

Jason N. Gaylords Blog, July 6, 2009
Views: 2,214 | Hits 19,681

If you are looking to follow this series, be sure to subscribe to my RSS feed at http://feeds.jasongaylord.com/JasonNGaylord or my Twitter account at http://twitter.com/jgaylord. This series can be fo...

Cascading drop-down lists

mikes web log, October 13, 2006
Views: 8,314 | Hits 2,189

This came up at work today, so I thought I'd toss in a quick note. You can do cascading drop-down lists declaratively in ASP.NET 2.0, or at least if your scenario is straightforward. Imagine two drop-...

Entity Framework vs. Linq to SQL

Wortzels blog, January 4, 2008
Views: 5,208 | Hits 1,416

These two data access strategies should be shipped in the new Visual Studio 2008 (aka "Orcas") but from some reasons Microsoft decided to cut the entity framework from this release and to sh...

Building a Rules Engine with SQL Server

MSDN: SQL Server, February 24, 2006
Views: 6,135 | Hits 1,112

Discover how to create a rule engine in SQL Server. Use this simple rule-engine design to implement state machines, predicate dispatchers, or any other rule-based system in a wide variety of applicati...

Accessing Profile Data in the aspnet_Profile table using TSQL Queries

David Silverlights Web Log, August 23, 2005
Views: 6,601 | Hits 1,104

One of the great new features of ASP.NET 2.0 is that persisting user profile data is about as easy as you can get.  You simply define the profile values in your web.config file and the framework ...

Reading Sql Server Image/Blob data in Visual FoxPro 9

Rick Strahls WebLog, August 6, 2006
Views: 6,175 | Hits 1,010

Bob Lucas posted a nice Visual FoxPro 9.0 tip on the Message Board earlier today in respect to how you can get Image values in and out of a SQL Server database and I thought I’d repost this here...

SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server

Journey to SQL Authority with Pinal Dave, February 6, 2008
Views: 6,603 | Hits 1,007

This is very common request recently - How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the sol...

Implementing SqlBulkCopy in Linq to Sql

Wortzels blog, May 5, 2008
Views: 6,236 | Hits 996

As I already mentioned in one of my previous post, the SqlBulkCopy is a powerful tool which gives us an option to perform insertion for a large amount of data. The evolution of the ADO.NET creates us ...

Update: GridView Custom Paging with ObjectDataSource

TheChaseMans Frenetic SoapBox, January 21, 2006
Views: 6,387 | Hits 993

About a month ago I posted some code for implementing custom paging with the GridView and ObjectDataSource with the goal being a single database call to get the records and the rowcount. The code ...

T-SQL: IF NOT EXISTS versus @@ROWCOUNT

JohnPapa.net, August 5, 2005
Views: 9,567 | Hits 928

I was asked a good question the other day regarding why I chose to use "IF NOT EXISTS" in my Nov 2003 MSDN article on User Defined Functions to check to see if a declared table variable ha...

Implementing SQL Transactions

ASP.NET Daily Articles, October 12, 2006
Views: 1,513 | Hits 846

This article describes how you might implement transactional inserts across multiple tables in SQL Server. The article covers the SQLClient.SQLTransaction class and walks through a real world example....

Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

The Visual Basic Team, December 19, 2007
Views: 4,589 | Hits 836

This post assumes youve read the previous posts in this series:           Converting SQL to LINQ, Part 1: The Basics       &...

[SQL] Stored Procedure To FTP Files From SQL Server

youve been HAACKED, April 21, 2006
Views: 2,556 | Hits 825

This is another useful Sql Server Stored Procedure I found on the net written by Nigel Rivett. The procedure uses the xp_cmdshell extended stored procedure to shell out an FTP command. You can use...

SQL Server FAQ : How to join tables from different servers

Mihir Solankis .NET Journal, December 8, 2005
Views: 12,354 | Hits 805

To be able to join tables between two SQL Servers, first you have to link them. After the linked servers are setup, you just have to prefix your tables names with server name, database name, table own...

Replacing an MSMQ queue with a SQL Server 2005 queue

Write Ahead Blog, April 28, 2005
Views: 5,236 | Hits 766

Today, we did a short presentation on Service Broker for a customer who is interested in using the Service Broker technology. Their current application uses a large backend SQL Server d...

Linq Tip #2 - Find overlapping date ranges

Williams .Net Zone, September 29, 2007
Views: 6,904 | Hits 746

/* * A deceptively ~simple self-join query to find all date ranges in a table that overlap. * A date range is defined by the range between InTime and OutTime. * The "Seq != Seq" filter is re...

Some Basic Differences Between ASP.NET 2.0 ObjectDataSource and SqlDataSource

GotDotNet: New resources, December 15, 2006
Views: 2,683 | Hits 728

The article has defined some very basic but importatnt diffrences between .NET 2.0 ObjectDataSource and SqlDataSource....

ASP.NET SQL Bulk-Insert App Data Caching Class

ASP.NET Daily Articles, May 21, 2005
Views: 4,354 | Hits 722

Repetitive database inserts are time-consuming; they slow down your application, and if it is a web-based app, they restrict your ability to handle larger amounts of traffic. This article presents a v...

Tag Your Database - A Data Dictionary Tool

youve been HAACKED, September 28, 2006
Views: 1,548 | Hits 717

A few days back Jon Galloway and I were discussing a task hewas working onto document a database for a client. He had planned to use some code generation to initially populate a spreadsheet and would ...

SQL Function To Generate Random Time of Day

youve been HAACKED, April 21, 2006
Views: 2,147 | Hits 708

Here is a function that will generate a random time of day. Later I will show why I am posting this particular query and how I am using it. It comes in useful when trying create random scheduled jo...

Table Variables In T-SQL

OdeToCode Latest Articles, May 7, 2005
Views: 5,793 | Hits 694

Table variables allow you to store a resultset in SQL Server without the overhead of declaring and cleaning up a temporary table. In this article, we will highlight the features and advantages of the ...

Why ASP.NET 2.0 Login control doesn't work with SQL Membership provider?

Keyvan Nayyeri, July 21, 2006
Views: 7,081 | Hits 665

In addition to previous post, another issue that someone had asked on ASPnix forums was about Login control in ASP.NET and SQL Membership provider.  He couldn’t make his Login control ...

SQL SERVER - 2005 - Get Current User - Get Logged In User

Journey to SQL Authority with Pinal Dave, October 27, 2007
Views: 5,319 | Hits 664

Interesting enough Jr. DBA asked me how he can get current user for any particular query is ran. He said he wants it for debugging purpose as well for security purpose. I totally understand the need o...

SQL SERVER - SQL Joke, SQL Humor, SQL Laugh - Valid SQL Error

Journey to SQL Authority with Pinal Dave, September 5, 2007
Views: 1,356 | Hits 663

Yesterday I had posted my 300th post and I missed the announcement. One of my reader sent me following Image in email congratulating SQLAuthority blog for completing 300th post and also informing me t...

Sorting GridView Manually

ASP.NET Daily Articles, May 23, 2006
Views: 4,142 | Hits 661

GridView control produces automatic sorting and paging behavior when bound to the SqlDataSource control. This is good news for developers who are using SqlDataSource. If you are using some other data ...

Dynamic WHERE and ORDER BY Without Dynamic SQL

youve been HAACKED, January 26, 2006
Views: 1,554 | Hits 660

My friend Jeremy (no blog) pointed me to these two useful articles on how to perform dynamic WHERE clauses and ORDER BY clauses without using dynamic SQL. These were written long ago, but I had neve...

A Library For Executing SQL Scripts With GO Separators and Template Parameters

youve been HAACKED, November 5, 2007
Views: 1,694 | Hits 621

One thing Ive found with various open source projects is that many of them contain very useful code nuggets that could be generally useful to developers writing different kinds of apps. Unfortunately,...

LinqDataSource vs ObjectDataSource vs SqlDataSource

Dino Espositos WebLog, September 24, 2007
Views: 6,026 | Hits 615

With ASP.NET 3.5, a new data source control joins the company: the LinqDataSource control. How does it position itself in the grid of data source controls? The difference between SqlDataSource and Obj...

Finding Code On Your Machine

youve been HAACKED, June 5, 2007
Views: 1,410 | Hits 604

As I mentioned before, I am the Product Manager for the Koders.com website. I am responsible for the search engine, the source code index, the forums, the blog and the Content Management System. My c...

Team Foundation Server: Bug in Team Build

Charles Young, March 9, 2006
Views: 1,556 | Hits 598

We found a bug in the Release Candidate version of Team Foundation Server which I shall 'report' here.   We accidentally found ourselves in the position of having a team build containing two...

Avoid Using a Database as an API Integration Point

youve been HAACKED, April 24, 2007
Views: 1,959 | Hits 596

Before I begin, I should clarify what I mean by using a database as an API integration point. In another life in a distant galaxy far far away, I worked on a project in which we needed to integrate a ...

Create Drill-Through Reports using ReportViewer in ASP.NET 2.0

The Code Project Latest Articles, December 12, 2006
Views: 4,489 | Hits 594

This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0....

Change Login's Default Database in SQL Server

Gregg Stark on SQL Server, October 16, 2007
Views: 5,849 | Hits 574

If you have ever dropped a database and found yourself not able to login because your default database no longer exists you know it can be quite annoying.  You can still connect through query ana...

[SQL] Create a Job to Backup and FTP Your Database

youve been HAACKED, April 22, 2006
Views: 2,005 | Hits 573

In two earlier posts I presented a couple of SQL stored procedures that I promised to tie together. The first procedure generates a random time of day and the second can be used to FTP a file from w...

Integrating Reporting Services 2005 Into a Web Application

The Code Project Latest Articles, September 4, 2006
Views: 3,366 | Hits 555

This article provides step-by-step instructions on how to integrate a MS Reporting Services report into an ASP.NET web application using the ReportViewer control. It also includes an HTML template tha...

Creating CSV Files Using BCP and Stored Procedures

Simple Talk, November 20, 2006
Views: 2,874 | Hits 555

Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach that gives complete control of the format of the extracted data....

Free .NET and SQL Server Interview questions download

GotDotNet: New resources, April 12, 2006
Views: 4,282 | Hits 548

Cool free PDF's with free interview question downloads....

SQL SERVER - 2008 - November CPT5 New Improvement

Journey to SQL Authority with Pinal Dave, November 23, 2007
Views: 1,431 | Hits 545

The progress map of SQL Server 2008 is diagrammatically listed here.I am listing the new improvements here as list.Data Collection and Performance Warehouse for Relational EngineService Broker Enhance...

ASPNETDB + Production deployment --> Practical Tips.

Sahil Malik - blah.winsmarts.com, May 19, 2006
Views: 4,813 | Hits 534

One of the biggest curse (in my eyes) and blessing, in ASP.NET 2.0 is that little cute web server that runs in your system tray. It's a blessing because it makes development and sending and receivi...

SQLEXPR.EXE vs SQLEXPR32.EXE

Jotekes Blog, October 26, 2005
Views: 5,588 | Hits 525

In case you've installed SQL Server Express and found out that there are two executables for installation (for example when installing SSE bundled with VS2005) SQLEXPR.EXE and .SQLEXPR3...

Retrieving the First N Records from a SQL Query

4GuysFromRolla.com Headlines, July 6, 2005
Views: 4,816 | Hits 523

There are often times when retrieving results from a database that you only are interested in displaying the first N records from the resulting query. For example, a news website might have a databa...

C# MySQL Profile Provider for .NET 2.0

The Code Project Latest Articles, September 13, 2006
Views: 4,196 | Hits 518

This is a MySQL based Profile Provider written in C#, for .NET 2.0....

Using ODP.NET To Insert Multiple Rows Within A Single Round Trip

ASP.NET Daily Articles, May 11, 2005
Views: 3,945 | Hits 516

Have you ever had the necessity to insert multiple rows into a database Of course you have. In this article I will explain how to make the most of Oracles ODP.NET Data Provider to easily pull off such...

Windows Server 2008 x64: Could not load file or assembly Microsoft.SqlServer.BatchParser...

Peter Brombergs UnBlog, December 31, 2007
Views: 3,725 | Hits 515

I was working with a partner on testing his MSI Installer for various operating systems, and on Windows Server 2008 x64 it was continuing to come up with this error: Could not load file or assembly 'M...

Another Marginally Useful Tool - BatchConcat

youve been HAACKED, September 21, 2006
Views: 1,542 | Hits 510

Based on my recent spate of posts, you can probably guess that I am working on improving a particular build process. In this situation, I have a pre-build step to concatenate a bunch of files into a ...

SQL Server Interview Questions

GotDotNet: New resources, January 14, 2006
Views: 4,611 | Hits 509

500 SQL Server Interview Questions right from DBA to developer. Cool one...

LINQ to SQL in VS2010/.NET 4

Julia Lerman Blog - Dont Be Iffy..., June 5, 2009
Views: 3,160 | Hits 506

For those of you ready to ring the death knell on LINQ to SQL, hold your horses and check out this post about fixes & enhancements to L2S in VS2010/.NET4. LINQ to SQL in VS2010/.NET 4...

SQLite - Database is locked

JonGalloway.ToString(), July 8, 2005
Views: 6,420 | Hits 503

Summary:SQLite is a great, free, embedable database. It's fast, tiny, and reliable, and has some cool features like support for NTFS compression of the database file. It's multithreaded, but its coars...

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances

hongmeigs WebLog, August 31, 2007
Views: 5,752 | Hits 503

If you are getting the following error: Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances What should I do?   Answer: To fi...