1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Recent Content by randheer

  1. randheer
    Post

    What is T-SQL

    Checkout TSQL Tutorial on http://www.sqlserverquest.com/p/t-sql-tutorial.html http://www.sqlserverquest.com/p/t-sql-tutorial.html
    Post by: randheer, Nov 8, 2014 in forum: Databases
  2. randheer
    Post

    Difficult SQL Query? select specific values?

    its seem below is the representation of your problem and i have provided some logic and let me know if my understanding is correct i will get you...
    Post by: randheer, Aug 4, 2011 in forum: Databases
  3. randheer
    Post

    difference mysql and ms sql

    My SQL is open source database while MS SQL Server is micrsoft product. MY sql has limited facilites while sql server is very advance and having...
    Post by: randheer, May 9, 2011 in forum: Databases
  4. randheer
    Post

    When do you create a new DB?

    its a good emaple of large database
    Post by: randheer, May 9, 2011 in forum: Databases
  5. randheer
    Post

    When do you create a new DB?

    Generally each application has single database.. having 30..40 tables is not big. some people keeps one more database for reporting or analytics...
    Post by: randheer, May 6, 2011 in forum: Databases
  6. randheer
    Post

    deleting duplicate rows from sql server databse

    selecting max id and putting this sub query in delete statement will work... delete * from table where id not in (select max id sub query)
    Post by: randheer, May 6, 2011 in forum: Databases
  7. randheer
    Post

    Need Solution for key

    After seeing your tables its look like Table1 Table2 should be the msater table and both have there primary key.... Table2_1 should contain...
    Post by: randheer, Apr 12, 2011 in forum: Databases
  8. randheer
    Post

    How to make table to store reminders

    Little more simplified form of you data model. Table: This will be reminder master table you can a type of reminder and than can use their ID...
    Post by: randheer, Apr 12, 2011 in forum: Databases
  9. randheer
    Post

    Help Me to Build MySQL Query

    did above example solves your problem or there is ny change required
    Post by: randheer, Apr 8, 2011 in forum: Databases
  10. randheer
    Post

    Which database has more demand in market - Oracle or SQL?

    Microsoft SQL Server is picking up..... for small application generally people prfers SQL Server while oracle used for larger data bases...
    Post by: randheer, Apr 8, 2011 in forum: Databases
  11. randheer
    Post

    Database normalization

    these three tables could be represent in to more normalised and Database design could be more simple
    Post by: randheer, Apr 8, 2011 in forum: Databases
  12. randheer
    Post

    How i can learn data base ?

    Get the some databse engine download and read e books online start doing the practical.... more you work hard more you will learn :)
    Post by: randheer, Apr 7, 2011 in forum: Databases
  13. randheer
    Post

    Help Me to Build MySQL Query

    ------------------------please check the query for you problem. its written in TSQL may be it help you I have Taken temp table and just change few...
    Post by: randheer, Apr 7, 2011 in forum: Databases
  14. randheer
    Post

    Inserting with Select

    You can do it in different ways as specified below… You can declare a variable and provide @var in place of GID in select statement...
    Post by: randheer, Apr 5, 2011 in forum: Databases
  15. randheer
    Post

    Search only first 3 characters of a column

    check this out Check this example you can provide the @var as 300 for your input declare @table table (phno varchar(100)) insert into...
    Post by: randheer, Apr 5, 2011 in forum: Databases