Hi there, I have a form that is trying to insert some data into an SQL Server 2008 database. The form has a function to get the current date/time and then insert it into the database as follows; $now = date("Y-m-d H:i:s"); $q = "INSERT INTO ".TBL_USERS." ( username, password, userid, userlevel, email, created, updated, timestamp, fulln...
I am doing a code review with a client. It is a proc on SQL Server 2008. He wants to do everything in SQL and not a process. He is looping through a list of catalogs and then running a proc in each one: DECLARE CatalogList CURSOR FOR SELECT 'EXEC ' + c.CatalogName+ '.dbo.procInEachDb ' FROM CatalogList FETCH NEXT FROM CatalogList I...
I am having report which are having builtin functionality of SQL Sever reporting service 2005 like 'Export to CSV','Export to XML etc. When i use this functionlity its working fine on IE. The Export functionality is works fine its is exporting file name like MX3_ Enrollment-User Enrollment.xml but it is not working in firefox. When same...
Is there a published list of expected values by SQL Server version that match to the DatabaseVersion column returned by a RESTORE HEADERLISTONLY command? For example, DatabaseVersion 611 = SQL 2005 SP_ ? Plenty of references for SQL Server build numbers to product versions (ex. SQL Server 2005 SP3 = 9.0.4035), my Google and Bing searche...
First, from BOL: Queries that modify table variables do not generate parallel query execution plans. Performance can be affected when very large table variables, or table variables in complex queries, are modified. In these situations, consider using temporary tables instead. For more information, see CREATE TABLE (Transact-SQL). Que...
Basically I am creating a database driven website in Web Developer 2008. The database is stored in the App_Data folder of my website project. Could I have an iPhone, Blackberry, Symbian, Windows Phone, webOS or Android app access the database via an HTTP (or some other type of) request? I would like to know if this is possible before I ...
We were doing load testing the other day and during it, one of our developers used the Performance Tuning Advisor and applied all the recommendations. Our site could then handle a lot more load and we were happy. However he did not save the recommendations and the load test was not done on our production server. I can't figure out how ...
Hi there, what is the benefit of having an additional identity column in each table of a database? What are the drawbacks? Update: Now i want to expand the case and introduce replication. What for is this surogate key (identity comlumn) aside of the rowguid we get with the replication. Behalf of K. Brian Kelley's objection one should s...
Hi folks, If i have a stored procedure or a trigger in Sql Server 2008, can it do some sql calculations 'in another non-blocking thread'? ie. something in the background also, can two sql code blocks be ran in parallel? or two stored procs be ran in parallel? for example. Imagine we are given the job calculating the scores for each St...
HI all, Iam using VS2008 and SQL2008 i want to access my stored procedures in VS2008 TFS so please tel me the steps to do it. Thanks in advance ...
Doctrine ORM 1.0 inserts Datetime values in ISO8601 format; that is: '2009-10-23 12:31:22', but for some reason using SQL Server 2008 Express as my DB, throws an exception as if the value inserted was NULL. Here's the query: {sfDoctrineLogger} executeQuery : INSERT INTO [vbif_inventarios] ([anulado], [id_restaurante], [fecha_inventari...
On a clean windows machine I installed Web Dev Express 2008. That also installs SQL Server Express 2008. I just wanted to add SQL Server Management Studio Express (SSMSE) 2008. I had problems, and I'm not the only one: http://msdn.microsoft.com/en-us/library/ms365247.aspx The msdn page has a lot of suggestions and a lot of people wh...
For simplicity suppose I have one varchar(50) per row and these are my rows: 1) The quick brown fox jumps over the lazy dog 2) I like brown foxes 3) fox 4) fox So the page compression would find the word fox for instance and put it in the dictionary. Would only rows 3 and 4 benefit and rows 1 and 2 would not because they contain other...
I have a large table I imported from an Excel spreadsheet. For five of the columns, containing teacher names, I'd like to collapse all of the blanks in each row so I have no blanks to the left of any name. An example would probably show better what I mean. Here's an example of the data now: Student ID Teacher1 Teacher2 Teacher3 Tea...
Hello experts, I have a table as shown below Q_ID DeptID EmployeeName City 100 100 testest abcd 100 101 tata cdd with 100K records. I need a query which should fetch all records with same Q_ID but different DEPTID. Please help. Thanks ...
After installing Visual Studio 2008 and SQL Server 2008 on Windows 7, I get the following error when connecting to a server with SQL Management Studio: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on t...
hi how can I delete duplicate rows in SQL Server 2008 ? thanks in advance ...
I've tried to get a solution for the above said question from MSDN Social and other resources from Microsoft. I was specifically looking for offline scenarios where client come online only to fetch updates from the Server. There are plenty of articles on Sync covering Sql CE but MSFT team seems to be ignoring questions from the communi...
I am successfully executing the following query in SQL Server 2008 built into VS2008: SELECT REPLACE(image32, 'img', 'images/Products') FROM Product but when I do a select * from product query, I am given the old results. Whats going on? Why isnt my data being updated? Did I just answer my question? Do I need to throw in an Update ...
This is an SQL Question, I think it is difficult one - I'm not sure it is possible to achieve in a simple SQL sentence or a stored procedure: I want to find the number of the longest sequence of the same (known) number in a column in a table: example: TABLE: DATE SALEDITEMS 1/1/09 4 1/2/09 3 1/3/09 3 1/4/09 ...