|
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
|
|
|
|
|
Regarding #2
Although you don't have to call Close() it is advisable. While the DataReader is open you are tying up the connection so it cannot be used until the reader has been collected by the garbage collector. You don't have any control over when the garbage collector will collect the reader.
Another option is to wrap it in a using statment and have C# close it when it drops out of scope
using(SqlDataReader dr = cmd.ExecuteReader())
{
while(dr.Read())
{
}
}
|
|
|
|