I am using VB.NET for coding and SQL Server 2005 for database. My application is ready for release. Just on thing missing before I can go live.
I\'m looking for the best method for importing csv or excel file to SQL Server 2005 using .开发者_Python百科net MVC.
I\'m trying to create an Excel XML that I want to store in an XML Field in SQL Server 2005.I have gotten this far:
Environment: SQL-Server-2005, SSAS 2005 I am using the following formula to create a Moving Annual Total
I\'ve been asked to put together a search for one of our databases. The criteria is the user types into a search box, SQL then needs to split up all the words in the search and search for each of the
I have a complex query that I need to use in a subsequent query (actually update statement).I have tried both using a CTE and a temp table.The performance using the CTE is horrible vs the temp table a
I want to know whether one SP is referenced anywhere. Currently I am checking using SP_DEPENDS. Is there an开发者_JAVA技巧y other way to check this...?If your dependencies are broken, the only way I
I have the a query which is union of two queries, the resulting query is returning duplicate records, I don\'t want duplicate records. I tried using DISTINCT but still getting the same result, can any
I have 2 tables: \"orders\" and \"visits\". in the orders table i\'m saving some details about the order including \"userIP\" and \"orderDate\". in the visits table i\'m saving details everytime a use
I have a database with merge replication set up on a SQL 2005 server with 1 subscriber.I am having some identity range issues an I started to look at the MSmerge_identity_range table.I have one subscr
加载中,请稍侯......