I tried this query for last 2 days but couldn't transfer. Now I have given it up. Please tell me can I transfer database from SQL...
DTS services are not included in SQL Server Express. So please let me know how to transfer data from excel sheet to SQL Server Express.
I will remember this.
I am using SQL Server Express evaluation version. And I want to tranfer database file from an EXCEL sheet to SQL Server Express.
I couldn't find...
Thanking you for your reply. I am executing query like this
INSERT INTO city (cityName)
I am just running this query
INSERT INTO city (cityName) // Where cityName is the name of the column in the city table//...
SQL EXpress server supports Ad-Hoc Queries. Pplease go to configuration manager and put the server instance then enable AD-Hoc Queries....
Thanking you, SQL Express is running AD-Hoc Queries. I also have one more novice question. In the query you provided, where to put the...
Thank you for your advice. I also have some problem. Actually I am unable to run AD-Hoc query (OPENROWSET) on my MSSQL Express...
Does anybody knows how to allow AD-Hoc queries in MSSQL server express edition evaluation version.
I am trying to run query
INSERT INTO city...
Thanking you for providing your suggestions. But I am sorry to say that I am unable to find to run any method for Ad-Hoc queries. I...
I just tried by the way you suggested. But I am sorry to say that it is showing an error that AD-Hoc Qyery should be on.
I tried to...
Hi Guys,<br />Only the selected cities I am cosidering...<img src='/community/emoticons/emotion-1.gif' alt=':)' />)<br /><br />Anshu
Yes, I am trying, I will just let you know in couple of moments.
I am sorry to say, I couldnot find DTS wizard in SQL Server Express edition. Also I couldn't find DTS Wizard in Visual Studio 2005 evaluation...
Thanking you very much. I apologise for asking this question in the wrong forum.
I am preparing a database in MSSQL for all cities list of the world. I have a list of all cities in MS-Excel file.
is there any way to enter...
I am using Visual Studio 2005. I create a list box on a webpage. and when I try to run it the content of list boxes opening on the upper side...
Thanking you very much. I gotta clue... and now ready to get it run.
When I was installing the MSSQL SERVER Express Edition then I gave dafault server instance. I also checked with computer managemnet services and...
Separate names with a comma.