Forum Replies Created

Viewing 15 posts - 5,986 through 6,000 (of 13,460 total)

  • RE: How to Print barcode with SQL Reporting?

    a related post from long ago implies the bar code font had to be installed on the client?

    that part i'm not sure, but Gianluca and i slapped together an example...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2012 at 9:19 am

    #1442495

  • RE: error in Trigger creation

    i wrapped it with a BEGIN / END to mark the limits of the trigger, and it seems to work fine.

    based on something in my snippets, i added some extra...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2012 at 5:32 am

    #1442348

  • RE: beginner requesting help with trigger that updates a table when an insert occurs in another

    the trigger, corrected for the syntax issue, seems to work fine for me; could it be you didn't reset the data back to teh original state when you were testing...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2012 at 4:48 am

    #1442320

  • RE: beginner requesting help with trigger that updates a table when an insert occurs in another

    two tables, the INSERTED and DELETED tables are virtual tables that exist inside the trigger.

    they are the data being inserted/updated/deleted into the table the trigger exists on...in your case,dbo.invoice.

    they...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 2, 2012 at 2:11 pm

    #1442080

  • RE: insert statement

    a WHERE statement is only valid with a SELECT,UPDATE or DELETE command.

    you can insert with either values, or a select statement.

    insert into tbTasks_New( AssignedToId)

    values('Employee')

    --OR

    insert into tbTasks_New( AssignedToId)

    SELECT

    Employee

    FROM YOURTABLE

    where

    Owner...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 2, 2012 at 1:18 pm

    #1442048

  • RE: Create foreign key script

    when you add a foreign key, all the pre-existing values are checked in the child table to make sure they exist/are valid in the referenced table.

    if values exist that violate...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 2, 2012 at 1:09 pm

    #1442043

  • RE: MD5-encryption - "translate" VB to SQL

    declare @val varbinary(max)

    SELECT @val = HashBytes('MD5','123456')

    print @val

    --0xE10ADC3949BA59ABBE56E057F20F883E

    SELECT

    CASE

    WHEN @val = HashBytes('MD5','123456')

    THEN 'True'

    ELSE 'FALSE'

    END

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 1, 2012 at 12:21 pm

    #1441376

  • RE: BCP to export data from global temp table

    simple syntax error.

    queryout c\test.txt

    i think that should be c:\test.txt; just missing the colon.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 1, 2012 at 10:50 am

    #1441341

  • RE: table variables in function slower in 2008

    spot on advice from venoym and Recurs1on;

    if you can provide more details, we can help you witht he perforamnce issue;

    ideally, if you can save the ACTUAL execution plan and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 31, 2012 at 2:56 pm

    #1440979

  • RE: Where can I download a Thesaurus file?

    didn't go that far as to play with Full Text.;

    it was purely from a Text-Dictionary to SQL Server Table project I fiddled with a few years ago; Full text wasn't...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 2:24 pm

    #1440261

  • RE: Apostrophes and Double Quotes - Should They be Allowed in table Text-Type Columns?

    if the software uses parameters, quotes are never a problem, performance could increase, as the query would benefit from the ability to be cached, because the parameters allow it to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 1:57 pm

    #1440247

  • RE: Where can I download a Thesaurus file?

    here you go Mark;

    dunno if this will help, i took a thesaurus file from the Gutenberg project, and bulk inserted it into a table, then built the table of synonyms.

    it's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 1:51 pm

    #1440242

  • RE: upgrade a database scheam

    I'm doing this via an application, but I've always found that comparing a schema is not enough;it's too complex for a TSQL script to fix or recover form errors.

    at least...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 8:27 am

    #1440039

  • RE: Script To Find Reserved Words in Schema

    here you go:

    a txt file with all the keywords as a CTE;

    at 600+ lines, i did not want to post it inline to teh forum, so tit's a text...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 8:14 am

    #1440020

  • RE: Script To Find Reserved Words in Schema

    SQLserver keywords can be found here:

    http://msdn.microsoft.com/en-us/library/ms189822.aspx

    you can see there is three sets there; SQl keywords, ODBC keywords, and future keywords.

    it would be very easy to paste them into a text...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 30, 2012 at 6:55 am

    #1439960

Viewing 15 posts - 5,986 through 6,000 (of 13,460 total)