SQL Server is a relational database management system from Microsoft. Use this tag for all SQL Server editions including Compact, Express, Azure, FastTrack and PDW.
1
vote
0answers
9 views
How do I use Sqoop for importing data from a relational DB to sandbox Hive?
How do I use Sqoop for importing data from a relational DB to Hive in Sandbox. I have Installed Horton Works sandbox in MY PC. Nw i want to know this migration.I have referd this link ...
0
votes
2answers
22 views
Get number of lines for specific varchar in MS SQL
In MS SQL Server 2012 I have a database with a table containing a varchar column that holds some text that might even include line breaks.
Basic example:
CREATE TABLE Example
(`ID` int, `Text` ...
0
votes
0answers
10 views
Unable to create Audit in SQL Server 2008
Whenever I try to create new Audit in SQL Sever I get the following error:
Unable to cast COM object of type 'System.__ComObject' to interface type ...
1
vote
4answers
24 views
Subqueries are not allowed in this context. Only scalar expressions are allowed
My stored procedure is working fine in SQL Server 2008 but when i try to run the same procedure in SQL server 2005 it throws this error stating
Subqueries are not allowed in this context. Only ...
1
vote
5answers
33 views
Keep a shadow copy of a table while retaining records removed from the original
This is probably laughably easy for an SQL expert, but SQL (although I can use it) is not really my thing.
I've got a table in a DB. (Let's call it COMPUTERS)
About 10.000 rows. 25 columns. 1 unique ...
0
votes
2answers
35 views
Copying table from one SQL Server to another
I'm trying to create a copy of a table (no data, just the schema) using SQL Server Management Objects (SMO), Transfer class. The only thing I haven't figured out is how to specify what server to copy ...
0
votes
2answers
27 views
Timestamp accuracy - gained milliseconds
If I store a System.DateTime as a timestamp in SQL using this fluent nhibernate mapping:
Map(x => x.LoggedTimeStamp).CustomType("Timestamp")
.Not.Nullable();
When I ...
0
votes
1answer
22 views
Perform a find and replace on thousands of Word files stored in a varbinary column of SQL Server DB
I've got a SQL Server database which has a table which contains a varbinary column.
This table has tens of thousands of rows.
This varbinary column contains documents: 85% in MS Word .doc format, ...
0
votes
1answer
35 views
SQL Server2008 Finding missing record
I have 1 table with these specification:
Year = int
Month = int
Code1 = varchar
Qty = int
And the records will be:
Year Month Code1 Qty
2012 01 ABC 3
2012 01 DEF 2
2012 02 HIJ 1
...
-2
votes
0answers
15 views
odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect
Here is my code details
Step 1.
/etc/freetds/freettds.conf
[mssql]
host = 192.168.1.10
port = 1433
tds version =8.0
client charset = UTF-8
Step 2
/etc/odbcinst.ini
...
0
votes
0answers
10 views
Difference between Contains and freetext when using FORMSOF
I use irony to parse the following string
Zaphod gave him
And it parses it to
(( FORMSOF (INFLECTIONAL, Zaphod) AND
FORMSOF (INFLECTIONAL, gave) ) AND
FORMSOF (INFLECTIONAL, him) )
...
0
votes
3answers
30 views
Deleting records from Master- Details tables
Following the very kind answers to my last question a short while ago I'd now like to clean up the tables from which I have just transferred records to the historical data tables of those records I'd ...
1
vote
0answers
22 views
MS-SQL stored procedure to MySQL
can anybody help me to write the following MS-SQL sp to MySQL sp,
use of this:
CREATE PROCEDURE sp_InputWork
@_DelimitedString nvarchar(MAX)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @_DataRow ...
0
votes
1answer
26 views
MSSQLSERVER ERROR: 18052 : Error: 9003, Severity: 20, State: 1
We have a SQL server 2000 installed in our production enviornment, suddenly one day morning, the Microsoft SQL Server service is not started in 'services.msc' list.
When checked SQL server log or ...
-6
votes
1answer
17 views
What keyword to use in place of table in postgres
CREATE Proc [dbo].[AbnormalODoMeterReading]
as
begin
set nocount on
Declare @TableDevice table
