Description:
Microsoft's SQL Server and related products.
|
|
|
Updating a column in a table from a temp table
|
| |
How do I update a new column in a table with data from a temp table Table with added field errormsg Table1 Name char(50) clientkey varchar(50) ErrorMsg varchar(50) Temp table Clientkey varchar(50) ErroMsg varchar(50) Right now in table1 the ErrorMsg field is null for every Name.
|
|
|
PRG-Group Hotlist
|
| |
Hi, This is Deepthi from PRG Group Inc, based in Piscataway, NJ PRG Group Inc, provide Consulting Services, Professional Services and Managed Services all over. We provide candidates for contract opportunities and contract to hire, all these are PRG W2 employees available with best market rate, open... more »
|
|
|
How to Find Extended Characters in Text
|
| |
Hi, I need to find records where a text (and/or varchar) field contains extended characters. If I knew particular extended characters, I could do something like this: select * from TableName where charindex('—',vchitem)<>0 or charindex ('°',vchitem)<>0 But I do not know what extended characters might be in the field, so I... more »
|
|
|
create table
|
| |
I am trying to create new table.APPUSER_ID has AppUserPerm_AppUser_fk and there is NONCLUSTERED INDEX .What is the correct syntax to put these two together? CREATE TABLE [dbo].[APPUSER_PERM] ( [ID] [int] NOT NULL CONSTRAINT [IX_PK_APPUSER_PERM_ID] PRIMARY KEY CLUSTERED, [APPUSER_ID] [int] NULL CONSTRAINT [AppUserPerm_AppUser_fk] FOREIGN... more »
|
|
|
Pivoting a table
|
| |
I'm back again and need help pivoting a table using weeks. This is what I have thus far: SELECT * FROM (SELECT doc, totovrSDW, totpndSDW, totovr, totpnd, weekdat FROM PendingdiarySDW) AS D PIVOT (SUM (totovr) FOR weekdat IN ([08/14/2009], [08/21/2009], [08/28/2009])) AS... more »
|
|
|
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edition
|
| |
Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008. The client db also receives some new data from server and needs to update itself. The question is HOW.... more »
|
|
|
Free Tools for SQL Server - SQLsoft.co.uk
|
| |
Hi All, We've written a number of (I think!) handy tools over the past few months which are available from here: [link] Newly released is SQLscripta, which both searches _and_ scripts sprocs, functions, views and triggers, with searches being performed across multiple databases - it's quick and makes a great alternative... more »
|
|
|
EXEC'ing on SQL Server 2008 from 2000
|
| |
Hi, I'm in the process of moving our database from SQL Server 2000 to a new server running SQL Server 2008. During the transition, I need to EXEC SQL commands on the new server from the old one. On my WinXP workstation, I can run this command without a hitch: isql -E -S NEWSERVER -d SANITIZED -Q "EXEC importation_FI"... more »
|
|
|
How to determine free time
|
| |
I have a table having classes start time and duration. So for example Create Table MyClasses ( ClassName nvarchar(15), StartTime nvarchar(5), Duration int ); Insert into MyClasses values ('Physics', '09:00', 40 ); Insert into MyClasses values ('Math', '11:30', 50 ); Insert into MyClasses values ('Chemistry', '13:30', 60 );... more »
|
|
|
|
