|
Hi.
I've created this program[^] some days ago. (I've had WinXP and SQLExpress 2008 then)
It works on XP well , but when I wanna run it on Vista SP1 Ultimate this error[^] occurred.
and there is a link in the error window http://oca.microsoft.com/en/dcp20.asp[^]
What's wrong ?
Could you guide me ?
Thanks
PS : I've installed SQLExpress 2008 on Vista
|
|
|
|
|
I dont know if there are any perl programmers here, but im looking for some testers in my creation of my project. It an flat file style database that uses SQL queries to access data thats stored. If you would like to help drop by. http://ffdperl.sourceforge.net
|
|
|
|
|
How can I check if a column has a constraint on it through SQL code please?
Thanks for your help
|
|
|
|
|
|
Hi Everyone,
I used the below stored procedure to delete a single record in a table in MySql.
Procedure:
DELIMITER $$
DROP PROCEDURE IF EXISTS `healthtour`.`USP_User_DeleteUserRole`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_User_DeleteUserRole`
(
IN UserRoleID INT
)
BEGIN
DELETE FROM HT_UserRole WHERE UserRoleID = UserRoleID;
END$$
DELIMITER ;
Problem:
I run this procedure as below,
CALL USP_User_DeleteUserRole(2);
I have the records in my table for the UserRoleID 10. And i don't have the records for the UserRoleID 2. If I give the input(UserRoleID 2) then the record 10 is deleted. It should not be deleted. Because i gave the input 2 and not 10.
Please can anybody help me?.
Thanks,
-Periyasamy Ramachandiran
|
|
|
|
|
|
Hi,
Yes I found the error that i have used the same name for both table column name and the variable name. Just i changed the variable name. Now it works fine.
Thank u very much.
-Periyasamy Ramachandiran.
|
|
|
|
|
hi,
i can some speak english. so i hope you understand me.
my question;
how to i measuring to database performance? are there tools for database performance?
best regards.
|
|
|
|
|
Hi,
I am Writing an sql that returns a single record which is row from a table. In the same sql i would like to traverse through the columns of this row. How can I do that? Is it possible to access the columns in SQL through indexing for example like column[1]?
Thanks for your time and help
|
|
|
|
|
You cannot refer to a column by it's ordinal (1) in SQL unless you use dynamic SQL in which case you look up the column name from the schema view and build a string to execute.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
thanks for your reply. I am using Dynamic Sql but the problem is that I don't know the name of the column to fetch for, thats why I was trying to find a way similar to indexing.Is there a way?
|
|
|
|
|
Take a look into the information schema views (under system views in Management Studio) INFORMATION_SCHEMA.COLUMNS is the one you want
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All,
I am new in MySQL Database. Can anybody give sample stored procedure for Insert Query with "Exception handling".
Please...
Thanks,
Easton.
|
|
|
|
|
You do know that there is a MySQL forum, right?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hi everybody
i have two tables
table1 with column name
SubmissionDate nvarchar(11)
table2 with column name
submissiondate2 (datetime)
and i insert data in table1 like 17/05/2009 but still in nvarchar format
cos this is my requirement (i mean nvarchar)
my question is i want to insert same date from table1's column to table2's column but dont know how to convert datatype nvarchar to datetime.
when i try to cast i got this error msg
Arithmetic overflow error converting expression to data type datetime.
any help would be really appricated
|
|
|
|
|
|
insert into table2
select cast(submissiondate2 as datetime) from table1
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
This is a fundamental error that a lot of newbies make - storing dates as strings. Your dates are stored in a format other than yyyy-mm-dd, probably dd/mm/yyyy and SQL cannot decide between the dd and mm structures, therefore the error.
Try using Convert(datetime,datefield,106)
or one of the other formatters. Under convert/cast in BOL.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
thanks holmes for your kind answer
my Problem;
the following code is working perfectly except date. every thing is working perfectly pleas let me know how to add Date into table through following query, and dont worry about other variables these are working perfectly because i have changed them into varchar like this
SELECT @str_Session_Id=CONVERT(nvarchar(10), CONVERT(int, @SessionId))
but i dont want to add date like varchar because i have to compare date with other dates therefore i dont want to convert into varchar.
select @date =(select DATEADD(dd, 1, GETDATE()))
Begin
set @txtSql =
case when (@Std_Count < 3) then 'insert into ProjectRequests values('+ @str_stu_Id+','+ @str_Priority_Id +','+ @str_Project_Id +' , '+ @str_Session_Id +', '+ @date +' , NULL)'
Msg 241, Level 16, State 1, Procedure FUALLY_QUALIFIED_STUDENT_BULK, Line 48
Conversion failed when converting datetime from character string.
any help would be appreciated.
|
|
|
|
|
Do some research into parameterised queries, they will make your life so much easier.
Inserting date using a string var is Ok, you just need to format it correctly, the following are valid formats for SQL Server. The important thing is to STORE it as a datetime data type in the database.
yyyy/mm/dd
dd/MMM/yyyy
mm/dd/yyyy
If you try to use a date in dd/mm/yyyy format it will create the error you are getting. MS is a US company so SQL Server used the stupid freakin US date format internally.
Also you need to add additional ' around your date value.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Having installed SQL Server on the same machine where my application
is running, under connection string I could mention Server and Database as follows
ConnectionString = "Server=ABCD-AC93CE29C0\SQLEXPRESS;Database=MyDatabase"
What if SQL server was on a different machine. How do I give the path of that
external machine on which my SQL Server is running?
|
|
|
|
|
This is a good resource for connection strings[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
In my application, I retained membership provided by aspnetdb
For other requirements in the application, I created a database and tables
in my SQL Server 2005.
My problem is I get an error message "Stored Procedure 'abcd' not found.
I have added Stored Procedure using SQl Server Management Studio for that database.
Where could the sp dissappear???
I canot see the sp in SQL Server Management Studio's object browser either!!!
Where could the sp dissappear???
|
|
|
|
|
SPs dont just desappear
Probably you created the sp in another DB (maybe the aspnet membership)
You are saying you have 2 DBs, make sure you have 2 connection strings as well and are not trying to access both DB with a single conection string
Dont complicate your life, just recreate the sp in the correct DB
Alexei Rodriguez
|
|
|
|
|
Hi Alex,
Actually I Missed the Execute Command after creating a stored procedure.
Thanks,
NetQuestions
modified on Sunday, May 17, 2009 1:37 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
