I have a SQL Server Integration Services project which queries a SQL Server 2005 database using an OLE DB Source with SQL Command as data access mode. I'm trying to parametrize my SQL query but the syntax is not @PARAM and when I try to use ? and click on the parameters I get an error saying that "Parameters cannot be extracted from the...
Hi, I am developing a WinForm Application in C Sharp on the .net framework. The database string I am using as of now is <add key="Conn" value="Data Source=MNTCON016; Database=Overtime_Calculator;Trusted_Connection=True;MultipleActiveResultSets=true" /> As I am using Microsoft SQL Server 2005 for development, I can use 2 data readers ...
Hello, I am having issues implementing SqlSiteMapProvider using the Wicked Code article. I am using VB.NET and SQL Server 2008 - and the OnSiteMapChanged event is not firing (the SqlDepdencyCache just seems to simply be not working at all). The article states "You also need to run the ASP.NET worker process with dbo privileges for SQL ...
Hi, I'm looking for a good solution to use the containstable feature of the SQL Serve r2005 effectivly. Currently I have, e.g. an Employee and an Address table. -Employee Id Name -Address Id Street City EmployeeId Now the user can enter search terms in only one textbox and I want this terms to be split and search with an "AND" opera...
The following tables are involved: Table Product: product_id merged_product_id product_name Table Company_Product: product_id company_id (Company_Product has a primary key on both the product_id and company_id columns) I now want to run an update on Company_Product to set the product_id column to a merged_ product_id. This update co...
We have a TFS installation on a machine that is close to going out of support life and we're planning on migrating to a new machine in a couple of months. However in the meantime we are getting really low on disk space and (for whatever reason) we can't add more disk space. This has me wondering if there is a tool that would show us ho...
Hi guys I have an error being thrown by SQL Server Management Studio when running this code: declare @percentage numeric(3,2) set @percentage = cast(15 as numeric(3,2)) but when I change numeric declaration to declare @percentage numeric(4,2) set @percentage = cast(15 as numeric(4,2)) everything goes fine. Is there a limitation ...
I created a view. The view's Query works fine. Now I want to write another Query which uses the first one. As far as I know it should look like this: SELECT * FROM myView; Now there is an Error returned: "Ungültiger Objektname 'myView'" in English its something like "unvalid object name 'myView'. How do I refer to or call views the r...
Possible Duplicate: SQL: What does =* mean? I am going through some legacy code and found a query like this: SELECT * from foo_table, bar_Table where foo_table.id *= bar_table.fac_id What does the *= operator do? ...
I have a stored procedure that takes a product_id and returns some data about the product. I would like to make a query or procedure that maps this stored proc over a "select * from products" query. Is there a way to do this? ...
I'm in a situation where I have to improve the performance of about 75 stored procedures (created by someone else) used for reporting. The first part of my solution was creating about 6 denormalized tables that will be used for the bulk of the reporting. Now that I've created the tables I have the somewhat daunting task of determining ...
On one of our sql 2005 servers we are no longer able to give any users server roles (ex. sysadmin). It appears to be successful both through the UI and through code. But when we check in the db and in the UI the role is unchecked and not shown for the user in the master db. Permissions don't seem to be the issue as we are testing this as...
Via this link, I know that a GUID is not good as a clustered index, but it can be uniquely created anywhere. It is required for some advanced SQL Server features like replication, etc. Is it considered bad design if I want to have a GUID column as a typical Primary Key ? Also this assumes a separate int identity column for my clustering...
I am using php against SQL Server 2008 using the mssql driver. Anyone know of a way to pass a table value parameter into stored procedure? ...
I have a varchar field in the database. I want to do a SQL to get the values in the field, and do like a substring on the result. I want to only return the words between some beginning and ending. For instance, for the field value "We few, we happy few.", I want to return only "we happy". Does SQL Server have a function to do this? ...
I have just installed SSMS tools pack from http://www.ssmstoolspack.com everything seems to work except I cant view queries from my .net application. If I run a query through management studion SSMS correctly displays the query. but when running my application no queries are shown in the local history window. There is mention of enabl...
Hello all, I have this BCP command: 'bcp DBName..vieter out c:\test003.txt -c -T /t"\",\"" -S SERVER' The output CSV I get does not put quotes around the field names, instead it puts it around the commas! How can I get the /t"\",\"" to put quotes around all fields. Thanks all ...
I have a SQL Server database with these pages: +------------+--------------+-------------------------------+ | pageid | parentid | title | +------------+--------------+-------------------------------+ | 1 | null | Home | +------------+--------------+----------...
I'm currently exploring the possibility of integrating MYOB Exo Business (Exonet) to a shopping cart developed using ASP.NET 3.5. I understand that there is an MYOB ODBC driver to use as a connector. Is this the only way to do it? ...
Recently a friend of mine has shown me a question as under declare @t table(data varchar(50)) insert into @t select ' _ |_ |_ ' God knows from where he got this idea ! How can I find that it is CL How to do that in a set-based manner? Thanks a lot ...