Skip to main content
23 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
32 views

I'm able to to see the output of the count() on a DB collection like below: docker exec -ti STG-mongo-rs mongo --port 27065 --authenticationDatabase '$external' --authenticationMechanism PLAIN -u ...
Ashar's user avatar
  • 3,195
0 votes
0 answers
102 views

I want to get a script from my database, but it gives the following error: System.NullReferenceException: 'Object reference not set to an instance of an object.' Microsoft.SqlServer.Management.Smo....
Mohamad Hasan Salmaaniyaan's user avatar
  • 200
2 votes
1 answer
2k views

My SQL CLR procedure depends on log4net, it depends on System.Web.dll. When I upload this System.Web.dll : create assembly [System.Web] from 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.Web....
ZedZip's user avatar
  • 6,592
0 votes
1 answer
242 views

I installed the freeware version of TOAD for Mysql and tried using it to run and execute a stored procedure in debug mode (procedure tab then right-click on the SP then choose 'Debug'). I placed a ...
andrew tan's user avatar
  • 13
0 votes
0 answers
30 views

I'm using the below to backup a db from a SQL job. Can someone tell me how to add the current date to the output filename? Preferably in YYYYMMDD format.
Waqar Baryar's user avatar
  • 1
1 vote
1 answer
545 views

I need to create an hourly .SQB backup file of some specific tables, each filtered with a WHERE clause, from a SQL Server database. As an example, I need this data: SELECT * FROM table1 WHERE pk_id ...
Eliezer's user avatar
  • 449
0 votes
1 answer
293 views

I'm trying to represent inheritance (I know) in creating a database. I have it figured out, but I'm not sure if I need to represent the PK that my tables inherit when creating tables. I have a ...
Dub's user avatar
  • 27
0 votes
2 answers
614 views

I am looping through an array and performing an insert/update. In the loop, I check if record exists. If not, perform insert. If it does, then perform update. STRING_SPLIT_FNC is a package that ...
saz's user avatar
  • 301
0 votes
1 answer
241 views

We have a long running project and we have continuous database scripts included in the project. Currently we use a manual way to run those scripts which I think does not work in a long run and the ...
Karthik G's user avatar
  • 1,282
0 votes
1 answer
184 views

We have a project that contains multiple EntityFramework contexts, each with migrations enabled. Now when we create a full migration script using Update-Database -SourceMigration $initialDatabase -...
Robba's user avatar
  • 8,464
6 votes
2 answers
40k views

I have a table in oracle: CREATE TABLE transaction ( id INT NOT NULL, accountnumber VARCHAR NOT NULL, stmtvaluedate DATE NOT NULL, ... ) And I want to partition this table by the ...
victorio's user avatar
  • 6,746
0 votes
1 answer
1k views

i am new to run SQL Scripts using sqlcmd in C#. i saw some code in Internet but i am not understanding how it Works. string path = string.Empty; OpenFileDialog opd = new OpenFileDialog(); ...
Anjali's user avatar
  • 1,738
1 vote
2 answers
345 views

I am using Google UI Apps and ScriptDB, and I have a map object similar to this: myMapObject = {record_id: projectA, apple : 316, orange : 956, banana : ...
user2943227's user avatar
  • 73
0 votes
1 answer
440 views

Is it possible to read a .sqlite script with row insertions and updates in iOS? Or if you want to read sql statements from a file, you can only read the file line by line as if it were a regular text ...
AppsDev's user avatar
  • 12.5k
0 votes
0 answers
443 views

In my sqlserver 2008 R2 I have a database script which generate successfully, but when I am trying to execute that script its only shows Executing query message and nothing happen. I had waited at-...
Sagar Upadhyay's user avatar
  • 819
1 vote
1 answer
927 views

I'm wondering if there is a tool that will let me check if a oracle script will run fine on another database (if my script from DEV db will run ok on QA db). I don't want to run/execute anything there ...
ardal's user avatar
  • 1,657
4 votes
1 answer
7k views

Can anybody tell me that how to get DB backup script from Remote Server in MySQL using command-line utility? I'm using a command as follows, but not working: C:\>mysqldump -h <server ip> -u ...
Unknown Coder's user avatar
  • 1,750
46 votes
4 answers
97k views

If I have a table with data in a database in SQL Server, how can I generate a script that will create the table and add the data too? If I right click on the table then select Script Table As > ...
General_9's user avatar
  • 2,329
26 votes
2 answers
46k views

I've generated a script of a database in SQL Server 2008. The generated script has the hardcoded path of where the database would be created. I don't want this path to be hardcoded, I want this path ...
Uzair Farooq's user avatar
  • 927
1 vote
1 answer
1k views

I am trying to automate ui tests on my Silverlight App. I need to setup and clear my Oracle Database when I run the tests. I've created a script: "setup.sql" where I define the the query that I want ...
user1051434's user avatar
  • 167
3 votes
2 answers
3k views

I usually create a solution folder in Visual Studio and put my DB scripts in them. I always use at least this set of scripts: Drop model Create model script User functions Stored procedures Static ...
Robert Koritnik's user avatar
  • 105k
1 vote
1 answer
316 views

I have problem when trying generate script insert with specific condition. So far I am already trying this step. Add references Microsoft.SqlServer.ConnectionInfo and Microsoft.SqlServer.Smo Add ...
Edy Cu's user avatar
  • 3,352
1 vote
1 answer
2k views

I don't know much about SQL but this is what I want: Visually design an SQL database schema in Visual Studio Let VS generate a create script for this database Track modifications to my schema and ...
Andreas Zita's user avatar
  • 7,640