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...
