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...
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 Experts,
How can we convert a variable @presentdate to varchar?
Declare @presentday as datetime
select @PresentDay = convert( datetime, convert( varchar(10), getdate(), 101 ))
selec...
How do I list all the tables in a database?
I'd like to cycle through all the tables in a database and push the contents into an ado.net dataset for export to an XML file.
This would be fo...
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. ...
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...
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...
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...
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...
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...
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...
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
I am attempting to create a stored procedure that, in part, places into a temp table the results from another stored procedure. Ideally I'd do something like:
Insert into #Temp
EXEC MyDatab...
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,
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,...
I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.
I have access from my LAN to my DMZ open.
I have the SQL Server configured to allow remote connec...
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
How do you escape an american apostrophe (') to be input into a text field in MS SQL Server 2000
I don't have a choice but to use an actual apostrophe because this is for a language ...
Hi All,
I am taking a chance on this.I am using SQL Server 2005 with t-sql syntax.
Now this is a bit of a guess that this would work as the other ways didnt:
I have 2 databases.
I am ...
Hi
i have a set of datetimes records stored in a sql server database. i need to determine if any of these entries occured on the current day.
i have used both
select * from daily_inve...
Hi Experrts,
I am having an issue with the correct syntax of the nested if then else in a stored procedure. I get a syntax error or access violation :code 0. please help!
CREATE PROCE...
Hello, I'm a relative newbie to this since the SQL database person at my work is out for an extended period of time. Recently, on of the applications we use stopped working and returned the er...
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...
I have a table with the following columns
ACCOUNTID CATEGORYID
1001 10
1002 10
1003 10
1004 10
..... ...
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...
