dr_csharp

What language are your apps written in?

Are they web apps?

Please post additional...

In short yes. Check out this BOL subject

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/68ae44ef-990c-49c2-b502-ff1dc41b4019.htm

You can copy column properties from a primary key column to a foreign key column if you want to relate the two...

Run:

sp_configure 'two digit year cutoff''

on each database examine the values

name ...

Paraphrasing your extract of your stored procedure as:

CREATE PROCEDURE TDateTest

@StartDate AS VARCHAR(11),

@EndDate AS VARCHAR(11)

AS

DECLARE @SDate AS DATETIME

DECLARE @EDate AS DATETIME

set @SDate = cast (@StartDate...

Mike C.

Thanks for that detailed explanation. Explains a lot and I will have to remember that when creating a thesaurus.

Again thank you.

From BOL 2008 Thesaurus Configuration

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/3ef96a63-8a52-45be-9a1f-265bff400e54.htm

You can define two forms of synonyms, expansion sets and replacement sets. By developing a thesaurus tailored to your full-text data, you can effectively broaden...

You could create a stored procedure which your users could run.... the SP would use the openrowset function to import the data into the table you specify.... Read:

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx

these will explain...

Declare your passed parameters as

@DisplayNo AS varchar(20)= ' '

Add IF tests to your procedure for example:

IF LEN(LTRIM(RTRIM@Display))) = 0

BEGIN

...

Hope this answers your question, but is obvious that you have numerous mistakes in your statement. (Hopefully only typographical)

your tables were given as:

- note the...

You can create a formula column in Excel, using Excel. Open Excel, select the column into which you want the formula. Click on the first row that will...

What you have posted does not have enough information to provide you with a good answer. Please read the article in my signature block and add to your post.

For what it is worth, it was written in 2003 and I do not know if it will still function, but I have attached the VB code. By the...

Here are a few to start you off:

Heap Structures...

These indexes could be covering indexes and before you removed any of them I urge you to read BOL Creating Indexes with Included Columns at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/973b128d-5114-4d48-8eab-52497b47611e.htm

Briefly, and very briefly:

index with...

Refer to

http://www.sqlservercentral.com/Forums/Topic577880-1291-1.aspx#bm577906

where you first posted this question