Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged sql

0 votes
440 views
1 answer
    I'm looking for a way to copy stored procedures from one sql database to another on the same instance. It needs to be automatic, preferably through code ... : Using mixture of sql 2005 and 2008 versions. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
386 views
1 answer
    I have a Database Hierarchy that sits somewhat like this LHID | location | parent ------------------------------ 1 | Trim | NULL ... m having trouble grasping the exact necessary syntax for it. Any ideas? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
476 views
1 answer
    How can I remove spacing between bars in SSRS 2012 report. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
401 views
1 answer
    I am new to T-SQL programming. I need to write a main procedures with 5 different sub procedures in it. How could i structure the program so that ... provide me with pseudo code if you can. Thanks. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
436 views
1 answer
    Sorry, I'm not sure how to phrase that and I'm really not very good with SQL. The db engine i SQL Server Compact. I currently have this ... queries were looking rather expensive. Thanks for all the help. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
552 views
1 answer
    I'm usually working with MySQL or SQL Server and I've experienced quite a problem in Oracle SQL Developer. I have query like this (making it simple ... enter variables. Colleagues are not SQL friendly. ;) See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
434 views
1 answer
    I have the following table-valued function for splitting strings. This works fine, was cribbed from elsewhere on the web, and I would have thought isn't the ... error, and how can I achieve what I want? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
427 views
1 answer
    I'm trying to test a .Net 2.0 Web Service I created in C#. One of our servers is on windows 2000 and can currently only support .Net 2. ... currently connect to MSSQL 2005 via classic ASP and ColdFusion. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
413 views
1 answer
    I have two tables in Access database. Table1 has more columns than Table2. I would like to merge those tables into one while removing duplicates. I ... above query to accomplish that? Thanks in advance. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
458 views
1 answer
    Is there a way to aggregate strings in Azure SQL Data Warehouse similar to the string_agg function in SQL Server? I have records with strings that I ... -us/sql/t-sql/functions/string-agg-transact-sql See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
328 views
1 answer
    Ok I have a table with a few fields. One of the fields is username. There are many times where the username is the same, for example: username: bob ... of more than one field working for the life of me. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
508 views
1 answer
    I have some data like this: id | templateName ----+-------------- 10 | a 61 | a 63 | a 4 | a 6 | a 7 | a 34 | ... do that? Reference: Humanized or natural number sorting of mixed word-and-number strings See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
348 views
1 answer
    I've got a SQL statement of the form: BEGIN UPDATE tab SET stuff WHERE stuff RETURNING intA, intB, stringC INTO ?,?,? I've registered the appropriate ... resultSet's that I need to loop over? Thanks! See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
501 views
1 answer
    I am attempting to execute an SQL Command through a 'using' code block, but can't seem to get it to work with Parameters. I get the error: 'Parameters does ... ex) { //(snip) Log Exceptions } } return dt; See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
336 views
1 answer
    Suppose I want to query a big table with a few WHERE filters. I am using Postgres 11 and a foreign table; foreign data wrapper (FDW) is clickhouse_fdw ... -calculated and sent as part of a remote filter? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
418 views
1 answer
    Say I have a table of items representing a tree-like structured data, and I would like to continuously tracing upward until I get to the top node, marked by ... Unfunny', 5 UNION SELECT 7, 'Dane Cook', 6 See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
437 views
1 answer
    I get this error when reading some data from an SQL column then converting it to XML: "System.InvalidOperationException: There is an error in XML document ( ... , char, char+% combinations, just in case) See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    first an example of my table: id_object;time;value;status 1;2014-05-22 09:30:00;1234;1 1;2014-05-22 09:31:00;2341;2 1;2014-05-22 09:32:00;1234;1 ... 1;2014-06- ... : 0 0 0 0 2 1 0 0 0 0 0 0 Thx for help. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
357 views
1 answer
    Following my recent question Select information from last item and join to the total amount, I am having some memory problems while generation tables I ... long as I cannot change the tables structure? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
454 views
1 answer
    I have MSSTAMP as "timestamp with milliseconds" in Oracle, format: 1483228800000. How can I cast that milliseconds timestamp into a date format "YYYY-MM ... in ('FINISHED') group by FINISHED_MONTH ASC See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
425 views
1 answer
    Lets say we have 2 Tables: Table A Table B - A_ID - B_ID - A_Name - A_ID I need a select statement, that selects * from Table B showing ... another database with the same schema all the commands work. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
457 views
1 answer
    Is there a way to provide access to users in my database to execute msdb.dbo.sp_send_dbmail without needing to add them to the MSDB database and the ... , database 'msdb', schema 'dbo'. Thanks! See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    This question has been asked before but it all involved using "go" which I am not in need of here, at least I believe so. I am following this tut ... ' must be the first statement in a query batch." See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
466 views
1 answer
    I have a query that will return an arbitrary number of result sets, all with the same columns - i.e. one for a Manager and then one each ... the query will generate an arbitrary number of result sets. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
619 views
1 answer
    Sample table ID: (num is a key so there wouldn't be any duplicates) num 1 5 6 8 2 3 Desired output: (Should be sorted and have a cumulative sum column) num ... .num <= a.num group by a.num order by a.num; See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
450 views
1 answer
    In trying to add a computed column to a SQL Server table, I've found that casting a column with a DATE type directly to a VARCHAR is considered non- ... EffDate as varchar(10)))) persisted; go Thanks, Ian See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
525 views
1 answer
    I'm trying to insert an image into the database. CREATE TABLE ImageTable ( Id int, Name varchar(50) , Photo varbinary(max) ) INSERT INTO ImageTable ( ... "C:caldophilus.jpg" does not exist. Please Help. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
7.3k views
1 answer
    So I have received this error: #1066 - Not unique table/alias: 'Purchase' I am trying to do the following: SELECT Blank.BlankTypeCode ,Blank.BlankCode ,Payment. ... am unsure of how I can make this work. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
...