Forum Replies Created

Viewing 13 posts - 16 through 28 (of 28 total)

  • RE: copy heirarchical data

    sure lets say there are 3 tables (actually table will be decided at the runtime , nyways)

    country , state , city in the source , they can be in...

  • RE: delete all constraints for a table

    but what if we dont knw the constriants and there name , we jus need to delete alll the constriants associated with a table

    i was wondering if such an...

  • RE: getting where clause for views

    hi this query will result in all the views that depend on a table , something that can also be achieved by sp_depends <table name>

    wat we are looking for is...

  • RE: getting all the distinct columns columns count

    hi

    thnx for all the help

    SELECT COUNT(DISTINCT COALESCE(ProductID, '')) ProdCount, COUNT(DISTINCT COALESCE([OrderID], '')) OrderCount

    FROM

     [Order Details]

    will only give the total distincrt value. wat we need is the actual ProductID , its...

  • RE: getting all the distinct columns columns count

    hi

    thnx for the reply but this is exactly wat i have written.

    basically wat we need is if there are other columns like orderId,CustomerId ....

    it gives distinct of all these...

  • RE: getting where clause for views

    hi

    The reason we need is that we are building a query builder kind of utility that wud query the view definition (which is already present in databases) and then wud query...

  • RE: getting where clause for views

    perfect Journeyman , this is wat we need , is it possible???

  • RE: getting where clause for views

    thats coz view is already created now we need to query the table based on where in view for that particular table

  • RE: getting where clause for views

    but wudnt this be specific for columns , wat we need is to query a view defintion and extract only those where clauses that are used for a particular table???

  • RE: getting where clause for views

    hi

    to clarify the issue let the view be like

    create view "Alphabetical list of products" AS

    SELECT Products.*, Categories.CategoryName

    FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

    WHERE Products.Discontinued =0  and Categories.CategoryID>12...

  • RE: getting where clause for views

    hi

    to clarify the issue let the view be like

    create view "Alphabetical list of products" AS

    SELECT Products.*, Categories.CategoryName

    FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

    WHERE Products.Discontinued =0  and Categories.CategoryID>12...

  • RE: getting where clause for views

    hi

    to further clarify the issue

    let the view be like create view "Alphabetical list of products" AS

    SELECT Products.*, Categories.CategoryName

    FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

    WHERE Products.Discontinued =0 and Products.productId>13...

  • RE: getting where clause for views

    hi

    hope this makes it little clear

    wat we need is to get all the where clause for a view which involve a particular table

    so if there is a view that depends...

Viewing 13 posts - 16 through 28 (of 28 total)