|
Mr. divyesh1432
if my answer correct plz tell me
thanks
Rami Abd Alhalim
|
|
|
|
|
|
in my application i use ado.net to connect the db and in ado.net when you connect the db it takes an instance of the relevant table and close the connection . but when the application runs it needs to access the db often and in order to do this do i have to connect the db each and every time the db is needed or keep the connection without closing . but the second option affects on concurrecy.
can you guys do some suggestions to this .
thank you ...
|
|
|
|
|
Hi,
I am createing a report in First.aspx page it may look like this with a report in table format using sql server rs
ID Name Salary
1 xxxx 10000
2 yyyy 20000
3 zzzz 30000
I want The ID Column as Link Column(i.e, values of ID 1,2,3 must reposnd to click events)
I did this By using Navigation Property of that feild, But It is asking another report To jump
In which event I have To right my Code-Behind
|
|
|
|
|
Is it possible to define a parameter for a stored procedure that is both an input and output value, in MS SQL Server 2005?
If so, how?
regards
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Yes you can used that.
(
@In_Out int out, --this parameter it can set and get data
@In int --this parameter it can set data just
)
Rami Abd Alhalim
|
|
|
|
|
Simple when you know how.
Thanks
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
hi,
I'm having a fixed length file hvaing rows of data and some/all of the records can be grouped together using a rowid.
for ex:
xx1|uiy2jof7giu4|0012000|2007-06-29|AAX
xx3|uiy1jofh3iud|0012000|2007-06-29|AAX
xx4|uiygjofhgiud|0020100|2007-06-29|CUY
xx1|uiyg3vb4giud|0212000|2007-06-30|1HU
xx1|uiygjofhgiud|0002000|2007-06-21|ZXX
xx4|ui2ygj7fhgi9|0052000|2007-07-29|559
Is it possible to read the file into sql as xmldata type and sum a particular value in the row with same id and send to the front end.
Can any one help ?
Thanks and Rgds,
PLS
|
|
|
|
|
I am no expert, but I believe you will need to look at DTS (Data Transformation Services)
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
you want read XML file and saving on SQL server ??
|
|
|
|
|
no the source file is a fixed length text file. the data should be read into sql server as xml datatype and sorted and a particular numeric field should be added there and returned to a dataset.
|
|
|
|
|
There are better methods for diong this, but maybe this will help some.
***********************
declare @cmd varchar(300), @file varchar(255)
set @file = 'C:\temp.txt'
set @cmd = 'type ' + @file
create table #temp (f_All varchar(255))
create table #temp2 (f1 varchar(10), f2 varchar(50), f3 varchar(10), f4 datetime, f5 varchar (10) )
insert into #temp
EXEC master..xp_cmdshell @cmd
insert into #temp2
select
substring(f_all, 1, 3),
substring(f_all, 5, 12),
substring(f_all, 18, 7),
substring(f_all, 26, 10),
substring(f_all, 37, 3)
from #temp
where f_all is not null
select * from #temp2
-- GROUP, SORT, SUMMARIZE, AND USE IT HOWEVER YOU NEED IT.
drop table #temp
drop table #temp2
**********************
Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia
|
|
|
|
|
I am using auto increment for the primary key in a table. For example,
table - (userID, UserName). Now the auto increment of last userId = 10.
If I would like to insert a userId = 111, I found that the next auto increment userId must be in 112, but it is not 11.
Is there any setting to change back the UserId to 11?
Thanks!
|
|
|
|
|
hi mimimimilaw
you must go to design table ,Set Identity Seed = 10 for column auto increment
|
|
|
|
|
It maybe 10, 20, 45 or any number. How can I using mssql statement to do this?
|
|
|
|
|
Hi mimimimilaw
You can use this statment
CHECKIDENT ('tablename',RESEED,10)
best Regard
Rami Abd Alhalim
|
|
|
|
|
Hi,
Try this
DBCC CHECKIDENT ('tablename',RESEED,110)
If u execute the above statement then the next number will be 111.
But you cannot set it back to 10, because already 111 exists which is greater than 10.
May I know the situation why you need the userid to be 111?
Senthil
|
|
|
|
|
If you need anything i am ready
RAmi
|
|
|
|
|
Thanks All,
I try to do what I want in other methods.;)
|
|
|
|
|
I got this error and I don;t know how to solve it even thought my parameters are matching.
'DHS_CostCenter' table saved successfully
'DHS_Employee' table
- Unable to create relationship 'FK_DHS_Employee_DHS_CostCenter'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_DHS_Employee_DHS_CostCenter". The conflict occurred in database "DHS2", table "dbo.DHS_CostCenter", column 'CostCenterID'.
User canceled out of save dialog
(MS Visual Database Tools).
Thanks for your help.
|
|
|
|
|
Check datatypes fields in relations tables
I Love SQL
|
|
|
|
|
Thank you for your answer.
However, I am sure I am right unless I don't understand what do you mean.
This is what I have:
I have a table called DHS_CostCenter that has these columns:
1- CostCenterID (Primary Key) int Not Null.
2- CostCenterName varchar(70) Not Null.
The other table called DHS_Employee that has these columns:
1- BadgeNum int Not Null.
2- Name varchar(50) Not Null.
3-CostCenterID int Not Null.
4- DateFrom smalldatetime Not Null.
5- DateTo smalldatetime Not Null.
I made a relationship between them (the primary key is CostCenterID that is in DHS_table and the Foreign Key is in DHS_Employee).
After that when I want to save it, I got this error.
I am looking for an answer.
|
|
|
|
|
Hi CanadianBoy:
When you made a relationship between them (the primary key is CostCenterID that is in DHS_table and the Foreign Key is in DHS_Employee).
You must compare between data PK and FK
i think found data in FK not Found in PK
Example :
Table DHS_CostCenter
----------------------------------------------
CostCenterID CostCenterName
1 'Cost1'
----------------------------------------------
2 'Cost2'
----------------------------------------------
4 'Cost4'
----------------------------------------------
Table DHS_Employee
----------------------------------------------
BadgeNum Name CostCenterID DateFrom DateTo
-----------------------------------------------------------
1 'badge1' 1 1/1/2007 2/2/20007
-----------------------------------------------------------
2 'badge1' 3 1/1/2007 2/2/20007(This Record have problem because CostCenterID 3 not found in table DHS_CostCenter)
----------------------------------------------------------
3 'badge1' 4 1/1/2007 2/2/20007
----------------------------------------------
best  regard
Rami Abd Alhalim
|
|
|
|
|
Thanks a lot. That was right. I was looking in each coulmn exept to this coulmn.
Thanks again.
|
|
|
|
|
Hai ALL! My TL used to told me that about to backup our database!
He told me that use business Inteligence Studio(BI) to develop DTS,
But i dont know where it reside? Whether it comes from SQL Server 2005 or .NET 2005!
Please give some information about to backup our database using DTS Concept in SQL Server aslo business Inteligence Studio(BI)! Help me please!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
