|
Hi there,
If I use SQL Server Migration Assistant for Access to convert my Access database to SQL Server Database, it adds constraints to each string type data column in my SQL database. Why is that? I've checked the string values in my Access database, and they do allow Zero Lenth values. If I add that Access database to my SQL Server Migration Assistant for Access project, and I select a Table to see the design of it, the Allow Zero Lenth flag is false. I want those characterlistics to be the same as in the Access Database. Is there a way to do that?
Thanks,
Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
I have written a SQL procedure to send mail using CDONTS. Now I want to specify Smart Host name in the procedure itself instead of specifying it in the IIS(Default SMTP Server). How I can do that.
thanks in advance
|
|
|
|
|
hello frnds,
I have a problem
i have 3 tables updating one by another if any of the update query get failed the whole transaction should be rollback and if the update query get successful then the transaction should be get commit,
i have called three methods for three table and if exception occour then in last method transaction object as rollback but failed...
plzz help me....
thankx in advance
-Koolprasad2006
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
begin transaction
update statement1.......
if(@@error<>0)
begin
rollback transaction
end
update statement2.......
if(@@error<>0)
begin
rollback transaction
end
update transaction3......
if(@@error<>0)
begin
rollback transaction
end
commit transaction
end
Try this out, hope this works if not will look for other options.
Gautham
|
|
|
|
|
Hi All,
I have one connection string which can be of MySql, Sql Server , Orable , access or anything.
i have create OdbcConnection object from connection string. now i want to know which DBMS i am using... any idea how to ? 
- thanks & ragards
- Sanket
|
|
|
|
|
You can always retrieve the connection string from the connection object.
|
|
|
|
|
but that is not giving me what i want.
e.g. oracle will give me DBQ=ORCL which can be configured as well.
|
|
|
|
|
hi
i am converting stored procedures in sql server 2005 to oracle 8i.
In one of the procedure they are using an insert statement which calls another stored procedure..
how can i convert this to oracle 8i..
eg;
insert into table1
exec test_procedure
|
|
|
|
|
I have a feeling that you cannot execute Stored Procedure in DML statements though functions can be used.
Am i wrong?
Gautham
|
|
|
|
|
Possibly return a cursor in the stored procedure, then iterate over that cursor to insert each record.
You may get more joy from a more Oracle-specific forum.
|
|
|
|
|
Hi
i m using javascript to open a popup window and want to paa one value from parent window to popup window. i need to use that value in my javascript function but i m not getting the point to retrieve the query string value using javascript.....
can anyone help
Thanks
Dinesh Sharma
|
|
|
|
|
|
hey Dinesh,it's easy
use the window.open() method and pass the desired value as a parameter the wll be get inherited on pop-up window
Best Luck
-koolprasad2006
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
I have the following stored procedure that works except that the "print" does display on the page when the "IF" condition is met...it shows up as a message when run from Query analyzer but not when the stored procedure is called.
Can anyone tell me what is wrong with my print? I have tried a few things with no success just errors. the solutions I saw in books online did not work for me.
here is the stored procedure:
(
@ticketid as varchar(20)
)
AS
Declare @Technician as varchar (40)
declare @count int
set @count=(Select count(*) from job_ticket WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20))
and status_type_id like '[1-2]')
if @count =0 print 'there are no open tickets'
set @Technician=(SELECT email
FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assigned_tech_id WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20)))
SELECT job_ticket.job_ticket_id, job_ticket.question_text 'Report', 'Ticket Number', @Technician
'Technician Assigned',job_ticket.subject 'Issue Description',
report_date 'Open Date'
FROM job_ticket WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20)) and status_type_id like '[1-2]'
-- modified at 20:56 Thursday 17th May, 2007
Regards,
Hulicat
|
|
|
|
|
How are you running your stored procedure?
Under ADO, a print statement does not create a resultset. Instead it adds an item to the Connection.Errors array.
Normally I would do the zero-records check back on the front-end (because the resultset is empty).
Also, most people add "SET NOCOUNT ON" to the top of their SQL-Server stored procedures.
|
|
|
|
|
Thanks for the tips, they are greatly appreciated.
Regards,
Hulicat
|
|
|
|
|
I want to create a stored procedure where I can select with a 'where in ' and a list of integers against the integer-typed primary key.
For example:
PR_GetSomething @ID='0,1'
Only that doesn't work since it is a varchar. Here is the ad-hoc query for what I want to do in an SP:
select * from Something where ID IN (0,1)
Thanks for any help....
|
|
|
|
|
When you are forming the string of ids itself try to include '' in that string.
"0,1" -> "'0', '1',...."
Gautham
|
|
|
|
|
Thanks for the response but that didn't work for me. I think it is becasuse theId param in my SP is a varchar? I dunno, maybe I should use a different datatype in that param?
I get this:
Conversion failed when converting the varchar value ''0','1'' to data type int.
|
|
|
|
|
Ah well...I'll just make two seperate SP's. One for a specific ID and the other for all of 'em.
|
|
|
|
|
Hi Everyone:
I have solved the problem of how to bind a DataSet to the BindingNavigator control thanks to those who guided me in the right direction.
I now have another problem that is causing me ulcers.
When I populate the DataSet with data I retrieved from some table. I have no trouble using the move next, move previous, move first and move last buttons on the BindingNavigator control. I can navigate from record to record with no problem.
When I try to add a new record into the dataset using the routine written below; two problems occur. 1 – The auto increment ID number goes from 5(the last record ID in the Dataset) to 7. What happened to 6? 2 – After I add the new record’s data; when I page back through the dataset’s records the new record I just added has the record ID of 7. When I move to the previous record 6 (the one that was skipped) I see the data for the first record in the dataset. Records 5 to 2 seem to be correct, but record 1 is empty.
Logic dictates when I add a new record to the dataset it is added at the end of the dataset. This doesn’t seem to be happening. What I plan on doing is after I update the Dataset I will use the DataAdapter to write the changes back to the SQL Sever database, but the dataset looks incorrect, so I won’t commit an update until I’m sure the dataset’s information is correct.
A corollary to this problem is when I try to add records to an empty dataset. I get the DBNull error.
Does anyone know how to add a new record to: 1) an existing dataset, or 2) an empty one?
Thanks,
Quecumber256
|
|
|
|
|
Private Sub New_Bindings(ByVal intOrdinal As Integer, _
ByVal strCode As String, _
ByVal strName As String)
Dim tblBindings As DataTable
tblBindings = MyDataSet.Tables("tblBindings")
Dim drCurrent As DataRow
drCurrent = tblBindings.NewRow
drCurrent("Ordinal") = intOrdinal
drCurrent("BindingCode") = strCode
drCurrent("BindingName") = strName
tblBindings.Rows.Add(drCurrent)
Call Clear_Form()
End Sub
Sorry,
Quecumber256
|
|
|
|
|
Instead of replying to your own post, use the modify option and do changes to your message if required!
Gautham
|
|
|
|
|
FYI - The code I added in the second post was the code I intended to place in the first post.
Obviously this board was the wrong place to ask my question. I'll repost it correctly on the VB.NET board.
Thank you,
Quecumber256
|
|
|
|
|
this is the script.
first table:
CREATE TABLE [ImePoste] (
[PostaId] [int] NULL ,
[imePoste] [varchar] (50) NULL
) ON [PRIMARY]
second table:
CREATE TABLE [Posta] (
[PostaId] [int] NULL ,
[Posta] [varchar] (25) ,
[Znesek] [varchar] (50)
) ON [PRIMARY]
GO
and view
CREATE VIEW dbo.View_posta
AS
SELECT dbo.ImePoste.imePoste
FROM dbo.ImePoste INNER JOIN
dbo.Posta ON dbo.ImePoste.PostaId = dbo.Posta.PostaId
How can i convert dbo.ImePoste.imePoste to int?
please help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
