Forum Replies Created

Viewing 15 posts - 10,021 through 10,035 (of 13,460 total)

  • RE: TRY and CATCH has no real use?

    ricky i'm just confirming what you are seeing; for me so far, if the try catch is in a transaction or using a transaction, i get the same failure; I...

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

    #1112310

  • RE: How to create a function that takes a table name and where clause as parameters

    In SQL you have to use dynamic sql and the EXEC(EXECUTE) statement.

    Oracle is the same, but you would use EXECUTE IMMEDIATE,

    ie execute immediate 'drop table TEMPTBL';

    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!

    February 2, 2010 at 8:11 am

    #1112298

  • RE: Table Naming conventions

    raju you are very welcome; you should get some other great feedback as other posters get their coffee and hit this thread as well.

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

    #1112195

  • RE: Hiding the Database

    ahh gotcha Satish; a zip+4 database is a little different. i think the issue becomes "that's my proprietary data" that if someone cloned, they could build their own app for...

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

    #1112193

  • RE: Hiding the Database

    not enough info i think Satish; still a lot of variables out there;

    your database is 30 gig, but if i were a client of yours, how much of that data...

    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, 2010 at 11:06 pm

    #1112090

  • RE: Table Naming conventions

    raju i can only tell you my experiences and the way we do things at my shop; you can review them and see what you like, since there's no real...

    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, 2010 at 10:44 pm

    #1112087

  • RE: the double pipe

    oracle is double pipe; SQL Server uses the plus sign, and will only concat the char datatypse(char/varchar/nchar/nvarchar); so of you need to concat an integer to the string , you...

    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, 2010 at 5:58 pm

    #1112030

  • RE: T-SQL return record for every day of year

    Joel you are on the right track; you'll need to join against another table, but it doesn't necessarily need to be a real calendar table. you can use a Tally...

    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, 2010 at 2:42 pm

    #1111960

  • RE: Copy DB - different name - end of month

    change the backup command so instead of NOINIT it says INIT:

    NOINIT=append to existing

    INIT=replace if exists:

    USE MASTER

    BACKUP DATABASE [MSPHXX]

    TO DISK = N'K:\MSPHXX_ARC.bak'

    WITH NOFORMAT, INIT, NAME = N'MSPHXX_ARC',

    SKIP, NOREWIND,...

    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, 2010 at 12:39 pm

    #1111884

  • RE: how to get data for next 3 months

    itskumar2004 (2/1/2010)

    Hi,

    i know the syntax dateadd(month,3,datefield) which will add 3 months and you can only see one month..

    but i want a syntax to see all next 3 months of...

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

    #1111860

  • RE: Query Help

    ugg; i didn't even look at the question, just tried to create the data in a ready to consume format;

    help us help you! in the future, try to give everyone...

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

    #1111856

  • RE: Physically remove record

    Steve it sounds like you could prevent it to me.

    If you can detect data that does not belong AFTER the fact, you could add filters in the application or in...

    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, 2010 at 11:04 am

    #1111825

  • RE: T-SQL Stored Proc calling T-SQL Function

    mark i believe you can also change the function to return a table value function, and use CROSS APPLY to apply it against your data for a big performance gain.

    Lynn...

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

    #1111752

  • RE: SQL Server Triggers - INSTEAD OF

    no the virtual tables are stiull there, but in an INSTEAD OF trigger, it's up to you to do something with the results; if you sent an did some buiz...

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

    #1111732

  • RE: SQL Server Triggers - INSTEAD OF

    carl you do not need the where clause at all inside a trigger;

    The trigger there are two virtual tables named INSERTED and DELETED;they have a mirror of the columns in...

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

    #1111705

Viewing 15 posts - 10,021 through 10,035 (of 13,460 total)