What is the best way to append to a text field using t-sql in Sql Server 2005? With a varchar I would do this. update tablename set fieldname = fieldname + 'appended string' But this doesn't work with a text field. ...
I modified one of the apps I made for russian market. Everything seemed to be fine, there was an issue when you enter data into database but it was solved by by setting page encoding to utf-8. So inserting and retrieving works fine. I ran into problem I just have no idea how to tackle. When I ran following query (simplified) in mssql que...
Background: I'm working on migrating from SQL Server 2000 to SQL Server 2005. This is providing DB service for a C++ application that uses SQL Native Client to communicate with SQL Server via ODBC. Problem: I'm attempting to insert QNAN into a float column in the database. In my application, this value is stored as a double (value: 1....
Today again, I have a MAJOR issue with what appears to be parameter sniffing in SQL Server 2005. I have a query comparing some results with known good results. I added a column to the results and the known good results, so that each month, I can load a new months results in both sides and compare only the current month. The new column...
Does the use of subscriptions in Reporting Services 2005 require special licensing? ...
Hello all, I've currently got a database with about 20 reference tables, i.e. stuff like products, assets, depots, users, etc. This information is stored in a central database and is downloaded to PDAs of engineers who are out on the road. Every table in my database has a PK of UniqueIdentifier (i.e. a GUID). I've realised after 2 year...
So I got a 64 bit virtual machine running x64 Windows Server 2003 Standard Edition with plesk from blacknight.ie. I installed all the updates from windowsupdate.microsoft.com apart from group policy, terminal services and windows search. I then tried installing SQL 2005 x64 Enterprise. I tell it to install everything including all the cl...
SQL Server 2005 has great sys.XXX views on the system catalog which I use frequently. What stumbles me is this: why is there a "sys.procedures" view to see info about your stored procedures, but there is no "sys.functions" view to see the same for your stored functions? Doesn't anybody use stored functions? I find them very handy for e...
How to deploy Sql server reports on productions boxes? Locally it's not a problem, I just specify the url and then right click on project and say deploy which deploy on my local server. But it's not gonna be the case for the production server ...
I'd like to take a table, generate it's hash string, store it, then compare it at a later predefined time and see if it matches, if not take note of the modification time and store that with the new change date. This is because I believe an on insert trigger would cause a bad slow down if a batch of over 5000+ insert statements is submi...
Main problem is about changing the index of rows to 1,2,3.. where contact-id and type is the same. but all columns can contain exactly the same data because of some ex-employee messed up and update all rows by contact-id and type. somehow there are rows that aren't messed but index rows are same. It is total chaos. I tried to use an in...
Hi all, In a pretty typical scenario, I have a 'Search' text box on my web application which has user input passed directly to a stored procedure which then uses full text indexing to search on two fields in two tables, which are joined using appropriate keys. I am using the CONTAINS predicate to search the fields. Before passing the s...
Can anyone help me with the trying to write SQL (MS SqlServer) - I must admit this is not by best skill. What I want to do is exactly the same functionality as appears for the seach boxes for the Yell website i.e. Search for company type AND/OR company name AND/OR enter a company name in a Location if anyone can suggest the SQL cod...
I am using the current code in attempt to access a msSQL 2005 db: <?php $myServer = "[server]"; $myUser = "[username]"; $myPass = "[password]"; $myDB = "[db]"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $s...
In MS Sql server 2005, by default 1MB Auto Growth is there, How can i change it to whatever i need.? Thanx, Ambanna ...
Context My current project is a large-ish public site (2 million pageviews per day) site running a mixture of asp classic and asp.net with a SQL Server 2005 back-end. We're heavy on reads, with occasional writes and virtually no updates/deletes. Our pages typically concern a single 'master' object with a stack of dependent (detail) obje...
Hi there, I use SQL Server 2005 and need to test whether values in a column that's metadata has been specified as DECIMAL(18.3) actually contains data that has values to the right of the Decimal point, and if so, what these values are. I've read a few articles that only discuss how to drop off the decimal places or how to round the val...
I have following issue: I have a table for maintaining the hierarchical data. I'd like to use CTE from SQL 2005. WITH tree (id, parentid, code, name) AS ( SELECT id, ofs.ParentID, ofs.code, ofs.name FROM OrganizationFeatures ofs WHERE ofs.ParentID IS NULL UNION ALL SELECT ofs.id, ofs.ParentID, ofs.code, ofs.name...
Some context: one of the systems I'm working on is a .net 2.0 web application. VB.net for the front end, and SQL Server 2005 for the backend. For a variety of reasons that have been lost to time, the original designer decided to use the .Net OleDB connection rather than the SQLClient connection. After a few years of development, this ...
I've used GetDate() in defaults for a long time. What is the equivalent call, or logic in SQL 2005 for me to put in a default that will give me the current UTC time. ...