Forum Replies Created

Viewing 15 posts - 6,226 through 6,240 (of 13,460 total)

  • RE: Auto Increment Option in SQL Server Management Studio Express

    in SQL, that's the IDENTITY() property;

    you can script it like this:

    CREATE TABLE MYTABLE(

    ID int IDENTITY(1,1) NOT NULL PRIMARY KEY,

    OtherCollumns varchar(30 )

    if you have SSMS for SQL Express, you can design...

    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!

    December 13, 2011 at 7:56 am

    #1420627

  • RE: Trim a string

    a visualization and explanation form a forum post on the same subject:

    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!

    December 13, 2011 at 7:54 am

    #1420621

  • RE: Remote Access to SQLEXPRESS (not the obvious solution!)

    Al the SQL Browser Service is what makes a SQL instance "visible", but that is not required. i don't think it's included in express versions, anyway.

    It sounds like you already...

    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!

    December 13, 2011 at 7:47 am

    #1420613

  • RE: Things to consider before migrating SQL 2005 to ORACLE DB

    we have an app here which supports either Oracle and SQL Server as the behind the scenes DBMS.

    I'll be the first to say I do not know how to tune...

    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!

    December 13, 2011 at 5:42 am

    #1420540

  • RE: Trigger to update and inser a count in column

    Dev and John i thought we might be overthinking the complexity of the original post, and wanted to throw the view possibility out there as well;

    It seemed to me he...

    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!

    December 12, 2011 at 6:49 am

    #1420049

  • RE: Trigger to update and inser a count in column

    i'd recommend forgetting about putting the count in the table.

    instead, create a view that is uesed to calculate the count based on a join; then the count is correct every...

    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!

    December 12, 2011 at 6:33 am

    #1420029

  • RE: Non-bound views with SELECT * broken after database changes?

    dogramone (12/11/2011)

    Your poblem is probably related to the "select *" stuff. When SQL creates the view with select * it creates the view in the underlying DB engine as...

    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!

    December 11, 2011 at 8:15 pm

    #1419847

  • RE: Do get a column in a specific order

    look up SQL server ranking functions, specifically ROW_NUMBER() and the OVER(PARTITION BY) predicate; that can do it, as well as

    RANK and DENSE RANK;

    if it was just an arbitrary #...

    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!

    December 10, 2011 at 8:16 am

    #1419716

  • RE: Trigger to insert records on a linked server else in a local server

    richardkel (12/10/2011)

    In my case I have an ERP system that needs to supply a plant control system with customer, pricing and order information. This information needs to get 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!

    December 10, 2011 at 8:03 am

    #1419712

  • RE: First letter upper case for each word in sql server.

    search the scripts section for "ProperCase" or "InitCaps" foir other examples, there's some out there that look for things like "O'Brian" and "St.James" or "David-Jones".

    here's just one 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!

    December 9, 2011 at 2:45 pm

    #1419639

  • RE: Restrict database access by date range?

    Pam do you youse a calendar table for the on off entries, or just a schedule assumption (ie biz hours mon-fri);

    i tested the concept with my calendar table, no...

    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!

    December 9, 2011 at 2:33 pm

    #1419637

  • RE: 64-bit upgrade checklist

    and post upgrade, to address how statistics are used differently in the updated sql engine:

    1. rebuild all indexes.

    2. UPDATE STATISTICS [EachTableName] WITH FULLSCAN

    nothing worse than to upgrade to a monster...

    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!

    December 9, 2011 at 1:12 pm

    #1419596

  • RE: create folders using t-sql

    just saw you said no xp_cmdshell;

    in that case, unless you can install a CLR, theres no way to do this from TSQL. xp_cmdshell is the only thing i know 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!

    December 9, 2011 at 12:56 pm

    #1419588

  • RE: create folders using t-sql

    a very bassic example using the "md" command for make directory;

    note in this example, the parent "Test" directory needs to already exist.

    DECLARE @Results table(

    ID int identity(1,1) NOT NULL,

    TheOutput varchar(1000))

    CREATE...

    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!

    December 9, 2011 at 12:52 pm

    #1419584

  • RE: create folders using t-sql

    create them on the server, based on a query?

    what if they already exist?

    what would the query you run look like? (is it really Select myname from mytable?) what columns/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!

    December 9, 2011 at 12:40 pm

    #1419580

Viewing 15 posts - 6,226 through 6,240 (of 13,460 total)