Stack Overflow
Stack Overflow

Questions tagged [sql-manager]

22 questions
0
votes
1 answer

SQL Server Management Studio Save a PNG to a Field

I have a database that I'm accessing via SQL Management Studio 2014 (SMS2014). There is a field Signature on my table User that its a varbinary(max) type. I have a folder of PNG images that I'd like to manually add to each record in the User table…
Barry Michael Doyle
  • 9,333
  • 30
  • 83
  • 143
0
votes
3 answers

sqoop to import data to hive

i am trying to import data to hive table using sqoop2. I am using --hive-import but it is not working Code: sqoop import --connect jdbc:sqlserver://192.168.x.xxx:11xx --username user --password user --table xxxx.NOTIFICATION…
animal
  • 994
  • 3
  • 13
  • 35
0
votes
1 answer

Dynamic SQL Error with REPLACE Statement

I am trying to create a script that builds a SQL statement dynamically and then executes it. Here is the string that is built & stored in @strSQL (verified by using PRINT) UPDATE DNN_RSM_Exams SET ScoringDates = REPLACE(ScoringDates, '/2015',…
TekkGuy
  • 107
  • 2
  • 15
0
votes
0 answers

Negative TIME values in MySQL

I was using MySQL with phpMyAdmin to manage a small database and system that my company was using to store the time a employee starts and finishes his shift. If say employee works 8 hours a day but starts at "08:00" and finishes at "15:00", for…
Carlos Yasuda
  • 121
  • 12
0
votes
1 answer

SQL Manager for MySQL - select inserts empty row

I have a very weird situation here. During development I discovered that one of my tables got more and more empty rows (the Id field is auto-incremented and was set). No insert statement was run from my code. I use SQL Manager 2010 Lite for MySQL to…
erikric
  • 4,049
  • 8
  • 32
  • 44
0
votes
1 answer

How to use my created SQLite DB in SQLite Manager apps in my Android program

As I'm working with many tables in my Android application, I decide to create database(DB) in SQLite managers (such as firefox plugin or navicat for sqlite). I finished creating them and export the .sql file ! but I don't know how to use this file!…
Hamed MP
  • 5,443
  • 3
  • 39
  • 37
0
votes
2 answers

Know how many table is modified on particular date in database in SQL Server 2005

I have a database with 40 tables in it. So I want to find tables which are modified on the particular date like How many tables were modified on 20 Aug 2011 in my database? UPDATE please note that I need the table name and not the record id like…
Gautam Arya
  • 723
  • 14
  • 40
1
2