I have 3 tables int sqlserver. I'm trying to do this query:
update personinfo set sme = 0 where exists
(select * from personinfo,grpname,grpassociation
where personinfo.personid = grpassoc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10566861.html
In sqlsever, how to write a triger, which will run a query at a given data and time(say 12:00am every day).
This triger(or the query) should be able to create a new table in the DB.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11660338.html
What is the best way to generate SQL Scripts for a database. What I want to do is point to an existing Oracle or SQLServer DB and be able to generate a SQL scripts to include table, index, etc. D...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20290655.html
In my application iam looking for a better solution for storing images,Documents and Excel sheets , The size of the image may vary between 1MB to 5MB. There will be huge amount of records as well.....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20385646.html
I have just installed SQLServer 2000 (Personal edition) and the work
of Enterprise manager is very slow. It takes a lot of time to perform
a simple tasks. For example, openning Security tag in th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20598401.html
Hi,
I need to retrive a SQL Database structure (tables, stores and views) [ do not need data only structure ].
We can't connect this SQL throught Enterprise Manager or Query because Firewall rest...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20791727.html
Zones:
DatabasesDate Answered: 03/23/2004 Grade: A Views: 0
Sir,
I want to know any api, or other function is there to search my whole network to get how many sql servers are installed in my network, and what are they ??
Please give me some code to get ...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21146912.htm...
Hi,
what would be the best way to do it?
I tried MySQL provided tool with no luck, then DBTools with various option, what worked best was setting SQLServer as ORBC datasource, then importing ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21586831.html
Zones:
DatabasesDate Answered: 10/07/2005 Grade: A Views: 0
there is a database in sql server and MSAccess application is used as the front end.
most of user have MSAccess and rights to connect to the sql database
I would like to know how to setup permi...
http://www.experts-exchange.com/Programming/Misc/Q_21690373.html
Zones:
ProgrammingDate Answered: 01/11/2006 Grade: B Views: 0
Greetings,
I'm using this command:
SqlDataAdapter.Fill(dataSet, "Orders");
to fill a DataSet, but am not sure how to populate it with the Tables and Rows which have a relational connection...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21744740.html
Zones:
C#Date Answered: 02/21/2006 Grade: A Views: 0
