我不敢肯定,如果我适当地讲了这个问题的话,我将解释一下我试图进一步che。
我期待着建立一个现有数据库的图表,显示表格关系的关键关系等。
我在互联网上看到了显示你可以走到的哨所;数据库图表。 但我在管理演播室中没有看到这方面的任何结果。
Something similar to this:
你们首先需要安装图表支持装置。 然后,你们都把数据库扩大到外,并正确地点击数据库图表的夹。
如果为数据库提取了数据库图,如果你在贵国数据库下数据基底图表倒塌,就应当看到。 如果你试图创建一种途径,即:create new database diagram。
I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...
TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...
I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. ...
Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...
I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...
I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
I m trying to transform the SQL Query below into Linq to SQL select Categorias.IdCategoria, Categorias.Nome, SUM(lancamentos.valor) from lancamentos left outer join Categorias on Lancamentos....
