Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. emilyng

    (B)Need Help in SQL View!(/B)

    The following is my statement that I put in SQL View : SELECT DISTINCT NO, Name, IndexNumber, Type1, Type2, StockCode, StockShortName, ISIN FROM Entity WHERE (Name IN (SELECT Name FROM Entity AS Tmp GROUP BY Name HAVING COUNT(*) > 1)) ORDER BY Name I...
  2. emilyng

    Copy table from one db to another db without copying data

    Can I know how to copy a blank table (with fields) from one database (with data in the table) to another database without copying the data? I am currently running SQL 7 (desktop version)
  3. emilyng

    What is the max for nvarchar data type in SQL?

    Hi there, Can I know how many character (max) that can be entered into a nvarchar data type?

Part and Inventory Search

Back
Top