Forum Replies Created

Viewing 15 posts - 5,731 through 5,745 (of 13,460 total)

  • RE: Simple Insert Stored procedure

    here's a pretty full fleshed model:

    CREATE PROCEDURE EXAMPLEINSERT(

    @Value VARCHAR(30))

    AS

    BEGIN

    BEGIN TRY

    BEGIN TRANSACTION

    ...

    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 22, 2012 at 6:21 am

    #1462641

  • RE: ETL Tool

    echoing Henrico and Anthony's responses, there is more support and examples for using SSIS than any other ETL tool out there, and the price for SSIS, being included free 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!

    March 22, 2012 at 5:28 am

    #1462622

  • RE: too many exec sp_reset_connection

    if you want to start digging into slow queries, something like this will get you started.

    you could then start reviewing the querie plans and see where the perforance issues are...non-SARGABLE...

    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 21, 2012 at 3:20 pm

    #1462450

  • RE: too many exec sp_reset_connection

    does your application make hundreds of separate trips to the server? so for example if you have a dataset with 100 table,s it makes 100 separate calls to the server...

    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 21, 2012 at 3:08 pm

    #1462446

  • RE: Sql Server 2000 - Special characters - High Priority

    all the code inserting the data has to use the same datatype : NVARCHAR or NCHAR.

    code as simple looking as

    try this code example out and see what happens 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!

    March 21, 2012 at 2:42 pm

    #1462429

  • RE: Deny users from viewing a column

    Seans idea of using a view has a lot of advantages.

    if you deny SELECT on a column like my first example,

    if you have code in an application they are using...

    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 21, 2012 at 2:34 pm

    #1462426

  • RE: Deny users from viewing a column

    deny trumps any other grants unless the user is a sysadmin...so deny it

    DENY SELECT ON [dbo].[PAYROLL] ([RATEOFPAY]) TO [ClarkKent]

    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 21, 2012 at 2:09 pm

    #1462419

  • RE: Invoke URL from SSIS?

    oops my error, i thought this was via TSQL and not in SSIS...sorry folks.

    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 21, 2012 at 9:46 am

    #1462248

  • RE: Invoke URL from SSIS?

    Paul can you add a CLR?

    if you can, it is REALLY easy.

    here's an example call

    select dbo.CLR_WebQuery('http://www.YourDomain.com?f=QueryString')

    and the code for the CLR, which i just tested was incredibly simple:

    'Imports...

    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 21, 2012 at 9:45 am

    #1462246

  • RE: Auto Increment

    yeah that's working by design;it's considered the normal behavior to throw away the identities that get rolled back in a transaciton or deleted; they are not reused.

    the identity() 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!

    March 21, 2012 at 8:44 am

    #1462186

  • RE: Stored Procedure Not Reading Duplicate Entries

    what are the specific row values that are not coming over;

    the WHERE statement you posted has WHERE items that might filter it out, as well as a group by 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!

    March 21, 2012 at 8:41 am

    #1462185

  • RE: Changes to Table definition from SSMS UI doesnt work

    Sapen (3/21/2012)

    Thanks for the reply Lynn.

    The option "prevent saving changes that require table re-creation" is currently checked. But I dont want any data loss if I am making changes...

    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 21, 2012 at 8:32 am

    #1462177

  • RE: Script all tables contraints, indexes, keys and triggers

    ramadesai108 (3/21/2012)

    I have too many tables. If I use "generate script" then it will create the table creation script as well. I don't want to create the scripts for creating...

    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 21, 2012 at 8:05 am

    #1462151

  • RE: How To Generate the deployment script wiht the binary string?

    Tom Brown (3/21/2012)

    If you select the Build...Deploy option in VS (at least in VS 2010), then Visual studio creates the deployment .SQL in the bin/debug or bin/release directory along...

    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 21, 2012 at 7:58 am

    #1462146

  • RE: Sequence Number based on Date and Customer Number

    Thanks for the reply...

    How could i now take that script but update a new column in my database to show the sequence.

    At the moment that seq column is blank but...

    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 21, 2012 at 7:54 am

    #1462144

Viewing 15 posts - 5,731 through 5,745 (of 13,460 total)