I\'m trying to create my first data mart. I am creating开发者_高级运维 my dimension table with a \"Select Into\"
i\'m going to running some queries against an SQL Server database, followed by a delete. Ideally all this happens inside a transaction (i.e. atomic).
If I have a parent table and a child table where there can be one parent to many children, how can I go about returning the following xml from a stored procedure in a stored procedure?
I have the field: APP_DATE (smalldatetime) I\'m doing this query: INSERT INTO table (TYPE, CODE, APP_DATE, DATE) VALUES (\'APP\', \'123\', \'02/10/2010 12.30\', GETDATE())
I\'ve got a problem with using for xml explicit in SQL Server 2000 (so I can\'t use the new path() stuff from sql 2005/8)
I work as a researcher at Tata Research Development and Design Centre, India . I am exploring the available Natural Language Interfaces for database.While exploring MS English Query, I found that cert
I am extracting data from multiple tables. mt query is as follows: SELECT p.Record_Num as RecordNum ,p.GCD_ID as GCDID
Is there a way to query the database and retrieve a list of all stored procedures and their 开发者_如何学JAVAparameters?
I need to find if /3GB switch and /PAE is enabled on a server. Also, I want to know the size of page file and physical RAM on the server.
I need to save the DataSet, results of a reportin开发者_如何学Pythong app, to a table in SQL Server 2000. Do I save the datasets the same way I would store files in the DB, via Byte Array()?SQL Server
加载中,请稍侯......