What do you think about Windows 7? Write a review or a how-to about Microsoft's newest product and earn unlimited points!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested MS SQL Server Solutions: 1 - 25 of 10013
 
I have a somewhat complex select, which is supposed to return appointments that need notified bewteen today and the appointment date. Sounds simple, but, the appointments have a notification d...
Hello, In SQL-Server, I'm trying to find the equivalent of the following SQL statement:       "CREATE TABLE employees AS SELECT * FROM all_emp" I know you can do this with to create a...
Hi Experts, How can we convert a variable @presentdate to varchar? Declare @presentday as datetime select @PresentDay = convert( datetime, convert( varchar(10), getdate(), 101 )) selec...
i have a table with students details in it, i want to select all the students who joined a class on a particular day and then i need another query to select all students who joined classes ove...
Hi, Anytime I start the PC the following message appears: "SQLWriter SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall t...
Hi. I have a large number of databases on my MS SQL server. There are files .MDF and .LDF files. From what I can tell (and I may well be VERY wrong here), the MDF file is the REAL data. ...
Ive lost my MS SQL Server disk and I need to use Enterprise Manager and other tools.  Can you download these tools?  I cant find anything on the MS site...
Can someone give me the syntax to add a default value to a column? Somehow it doesn't want this ALTER TABLE BOM ALTER COLUMN MFD  DEFAULT 0 ) table is BOM, column is MFD (bit field) a...
Here is my statement: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = SIM20050214) DROP TABLE SIM20050214 Here is the error: Server: Msg 207, Level 16, State...
Hi, Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated. This error happen when I tried to insert a value too long i...
I have a table with the following columns ACCOUNTID     CATEGORYID 1001                10   1002                10 1003                10 1004                10 .....              ...
Where can I find an entire list of the trappable SQL error codes?  Is there a web site that contains a list of the error codes.
In SQL we can do the following insert into Test(va1, va2, va3) select va1, va2, va3 from Other where ...... How do I do the same thing like above but in format of update-select ?
I have read every possible article but cannot setup a new instance of SQL Server 2005 I have XP SP2 SQL Server 2005 Enterprise Edition and i dont know how. Please help
Hello all, Thank you for viewing this query. My query is as follows: I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd s...
When I run an online report sometimes I get the following error pointing to my ASP page How can I stop this from happening....This happens when the user requests lots of data. Is there any w...
ALTER TABLE dbo.TCONTACT_TEST ADD       LVL_SYS_NR INT AFTER  ACC_NR_TE,       CNT_FAX_NR_TE VARCHAR(15)AFTER CNT_PHN_EXT_TE ----This brings up an error on the word AFTER
I have table with some columns and want to copy it's strcture in a new table inorder to add some more columns to that table in sqlserver. how do i copy it structure to the other table. creat...
I have a Windows SBS 2003 Server, Service Pack 2, 2gb ram and 200gb disk. I have installed MS SQL Server 2000 with its latest Service Pack 4 and left in tact its standard "MSSQL Desktop Eng...
I need to update a field of a table that is itself used in the query to determine what to update.  The only error I get out of SQL is a general syntax error. UPDATE tblInvoice_Master SET tb...
hi experts. i am using mssql 2000 i have 2 databases, named : db1 and db1, i need to copy some of the tables in db1 to db2 with their indexes, foreign keys, etc. I used : SEL...
I have an Excel Source component hooked to an OLE DB Destination component in my SSIS 2005 Data Flow Task.  After I mapped the excel columns to the OLE DB table columns i get these errors belo...
I am trying to write a new stored proc based off an exisiting one that counted the number of ads placed and inserted the data into a table. But now I want to break it down by class, so I am wo...
Hi, We are developing a report in MS-Word through VB application.  Our database is SQL Server 2000. We are getting the following error while generating the report:-Error Number -2147467259,...
Hi, Experts:     Does SQL Server 2000 has any function or extended storeprocedures that has the same functionality as Split() function in VBScript or Javascript?  I try to split the followi...