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
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
0 answers
29 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
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
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
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
1 vote
2 answers
342 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
0 answers
441 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
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
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
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
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