Forum Replies Created

Viewing 15 posts - 8,221 through 8,235 (of 13,460 total)

  • RE: User Defined Roles

    I'd like to take a stab at this one; i've got a lot of examples I post to the forums on the 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!

    January 10, 2011 at 2:44 pm

    #1271628

  • RE: Separate track to several fields

    it depends on your data.

    if you are absolutely sure there are only two spaces in the field for every single record, you could use something like CHARINDEX2 and substrings 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!

    January 10, 2011 at 8:31 am

    #1271439

  • RE: Linked Server Problem

    Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "MSDASQL" for linked server "AS400" reported an error. The provider reported an unexpected fatal error.

    Message 7330, Level 16, State...

    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!

    January 10, 2011 at 6:04 am

    #1271340

  • RE: Parameterize all your queries using the sp_executesql - what does it mean

    your probably doing it right.

    The important thing to remember about sp_executesql is that it is susceptible to SQL Injection. since using parameters defeats that security hole, simply using params everyplace...

    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!

    January 10, 2011 at 5:58 am

    #1271339

  • RE: Q: How would I update a table based on changes in an Oracle Linked Server view

    Koen (da-zero) (1/10/2011)

    At first glance this seems like a situation that the MERGE statement could handle.

    I agree with Koen, a MERGE statement would work perfectly...only problem I forsee is the...

    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!

    January 10, 2011 at 5:50 am

    #1271335

  • RE: Encrypt Stored procedures in Sql Server 2008

    kind of... you can use this example to put together jsut a final script that executes a varbinary(max) ...so the proc body is not so obvious.

    just remember that SQL 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!

    January 10, 2011 at 5:33 am

    #1271326

  • RE: VB.Net Web Applications with SQL backends

    a datatable in .NET has a flag on each row that signifies whether the row has been changed;

    typically at our shop, we test a datatable,(usually from a types dataset, 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!

    January 7, 2011 at 12:34 pm

    #1270848

  • RE: Comapre Oracle Schema with SQL Server 2008 Schema

    If you are talking about comparing a table in SQL Server to it's assumed equivient table by the same name on oracle, two important things are the way an IDENTITY...

    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!

    January 7, 2011 at 12:18 pm

    #1270837

  • RE: BINARY vs VARBINARY ---- How to decide for a given scenario

    I'm a bit confused...the PK will be the hashed binary/varbinary column? And you need to search the column? That doesn't sound right at all.

    I don't think you can search 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!

    January 7, 2011 at 11:14 am

    #1270795

  • RE: Dump table to email

    one of either two ways: send as plain text:

    @body_format = 'TEXT',

    or, as i mentioned before, add an extra column that will have a "<BR>"

    @query = 'SELECT ##TableTemp.*, <BR> 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!

    January 7, 2011 at 9:00 am

    #1270710

  • RE: Dump table to email

    one of the many optional parameters sp_send_dbmail allows you to include the results of a query as either an attachment, or as part of the body of an email.

    here's a...

    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!

    January 7, 2011 at 8:32 am

    #1270699

  • RE: Using xp_cmdshell and Zip Genius 6

    i don't think it's 32 bit vs 64;

    it might be that your zipgenus app is returning an error at teh command line that you are not seeing...

    could you try this...

    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!

    January 7, 2011 at 5:56 am

    #1270585

  • RE: Using xp_cmdshell and Zip Genius 6

    when you run xp_cmdshell, you are not running under your own credentials....

    prove it to yourself by running this, which will show you what NT name you are running cmdshell from.

    DECLARE...

    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!

    January 6, 2011 at 4:50 pm

    #1270370

  • RE: Path for sqlservr.exe - Query?

    the server executable itself is always installed on the same disk the %SYSTEMDRIVE% directory exists; databases, traces ,previous backups you can discover form some of the system views, 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!

    January 6, 2011 at 4:45 pm

    #1270368

  • RE: Data Trimming Issue

    here's a single SQL with both examples:

    formatted zip, and jsut the first 5:

    select CASE

    WHEN LEN(ZIPCODE) > 5

    ...

    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!

    January 6, 2011 at 1:48 pm

    #1270313

Viewing 15 posts - 8,221 through 8,235 (of 13,460 total)