Viewing 15 posts - 2,806 through 2,820 (of 3,221 total)
dr_csharp
App1 Insert records in Database,i need when record inserted in db,SQL alert to App2 and send sth to App2.
What language are your apps written in?
Are they web apps?
Please post additional...
October 18, 2008 at 6:47 am
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...
October 17, 2008 at 10:51 am
Run:
sp_configure 'two digit year cutoff''
on each database examine the values
name ...
October 16, 2008 at 12:40 pm
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...
October 13, 2008 at 5:40 pm
Mike C.
Thanks for that detailed explanation. Explains a lot and I will have to remember that when creating a thesaurus.
Again thank you.
October 12, 2008 at 9:56 am
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...
October 10, 2008 at 10:46 am
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...
October 7, 2008 at 2:51 pm
Declare your passed parameters as
@DisplayNo AS varchar(20)= ' '
Add IF tests to your procedure for example:
IF LEN(LTRIM(RTRIM@Display))) = 0
BEGIN
...
October 7, 2008 at 10:21 am
Hope this answers your question, but is obvious that you have numerous mistakes in your statement. (Hopefully only typographical)
From InvoiceLineItems JOIN GLAccounts
your tables were given as:
Invoice_Line_Items
- note the...
October 5, 2008 at 4:02 pm
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...
October 2, 2008 at 1:03 pm
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.
October 1, 2008 at 1:29 pm
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...
September 30, 2008 at 5:53 pm
Does anyone have any suggestions for additional reading that explores the inner workings of SQL Server regarding indexes and rebuilding them?
Here are a few to start you off:
Heap Structures...
September 30, 2008 at 3:25 pm
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...
September 30, 2008 at 3:05 pm
Refer to
http://www.sqlservercentral.com/Forums/Topic577880-1291-1.aspx#bm577906
where you first posted this question
September 29, 2008 at 3:17 pm
Viewing 15 posts - 2,806 through 2,820 (of 3,221 total)