Forum Replies Created

Viewing 15 posts - 9,736 through 9,750 (of 13,460 total)

  • RE: Please unsubscribe me from all your mailings.

    ironically, since the OP posted to the forum, he gets another email every time we post to the thread,

    because he hasn't unsubscibed from the thread, which is different from...

    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 5, 2010 at 6:34 am

    #1145666

  • RE: Converting Image to varchar

    if you are sure the image field contains text that was converted to varbinary, then you need to convert to nvarchar isntead of varchar i think.

    here's a proof of concept:...

    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 5, 2010 at 6:27 am

    #1145658

  • RE: Triiger On Insert

    nilesh k (4/5/2010)

    well identity columns value is going to differ in delete and insert.so how can i make it worth?

    that is not true; I can understand how it might seem...

    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 5, 2010 at 6:17 am

    #1145651

  • RE: UPDATE to new column creates 'Invalid column name' error

    when you add the column with the default, you could include the WITH VALUES statment so that existing data gets the new default; then you would not have to update...

    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 1, 2010 at 10:57 am

    #1144257

  • RE: Finding Columns

    i use this a lot; it's ideal for finditng tablenames or column names that you are looking for.

    stick in in the master db:

    sp_find inv

    finds all tables, and then all columns,...

    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 1, 2010 at 10:51 am

    #1144246

  • RE: Locating All Columns

    andrew sysforeignkeys can get you all the relationships, but it's all integers in there; you have to use some functions to get the data out where it's human-readable.

    for example, if...

    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 1, 2010 at 9:47 am

    #1144151

  • RE: Insert Footer for a Word Doc from T-SQL

    i just tested it, and it would not work; created a word doc with "[header]" in the header,"[footer]" in the footer, and "[body]" in the main document;

    saved it 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!

    April 1, 2010 at 9:19 am

    #1144115

  • RE: Insert Footer for a Word Doc from T-SQL

    if your template has a keyword you could search for, like a token of "[footer]" that you could search for and find/replace as a raw text string, that might be...

    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 1, 2010 at 8:45 am

    #1144056

  • RE: No More NULL

    All right! things are going to be so much easier now!

    so when i define a table, i can decide to use my own default ie, "1" for the default value,...

    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 1, 2010 at 6:43 am

    #1143902

  • RE: Bulk insert issue

    because the data is quote delimited, you'll need to use a format file, i think; BOL or a google search will be your best bet to help you research 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!

    April 1, 2010 at 6:26 am

    #1143887

  • RE: Delete / Replace Blobs

    you definitely should follow Jeff's advice and add a datetime column to the table; it'll save you a lot of toruble, and is harmless:

    ALTER TABLE [tblCustomerImages] ADD [CreatedDate] DATETIME DEFAULT...

    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 1, 2010 at 4:51 am

    #1143815

  • RE: Foreign key constraints...WHY??

    I'd also note that Referential Integrity is a best practice; be sure to read all the articles on Best Practices /Worst Practices here on SSC to get a good flavor...

    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!

    March 31, 2010 at 12:14 pm

    #1143333

  • RE: How to query out duplicate rows (without deleting)

    basically, you'd replace #EXAMPLE with the query(in parenthesis) you were going to use; without all the CREATE TABLE info, there;s nothing i could test based on the sql you posted;...

    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!

    March 31, 2010 at 12:01 pm

    #1143317

  • RE: How to query out duplicate rows (without deleting)

    it looks like you want to get duplicate rows, but ignore the Title, right? I'd probably not partition on the date, either, but look at this and see if it...

    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!

    March 31, 2010 at 11:09 am

    #1143281

  • RE: Intermitent Primary key violation in Nightly jobs

    Alex i think i can see a couple of issues here.

    I'm not trying to bash you, just hoping to help you make your process better.

    first, it's clear that you are...

    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!

    March 31, 2010 at 9:31 am

    #1143197

Viewing 15 posts - 9,736 through 9,750 (of 13,460 total)