i want to get the sum of quantity from the below query. how i write the group by clause in below mention query.
In a project on which I am performing maintenance, I am referencing a database stored on another server. This reference was previously pointing at a database on the same server, but my testbed server
I have a big list of int parameters for a SQL query: update mytable set col=\'xyz\' where id in (/* thousands of ints */)
I\'m running maintenance on a database program with no foreign key constraints, even though it really should have...
I want to create a view in which I select something like the following: select id, name, 1 as active from users
I have 6 tables in an SQL Server 2000 databa开发者_C百科se. The XML contains a similar schema. What I want is to update the records in the database and append the new entries. I am a bit new to this.Y
One of the most important databases that I administer is poorly designed. The program which uses it uses only 1 login which happens to be a System Administrator. Edits and deletes are done in place so
Right... I\'ve got a program I\'m doing some maintenance on. Urgh. Even describing it makes me shudder... Right, okay.
I have the following problem. I have to stored procedures (debug messages double-indended): CREATE PROC innerProc
I have 开发者_Go百科a SQL Server 2000 box that houses several databases, some of which are probably no longer in use.I\'d like to clean things up by first taking them offline, and then later removing
加载中,请稍侯......