Search:

Type: Posts; User: CSOOR; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.10 seconds.

  1. Thread: Table Metadata

    by CSOOR
    Answers
    2
    Views
    1,229

    General Re: Table Metadata

    Use JDBC MetaData classes using any RDBMS, i think that will help you with your knowledge.
  2. Answers
    3
    Views
    1,352

    Data Warehousing - Re: Integrate data in real time

    Try SAS's Data integration tool
  3. Thread: Change Date

    by CSOOR
    Answers
    2
    Views
    1,453

    Unix/Linux Re: Change Date

    You will have to do some programming in unix using the date format.
    e.g to find the date you can try ,date '+%d' to get the date ,then check for day ( Sun ) using date '+%a' and build the...
  4. SQL Re: diffrence between delete with commit and truct table

    Please go thro' all replies and add this into that, delete keeps the log while truncate does not.
  5. Thread: primery key

    by CSOOR
    Answers
    2
    Views
    1,482

    General Re: primery key

    You can consider entire set of attributes of relation as the primary key of the relation since this is uniquely identify the row,but same time if you think about the whole system design , there...
  6. Answers
    4
    Views
    2,629

    Re: Can u pls solve this pls

    This is very simple problem, i think you should solve yourself. You should know the
    System Design Life Cycle ( SDLC) .
  7. Thread: welcome message

    by CSOOR
    Answers
    2
    Views
    1,622

    Windows Re: welcome message

    Use "banner" command in your login shell.
    eg. If your login shell is K shell. Then in the .profile file add this command
    like banner "Welcome to My World"
  8. Answers
    4
    Views
    1,298

    Oracle Re: How to run queries from flat file

    Suppose you have file name my_script.sql which has all the code then you can run from
    command line by calling this file.
    eg.
    c:\>sqlplus username/password@databasename @"c:\my_script.sql"
  9. Thread: sql

    by CSOOR
    Answers
    5
    Views
    1,491

    SQL Re: sql

    Do practise as much as you can .
  10. Answers
    1
    Views
    1,110

    SQL Re: how to retrive data in batches

    - Note : First alter the employee table with identity col then go with the logic below, after you finish the migration just remove that identity column from employee table



    Declare...
  11. MySQL Re: how to change first letter capital through MY sql

    select concat( upper(substring(Col_Name,1,1)),lower(substring(Col_Name,2)) )
    from Table_Name

    -- Note : Replace the Table_Name and Col_Name with your actual tablename and column.
  12. SQL Server - Re: How to convert rows into columns in sql server 2000

    Please take the idea from one of my answer for "One row to Multiple Rows" in the same sql server thread.
    The member name is "kkknnn" .
  13. Answers
    2
    Views
    1,296

    SQL Re: Retrive long data type values from database

    You are loosing the CR/LF characters when you are bringing the data thro' spool , you will have to preserve the CR/LF characters. Then you can see the
    data in multiple lines.
  14. Answers
    4
    Views
    12,431

    SQL Server - Re: intersection in SQL server 2000

    Try this query in SQL server 2005
  15. Thread: SQL Insertion

    by CSOOR
    Answers
    5
    Views
    1,546

    SQL Re: SQL Insertion

    Internally , rowid take care of the order in which you insert the row.
  16. Thread: SQL Insertion

    by CSOOR
    Answers
    5
    Views
    1,546

    SQL Re: SQL Insertion

    select sno,name,marks from t_name order by 3 desc;
    Put this result into some other table call t_name2 in the same order the way you want.
    Now delete all the rows from t_name.
    Again insert the...
  17. Answers
    1
    Views
    2,044

    SQL Server - Re: One row to Multiple Rows

    CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))
    returns @temptable TABLE (items varchar(8000))
    as
    begin
    declare @idx int
    ...
  18. Thread: Row count

    by CSOOR
    Answers
    3
    Views
    1,801

    Oracle Re: Row count

    select max(rownum) from TableName
  19. Thread: which one is odd

    by CSOOR
    Answers
    9
    Views
    2,146

    SQL Re: which one is odd

    You can do whatever you like within the Cursor; But question is like that .
  20. Thread: which one is odd

    by CSOOR
    Answers
    9
    Views
    2,146

    SQL Re: which one is odd

    Insert is Odd, which is not a part of CURSOR syntax.
  21. Answers
    6
    Views
    2,483

    SQL Server - Re: Chating Dilog box

    Please send your questions in proper thread, this thread is only for sql server .
  22. Thread: Partial Classes

    by CSOOR
    Answers
    2
    Views
    1,539

    Re: Partial Classes

    The class defination is divided into multiple classes . Each class will represent the small model. This is good for modeling the business logic. Code will be clean and easy to maintain.
  23. Answers
    1
    Views
    1,917

    SQL Server - Re: Inserting value into unique Identifier

    use NEWID() function as default, while creating the table with unique Identifier

    eg.

    col_name UNIQUEIDENTIFIER DEFAULT NEWID()
  24. SQL Re: How to update more than one row with a different value

    There are two ways :

    1. CASE
    2. Subquery
  25. Answers
    2
    Views
    2,745

    Re: How to convert string to integer

    #include <stdlib.h>

    Try atoi function
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact