Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 13,460 total)

  • RE: SSMS -> File -> Open: gives Notepad rather than Query Editor

    i think you answered this in your first post...but just in case...

    can you go to this spot and put sql files in there? does that make any difference?

    i know...

    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!

    June 8, 2011 at 3:12 pm

    #1335969

  • RE: Couple of questions about trigger

    show us your trigger, and we can help you tweak it to handle multiple rows as a set based solution..

    as far as whether it's insert/update/delete, if there is any 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!

    June 8, 2011 at 12:59 pm

    #1335889

  • RE: Any simple way to determine which which Procedures, Views, and Functions call a table?

    there is a view you can use, that is mostly correct:

    SELECT OBJECT_NAME(REFERENCING_ID),* FROM sys.sql_expression_dependencies

    WHERE OBJECT_NAME(REFERENCING_ID = 'YourProcName'

    issues can arise sometimes, becasue you can create a view that references tables...

    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!

    June 8, 2011 at 10:52 am

    #1335816

  • RE: Problem extracting value from CONTEXT_INFO() to NVARCHAR field

    definitely the conversion in there: here's a stark example...you'll see none of the results are the same,all due to the conversion issues:

    /*

    (No column name)(No column name)(No column name)(No column name)(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!

    June 8, 2011 at 10:31 am

    #1335800

  • RE: Problem extracting value from CONTEXT_INFO() to NVARCHAR field

    ok, i can duplicate some of what you are seeing...

    try this, which is barely modified form what you posted....

    i get chinese characters from my loginnmae due to the conversion:

    what 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!

    June 8, 2011 at 9:49 am

    #1335764

  • RE: Problem extracting value from CONTEXT_INFO() to NVARCHAR field

    as far as I know, the data type and sizes should always be varvbinary 128 and nvarchar(64), right?

    wouldn't an implcit comversion form nvarchar to varchar mess up the data?

    or is...

    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!

    June 8, 2011 at 9:17 am

    #1335728

  • RE: convering and then comparing dates

    you can do what you want with the dateadd/datediff functions

    In this case, one easy way to do it is to find the beginning of the month for the date 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!

    June 8, 2011 at 7:24 am

    #1335644

  • RE: Text Matching with Case sensitive

    as far as i know, you could use a case sensitive specific, but all the examples i've tripped on here in the forums always go compare binary; some collations cannot...

    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!

    June 8, 2011 at 6:32 am

    #1335590

  • RE: Bulk Import with data like cobol S99V999

    i think you'll have to bulk insert into a staging table, and then move fromt he staging table to a final table. BULK insert doesn't have any data massaging like...

    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!

    June 8, 2011 at 6:11 am

    #1335574

  • RE: Text Matching with Case sensitive

    yes...all you have to do is COLLATE using a case sensitive collation just for the comparison/where statement:

    ...where name <> upper(name) collate Latin1_General_BIN

    SELECT

    CASE

    WHEN 'India'...

    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!

    June 8, 2011 at 6:04 am

    #1335568

  • RE: Permissions basics

    Stefan one of the things i love to do is test the permissions... you don't need to login as them or anything.

    for example, supposed add a user to a database......

    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!

    June 7, 2011 at 6:12 pm

    #1335413

  • RE: Permissions basics

    Stefan Krzywicki (6/7/2011)

    Thanks, I'll take a look at that. It is actually a single person I'm granting access to a single table. In the scenario I described, they shouldn't see...

    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!

    June 7, 2011 at 3:48 pm

    #1335377

  • RE: Permissions basics

    not really a basic question; usually developers are used to having full permissions on everything, and preventing access isn't really part of the picture until later.

    SQL is deny by default...so...

    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!

    June 7, 2011 at 2:36 pm

    #1335331

  • RE: Multiple double quotes in a csv

    is every field dbl quote delimited, regardless of value being integer, decimal or string, or just strings?

    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!

    June 7, 2011 at 2:13 pm

    #1335305

  • RE: Making multiple copies using a Schema

    please post back if it works for you; this same issue comes up on otehr posts, this is the first time i really jumped in at 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!

    June 7, 2011 at 11:25 am

    #1335195

Viewing 15 posts - 7,411 through 7,425 (of 13,460 total)