I just ran into an issue in 2005 where if I have a field that is a char(8),
the select statement will still find the values if they are less then 8
characters (even though chars blank fill).
For example if Quarter is char(8), I can do:

How can I display tables with specific columns?
Mainly I am looking to find all the tables that have 4 or 5 different
columns.  If all these columns are not there, I don't want to see them.
I also am trying to do just the opposite.  Find all the tables that don't

To All,
I am trying to get a parameterized query to run in a ssis package.
I ran the dtsx file with hard-coded values and the query and package work.
The package exports data from a database into an Excel file.

Hi Group,
I have the following query, but I need to add a column from another table in
the resultset.  No matter what I do I end up with what seems like a
cartesian product.  I want the same number of records that this query gives

I need to allow some users to run a script once a month that involves
calling 'sp_send_dbmail' to communicate progress. What is the best practice
method for giving users access to a system SP like this? I guess I can
probably go into each ones server account and do it there?

I want to know about,
                What is sqlserver?
                 What is the benefits of sqlserver?
mailto:6eS64VhxZW@repairondemand.com

i have a problem with SQL2005 and VB2005.
I receive randomly this error when calling a "select from a table"
Random Error1:
Column 'mycolumn' does not belong to table .

I am just wondering if what I am doing would be considered the correct
way to insert data into multiple tables when a forigen key is in place
between the tables primary keys.
Here is a simple DB structure

I am getting the following error message when I run sp_databases:
Server: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 32
Arithmetic overflow error converting expression to data type int.
I also get the same message when I run  "select count(*) from ...."

I am trying to run a SQL Server Restore of a Test Database and am getting a
message saying...
Exclusive access could not be obtained because the database in use.
I have seen this before when I have an open thread to the database. I

I am having trouble with using Soundex and Difference effectively. As a
simple example:
Select surname from membership where soundex(surname)=soundex('smith')
Now I was expecting smith, smyth, smythe, smiff, sniff... instead I get

What does dbo.MIN3 represent in your code?

Hi, i'm trying to create a banner exchange system on a 1:1 basis but
stuck on weight calculation logic. with weight, i mean a logic that
while deciding which site will be showed more will allow sites with less
credit too.

First here is the Proc I have so far....
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

i am creating a advance job search page.i want to retrieve the company details that are recruting using selected  keywords like 'c#'.i want to retrieve company details based on datedifference method using store procedure
 Eg:from database entried date and current time tell me the ...