I'd quite like to use ADO.NET to generate a CREATE TABLE script to create an exact copy of a given table. The reason for this is persistence testing. I would like to know whether my application will persist to a particular database. I would like to be able to point the app to the database and table in question, and then the app will gen...
Adding constraints in sql server comes under which category DML or DDL? ...
I'm trying to support multiple databases for an app that I'm writing. The app mostly uses Hibernate, but it's incredibly inefficient to iterate over millions of rows and process them individually when a DML statement can process them in a fraction of the time. Therefore, for certain operations, I need to work out the SQL. I'm more of ...
Is there any way that we can do DML operation with out logging it into log file? For example, when I am inserting a row in database, this operation will be logged in log file irrespective of using transaction or not. But I don't want to log this operation in the log file. ...