Forum Replies Created

Viewing 15 posts - 5,596 through 5,610 (of 13,460 total)

  • RE: sqlserver1

    asranantha (4/10/2012)

    1)why a table can have one primerykey?

    2)what is derivedtable in sql server?

    3)what is subquery in sql server?

    4)what is insteadof trigger in tsql?

    plz tell me answers

    i've linked...

    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!

    April 11, 2012 at 10:22 am

    #1472020

  • RE: Question regarding appropriate applications of SQL CLR

    whhjops! posted to the wrong thread!

    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!

    April 11, 2012 at 10:21 am

    #1472019

  • RE: Date Format to String

    Cadavre (4/11/2012)

    Nice Lowell 😀

    I did a quick test to compare, as I normally do when I see something different.

    Cadavre I always love your performance tests.

    I have no idea how many...

    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!

    April 11, 2012 at 9:21 am

    #1471956

  • RE: Tooltip Dilemma

    i've used soem javascript stuff to make a DIV appear based on mouseover; it should be easy to add to the report.

    obviously a DIV is not limited to any specific...

    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!

    April 11, 2012 at 9:17 am

    #1471952

  • RE: floating error

    you said if you remove the exp() it works.

    what value is returned by sum(log(CASE WHEN field = 0.0 THEN 1 WHEN field IS NULL THEN 1 WHEN field= -100 THEN...

    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!

    April 11, 2012 at 9:11 am

    #1471946

  • RE: Date Format to String

    SELECT CONVERT(VARCHAR,@date,112) + '' + REPLACE(CONVERT(VARCHAR,@date,108),':','')

    i keep a handy proc sp_dates in my master database so i can get a list of common datetime formats for myself:

    i just run sp_dates...

    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!

    April 11, 2012 at 9:05 am

    #1471937

  • RE: trigger failing on data transfer

    =echo=

    i'm just Jack and Sean's Parrot today!

    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!

    April 11, 2012 at 9:02 am

    #1471931

  • RE: trigger failing on data transfer

    paste the CREATE TRIGGER definition here, and the CREATE TABLE definitions for the two tables in question;

    with that, we should be able to show you exactly what the issue is.

    also,...

    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!

    April 11, 2012 at 9:02 am

    #1471929

  • RE: Reading microseconds from Sql server into oracle 10g

    that was my point.

    I thought you said you said sourceid exists on SQL Server., and assumed you were doing the work from SQL server, with linked servers to Oracle.

    What confused...

    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!

    April 11, 2012 at 8:56 am

    #1471921

  • RE: Need to tune sql

    since there is no WHERE statement, there's not really much to tune, right? that'll be a full table scan regardless of the indexing, I'm thinking.

    returning 4.9 million rows will take...

    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!

    April 11, 2012 at 6:45 am

    #1471808

  • RE: How to find the SQL Server databse Last used by db users ?

    Gazareth (4/11/2012)

    Could Logon triggers be used?

    Get them to write to an auditing table and then query that for the information you require?

    As Lowell says though, after the initial login event...

    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!

    April 11, 2012 at 6:40 am

    #1471807

  • RE: How to find the SQL Server databse Last used by db users ?

    charipg (4/11/2012)

    Thanks Lowell.

    but i need to get the details of all the users of all the dbs with last logintime to the databases.

    The logon event only occurs once;there no lo...

    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!

    April 11, 2012 at 4:31 am

    #1471744

  • RE: Reading microseconds from Sql server into oracle 10g

    caramelkaps (4/10/2012)

    currently im not trying to insert into Oracle.In oracle for insertion I have the column as Timestamp(9).

    Currently Im just trying to select from Sql server via Oracle. and 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!

    April 10, 2012 at 3:25 pm

    #1471554

  • RE: Reading microseconds from Sql server into oracle 10g

    caramelkaps (4/10/2012)

    Thanks...the example u provided works in oracle.

    But when i try to exceute this query to get values from sql server table it fails and gives an error date...

    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!

    April 10, 2012 at 3:01 pm

    #1471533

  • RE: Rollback the inserts

    i use SSMS tools to always use a template that looks like this:

    SET XACT_ABORT ON

    BEGIN TRAN

    --do stuff like the insert

    --check your row counts

    --highlight and execute one of the two...

    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!

    April 10, 2012 at 2:24 pm

    #1471509

Viewing 15 posts - 5,596 through 5,610 (of 13,460 total)