Forum Replies Created

Viewing 15 posts - 436 through 450 (of 2,894 total)

  • RE: Limit count of user work with my DB (by C#)

    armm1388 (5/15/2013)

    Hi

    I have sql server DB and C# Application.

    How can I restricted count of user who use from my DB?

    How can I do this by c# or by SQL SERVER...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 15, 2013 at 3:25 am

    #1615333

  • RE: convert varchar to date

    Jeff Moden (5/14/2013)

    sqlfriends (5/14/2013)

    I would like to convert a varchar column to datetime.

    The varchar column are supposed are be like a date : 2013-05-12

    But there may be a wrong date...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 15, 2013 at 3:18 am

    #1615330

  • RE: Count Number Of Investors in fund

    That will help to start getting relevant help:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 15, 2013 at 3:16 am

    #1615329

  • RE: Identity insert without reseed

    The only way for SQL Server to start counting from 2 after inserting 1000 into identity is to reseed it. But, it's a stupid thing to do anyway.

    However, if...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 11:36 am

    #1615122

  • RE: call sproc in Oracle

    sqlfriends (5/14/2013)

    Thanks, but this is .net application we probably not going to use SSIS.

    than use the first link from my previous post.

    You can use ADO.NET transaction to do so,...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 11:31 am

    #1615121

  • RE: call sproc in Oracle

    sqlfriends (5/14/2013)

    Lynn Pettis (5/14/2013)

    I'd probably have the application do the update, but that's just me. The app could be coded such that the update needs to occur in both...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 11:19 am

    #1615113

  • RE: Identity insert without reseed

    salliven (5/14/2013)

    Hi!

    Can I insert a table without identity reseed?

    Exapmle:

    CREATE TABLE #table (id int IDENTITY (1,1), col1 int)

    INSERT INTO #table DEFAULT VALUES

    -- Id = 1

    -- If I insert identity values, then...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 9:35 am

    #1615072

  • RE: Add a value IF ISNULL

    ninobuttez (5/14/2013)

    Hi,

    I need again your help. Something very easy for you I guess:

    I need to add a value in the column of a table when the value is null.

    So let's...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 9:32 am

    #1615068

  • RE: SQL counter> need help

    Hi and welcome to the forum.

    As you here first time, I would advice you to have a look an article from the link at the bottom of my signature....

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 8:54 am

    #1615047

  • RE: To Split SP or Not to Split SP

    GilaMonster (5/14/2013)

    Yes, you probably do want to split that up.

    This blog post's probably closer than the catch-all one

    http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

    Yeah, my wrong. Clicked the wrong link and didn't bother to check...

    Thank You...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 8:26 am

    #1615026

  • RE: Combining two query result sets.

    Lynn Pettis (5/14/2013)

    Eugene Elutin (5/14/2013)

    William Gary Wright (5/14/2013)

    I left the office last night being half way done writing a script to create a database with some data in it for...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 8:22 am

    #1615022

  • RE: using multiple UNION in query

    Abhijit More (5/14/2013)

    How do you want us to help? - need help to optimize the query.

    Can you drop this proc and never use? - not possible

    If not, what...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 8:18 am

    #1615020

  • RE: Combining two query result sets.

    William Gary Wright (5/14/2013)

    I left the office last night being half way done writing a script to create a database with some data in it for you all to look...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 7:13 am

    #1614975

  • RE: using multiple UNION in query

    Abhijit More (5/14/2013)

    Hello!

    I have one stored proc which returns data by querying multiple tables using union clause without any search criteria.

    select xyz as Col1 from table1 join table2 ...(total 8...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 7:11 am

    #1614973

  • RE: To Split SP or Not to Split SP

    that classical question was answered long ago ;-):

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 7:07 am

    #1614972

Viewing 15 posts - 436 through 450 (of 2,894 total)