Forum Replies Created

Viewing 15 posts - 11,146 through 11,160 (of 13,460 total)

  • RE: import data without creating table?

    the import wizard will easily help you connect to an excel spreadsheet or any other data source, and automatically create a table with the same column names the excel spreadsheet...

    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!

    May 5, 2009 at 7:21 am

    #988765

  • RE: SQL Trigger

    can you provide a bit more information?

    a trigger should do any work that is directly related to the data that is being inserted, Updated. or Deleted. it would fire one...

    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!

    May 5, 2009 at 7:16 am

    #988758

  • RE: System Generated Primary Key

    identity property is one of those items that needs to be done at table creation. to add it later, you can use the GUI to add it...it makes a temp...

    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!

    May 5, 2009 at 5:24 am

    #988673

  • RE: System Generated Primary Key

    yes...the IDENTITY property auto-increments the enxt value for your int column...technically it doesn't have to be your primary key, but it is very common for them to be the same;

    here'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!

    May 4, 2009 at 6:50 pm

    #988488

  • RE: Convert SQL data or Flat File or Csv File to XML ?

    not as easily;

    xml is supposed to be self describing...so an xml element can contain the name, the data type, and the value; it can contain much more information than those...

    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!

    May 3, 2009 at 11:23 am

    #987833

  • RE: Unsubscribe from Topic

    Steve Jones - Editor (5/2/2009)

    Lowell,

    There isn't a better way right now. I periodically spend 10-20 minute killing off threads from my subscriptions.

    I'm not clear, are you trying to find a...

    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!

    May 2, 2009 at 3:19 pm

    #987753

  • RE: String or binary data would be truncated

    not an easy way...unless your "Table1" has columns named the same as "Table2"

    you can maybe find something quickly with this sql:

    you can ignore a lot of you 181 columns that...

    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!

    May 2, 2009 at 9:10 am

    #987720

  • RE: what the decrypt function in Ms Sql Server ?

    definitely a built in function, especially considering both encrypt() and decrypt() show up with syntax highlighting.

    I googled a bit and I guess you are right that they are undocumented/unsupported.

    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!

    May 2, 2009 at 8:28 am

    #987713

  • RE: Unsubscribe from Topic

    Thanks Florian, but it's the "select the topic" that is killing me

    that navigation provides the paged navigation list of all 2500 + subscriptions I've subscribed to...in the case of, say...

    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!

    May 2, 2009 at 8:21 am

    #987712

  • RE: Unsubscribe from Topic

    Steve Jones - Editor (4/15/2009)

    Two ways, topic options in the upper right here (blue bar)

    Post again, change the default to "no subscription" in the drop down.

    Steve I'm having a similar...

    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!

    May 2, 2009 at 7:12 am

    #987706

  • RE: Simple Calculus is not that simple? D:

    it's integer division that is killing you

    @integer / 100, if it is less than one, is zero. SQL server shortcuts the math and says int / int is an...

    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!

    April 30, 2009 at 12:08 pm

    #986830

  • RE: Queries running slower in SQL 2008 than in SQL 2000

    doh i missed he said he did that already;

    only advice i have left is one post i read said that rather than update statistics, they dropped and recreated the statistics,...

    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!

    April 30, 2009 at 10:49 am

    #986785

  • RE: Queries running slower in SQL 2008 than in SQL 2000

    this is a common issue after upgrading;

    you've got to update statistics and rebuild indexes after upgrading or restoring a database that came from a previous version in order 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!

    April 30, 2009 at 10:37 am

    #986771

  • RE: Dealing with incoming mail

    doh! CLR is what i meant....I just grabbed a sample project off of codeproject.com to see if it's easy to do...

    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!

    April 29, 2009 at 9:57 am

    #986072

  • RE: Dealing with incoming mail

    this sounds like something perfect for a CTE to do. expose an SMTP dll and read an email account.

    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!

    April 29, 2009 at 9:32 am

    #986038

Viewing 15 posts - 11,146 through 11,160 (of 13,460 total)