|
Hey everyone;
I would like to know if sql 2005 express edition will allow me to create web services. what i want to do is write an application that will be able to communicate to a sql database via http. i also addtional help in creating the web service, i'm new to sql 2005 and need all the help i can get.
thanks
I@n
|
|
|
|
|
Yes I believe you can create a web service in SQL Server Express. I think for the msot part Express will most everything the full version will as far as web service - could be wrong though. Check out this article:
http://davidhayden.com/blog/dave/archive/2006/03/31/2897.aspx[^]
You might also check out the code in the Teach Starter Kit[^] for Express version. Looks like there might be some code of use in it.
|
|
|
|
|
Hi
When I view a table withen DataGridView . for eg .. then rows count on the table is 5 rows .. you found at the end of rows on the dataagrid control a balck area with the back color ,,,
Can I make the DatagridView Countinue view it's rows even it is empty ..
I hope that my idea is clear
jooooo
|
|
|
|
|
Hi,
i am getting the following error while i am trying to create a table in the database in sql2005.
Unable to create table.
The transaction ended in the trigger. The batch has been aborted.
p.sethi
p.sethi
|
|
|
|
|
When exactly you are creating this table? In a trigger or something??
Gautham
|
|
|
|
|
i am not creating the table in trigger.i just enter into the database,tables,create new table.like this i am creating but while saving i am getting the error.
Unable to create table.
The transaction ended in the trigger. The batch has been aborted.
p.sethi
|
|
|
|
|
Couldnt exactly understand the cause for the problem!!
Do the formal check i.e:
Check whether you are giving the same tablename!
Any errors in the design/data of your table before saving it!
Gautham
|
|
|
|
|
Post your Syntax here and infact write all the systax here then we will be able to help you
Vuyiswa
|
|
|
|
|
I have three tables in msaccess which are related with each other using forign keys. I want to delete the row of the innertable and second table with a single query
can u help me?
My small attempt...
|
|
|
|
|
|
I need ur help for designing PAYROLL DataBase.
Any Knows Plz Send Me(US PAYROLL)>
sree reddy
|
|
|
|
|
I need ur help for designing PAYROLL DataBase.
Any body Knows Plz Send Me(US PAYROLL)
sree reddy
|
|
|
|
|
sree reddy wrote: I need ur help for designing PAYROLL DataBase
Start with the customer's requirements. What do they require the payroll database to hold? What do they require it to do?
|
|
|
|
|
hi,
Hey...how others can db design upon your requirements .....
regards
jijo jose
|
|
|
|
|
Hi
I am new to SQL ..
Curently I am trying to do database mirroring in SQL Server Management Studio Express..
After i have made a back up and restore it on another computer, there would be a Mirror choice for me to click under the tasks option after right clicking on my database .
But the Mirror choice does not appear there..
What could the problem be ?
Anyone can help me ?
Thanks in advance...
|
|
|
|
|
hi to all
My name is Devkranth .. i need help in sql.... i have 3 tables to retrieve data and display it.. there is no Primary key in any table.. but there is a common column , so if i join the tables i am getting rows duplicated... plz help me..
thanks in advance
|
|
|
|
|
hi,
you can add identity column for these tables and join with this column.
regards
jijo jose
|
|
|
|
|
hi jojo
Thanks 4 ur reply.. i will just try it and come back to u..
|
|
|
|
|
after joining all tables use one of them and put a criteria like this
--where fielname in ( select distinct fieldname from table1)--
this may solve the of duplicacy.
Pradeep Shukla
|
|
|
|
|
thanks Pradeeop
well will try it and get back soon..
|
|
|
|
|
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End
I now want to generate report using through sql server reporting services.
Please give me some useful link so that I can able to use report generated by sql server 2005 through my web application
Thanks
regards
imran khan
|
|
|
|
|
1. If there are duplicate rows in a table how do you retrieve them. We can use select distinct(fieldname) but not in this way. Is there any other way.
2. After reading the reading like,
while(dr.read())
{}
can we close the reader automatically without calling dr.close().
yamini
|
|
|
|
|
1. listing only duplicate row data is possible. need table structure and sample data.
2. to my knowledge gargabe collector should do.
Regards
KP
|
|
|
|
|
suppose there are five similar records like same name, id, dept then without writing a query in sqlserver how are the duplicates removed means only a single record should be retrieved.
thanx,
yamini
|
|
|
|
|
i regret,
i'm, not getting your query. can you explain in detail
Regards
KP
|
|
|
|