All Sql Answers
- paging design recommendation for asp.net and sqlserver 2005
- how to load displayed sql data into wpf scrollable list view? large collection (20k+) without running into memory problems?
- utl_match-like function to work with clob
- what is the sql command to forcibly close all other connections to the a database
- how to pick records an hour apart from one another in sql server
- ssis excel file issue - failure creating file
- how can i convert a varchar with hexadecimal value to int?
- laravel mssql driver support
- changing order by from id to another indexed column (with low limit) has a huge cost
- run a 32 bit powershell script on sql server agent
- does/will entity framework 6 support the new sql azure & azure active directory authentication
- create a table with unique values from another table
- sql query to 'order by' on 3 different columns
- mysql limit occurences of a particular column value
- how do i design backing data types for a databound wpf dialog with ok/cancel buttons?
- count distinct values for every column individually
- what data structure to use in order to sort this data in pl/sql?
- visual studio database project target platform in publish profile
- oracle sql: selecting a single row with the latest date between multiple columns
- adding related entities without using navigation properties
- understanding mysql explain output
- how do i exclude weekends in sql?
- using an oracle pl/sql stored procedure to grant rights on another user's tables
- insert select in firebird
- ref cursor with execute immediate
- serving an image stored in a database on an aspx page
- sql where depending on day of week
- should we also close db's .prepare() in golang?
- how do i use my alias in the where clause?
- trigger and update to a row in sql server after it's been updated
- varchar(max) versus varchar(n) in oracle
- how to decode html encoded text in sql server? (or ms access!)
- linq to sql grouping multiple columns with a distinct row
- parameterizing xpath for modify() in sql server xml processing
- update geography column in table
- sql in postgres convert datetime for recurring event to future datetime
- generating entity keys
- access and sql server calculate date differently
- double foreign key in django?
- sql query to find rows with at least one of the specified values
- is it possible to use limit with a subquery result?
- custom aggregate function inside a package
- efficiency of checking for null varbinary(max) column?
- return only rows whose max value is less than specified
- insert into select * for sql server, not possible, am i correct?
- defining indexes: which columns, and performance impact?
- how do i map a column to uppercase in .net 4.5 c# entity framework 6 using both oracle and sql server?
- postgresql generate date series (performance)
- performance benefit when sql query is limited vs calling entire row?
- select the same day each month for the next 5 years using sql?
- spring + hibernate + sql server connection failing
- convert string to double c#
- how to create a unique index with conditional and subquery in postgresql?
- dynamic table names in linq to sql
- oracle sql statement dynamic schema variable
- how to get similar objects based on tags
- oracle sql query for getting top 3 salaries rownum greater than
- how do i convert an int into hh:mm:ss using ssrs 2005
- sql: nolock causes query slow down
- swapping two rows in ms sqlserver retaining the original primary key and without manual update
- save a sql query result to an xml file without ssis or xp_cmdshell
- return select * result in postgres function
- java.sql.sqlsyntaxerrorexception: ora-00955: name is already used by an existing object
- how to count number of non-consecutive values in a column using sql?
- oracle apex redirect to modal dialoge page from pl/sql code
- how to find matching begin end pairs in complex sql server query?
- sql server optimistic locking - returning changed timestamp value
- can this simple string escaping prevent any sql injections?
- unable to connect to sqlserver because of sslexception
- sql server query by column pair
- sql duration time calculation
- is it possible to combine near and formsof together in a fulltext search?
- ef. how to union tables, sort rows, and get top entities?
- mapping to a nested class
- use sql to delete old mediawiki revisions without shell access?
- hive query: matching column values from array of string to make flags
- how does mysqlcommand.lastinsertedid work?
- how to change a column to an identity column and preserve the data?
- combine rows when the end time of one is the start time of another
- selecting from xml field where xml field = x
- fetching values from a table without using cursors
- pdoexception with message 'sqlstate[] (null) (severity 0)'
- find the source of data for certain table - oracle
- delete duplicate entries in table
- how to retrieve inserted identity in migration of fluentmigrator
- mainting identity value across multiple tables
- efficient assignment of percentile/rank in mysql
- how i can get table definition in sql server 2008 r2 using sql query?
- azure data factory complex json source (nested arrays) to azure sql database?
- difference between "=" and "is" in sql server
- performance impact of view on aggregate function vs result set limiting
- mysql insert if not exist two column pair otherwise update
- sql server 2012: sum over order by gives error incorrect syntax near 'order'
- trying to pull most recent pay rate from table
- validation with asp.net mvc linq to sql: how do i avoid editing a generated source?
- consecutive streak of dates
- removing replacement character � from column
- how to get the first row form sql group query?
- maximum row size exceeded when copying varbinary(max) field
- unable to cast object of type 'system.web.security.sqlroleprovider' to type 'webmatrix.webdata.simpleroleprovider'
- linq to sql: queries don't look at pending changes
- strip ole header information (ms access / sql server)
- quick and dirty sql string escaping
- linq: self join query, how to accomplish this?
- populate table with random data
- one address table for many entities?
- how did my trigger get deleted?
- how to find out which tables are most accessed or frequently used in sql server
- filling in missing days for rows
- once again linq to sql or entity framework for new mvc 3 project
- sql update with case, group by, and having
- sql server trigger to update time field when there is real change in another field
- sql server row size limit and table design
- 3 table join with sum and group by not working
- sql conditional order by
- oracle multi row update using subquery
- combining two tables with oracle sql
- flyway customizing 'version' in naming convention
- prevent rows affected entry in file export from ssms
- connect appmaker to google sql
- sql query using outer join and limiting child records for each parent
- dynamic access to tables from another database inside an user function
- process rdl/rdlc report files without ssrs?
- multiple queries with mysql_query in a c++ project
- bypassing character limit on openquery failing use execute
- case in an insert into statement
- catch exception with isnumeric in sql server
- joining multiple tables without common key
- difference between linq to sql and entity framework
- oracle sql: merge rows into single row
- select max dates plus id value
- incorrect column specifier for column
- sql alchemy before-select event
- how to insert row into a table by select column name and value from another table in sql server
- values inserted in hive table with double quotes for string from csv file
- create entity with both primary key and identity column in ef6
- how to write an excel function which returns a value from an sql database?
- non-clustered index and clustered index on the same column
- postgresql: how to get primary keys of rows inserted with a bulk copy_from?
- how often are sql server index usage stats updated and what triggers it?
- how to return custom error code in sqlite3?
- sql select last entry without limiting
- how do you configure a biztalk wcf-sql adapter to get data from a sql server 2012 "always on" replica database?
- using recursive cte to resolve a group, not hierarchy
- need advice on selecting a clustered index for a logging table
- why hibernate generates 't_' prefix tablename during insert and delete operation?
- how to count students and classes of every teacher in sql server?
- t-sql order by number and letters mixed in string
- sqlite: is there a way to make a conditional or / coalesce in the select clause?
- how to genenerate database backend during software installation?
- c++ odbc sql server 2008 connection
- accessing google cloud sql from google compute engine using private network
- java.sql.sqlexception: [microsoft][odbc driver manager] invalid cursor state
- how to convert sqlite3 script into script that postgresql can understand?
- does tomcat use cached versions of pl/sql modules?
- postgres order column with nan values
- postgresql 9.3 trigger function to insert into table with parameterized name
- using math functions in sql with ms access
- create or replace table in oracle pl/sql
- subquery total performance vs case sum performance
- find if there is a 6 digit number within a string
- unioning in parallel... will sql server do it?
- how can i check whether a table exists in the database (access or sql) in c#
- using sql parameters to drop index in c#
- varchar max length is 4000 but only 2666 byte long thai text can be stored
- using functional notation in postgresql queries instead of dot notation
- how to get the row count for views from a database?
- am i able to run sql functions on a contentresolver columns query?
- how to configure passportjs with sql server?
- hibernate cascade delete for one-to-many call sql "update" instead of "delete"
- glm fit (logistic regression) to sql
- web forms application storing data offline using sqlite
- sql try-catch and the missing columns
- how to do a contains() on two columns of full text index search sql
- connecting to sql server through a .net winform application
- sql error: 1452: cannot add or update a child row: a foreign key constraint fails
- how i can replace odd patterns inside a string?
- linq to entities conditionals give weird results
- c# sqlcommand connection.open() issue
- aggregation by timestamp
- python - insert into ms access table
- generating a mysql hourly breakdown from current timestamp
- is there a applypropertychanges with a datacontext?
- many to many relationship using sql and linq (entity framework/to entities)
- sql query two tables with relation one-to-many
- what is maximum rows count in oracles nested table
- how can i concatenate and make a group of text in sql server?
- linq query for a forum
- how to combine three mysql queries into one?
- compare s, t with ş, ţ in sql server
- mysql custom order
- value too long failure when attempting to convert column data
- insert new child+parent with linq2sql
- can i have multiple boolean expressions in a searched case sql statement?
- sorting with csqldataprovider in yii
- sql query to match sellers and buyers
- sql insert with inner join from list of constant strings
- sql server: can a stored proc that updates tables be called from within a clr udf
- is there a not in sub-query for linq to enties as in this t-sql
- can not delete or modify or see same table foreign key constraint
- how do i import columns into excel from sql in the same order as they are in sql server?
- selecting overlapping time ranges
- sql convert yyyymmdd to timestamp in bigquery?
- does index_id=0 in sys.indexes refer to the table itself?
- what is the smallest way to store a uuid that is human readable?
- how can i delete database table in django?
- string or binary data would be truncated. the statement has been terminated. system.data.sqlclient.sqlexception (0x80131904)
- is this a safe way to filter data and prevent sql-injection and other attacks?
- oracle external tables: advanced flat file layout
- connecting to multiple databases using different jdbc drivers
- replace value in deep nested schema spark dataframe
- sql subquery returned more than 1 value
- calculating the longest binge-viewing streak using sql
- impala: how to query against multiple parquet files with different schemata
- reset pk auto increment column
- teradata sql syntax - common table expressions
- insert using a subquery as a target
- linq to sql vs entity framework, microsoft support for
- how do i multithread sql queries in python such that i obtain the results of all of the queries
- will indexes get used if you query a subset of the columns of the index?
- sql: select in faster and best practice?
- vba (excel) vs sql - comparing values in two rows (loop)
- spark sql broadcast hint intermediate tables
- best way of importing data into mysql
- how do i combine data from multiple rows into one?
- multiple connections to an mdf file
- entity framework - extremely long execution time for stored procedure
- caused by: java.lang.classcastexception: java.sql.timestamp cannot be cast to java.sql.date
- "'dataframe' object has no attribute 'apply'" when trying to apply lambda to create new column
- linq query with conditional join and non-anonymous return
- maximum number of concurrent tasks in 1 dpu in aws glue
- how to escape special characters when retrieving data from database?
- mnesia equivalent of sql not in
- sum values in sql starting from a specific point in another table
- eliminating outliers by standard deviation in sql server
- sqlite alter table - add column between existing columns?
- what are the options available to encrypt a sql server express database?
- starting thrift server in spark
- xquery: finding rows which contain specified xml data
- wcf certificate store from sql server database
- selecting values out of xml with sql server 2008 with namespaces
- error in azure sql server database connection using azure function for python with activedirectorymsi authentication
- linq2sql - using a local collection as part of a sub query - "queries with local collections are not supported"
- how do i use a computed column specification to persist a datetime value using getdate()?
- repeating characters in t-sql like condition
- how to insert values into an mysql-table by using select-statements
- sql offset only
- daily average for the month (needs number of days in month)
- sqlmembershipprovider: use my own database as user store database
- how do you write the sql for a preparedstatement using a where x in clause?
- what are the advantages/disadvantages of using a cte?
- speed up range test for key values nested in jsonb array of objects
- oracle sql. what statement should i use
- is this a spurious warning when using linq to sql?
- group data using sql "group by" function in excel vba
- sql query ordering in custom order
- get records for each person's each day's min datetime
- number of similar columns occurrences
- cast string into date in bigquery when date is in the following format: m/d/yyyy
- i want a select query result in tabular format like summary report
- join help in sql
- hanging linq query with guid.empty in the where expression
- default column value based on the value of a different column
- retrieving the most recent entry per user
- sql not in clause
- using subquery in entity framework
- extract weekday, millisecond, microsecond, nanosecond from a date in postgres
- sqlexception timeout expired without being reached
- why we should use quotename function?
- copy into snowflake table with extra columns
- error in multiple select statements in insert statement
- named scopes with inheritance in rails 3 mapping to wrong table
- can mysql import a csv or other txt file into one column?
- ansi_nulls flag in sql server?
- counting business hours between timestamps
- how to use indexes for a query filtering between two columns
- create table new_table_name like old_table_name with old_table_name's auto_increment values
- how to get and order the most relevant entries from the database with multiple keywords laravel 5
- etimeout error | google cloud sql database with nodejs
- how to create sequential number column index on table with data
- why are null values fetched from ado recordset instead of correct ones depending on the order of retrieval? (the db table has ntext values)
- transaction isolation and reading from multiple tables on sql server express and sql server 2005
- add indexes to speed up geocoder near search
- can sql server 2008 handle 300 transactions a second?
- union vs cross apply performance
- how can i call a pl/sql procedure without specifying a variable to hold its out parameter?
- automatically set up user's subscription in ssrs
- mvc4 - db.savechanges() - decimal value out of range
- sql update replace statement
- sql server performance tip
- how to register internalrow with kryo in spark
- how write a query which receives data group by date?
- how to read multiple partitioned .gzip files into a spark dataframe?
- generate unique id to share with multiple tables sql 2008
- way of executing several .sql files at once in sql server
- how does sql like actually work
- asp.net mvc; edit option only for one user at a time
- cumulative adding with dynamic base in postgres
- insert client input into mysql database with c
- how to perform bitwise operations arithmetic in ms-access
- returning nulls in sql if joined table is missing records for that date
- adding columns resulting from group by clause
- is it possible to change partition metadata in hive?
- pivot or transpose a table in sql server without grouping by
- t-sql query gives different results when declaring integer vs calculating in-query
- what is the best place to inject the db password to the default ef connection string
- ssdt, ssdt-bi confusion in backwards compatibility for different sql version
- getting top n latest entries from sql server full text index
- ideas for combining thousand databases into one database
- error converting data type varchar to float
- execute sql command and output result to datagridview in c#
- cell to cell comparison in sql server?
- mysql - insert into from a temporary table
- dapper unable to cast object of type 'microsoft.sqlserver.types.sqlgeography' to type 'system.data.entity.spatial.dbgeography'
- closing sql-connection but open connections keeps incrementing
- sql insert with data from multiple tables
- dblinq not generating where clause
- does the number of fields in a table affect performance even if not referenced?
- the multi-part identifier could not be bound again
- violated - parent key not found error
- microsoft sql server analysis services olap cube
- when i run a c# parameterized query, it times out. same query with hard-coded parameters works fine
- mysql subset operation
- mysql view vs. embedded query, which one is faster?
- using an arbitrary number of parameters in t-sql
- what's wrong with this sql create table statement?
- selecting max of a sum of two columns
- bind datatable to datagridview that already have column defined
- mysql crash when querying
- get newly created row id in hibernate native query
- native query in clause throwing sql error
- sql keeping count of occurrences through a sliding window
- sql case statement specifiying condition in where clause?
- postgresql: ordering columns to match custom criteria
- spring boot ignore data.sql when running unit tests
- getting count of each item
- sql query: how to translate in() into a join?
- linq to sql: exception "string must be exactly one character long"
- sql server integration services are missing in sql server 2014 installation
- mysql sum with same id
- how to find records that violate referential integrity
- is mixing ado.net and linq-to-sql bad? my data layer isn't working
- count the number of rows that contain a letter/number
- usermanager.addtorole not working - foreign key error
- how to create a trigger for all tables in a sql server database
- split one string with commas into columns
- how to split repeating string delimated by commas in t-sql
- creating multiple users for a c#.net winform application using sql server express
- bulk insert failed "bulk load data conversion error (truncation)"
- get most sold product for each country from northwind database
- calling a ms sql server scalar udf from vba
- how to extract list of values into rows from xml using xquery?
- for each employee in employee table, find number of direct and indirect bosses in hierarchy
- postgresql: selecting rows that occur on a certain day of the week, in a specific time zone
- eliminate tuples with reverse relation and no primary key
- force truncation on varchar modification?
- how to serve a view as csv in asp.net web forms
- converting conditionally built sql where-clause into linq
- how to conditionally update/insert after delete that doesn't find rows?
- postgres: how to find nearest tsrange from timestamp outside of ranges?
- sql to set an xml value
- how to call stored procedure in background?
- how could i rewrite a query without using joins
- import image from excel sheet into sql server table c#
- compare result of two table functions using one column from each
- mysql if condition in a calculated field
- how can sqlserver notify a vb.net application of an event?
- oracle sql query with all mandatory values in where condition
- postgresql fibonacci sequence - query has no destination for result data
- mssql server injected with hidden spam links, any ultimate solution?
- join two tables, only use latest value of right table
- php variable statement at end of sql query produces error flag sql dialects
- connecting to ms sql from php on iis using pear mdb2
- pass value stored in a pl/sql variable into an in clause
- datagridview selection changed event and deleting selected rows from database
- cannot resolve collation conflict for column 4 in select statement
- how to parameterize the set for an in statement using inline sql?
- questions about sort order using xquery in sql server
- access denied for service account (permission issue?) when importing a csv from cloud storage to cloud sql
- how to automate deployment of entity model changes to database?
- best practices for dealing with encrypted data in mssql
- why are double nested not exists statements unavoidable in sql
- skip missing files from hive table in spark to avoid filenotfoundexception
- queryover many to many with a single sql join
- using sql to find the total number of customers with over x orders
- asp.net sql update statement
- how to merge unrelated tables, but sort on a common column type?
- fuzzy matching a string in sql
- can't seem to find a way to loop through a pl/sql array?
- using row count from a temporary table in a while loop sql server 2008
- clicking on a datagrid row and displaying its contents in textboxes
- basics of parameterized query
- join tables from different databases (postgresql)
- view all transaction logs in sql server 2008
- sql server equivalent to dbms_metadata.get_ddl
- universal store app getting data from server
- extending membershipprovider
- using db function (trim(leading '0' from column)) in slick
- handling files with different structure for each loop ssis
- how to set the proper connection parameters to connect a sql server database in atom editor using data-atom package?
- i am trying to connect to connect to my sql server database with node and hapi.js
- nhibernate hilo generation and sql 2005/8 schemas
- what isolation level does autocommit transaction use in sql server?
- sql optimizer for large db table
- linq to sql + exception when querying objects
- explanation of using the operator exists on a correlated subqueries
- using openquery to connection to active directory
- apache camel how to get header attributes from sql-component
- how to start sql server agent jobs automatically
- sql like operator not showing any result when it should
- use of cfqueryparam to specify table/column names in sql
- t-sql how to get all items from a tree in t-sql?
- does mysql use existing indexes on creating new indexes?
- deadlock puzzle : victim doesn't own any resource, used to kill to resolve deadlock
- strong vs weak entities mysql
- what model/pattern should i use for handling multiple data sources?
- update sqlite table based on data in another table
- retrieve highest two scores
- how do i apply unique constraint on two columns sql server?
- developing for sql azure offline
- bigquery: search multiple tables and aggregate with first_seen and last_seen
- dump a mysql embedded database into a sql text file [closed]
- rails activerecord query using inner join
- sql server - clustered index design for dictionary
- how can you unit test a database in sql server?
- insert new row in table 3 if combination of col a and col b in table c don't exist
- selecting the highest salary
- select between today and yesterday
- dynamically create popup menu tree from sql server table in delphi
- how do i join two tables with different column in sql server ce?
- how to determine programmatically mysql relationship type (1:1, 1:n, n:m) between tables?
- can not connect to azure sql server using active directory integrated authentication in appservice
- how do i get the position of the match in a formsof inflectional full-text search?
- pivot two columns and keep others as they are
- how to select posts created by me or my friends in a news feed?
- sys.dm_fts_parser sql full text
- split date range into months
- deleting data from access with vba
- i want to sum specific cell values by searching for similar values in textbox in c# .net
- selecting a distinct combination of 2 columns in sql
- sql how to group in time periods
- how do i do running totals from second column
- change the file encoding of the file which is created using ssis log provider for text files
- postgresql, find strings differ by n characters
- is combining (result sets) of "two queries with aggregate and group by" possible?
- different drill through for each row
- how to store column values in particular column in sql server 2008?
- sql get data out of begin; ...; end; block in python
- connecting to cloud sql from google cloud function using python and sqlalchemy
- powershell multiple sql queries into excel workbook
- cte delete not committed until following statements complete
- count days in date range with set of exclusions which may overlap
- sql full outer join with multiple tables
- ef core 3.1 can not run complex raw sql query
- postgresql and pivot tables using crosstab function
- installing and using ms sql jdbc driver?
- what is the difference between package com.mysql.jdbc.preparedstatement; and java.sql.preparedstatement?
- how to hide distinct column in sql selection
- render html code in sql server client report (rdlc)
- unable to connect to azure function app after integrating into vnet
- break on instruction in mysql queries?
- sql query performance improvement for advice
- sql server profiler: how to inspect/understand the duration for the audit logout event in more detail?
- load xml update table--mysql
- how can i use tsql to check when a user's password will expire?
- how to receive two values from a subquery sqlite
- auto-increment id based on composite primary key
- forward fill new row to account for missing dates
- magento sql query have no index
- cannot use pass through queries in excel
- linq group by sum
- rotate/pivot 1000 columns to rows
- mysql query to find id where multiple condition meet for one column
- not getting all records from table a in left join
- does sql server support hash indexes?
- autocomplete jquery and sql , asp.net
- how to configure a timeout for an sql query in groovy?
- setting a dynamic sort name field in a linq query
- count number of columns that have data for each row
- how to create a table of name-value pairs in sql
- sql server database synchronization issues
- mysql select column name and value as a field
- how to automatically create the primary key that has the following series a001000001 ... a001xxxxxx in sql?
- how to query a sql server backup file
- found an unknown relational diagram symbol in oracle sql developer
- tsql round to half decimals
- sql server: uniqueidentifier plus integer compound pk ... what type of index to use?
- pl/sql referencing another cursor in a cursor?
- performing a left join across a many-to-many table with conditions
- what is the best way to group and aggregate and sum tree data?
- spark expression rename the column list after aggregation
- missing keyword in join syntax
- increment and record creation based on field value
- how do i write a django query that does date math when executed as postgres sql?
- query a specific time range data from cosmos db and store it in sql database via azure data factory
- left join lateral and array aggregates
- log4net writing custom object to sql database using custom appender?
- how can i install the northwind database into sql server local db?
- get data from last 48 hours
- asp.net > sqlserver; trust and delegation
- displaying oracle table's column names
- the type "geography" is not comparable. it cannot be used in the group by clause
- putting a sql query in a php function
- external "hello world" function in sql anywhere with powerbuilder-generated dll
- what is the best approach to retrieve records from one table that stores it's history?
- why is this sql function tickstodatetime non-deterministic? and how to make it deterministic?
- must i include all column attributes in an sql statement when i want to alter only one?
- oracle/sybase sql - get value based on a previous record (not a simple lag)
- sqlite table aliases effecting the performance of queries
- how can i encode string in hmac-sha256 using pl/sql?
- oracle parallel query behaviour with ide tools as sql developer or toad
- oracle sql hierarchical query: flatten hierarchy and perform aggregation
- attach database programmatically
- pyspark - combining session data without explicit session key / iterating over all rows
- convert comma delimited string to table or array in sql server 2008 without using dbo.split
- get column names after columnsimilarties() spark scala
- in dataframe.withcolumn, how can i check if the column's value is null as a condition for the second parameter?
- how to convert/export sql server database to msaccess from c#
- efficient way to look up sequential values
- help with query over relation table
- make query like treeview
- selecting hierarchical data using mysql variable
- shredding xml from db using ssis
- how to get the sql print message using pymssql
- datediff in db2 query
- how to optimize query with 10+ joins?
- sql to return the rownum of a specific row? (using oracle db)
- how can i "shred" json data already in a sql database?
- sql: partition over two columns
- using sql server spatial types in ssis data load
- complex sql tree rows
- trouble setting up witness in sql server mirroring scheme w/ error
- order by for currency values
- mysql join, how is this interpreted?
- using @@identity or output when inserting into sql server view?
- one letter mistake allowed in exact word search
- split a table into multiple tables in bigquery sql
- ssms removing pre-begin comments from my stored procedures
- dynamic sql script to generate list of drop table statement
- hierarchical span of control report in sql, without oracle connect by syntax?
- is there a quick way to report database metadata in sql server 2005?
- create query to get count of uncompleted calls
- how to drop all default constraints in a database?
- capture linked server queries using sql extended events
- vba clear just pivot table cache, but leaving pivot table structure
- little complex sql row postion
- drop table if exist with similar name in two schema
- postgresql distinct not working
- how to work with javax.persistence.sql-load-script-source?
- connect to azure sql using azure active directory from an azure website?
- get month, quarter based on work week number
- sql server use union all and paging
- check if database exists and current login can access
- determine if a range is completely covered by a set of ranges
- linq-to-sql optimization for queries
- entity framework: loading many to one entity
- counting employee attendance
- assign role of db_denydatawriter to user dbo
- linq in or contains?
- set field to random value from another table
- grabbing extended properties from sql server into datatable
- cache sql chunk with r markdown / notebook without knitting in rstudio
- how to insert image from image control into wpf to sql database using entity data model
- sql query for join two tables of different databases that are in two servers
- duplicate (repeat) rows in sql query result
- sql exception while connecting to sql server
- java.sql.sqlsyntaxerrorexception: ora-01745: invalid host/bind variable name in managed bean
- number of rows in big table
- how to see if date is in current month sql server?
- usage of nested using in c# and sql server
- flask sql-alchemy | mysql - multiple foreign keys issues
- not able to execute sql query
- sql merge 3 tables by date where some dates are missing
- how to show due date column in the trac reports?
- how to yield pandas dataframe rows to spark dataframe
- how to prevent sql injection in postgresql json/jsonb field?
- hibernate @onetomany throws mysqlsyntaxerrorexception: you have an error in your sql syntax
- how to properly export results of select statement into csv file using spool in oracle sql developer
- finding a 'run' of rows from an ordered result set
- sql duplicate delete query over millions of rows for performance
- erlang mysql: how to prevent sql injections
- session setting to support indexed views
- convert sql dump to json?
- adding mode to this sql
- update large sqlite database in chunks
- sql query that sorts all results alphabetically except one?
- why sql "not in" is so slow?
- memsql - surrogate key as primary and different unique keys at the same time in table creation
- selecting matching subset in many-to-many relation
- sql - calculate forecast average
- method chaining equivalent?
- mysql - unable to get all columns with select *
- how to execute sql queries from a shell script
- compiledquery vs. plain linq sql generation
- sql server 2016 installation error
- firebase vs google cloud sql for laravel [closed]
- set connection settings with pyodbc + unixodbc + freetds
- spark sql 2.1.1 thrift server - unable to move source hdfs to target
- db2 unique constraint over multiple columns
- sql isn't in group by using query builder laravel
- how to define many-to-many to itself in jpa?
- paramterized queries
- metaprogramming oracle sql select statement
- django using order_by with .annotate() and getting related field
- t-sql: finding the closest location of an object on a map grid
- duplicate values in identity column
- how to manage huge amount of data using filestream since only local paths are supported for data storage?
- should i use a struct instead of a lightweight data class for my linq2sql data?
- oracle xmlquery passing parameter value
- retain ordering from in subquery
- querying conversations from messages table
- count number of words in each sentence spark dataframes
- linqtosql - mapping out the datacontext with lots of tables?
- sql split string at first occurance of a number
- identify sub-set of records based on date and rules in sql server
- insert extra rows in query result sql
- t-sql - order by on alphanumeric
- linq contains between 2 lists
- how to create multiple rows from a single row - normalize a table
- how to write an equivalent if else adhoc sql query in snowflake
- how to use join instead of union to count the neighbors of "a or b"?
- how come stack trace line numbers don't match source code line numbers?
- how do i inspect table variables and temporary tables from within a debugging session in ssms 2008?
- syncing data between ms sql server and oracle server
- indexing on a field and "order by" on another field
- find duplicated values on array column
- update with multiple values from subquery
- having/where clause not working for haversine formula using microsoft sql
- rails activerecord friendly code from a complex join, sum, and group query
- avoiding sql not in by using replace and length check
- using r functions lapply and read.sql.csv
- what is max(rowid) in oracle
- calculating stock returns using sql lag function
- can't refer to column counting the ocurrences
- how to convert parquet data to case classes with spark?
- advanced (?) and / or query
- calculate maximum number of concurrent user sessions
- what is the best database design for this table when you have two types of records
- asp.net, sql 2005 "paging"
- send sms using triggers and stored procedures from sql server 2008
- ef migrations drops index when adding compsite index
- is it possible to set mysql to have a saturday as the start of the week?
- regular expressions in sql server 2008
- convert tick data to candlestick (ohlc) with sql
- power bi. execute sql server stored procedure with a user parameter
- how sqoop converts sql datatypes into hive
- bcp import all files from a folder to database
- linq returning list of anonymous types
- sync framework: oracle/sqlserver
- best way to handle connection when calling a function from a console app or sqlclr object with ("context connection=true")
- categories from 2 combobox affecting third combobox for datagridview with sql
- drop and recreate a single table (on heroku)
- mysql count matching words
- curried udf - pyspark
- t-sql to pull decimal values from a string
- sql query for informix to get all the records from previous month
- why i cant save a long text on my mysql database?
- android content provider without sql
- formatting dates in postgresql
- querying association tables in sequelize
- postgres insert triggers with 'on conflict do nothing'
- sql server automated daily table partitioning
- is using a select inside a pipelined pl/sql table function allowed?
- can a transaction be rolled back after it's committed and connection is closed?
- ad hoc updates to system catalogs are not allowed in sql server 2012
- group by, order by - how to make group by consider latest apperance of item
- how to execute an oracle procedure with an out sys_refcursor parameter?
- r dbgetquery with dynamic string
- get working days in sql server
- dataframe to hdfs in spark scala
- display large result set
- sql how group by fiscal quarter and year with a date field
- how to transpose columns and rows in postgresql (i.e., how do i switch rows and columns)?
- remove and split data into multiple columns in select statement
- store and retrieve .zip file in sql server 2005
- how to securely and efficiently store ssn in a database?
- export sql server 2005 query result to sql insert statement?
- how to use linq to sql to create ranked search results?
- effective way to join tables by range using impala
- do i need to create surrogate key for my relationship table?
- how to check database compatibility level sql server?
- entity framework multiple aggregation performance
- distribute by notices in greenplum
- get paginated rows and total count in single query
- select updated rows in mysql
- run stored procedure in airflow
- stored procedure timing out.. drop, then create and it's up again?
- javascript search in object array like sql by object key
- sql server 2008 reporting services permissions
- error on sql script with 'openrowset'
- group by retrieve 3 values
- connection timed out: nodejs google app engine to cloud mysql
- inner join in zend framework
- mysql query taking over 6 seconds
- sql server localdb issue in asp.net mvc 4 project
- how to get bmp image from from binary blob data with php
- why all the records are not being copied from csv to sql table in a ssis package
- oracle sql checking for overlapped dates using a trigger
- converting dd/mm/yyyy input to yyyy-mm-dd in date format not varchar/datetime
- combine two tables by joining on the same date or closest prior date (not just exact matches)
- sql rename table command
- pyodbc to sqlalchemy connection
- how can i rename columns by group/partition in a spark dataframe?
- how to delete every table in a specific schema in postgres?
- how do i create a stored procedure that calls sp_refreshview for each view in the database?
- creating snapshot of application data - best practice
- self join tutorial #10 on sqlzoo
- how can i specify the current schema for sql server in a jboss data source url?
- cogroup on spark dataframes
- delete azure sql database rows from azure databricks
- how to execute a sql server stored procedure asynchronously and ensure it's completion
- are there more efficient alternatives to asp.net 2.0 anonymous profiles?
- storing user preferences in web application [closed]
- check who performed insertion in table on ms sql server
- using spark to expand json string by rows and columns
- oracle - regexp_substr to return null values
- i can't login with a user i created in sql azure [closed]
- create new database programmatically in asp.net mvc application?
- how can i properly present and write a checkboxlist to a db? (theory/logic help)
- left and right function in pyspark sql
- select top 1 with a group by
- mysql query return duplicate entries with in and find_int_set
- sql dataretrival in vb.net datatypes error
- how to run sql from a .net application against sqlserver and get output like with sql management studio?
- large file download from sql via webapi after custom multipartformdatastreamprovider upload
- what exception should be thrown when an ado.net query cannot retrieve the requested data?
- sql server returns different record after insert on linked ms access table
- mysql group by / order by issue with flat messages table / threads
- finding non-numeric values in varchar column
- tool to convert t-sql (sql server) stored procedure to pgsql (postgre sql) [closed]
- deleting a large number of records using pl/sql
- selecting similar values in mysql (some thing, sömé thińg, some-thing, some¤thing should be the same)
- query a mysql database and group by date range to create a chart
- which row is selected in group by?
- what does <> mean on sql
- convert rows to columns
- keep linqtosql sync with the database
- how scale is defined when decimal and bigint are divided?
- the year function doesn't support dt_wstr
- inserting duplicate records with sql
- will messagebox.show cause the timeout issue on server side?
- how does one handle exceptions in date casting in sap's hana?
- can i select full hierarchy of parents when id and parent id are in the same table?
- aggregating in sql
- scala: how can i split up a dataframe by row number?
- postgres order by values in in list using rails active record
- difficulties comprehending iso_week and week in microsoft sql, what's happening exactly?
- to_char number format model in oracle
- is there a secret to using linq to sql to add records when the object has relationships?
- can't bind a gridview to a linq to sql result
- getting sql data back into javascript after jquery ajax call
- querying database schema of sql server db via odbc?
- how to track changes in records in sql server?
- pl/sql: contradiction in oracle document on implicit rollbacks
- about choosing data type
- sql max-min in ormlite - android
- how do i use dateadd to get the first day of last year?
- hive sql coding style: intermediate tables?
- how to query for rows containing <unable to read data> in a column?
- java database with mapping?
- linq: order by anonymous type
- sql server rowversion definition is not accurate?
- ansi 92 recursive sql statement required
- why would a sqlclr proc run slower than the same code client side
- how to debug a linq to sql insertonsubmit statement?
- copy missing rows from one table to another in sql server with stored procedure
- what exactly are in, out, in out parameters in pl/sql
- how can i convert sql comments with -- to # using perl?
- return the sql statement of an explicit cursor
- paginate rows from sql
- joined table rows into columns with column titles from original rows
- mysql - select all from one table and one column form another where $var is found
- enable sql dependency in application insights on azure functions with ef core
- pl/sql: sql statement ignored?
- how do i get values for all months in t-sql
- migrate sql server express tables to sql server database
- why can i connect to azure ms sql with tsql but not pymssql?
- asp.net mvc ef4 sql table or field level security
- sql server operand type clash: date is incompatible with int
- sql server compact edition with entity framework
- select only largest values in a sql relation?
- basic sql sub-query
- entire local database sync with sql azure
- implementing security in asp.net web app as afterthought
- how to get sql substring?
- update multiple table using one query in sql server
- sql server: how to populate sparse data with the rest of zero values?
- creating collection in azure search service using indexer
- how is a spark dataframe partitioned by default?
- flutter sqflite insert list<string>
- how do i locate the failure in a failure to convert varchar to int in sql?
- sql ssis convert question
- oracle sql for handling null values
- minutes(integer) conversion to hours(float) in hh.mm format in sql server 2008
- integrating sqlcipher with android application (on windows)
- explode sparse features vector into separate columns
- calculate overtime per day
- how to convert a sql query using common table expressions to one without (for sql server 2000)
- using mysql group_concat or pivot on multiple joined tables
- any alternative of mysql_ping for mssql?
- query response in json format without column name
- programmingerror: when using order_by and distinct together in django
- whats the recommended data access layer design pattern if i will apply ado entity frame work later?
- #1062 - duplicate entry '0' for key 'primary'
- how can i use sql server table views as rails models (read only)?
- sql server 2005 collation issue
- sql query to fetch numbers in given steps between a range
- sql not a group by expression with oraclesql and innerquery error
- multiple counts in cakephp
- sql update row number
- getschema("foreignkeys") against sqlclient doesn't yield enough information
- entity framework 6.1 : the given key was not present in the dictionary
- order by "count (columns not null)"
- check rows for monotonically increasing values
- sql: how to populate a census column with a count of active clients for each date based on admit date and discharge date
- ipv6 regular expression (regex) not working in pl/sql
- declaring a list variable of an anonymous type in c#
- how to map `time(0)` to `datetime` with entity framework 6
- case sensitive database query
- error 1442: can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
- set the result table name in stored procedure
- getting doctrine dql results the sql way
- how to convert birth date to current year's birthday from a field timestamp?
- sql server - how to dynamically determine financial year?
- get url part only in sql server
- wcf disabling usenaglealgorithm while connecting to sql azure
- pl/sql - caching two resultsets into collections and joining them together?
- upgrading winforms sqlite database techniques
- where clause with multiple unknown conditions
- generate row number for every 3 rows
- subsonic 2.x now supports tvp's - sqldbtype.structure / datatables for sql server 2008
- mysql sql recursive loop
- how to get a time and date separately?
- select all until first occurence of a character
- change date format in mysql database table
- how to search content of a routine/(sp-trigger-function)
- informix: how to pass, use and execute multiple values in a single parameter to a stored procedure
- add excel expressions to a sql query result
- vb.net - read null value from database
- storing data into appconfig from textbox
- sql server select distinct hell
- hierarchical query
- spark 'limit' does not run in parallel?
- prevent jpql query sql injection
- alternative to any() in linq to sql for better performance
- is a stored procedure call inside a sql server trigger implictly thread safe and atomic?
- tns listener error
- how to sql sum with condition
- linq to get immediate children in nested set model
- rails add new row in table
- inserting all rows of a datatable into a sql server table, including id values
- concatenate a column on one line depends on a id
- error handling with cursor in sql
- aes encrypt in c# decrypt in t-sql
- how to run sql set statements against db at start of connection/session using hibernate?
- how to create like '234%4' or %2324%335% in entityframework
- spark pivot one column but keep others intact
- how to remove duplicate values from mysql table
- proper way to refer to coalesced value in select statement?
- select one row with max(column) for known other several columns without subquery
- django orm equivalent for this sql..calculated field derived from related table
- how use pqexecparams in libpq?
- sql multiple select query with xmlagg function- data not pulled in the required fashion
- how do i design a table which will store very large data?
- activerecord nested select -- can i do it without manual sql?
- mysql simple select query is slow
- unable to load csv file in postgresql
- how do i convert array<floattype> to binarytype in spark dataframes using scala
- change huge table pk column data type
- design an access form with dynamic sql as recordsource
- read xml node attributes without using node name in sql server query
- create dynamic linq query expression at runtime which translates into a parameterized sql query
- parametizing query for excel
- best practise when updating individual fields in a database record
- sql deployment automation
- could not find sdk "sqlite.winrt" - add reference shows "missing value for targetplatformwinmdlocation property"
- ssrs: report label position dynamic
- windows phone 7 databases
- pl sql trigger to insert history record when a column is updated
- remove duplicate rows by value
- result order of string_split?
- why linq can't translate expression/treat as local expression and throws an exception?
- searching data in datagridview
- how to find missing rows?
- select max value in subquery
- combining mysql query sum() result using inner join
- hh:mm format in sql server
- insert rows from one table to another, with identical schemas and composite keys on sql server
- using dynamic query + user defined datatype in postgres
- display more than one value using a sql query
- sql stored proc - help me write this one, please! (part 2)
- minus in mysql?
- mysql - search in longtext
- sql clone record with a unique index
- mysql detail query string, like wildcard
- linq-to-sql multiple trips to the database
- store asp.net access rules on sql server
- datacontext.createdatabase() says file already exists - but it doesn't
- how can i change back to trial?
- azure sql query is slow when an indexed column used in where clause has a particular value
- custom properties and lambda expressions
- remove duplicates based on two columns
- sql where exists doesn't filter?
- insert if not exist mysql
- ef core spatial data: query and get distances in meters
- string concatenation using operator "||" or format() function
- what is a good practice/design to thread mulitple sql queries in python
- ora-00904: "from$_subquery$_014"."column_name": invalid identifier
- updating table with business day and calendar day
- count the number of sub tags from xml in sql
- weekly active users for each day from log
- c - how to use variables as part of an sql query?
- how can i get stored procedure return value in c#?
- localstorage no longer working in ios 7 webview
- how to recursively compute ratio of remaining amounts based on rounded values from preceding rows?
- single sql query to update datatypes of all columns in a table at one shot
- are there any utilities to extract binary data from sql server?
- how to read sql generated by nhibernate in visual studio
- is there a safe way to modify the table pg_constraint so as no more checking be done ( temporarily )?
- how to save output of sql server stored procedure with multiple result sets into each dataframe in pandas
- prevent data from being deleted after test run with hibernate / spring / maven / mysql
- oracle bitand function
- equivalent date_part function in sas
- entityframework : calling tolist() on iqueryable with ~11.000 records takes 10 seconds
- use sql regexp to ignore number and get only string and '/'
- freetexttable alternative
- update rows with values from the same table
- linq-to-sql with sqlite: syntax error near "select" when inserting
- oracle query - get only strings in the select field
- performing multiplication in sql server(set based approach)
- why does "m" appear in clojure mysql query results
- use of single quote and double 'single quote' in pl/sql block
- how to store goals (think rpg quest) in sql
- always encrypted feature - failed to decrypt column. call from windows-service app
- how to do a postgresql query with where-in clause which contains multiple columns programmatically?
- how do i insert a bc date into oracle?
- sql update table with cumulative value
- pl/sql extract select statement column names from custom query
- sql server case statement gives me errors in user-defined function
- sql server 2005 percentage in parenthesis in pivot table
- how to combine tables with 1 to many relationship into 1 line of record
- how to parameterize sql query when the parameter can sometimes be null?
- sql select like keywords in any order
- total results of paged projected nhibernate query with aggregates
- on update: auto update date/time field
- composite primary keys in n-m relation or not?
- when you create a new login in sql server it selects db_owner by default
- sql query for exact match in many to many relation
- returning nearest date to date in a different table
- error when executing mvn sql:execute
- linqtosql. deadlock while updating a row. parallel.for
- `spark.debug.maxtostringfields` & `spark.sql.debug.maxtostringfields` relation?
- creating a new column based on another column in sql server
- postgres regr_slope returning null
- connect to a local sql server db with sequelize
- spark dataframe except method issue
- containstable wildcard fails on phrase match?
- android single quote in sql with a like statement
- sql server: in ('asd') not working when column is ntext
- .net, c#, linq, sql and or-mapping - i just don't get it :(
- mysql: calculating remaining days of subscriptions based on payments
- sql server 2014 replace with regex
- selecting random rows from a big table in h2 database
- vaadin converter for java.sql.timestamp
- how to insert into two tables from vb.net
- what is better, dynamic sql or where case?
- collation conflict in sql union all query
- does postgres union guarantee order of execution when invoking functions with side effects?
- unique - way to have unique rows in table?
- mysql query perfomance. which one is best?
- calling pl/sql procedure with user defined record as its in parameter using jdbc
- sqlite convert string to date when date column has single digit months and days
- ef: how to execute a sql-query with multiple joins?
- sql query to make a column of numbers a string
- running cumulative return in sql
- sum highest consecutive occurrence
- not serializable exception when integrating spark sql and spark streaming
- sql standard for timestamp in utc or with timezone
- change the connection string dynamically (per request) on entity framework 7 / mvc 6
- mysql - how to update a field for all items resulting from group by select statement
- sql - ordering a common table expression
- in sql, how do i exclude result from select * from ...?
- why this linq code always throws system.exception?
- mysql: select part of text and cut it of based on dot location
- sqldataadapter.fill(datatable) not filling datatable
- how to pass parameter on jpa query?
- sql based encryption performance
- how to generate sql script file from c# codebehind?
- mysql function to add a number of working days to a datetime
- how to show raw sql in typeorm querybuilder
- wix bootstrapper - difficulty detecting if software is already installed c++ redistributable, sql server compact 3.5 sp2
- is there any way to loop through my sql results and store certain name/value pairs elsewhere in c#?
- sql select sum values without including duplicates
- mysql select of record with latest date
- on course completion update external database
- how to restore an azure sql database to point-in-time using azure management libraries for .net
- ssis : how to handle multi select lookup column values to be inserted in sql server table
- django: unable to connect to microsoft sql server
- django: how to wrap a bulk update/insert operation in transaction?
- retrieving the an sql agent job's specific error
- asp.net mvc - switching from sql server express to compact edition - connection issue
- "group by" needed in count(*) sql statement?
- get data from every column in every table in a database | sql server
- mysql: enum confusion
- sql server replication without deletes?
- oracle database search all tables for string, return row data
- mapping a uri to string-field in linq-to-sql
- sql ce native exception 0xc0000005
- sql stored procedure with a lot of parameters
- logging update operation in triggers
- searching multiple columns with multiple values sql
- how can we have dynamic output file name in u-sql in azure data lake based on timestamp job is excuted
- sql inject - badstore.net
- with ado, using sqldataadapter.fillschema clears @returnvalues and other stored procedure parameters marked for output
- optimizing the sql query for calculating account balance
- last_insert_id not working on update
- sql server split string into columns by delimiter (dynamic length)
- sql server database connection errors
- how can i make this geo-distance sql query postgres compatible
- how to return total number of records with top * select
- create foreign key sql
- return a list of data via stored proc to dapper
- how to connect to sql server express db from server explorer vs 2010?
- can't create/write to file (errcode: 22)
- export a text file from a sql stored procedure
- why hive query doesn't support in/exist operator?
- looping between 2 case parameters (date range and row count) | sql server 2012
- possible to get sqltransaction from ambient transaction?
- stragg in oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production
- cannot register stdole assembly in sql server 2012
- database normalization: how can i tabulate the data?
- linq to sql int16 gets converted as int32 in sql command
- how to ensure entries with non-overlapping time ranges?
- mssql deadlock when update withc (updlock)
- mask characters in string sql server
- database trigger that communicates with an external program
- daylight savings time in sql server
- rownum issue in oracle query
- how to i design a database constraint so two entities can only have a many to many relationship if two field values within them match?
- ms access runtime error 3464
- how to test for an empty sql result in asp
- validate data before uploading through ssis
- sql server (2005) - "deleted on" datetime and indexing
- entity framework 4.0 - the underlying provider failed on open
- how to save html to a database field
- how can i check for date range exists
- using smo to script partial data content (only rows matching a where clause)
- backand deep querying
- sql server 2005 - trigger loop?
- parsing xml into a sql table without predefining structure. possible?
- joining two separate queries in a postgresql ...query... (possible or not possible)
- how do i sort a “foreign” column using datatable/will_paginate as in railscast 340?
- select relevance title based on tag similar to like with mysql
- relative efficiency of join vs apply in microsoft sql server 2008
- calculating distance between 2 points with sql
- how to know which checkbox is checked from a expandable list view and get its info(android)
- add a summary row to ms access query
- what is the sql query for finding the name of manager who supervises maximum number of employees?
- t-sql query to flag repeat records
- does entity framework support applicationintent=readonly in sqlclient connection string
- count in a query with multiple joins and a group by clause
- oracle sql merge into with a single where clause
- how to join nested columns in spark with usingcolumns
- would building an application using a sql server database file (mdf) be a terrible idea?
- comma delimited result set + sql query
- foreign key and index issue
- sql server transaction
- null value parameters in where clause in ado.net
- generating simple crud stored procs
- optimizing search for values in columns in sql server
- oracle case statement?
- what's the most efficient way to generate this report?
- oracle - comparing default value of a column
- lesser the number of indexes means faster inserts, updates and deletes? [closed]
- laravel multiple where clauses in query from given array
- how to import text file and save data into database? [closed]
- reporting services 2005 timeout when exporting via web service
- sql server compare two tables rows with identical columns and return changed columns
- quote_ident() does not add quotes to column name "first"
- where is entityset<t>'s "results view"?
- convert to valid decimal data type
- how to capture the result of stored procedure through shell script?
- select into command not allowed within multi-statement transaction in hibernate for sybase db
- sql syntax: create a single table with column names created from data stored over multiple tables
- sql turning rows into columns and populating with values
- how to calculate the night working shift in sql server?
- split column values into multiple columns with create view
- sql super search
- subtract values of two rows and inserting it into a new column (not subsequent rows)
- to fetch duplicate values with condition
- using parameter overrides in ssis managed object model
- ssis mysql copying table to sql server
- select with two counts on same column
- sql (oracle) counting number of overlapping intervals
- how to pass macro variable to proc sql on in statement in where clause on ms sql server
- update query from a lookup query
- how to count open records, grouped by hour and day in sql-server-2008-r2
- sql count duplicate values across multiple tables
- sp_oadestory is not clearing/destroying created object
- simulate a 128-bit unsigned integer in sql and c# using a 64-bit signed value?
- check for new data after a certain time frame
- spark sql issue with columns specified
- how to store custom entity properties in a relational database
- configure google cloud sql instance in eclipse
- mysql insert if not exist without unique key
- sql query to return data only if all necessary columns are present and not null
- hide characters in email address using an sql query
- linq to sql default value ?? nullable
- spark: group rdd sql query
- pl/sql no data found error on forall loop
- sql xquery command to recursively get descendants of same type
- redshift - calculate monthly active users
- using native sql in java criteria predicate
- in hive, how to explode same child-tags under the same parent-tags appearing multiple times within an xml?
- using impala get the count of consecutive trips
- create an spark udf function to iterate over an array of bytes and convert it to numeric
- how to find unmatched rows in oracle without using set operator and join & also query the unmatched column names for an particular row
- mysql joins: choosing which table to join from based on source table data
- how do i analyse time periods between records in sql data without cursors?
- split pipe delimited into new columns
- excel parameters from sql query from odbc "error - no value given for one or more required parameters when using question mark `where xxx = ?`
- ef core 3.1.1 avoiding the exception "the data types text and varchar are incompatible in the equal to operator" just as linqpad 6 does
- get date even if it doesn't exist in table from sql select statement
- ms access application work offline
- deadlock from range locks on primary key index
- multiple table join mysql multiple foreign keys
- (my)sql join - get teams with exactly specified members
- how to create new column 'count' in spark dataframe under some condition
- trimming any leading or trailing characters
- updating database through edits to wpf datagrid
- sql server data conversion
- sql server: compare salary of people in the same table, and display both names, with the difference
- update xml file in sql server (with namespace)
- changing guid primary keys to integer primary keys
- query for labor cost by hour
- open sql server 2012 from command prompt
- entity framework 6 code first on sql server: map "bool" to "numeric(1,0)" instead of "bit"
- how i remove duplicates from listagg
- expand json with unknown keys to rows with mysql json_table
- query to convert exponential number to float in sql server
- how can i pass a row from my table to a udf without specifying the complete type?
- azure sql data warehouse: max size of varchar type
- how to convert columns data in comma separated list
- looking up access database in excel
- net core: entity framework and sql server temporal tables, automatic scaffolding
- error: syntax error at or near "over"
- hide sql > statements in the spool file
- compare value with comma separated string sql php
- how can i get sql admitdate and dischargedate with specific events?
- dropping a schema and all of its contents in db2 8.x
- inserting into sql server using ms access
- delete duplicated records firebird sql
- enumerating records by date
- sql server int primary key and guid
- map(&:id) work but not pluck(:id)
- how to send data from android to sql server 2008?
- how to set connectiontimeout to 0 in sql server 2008?
- convert sql case statement into spark
- how to read a dbase file in java or oracle pl/sql
- spark scala: how to update each column of a dataframe in correspondence with each position of a vector
- how to sum one column value to other column value
- how to make a query in postgres to group records by month they were created? (:created_at datetime column)
- pandas read_sql with multiple parameters and lists
- sql query with not in and where relation with guids
- using distinct inside join is creating trouble
- sql server - sum comma separated value from a column
- string aggregtion to create pivot columns in big query
- where current of in pl/sql
- mysql/oracle stored math formula
- how to calculate aggregated product function in sql server
- is this possible in oracle/sql?
- hive:select all column exclude two
- select rows that have specified values in one of the columns
- sql replace function that matches whole words
- sql server: how do you select a column only if it exists?
- convert an int column to a varchar in frontbase sql?
- treating null field as zero for an update query
- sql to check when pairs don't match
- saving data from sql server database into a pdf file
- spring boot / jpa / mysql - many to one relationship creates too many sql queries
- how to select top n record from every group mysql
- how to transfer the server logins from sql server 2000 to sql server 2012
- how to add a sql database to an elastic pool programmatically?
- building a datetime object for sql database insert
- postgresql 9.3: union two columns in one
- error : the type of column "dob" conflicts with the type of other columns specified in the unpivot list
- orientdb group by query using graph
- problem creating foreign keys in mysql
- help with generating a report from data in a parent-children model
- changing a primary key to a composite primary key
- why are there gaps in my identity column?
- python: typeerror: unsupported format string passed to nonetype.__format__
- mysql weighted average in a single query
- sql: taking the result of of query and using it another - combine
- in sql server 2000 how do you add 0's to beginning of number to fill nchar(n)
- transform a table from rows to columns
- splitting coredata up for a faster query time
- asp.net login with sql server database
- how to select records grouped by the hour of the day including hours that have no records
- star schema design - one column dimensions
- select the most recent entry
- best way to use a scalar udf that needs to appear in the select and where clauses
- how to store confidential pdf documents (file system vs. sql) if we only use forms authentication
- postgresql, odd offset/limit behavior ( records order )
- mysql: get last conversation records by user
- how to string concatenation in entity sql?
- oracle 10g pl/sql- select results as update column values
- asp mvc 2 uploading file to database (blob)
- sql find the same column in different tables
- django idiosyncrasies
- sum of counts of different columns of same table
- c# sync ms access database to sql server
- indexing by database engine tuning advisor
- how to calculate the sum of a column in an sql table for a given date and patching missed values with those of the closest previous date?
- tdd - 100% coverage for methods that wrap sql
- mysql string split
- how can you reference multiple rows in another table?
- dynamic order by in paging sql query
- copying database from one sql server to another
- getting data from sql server database
- executestorecommand returns -1 , entityframework , c#?
- how can i compare the one line in one csv with all lines in another csv file?
- sql job to run every certain time and execute a console application
- how to optimize below spark code (scala)?
- how do i merge two tables in mysql and where table 1 is primary
- understanding android.com's "saving data in sql databases" tutorial
- how to efficiently select distinct rows on an rdd based on a subset of its columns`
- which join will spark choose when all the selection criteria are not met?
- how to properly access linked table fields using lambda?
- postgresql: select all types that have an entry corresponding to all entries in another table
- stored procedure is failing when one of the values contains specials characters
- need to calculate latitude longitude from postal code database when location has multiple codes
- "ora-00937: not a single-group group function" when running my query
- can i add a user defined function at the server level in sql server 2008 r2?
- sql server cast and rounding
- sql server 2016 with row level security - addressing the bottleneck
- mysql how to update a table by auto-incrementing a column
- how can i find the particular days
- sql join data row by level
- nodejs mmsql bulk insert to temp table
- self-referencing a partial key of a table
- display images from windows folder in ssrs report
- parameterize sql queries using r rodbc
- how to find who last modified the table in sql server?
- how can find size of each row in apache spark sql dataframe and discrad the rows having size more than a threshold size in kilobyte
- keywords in sql script data causing problems when executing programmatically - c#
- asp.net populate a listbox without a postback
- sql server : openquery insert linked server
- sql aging report
- how to output different 25th, 50th, 75th percentiles in single teradata query?
- complex sql statement to different rows
- ef core - multiple counts in one sql request
- how to skip first and last line from a dat file and make it to dataframe using scala in databricks
- view ef4 generated queries?
- controlling the data partition in apache spark
- creating xml with pl/sql
- mysql: select sum of field values while also selecting unique values?
- bigquery update table using like returns "update/merge must match at most one source row for each target row"
- how to use openxml to load xml data into existing sql table?
- preventing a specific record from being deleted
- in asp.net (c#) ,how to store an image in database(linq to sql)?
- sql distinct, getting 2 columns
- enforcing common foreign key in many-to-many relationship
- insert if not exists else update it in netezza
- how to use pivot in sql server
- trace oracle statements
- logging hibernate sql using log4j
- how to remove 'wasted rows' after delete in oracle sql database
- dates and timespans with sql
- asp.net mvc core web post request populating data model with null values
- where clause for equals a field, not equal another
- spark dataframe access of previous calculated row
- backup azure database to .bak file using ssms?
- write sql info to a txt file
- sql row sum for some colums
- visual studio 2010: can't create new connection to sql server compact 4.0
- inconsistent datatypes: expected ref got .. error when trying to insert data
- oracle sql - query to calculate values from multiple tables
- redshift like column value with %
- replacing null values in dynamic pivot sql query
- finding difference between two rows in a table. oracle
- how to get checkbox value from gridview when checkbox oncheckedchanged
- count number of registers in interval
- ora-31011: xml parsing failed - invalid characters (oracle sql)
- inferschema using spark.read.format("com.crealytics.spark.excel") is inferring double for a date type column
- need some advice and feedback on coding a many:many relationship in mysql
- import data from one table to another table
- a covered index formed by a composite index or index with included columns
- populating multiselect list with data mvc 3 .net
- understanding the queries generated for one-to-many and many-to-one on join table
- hyphen in mysql order by clause
- build array based on add and remove event rows in bigquery
- how do i connect to mysql server with go and go-sql-driver?
- will moving a table/partition to a different tablespace interrupt queries accessing said table/partition?
- sql join with nested query
- postgresql get relative average with group by
- analog of "select level from dual connect by level < 10" for sybase?
- can sql server hierarchy type method isdescendantof accept multiple input values?
- call tvf on every record of a table and concat results
- sql - pivot multiple columns without aggregrates
- the weird length of varchar and nvarchar in t-sql
- how do i convert a y2k date to sql date in ssis?
- split string in column
- cannot resolve the collation conflict in my query
- define default constructor with structuremap without providing arguements or using defaultconstructor attribute
- will_paginate for asp.net mvc
- total number of records per week
- using import wizard to import excel data into table in sql server 2012 failing - text truncation
- unique index error when creating non-unique index - sql server
- sql server : cast within exec (dynamic sql)
- updating a column in a table having duplicate rows
- cumulative sum per item in db2
- access cassandra from spark "com.esotericsoftware.kryo.kryoexception: unable to find class: org.apache.spark.sql.cassandra.cassandrasqlrow"
- convert dbnull to string. record dbnull.value in database instead of nothing
- are the rows locked in order in a select ... order by ... for update statement?
- sql select set of records from one table, join each record to top 1 record of second table matching 1 column, sorted by a column in the second table
- how to check whether all records have the same value in a field?
- thinking sphinx ordering by mixing capitals and lower case
- creating a address database
- sql - oracle - selecting the first and last record for specific group/sku
- publish asp.net mvc 5 website to windows azure
- select only newest grouped entries
- oracle sql - dynamic case statement
- query for min, max, avg, and last value in tsql
- inserting data into a table that has a many to many relationship
- google compute engine lamp stack sftp,sql and https
- output the column name with the highest value
- calculate a running total with a condition in bigquery
- convert nvarchar to date and get data between two date
- sql: populating column b where column a has a match elsewhere in column b
- how do i write a sql query with a condition involving a second table?
- checking if the "system" falls between two dates in sql
- bigquery, fill missing values with linear interpolation
- informix 7.3 - declaring a date column data type with default as current date on insert/update
- how to lock some row as they don't be selected in other transaction
- how can i perform sql order by exposure, focal and iso (in numeric not string)
- sql compact 2008 connection string problem
- sql injection on badstore
- fill in missing values for joined tables in bigquery
- get numbers from string tsql
- self-joining query to find descendants of a node syntax issue
- find all slots in a given range [closed]
- azure function connectionstring for azure sql trough vnet
- sql query for returning the latest record for each id
- how can i create out parameters with raiserror in stored procedure?
- sql 2008 r2 - reporting services, using data model with report builder 3 over internet causes crash, any ideas?
- join two tables based on different column type
- query to pair interleaved start and end times
- sqlite3 "in" clause
- access 2007: querying for datetime field between two short date values
- is this query injection proof?
- is delta lake supported by spark2.xx
- mysql query for booking. how to allow two reservations on the same date (check-in/check-out)
- join with comma separated values in sql server [linq]
- how to select count of multiple columns
- sql server: data type "rank" in arithmetic operations?
- create more than one non clustered index on same column in sql server
- replace empty string in hive- nvl and coalesce tried
- xml to sql issue - how to get position of an element
- combine keyword search and tax query in wp_query
- oracle sql cross tab query
- column with same name in multiple tables causing problem in subsonic select
- linq does not lazy load if invoked via generic method?
- multiple left joins - how to?
- getting latest based on column condition in spark scala is not working
- how to get the last inserted id in a linq to sql custom sql expression?
- do i need to install sql server compact edition on all client's desktops?
- how to achieve "last. or first." using proc sql
- an alternative for "not in" in sql server
- sql server : create a column as an identity that repeats a pattern
- how to make this query also return rows with 0 count value?
- window moving average in sql server
- must declare the scalar variable "@mydivision_1"
- linq to sql with the where with case statement
- reporting services chart - hard coded series
- mysql - can't retrieve max value within a left join and 2 distinct select perimeters
- org.powermock.reflect.exceptions.methodnotfoundexception: - when mocking java sql classes
- how to append a string to where clause in apex interactive report sql
- pull sql data from two tables
- self-closing tags in xml in sql server
- sql server error: executenonquery: connection property has not been initialized
- comparing "consecutive" rows in ms access
- finding the 'earliest' composite primary key
- concatenate table name on update statement using mysql user-defined variable
- error 0x84bb0001 while installing sql server 2012
- how can we create a lightbox gallery with sql images
- disable and rebuild an index in hsqldb
- the instruction at "0x7c910a19" referenced memory at "oxffffffff". the memory could not be "read"
- oracle event count query
- datagridview to excel with colored cells
- converting linq2sql simple queries to compiledqueries to increase app performance
- how to find ascii of every character in string using db2 function?
- tempvar use in query
- match sections of sql connection string with regex
- linq-to-sql to search only date portions of a date
- getting date difference between consecutive rows in the same group
- sql server does not exist or access denied error
- how to efficiently query many-to-many relationship on two columns
- get sqlite3 database from disk, load it to memory, and save it to disk?
- order result form mysql group by
- ssis: script task to write recordset to file
- help needed in getting total resource count (sql server 2005)
- how do you view sql server 2005 reporting services reports from reportviewer control in dmz
- sqlbulkcopy - importing xml data into sql table
- sql creating a new column with previous dates in new column
- sql server bulk insert into temporary table syntax error
- is it possible to create user-defined data types when using ef 4.1 code first?
- how to escape one or more consecutive rows from table, inoutmode either 1 or 0
- kafka jdbc connect query causes ora-00933: sql command not properly ended
- how to convert a nested flatten into standard sql
- mysql: select previous month and month before
- select only one value per id - sql server [closed]
- can not execute sql server stored procedure
- parallel.foreach throws exception when processing extremely large sets of data
- mysql update whole database without downtime
- postgresql : how to update one field for all duplicate values based at the end of the string of a field except one row
- duplicate-key error in mysql triggered by count(*) on group by
- how can i get a list with sublists using one query?
- stopping sqldependency gracefully
- are inner join and outer join necessary?
- can i save result of a sql query in a property directly in ant
- how to implement custom linq provider for decorator?
- foreach loop container failed to traverse through all files in a folder
- parallel database calls with rodbc
- how to use 'for statement' triggers in postgres?
- how can i use "for update" with a join on oracle?
- how to generate the primary key in db2 (sql optimization)
- list tables in an msi file?
- join takes too long
- mysql world database trying to avoid subquery
- permission denied when trying to create database at a specified file location
- mysql convert string to date calculate age and order by age
- sql query to calculate hours spent from the the other day and ending up on the next day
- lazy evaluation of oracle pl/sql statements in select clauses of sql queries
- ignore skip/take in stored procedure
- build queries from table/column names stored in a table
- sql server 2012 potential race condition on select or insert
- transforming (synchronizing) data between sql to hbase
- jbdctemplate - preparedstatements with dynamic sql query
- how to filter app engine connections by host with google cloud sql second generation? (2nd)
- is there a way to easily convert a flat datatable to a nested .net object?
- how to convert densematrix to spark dataframe in pyspark?
- how to overcome "java.sql.sqlexception: too many connections" exception?
- does mysql allow two primary keys on one table?
- generate an update sql for changing the order of an item?
- runtime error 3001 'arguments are of the wrong type or out of acceptable range...'
- getting an error on website when multiple users access same page simultaneoulsy
- making `group by` result in multiple columns
- sql server ce can i delete top or only 1 record from table that matches my query
- flatten only deepest level in scala spark dataframe
- how to change the value of a global variable in a pl/sql package dynamically?
- pdo union with ? not working
- join multiple tables by multiple grouping
- variable for database link name
- storing and querying interval tree in postgresql
- group rows with that are less than 15 days apart and assign min/max date
- storing multiple values in one field
- how to use in operator in linq?
- fbsqlexception key size exceeds implementation
- update stored procedure not updating
- connection problem linux apache+php to ms sql server using windowsauth / kerberos ("no kerberos credentials available")
- oracle pl/sql package/procedure for processing csv from clob
- rails sql insert statements not showing up in console
- how to find the changes in records in sql server
- why is sort operation before nested loops (inner join)?
- displaying results fetched from database on interface (javascript/html/sqlite)
- pyspark - reusing jdbc connection
- why do i need to manually open this .net core database connection when usually dapper auto opens it?
- sql server cursor - loop through multiple servers and execute query
- import xml file into postgresql database
- traditional sql approach vs orm [closed]
- hierarchical data from db - to join or not to join
- sql server guid (from active directory) vs int
- how to include multiple commands in a jdbc sql query to oracle 10g?
- sqlite fuzzy duplicate search using like
- oracle how to partition data and get records at every 10%
- is there a library to benchmark my django app for sql requests?
- how do i get ef6 to generate efficient sql containing mulitple aggregate columns?
- rpostgresql cannot connect to the server
- generate and insert large clob (1 mb) using sql*plus
- how to return multiple result in the same query?
- how to search for rows containing specific words then return count of each word?
- sas - what is the sql language used in a proc sql?
- spark is taking too much time and creating thousands of jobs for some tasks
- write sql to identify multiple subgroupings within a grouping
- spark sql search inside an array for a struct
- how to read many tables from the same database and save them to their own csv file?
- count function on multiple columns by date (sql server)
- c# insert into sql table with list as parameter
- using sql server application locks to solve locking requirements
- query a json key in postgres json field
- how to setup single-code multiple-database asp.net saas application
- sql nth day of nth week of a month
- how to redirect python's subprocess.call methods output to a file and not console?
- do some calulations of the values in two table and store it in third table mysql
- to compare count between two hive table
- loading file from azure blob storage into azure sql database using bulk insert
- how to extract median value?
- sql: count each row value in a column and return count into multiple column
- mysql - max() return wrong result
- pass-through queries and linked table queries using different connections
- sql for deleting records which are duplicate(consecutive), but storing there min date in start date and max date as end date
- how to split time and calculate time difference in sql server 2005?
- microsoft access sql injection
- how do i access an out parameter in a pl/sql proc via hibernate
- get hierarchical data in mysql
- vs2010 database project deploy - "sqldeploytask" task failed unexpectedly, nullreferenceexception
- prepopulated core data sql store with new write-ahead log (wal) journaling
- populate dropdown from sql in classic asp
- how can i create user name and password protected ms access 2007 file from c# and sql?
- help creating a yql query to search companies
- how to work around unsupported unsigned integer field types in ms sql?
- % sign in java's preparedstatement
- mysql query to select -> insert and delete selected rows
- aggregating all values not in the same group
- migrating moss 2007 from sql 2000 to sql 2005 [closed]
- applying where clause for order by in sql
- dynamic sql query for matrix
- number of days between two given dates
- vb.net check if database value is null
- restore database in sql server 2005
- sql string in vba in excel 2010 with dates
- sql table comma separated values contain any of variable values checking
- uploading file from access to sql server with dao code - object required error
- use blob field as query parameter in sqlite
- storedprocedure in c#, passing parameters from text boxes
- jpa with google cloud sql "noclassdeffounderror: java.util.prefs.preferences is a restricted class"
- delete all indexes of specific database
- query a list of names from one table that appear in a field in a different table
- change lower case to upper (title) case using sql query
- how to monitor database updates from application?
- linked server setup between sql server express and sql server
- islands and gaps tsql
- create list of all days per month and split value equally to each day
- return count and data as json into extjs grid
- strange scripts generated by sql server when exporting a job
- how to replace string values of column values by sql stored procedure
- how to avoid or ignore sqlexceptions by schema.sql at spring boot app startup
- unsure of with check clause when adding a constraint
- efficient way to store large datatable into database
- how to retrieve data from database to word document . net
- best database design approach to join complex data to asp.net membership tables
- "explode" table returned by sql function into columns
- azure vpn to on-premises cannot connect sql server from azure web app
- why does sql_latin1_general_cp1_ci_as sort number-sign before underscore?
- change a cte select to a table value user defined function
- one large table or split into two smaller tables?
- how to update sql server table with data from other source (datatable)
- fill factor sql server
- condition on a timestamp column to select data for a year
- finding top 3 students from the student table and department table group by department
- subtract two rows of same table and sum the difference
- batch insert sql statement
- fill dynamic array with values from an array
- is it possible to left join two tables and have the right table supply each row no more than once?
- hierarchy query sql server 2008
- mysql setting default value to be items auto increment key
- failure to create table in sql azure database using smo
- how to query multiple tables at a time?
- connect local laravel environment to google cloud sql - mysql
- how to add attribute for all subnodes of the xml in sql
- mysql group by consecutive values
- select in using varchar string with comma delimited values
- sqlserver2016, hibernate schema-validation: missing table, but table exists in db
- mysql left join of three tables returns to many rows
- how to retrieve the auto incremented id using slick / plainsql?
- calculating follower growth over time for each influencer
- sql loader - how to pass data file as a variable?
- business logic in database layer
- select statement to always return 3 rows on execution
- getting count from 2 table and group by month
- linq to sql (ce) speed versus sqlce
- table column split to two columns in sql?
- find tables without clustered index but with primary keys on a table
- copy records with insert select, then update attributes in the same set of records
- can i send array of parameter to store procedure?
- hosting site asp.net mvc and sql server compact 4
- transform sql query results
- not in statement for visual studio's query builder for tableadapter
- putting together a tricky sql query
- begin...end blocks in sql server: is this code right?
- what is the easiest way to pull data from a blob and load it into a table in sql server?
- apache spark mllib with dataframe api gives java.net.urisyntaxexception when createdataframe() or read().csv(...)
- sqlcommand result - object cannot be cast from dbnull to other types
- keyword not supported: 'dsn'
- commit and rollback in c#
- how to rank mysql results, based on different values?
- how to generate date in sql query?
- modify a struct column in spark dataframe
- is the order of inserts specified for insert ignore ... select?
- t-sql: select related column data for the max two other columns
- export a sql database into a csv file and use it with weka
- wrong sql script generated for sqlite database by ebean in the play framework
- localdb in visual studio 2015 error 52 (sql server)
- split row into several with sql statement
- running sql file from vba
- using sqlalchemy on app engine development server
- addresses stored in sql server have many small variations(errors)
- how to read sql queries from properties file in mule 3.5 database connector
- temp tables on the current connection
- mysql first free number between exists values
- design pattern to convert tree-rules from weka into sql query
- stopping duplicate of printing name of user php sql
- how to insert a query result into a column mysql
- how to get last modification datetime on sql server 2005?
- sql: get records that satisfy conditions coming from multiple records
- sql server: multiple index for the same columns performance
- vba sql string run-time error 3075
- connect sql server on button click vb.net
- join multiple tables, keeping nulls
- linq to sql join and sum
- ruby rails complex sql with aggregate function and dayofweek
- delphi ems firedac: cannot open dataset [fdmemtable]
- how can a sum of a column in sql server where values are 2 decimal places result in 0000000000087?
- oracle, connect by rownum
- azure - data not showing on easy tables
- how do i automatically insert monthly records into a table via sql?
- order by join column but use distinct on another
- sql server datetime
- how to implement a bidirectional unique index across multiple columns
- sql server linked servers
- sql : using the target table in an update statement in a nested from clause
- oracle - cursor using dbms_utility.exec_ddl_statement not executing properly
- do azure easy tables support relationships?
- cancel sql statement with jdbc
- how to get a value from stored procedure
- union causing an ora-01790: expression must have same datatype as corresponding expression
- how to update table with sum() and count() in same table to different columns
- create and use temp table in nested queries
- enumerate in postgresql
- combine rows in bigquery ignoring nulls
- how to sum time from a datagridview columns
- making query to find nearest multiple(lat,long) from the single(lat,long)
- access 2007 file picker, replaces all rows with the same choice
- sql query to conditionally retrieve records based on a key value list
- sql to generate periodic snapshots from transactions table
- system.data.sqlclient.sqlexception after create/alter/print
- update or delete first then insert
- should we delete datalake analytic job after completion?
- invalid data conversion: parameter instance 50.0/100 is invalid for the requested conversion. errorcode=-4461, sqlstate=42815
- retrieve previous row to subtract from current row by date
- sum up the data from today specific data to the next day data and the rest of the data
- create a list of the alphabet via sql
- retrieving xml elements from xmltype oracle
- sql script command line arguments
- sql - performance in varchar vs. int
- trigger to delete rows from related tables before deleting rows from actual table
- storing 'point' column from shapefile
- transposing columns to rows using unpivot
- how to repartition a dataframe in spark scala on a skewed column?
- instance servername sql server 2012
- how can get obj between two date range for each date
- store multiple email addresses in database for different user types
- generating sql script from mysql database table
- sql server equivalent to using for a join to avoid duplicate columns
- delete huge number of rows from an ejb timer
- how do i display fields in sql vertically instead of horizontally
- use managed identity to authenticate azure app service to sql database
- use invoke-sqlcmd and return number of rows deleted/affected
- asp.net gridview throws: the version of sql server in use does not support datatype 'date'
- how to store array or blob in snappydata?
- how to fix postgres-utils eval() error: missing from-clause entry for table "foo"?
- how to import xml files into sql table with their column names?
- grant permission to all operations with database
- monthly snapshot using date dimension
- why i can't call a function inside a linq query?
- like operator, n and % sql server doesn't work on nvarchar column
- google app engine and sql like
- retrieve avg temp by month using bigquery?
- django query: count and group by
- how do i assign group id's from one table to rows in another based on datetimes being between start and finish datetimes?
- format sql server 2012 time(7) to "hh:mm"
- how to get multiple column data in a comma separated string?
- comparing date with string entity framework
- select row from left join table where multiple conditions are true
- how do we control dynamic ordering by a field in a table?
- sql query using redbeans php
- creating dbcontext with both custom connectionstring and dbproviderinfo
- string to date - hive sql
- how to inject sql in login process
- convert multiple rows into one row with multiple columns
- python - sql connector: update do not work
- exporting db objects for version control
- mandatory field mysql
- how to find what products sell well with others in an sql server query
- help with or logic in linq lambda query
- mysql tables, error #1064 & error #1068 multiple primary key defined [closed]
- update varbinary(max) column
- rails 3.1: sqlite exception
- executestorequery passing parameter to sql statement
- transforming spark sql ast with extraoptimizations
- how can i get results from a jpa entity ordered by distance?
- mysql query to count items by week for the current 52-weeks?
- retrieving column names and data types in plsql
- sql query to search in a concated string
- spring jdbc template. how can get outcome variables of the pl/sql script
- check if date falls between previous row start date and end date
- how to convert an sql server blob string to system.drawing.image?
- how can i track the source of slowness for my scenario?
- auto generating dates based on a table
- get most recent price for each item
- how to ignore rows with moving 30 day interval?
- imported failed: cannot convert sql type 2005==> during importing clob data from oracle database
- performance optimization of query using xml.modify() in sql server 2008
- sql commands not compliable by h2
- cannot connect from android to sql server directly
- distinct on query w/ order by max value of a column
- basic syntax on for update cursor
- how do i create a foreign key in access?
- why does this query only select a single row?
- python postgresql sqlalchemy query a daterange column
- create a row for each cell that has data from multiple columns
- is there any way i can speed up the following insert(s)?
- sql statement from dml trigger
- parameters fdquery delphi does not work
- can i switch the 'connected' user within an sql script that is sourced by mysql?
- migration from google cloud sql to datastore
- how to group datebase records into 15-minute time intervals
- how to check and change custom string in sql server
- apache scala/python spark 2.4.4: group data by year range to generate/analyze new feature
- how to calculate compound interest with varying interest rates in sqlite
- sustract two queries from same table
- parse json root in a column using spark-scala
- pass html dropdown value to jstl sql:query
- hibernate or hsql does not respect column length
- sql server clr : how to call wcf service in clr sql stored procedure in database project
- ora-22054 underflow error
- windows batch file to backup sql database
- count combination of columns in postgresql matrix
- sql query to find a row with a specific number of associations
- replace the xml element with new element in sql server
- asp.net mvc : using the same database for entity framework and asp.net membership
- how i get all month from date form sql?
- access is re-writing - and breaking - my query!
- deleting part of a string in hive
- accessing infomessages for sql server queries in c#
- how to get values for same column name from two different tables in sql
- datagrid row selection and printing its data
- handling objects being different for different sql server versions
- connection string problem connecting to local sql database using vb.net in visual studio
- split a row based on a column value
- sql insert...select with auto-increment datetime
- create schema using struct in spark scala
- using jtds to connect to sql server 2012 availability group listener
- compare phone numbers without considering any format in linq to entities and check performance as well
- recover updated data - sql server 2005 [closed]
- how to set network security group rules for azure storage services?
- update a field of an existing table with auto increment logic
- how to get unique values from all columns of a table in sql server
- how to convert between time zones in sql server 2008?
- merge statement for stocks using three tables
- mysql query to calculate percentage of total column
- how to know if insert query succeeded in stored proceedure?
- custom queries in mvc 4 / entity framework?
- python - dynamic variable in redshift sql query
- how can i connect to a sql server compact 3.5 file as a data source in visual studio 2012?
- is concat_null_yields_null sql a persistent runtime setting? (server 2000 and up)
- is it possible to execute a query for each database in mysql databases and sum or combine results using only mysql command environment?
- mass delete unpopular tags
- ssdt - track database changes from dacpac deployment
- adding grand totals in pivot table
- how can i lock a table for read and write so i can execute sql and then remove the locks afterward?
- sql inner join multiple tables not working as expected
- how do i get to the bottom of this linq to sql error?
- how to properly group by in mysql?
- reading ms access using ado.net
- merging two tables in sqlite from different database
- conditional compilation of schema objects in ssdt project
- how to get the last week date from sunday to saturday
- remove duplicates from pyspark array column
- get sql server job status
- sql server - stored procedures slow vs "giant" script
- get max and min values of each rows in sql server
- sql syntax error 1064
- t-sql: split and aggregate comma-separated values
- windows forms vb.net - populate treeview with hierarchical data
- why does added rand() cause mysql to overload?
- how to write hibernate criteria for this sql query?
- sql syntax error when trying to insert new record into access database
- can i use if in pl/sql?
- select case cast conversion error
- write a sql for searching with multiple conditions
- count grouped gaps in time for time range
- cannot add foreign key constraint on a date field
- errors declaring variables in stored procedure?
- spark filealreadyexistsexception on stage failure while writing a json file
- what is reason for following sql code couldn't insert data?
- select column value that matches a combination of other columns values on the same table
- sql statement to create a table as a result of a count operation?
- rails group a table by :created_at, returning a count of the :status column, and then sub-group the :status column with count of each unique value
- sql return rows if matches keywords
- sqlite query select all records that does not exist in another table
- moving large sql query to numpy
- order by char column numerically
- mysql: on update cascade for a simple table "id|parent|text", not possible?
- how to map type table of varchar2(5) in java?
- select max date, then max time
- is there a "appears in all" (set division?) operation built into mysql?
- scala/spark - how to get first elements of all sub-arrays
- oracle issue with reporting sql
- how to query sql server database size
- help with a three table linq query
- order versions as numbers
- showing trigger dbms_output.put_line in oracle apex
- sql column names and comparing them to row records in another table in postgresql
- execute sql*plus from powershell
- coldfusion: dealing with null values in date field
- bigquery window order by is not allowed if distinct is specified
- web api error: "cannot insert the value null into column 'id'
- google chrome extension - webdb or indexdb
- firebase leaderboard, best implmentation. sql joins and orderby
- insert into mysql database, if records already exists, then update
- failover partner behavior for sql connectionstring with connectiontimeout
- search based on matched criteria
- speed up linq to sql with compiled queries
- import from excel to sql table
- conversion failed when converting the varchar value 'n' to data type int
- (python) cursor.execute(sql)
- enforcing unique date range fields in sql server 2008
- c# & sql server ce : treat words after defined symbols (+ or &) as a seperate word in search
- how to find gaps of data and insert null data points instead having gap
- how do i write multiple conditions in single sql query to get data - python mysql
- sum values of an inner join and many left joined tables
- sql query to calculate remaining running balances based on a given conditions
- sql server sync to mysql program
- how do i sql export table structure and data to firebase?
- mysql strict select of rows involving many to many tables
- calculate difference between two dates with timestamps in laravel
- transpose / pivot rows to columns
- storing time and dates into an sql database using php [closed]
- oracle pl-sql how to split a string and return the list using a function
- sql server query multiple aggregate columns
- use my sql to randomly select exclusive records
- how to update a specific field(column) of a row by that row's autoincrement value with some prefix in mysql?
- users, groups and tags database design
- what is best tool to compare two different database ,the first database is ms sql and another is db2
- getting error while converting a string to datetime in derived column
- how to add and subtract value from previous rows based on condition
- select parent and child from the same table
- which column for foreign key: id or any other column and why?
- sql to linq conversion with not in
- using "in" statement for stored procedure parameter sql
- how to update in sql to get distinct tuples / not to violate a unique constraint
- how do i convert sql's convert(varchar,datefield,106) to linq?
- pivot the results of a stored procedure?
- pyspark: how to update nested columns?
- sql - parsing a query
- what is the best solution for sql injection security on mysql?
- check duplicate entry before inserting into sql server
- unknown column {0} in on clause
- update sql table from values in excel
- on ms-sql server, what is the best tool to get all the dependencies between all the objects? [closed]
- looping updates - better way to do this?
- why is this procedure generating two emails?
- node.js / edge.js - insert js variables into sql
- oracle "order by" clause returning results in wrong order or with results missing
- sql server: combine multiple rows into one row from a join table?
- how to convert nvarchar m/d/yy to mm/dd/yyyy in sql server?
- invalid instance when using adodb.recordset
- how to add to where clause depending on parameter value
- oracle merge: only not matched is triggered
- sql query for date range, multiple start/end times
- talend: how to import this csv file in sql?
- table specified twice in procedure, how to fix?
- why can't i apply a criteria on a sub-query?
- sql select statement from both tables
- oracle select dates for items sold within 1 minute of each other
- how to get multiple columns from one column, sql
- sql server: look for nulls across all columns
- can using multiple json_value-s in mssql query harm performance
- how to convert time to date in the local timezone during query
- how can i change a mysql column from varchar to date time and convert the data at the same time?
- is or is not 'for xml' supported in sql azure
- i cant see sql queries in mysql stored procedure!
- auto number fields
- iterating through pl/sql result in shell
- calculation in two columns of different row in sql
- proper way of updating sql server table using access front end
- how to save current date and time to database using java?
- can not bind to datatable with no name error while filtering a gridview
- using merge statement for single table
- is a half-written values reading prevented when select with (nolock) hint?
- multilevel nested product categories display with asp.net and sql server?
- multiple sql queries in nodejs
- how to create category and list in one query with linq
- return data from jquery $.post
- how to execute this sql query using ado.net?
- connection string formation for android to sqlserver connectivity
- stored procedure in pl/sql to insert new record in table
- using doctrine 2 with sql server
- how to automatically escape strings in a php sql query?
- tsql in not working properly if passed as parameter
- finding unique users from linked values
- multiple cumulative sums
- filtering results based on most common occurrences of values in other columns (excluding outlying values)
- connecting a google cloud sql postgres database to google data studio
- select all table/view names with each table row count in teredata
- running recursive query in vertica
- oracle pl/sql procedure requires authid current_user for execute immediate with ddl
- count of students in each class while listing class names [closed]
- how to extract xml value field with in sql server ( extractvalue function in mysql )
- populating treeview using linq
- sql sum and count returning wrong values
- how to append eof to file using perl or python?
- c# select clause returns system exception instead of relevant object
- null pointer exception when trying to use persisted table in spark streaming
- how can i detect if a row was inserted into the database x seconds ago
- how can i get the most recent date in sql?
- oracle sql : procedure which can create temporary tables inside it
- postgres dynamic sql and list result
- from clause in rodbc quotations - sap hana
- group rows based on column sum value
- sql server : how does the replace function work as its acting strange for me
- drop foreign-key constraint
- spring jdbc template- how to retrieve multiple result with multiple parameters with a single query
- evaluate select clause embedded in each row
- tsql passing multivalued reporting services parameter into dynamic sql
- how to insert value to table using cursor in stored procedure without getting duplicate records?
- run express service and angular 6 app in parallel
- how to set a function as a default value in sql server?
- sql query to generate monthly pay dates within a date range
- how could i return all records from a stored procedure?
- comparing time in sql server through hibernate
- clickhouse join with condition
- how to setup connection to hive using pyspark and sparksession (how do i add username and password)?
- how do i change datatype of an imported spreadsheet in mysql?
- how to setup sqlite join on variable column data
- how to compare groups of tuples in sql
- passing value to one table and updating in parent table
- chrome extension: webql database is not appearing in inspector
- oracle group using min date
- sql server: check references when altering function/procedure signatures
- ssrs bids summing a sum to produce a sum
- sql parameters inside a loop
- how to establish a many to one relationship between 2 tables for a field
- java: insert into inside a loop using result test
- ms access sql to get the average of two records
- sql query that groups by sets that are unknown when the query is run
- how to make wpf apps on same netwrok read data from one sql server?
- read text file content and insert it into a mysql database
- apply join like sql to get data from multiple collections - firestore
- split json value from csv file and create new column based on json key in spark/scala
- mysql join two tables sum, where and group by
- create a new table from a select?
- remove nested column in pyspark
- cursor in a trigger
- auto increment in temporary table
- setting up ssrs server with alternative to anonymous authentication
- help building a sql query from multiple tables
- why does oracle 12c query require double quotes around table
- sql udf and query optimization
- group by records based on 10 second time interval in sql server
- one sql server instance, two server names
- transaction with loopback linked server - locking issues
- insert data from a dataset to an excel table in a worksheet using powershell [closed]
- how to handle sql transaction in this scenario?
- what is the best way to generate xml from the data in the database?
- can i use regular expressions in usql?
- the column cannot contain null values. sqlce exception
- your reasons to store blobs less than 0.3 mb in database?
- sql server what to do to make collation key from a string value
- pyspark dataframes: filter where some value is in array column
- how best to block multiple "counts" on a counter?
- sql - break a start/end time into 15 minute records
- ms access error: 'at most one record can be returned by this subquery'
- what is the tablecontroller class for and where are its methods used?
- is there a tool to generate database schema from xml schema? [closed]
- how to use substring and patindex in sql server
- using enterprise library's executesprocaccessor method with generics
- update httpresponse every few seconds
- ssrs subscription file name w/ date
- how to call sql statements from a php function
- why is my result duplicated when using subquery?
- oracle sql: additional restriction causes performance issues
- how to use oracle pl/sql to create ten similar tables from a given oracle source table
- mysql, using unique table names vs using ids
- how to pass sql array values from java controller to scala template
- update case when sql query to vba
- what is a good idea to save "chat" data in database?
- fine-tuning a geospatial index
- handling dates in derby within query
- how to format a column in spark dataframe
- check constraint to make sure values in a character column are all digits
- what happens after inserting data to a table with default clustered index in sql
- issue about xss attack and sql injection
- how to link and odbc table to ms access database using vb and without connecting to the server?
- sql server 2012 slower than 2005?
- how can i add variable count of sqlmethods.like() in one query?
- fill data grid view from sql table
- datetime convert in sql
- select distinct values based on a column with maximum date value from second column
- certificate-based authentication in sql server
- utf-8 support, sql server 2012 and the utf8string udt
- sqlite3 run sql - select all with pua characters
- file uploads in a non-apex pl/sql application migrated to ords
- get row number of random records
- sql server : how to make query from xml file
- visual studio (ssdt) 2017 unable to start debugging
- check authentication mode of sql server
- create a mysql function while installing a component
- getting org.hibernate.hql.ast.querysyntaxexception though it works fine sql server?
- creting udf function with nonprimitive data type and using in spark-sql query: scala
- how to find duplicate field combo
- sql - where clause with join
- sql - how to tell if a date is the last day of the month?
- using having with count to restrict results
- mysql to check room availability in a hotel for a particular date and time duration
- sql query ...multiple max value selection. help needed
- select rows in a self-relationship where all children meet a condition
- sql for xml: how to avoid a specific field is output as attribute?
- building and deploying works, but not running
- using linq to group a table that contains substrings
- is it possible to call functions and stored procedures of one database in another database- azure sql server
- sonar + ms sql database
- ms sql 2005 can't compare dates
- how to order entities with parent/child relationship together in a list
- change username programmatically when connecting to a sql server using windows authentication from a delphi application
- aggregate value in different rows
- formatting in pymysql multiline statement
- combine multiple record types in ssis data flow
- why is this stored procedure inserting null values into the table? [closed]
- complex mysql query is giving incorrect results
- mysql: error 1628: comment for table 'customer' is too long (max = 60)
- raw sql vs oop based queries (orm)?
- how to generate series for date range with minutes interval in oracle?
- how do i tell entity framework to allow sql server to provide a defined default value for a field?
- delphi seattle firedac.phys.mssql not found
- how do i install a sql server on the hosted build agent in visual studio online?
- how to create copy of database using backup and restore
- i need to call another sql file within an sql file using sql plus
- problem in removing hardcoded values using temp table
- running the script, made by generate script on different server gives error
- how to turn on/off cloudsql instances using python3
- oracle - how to force user to insert multiple row
- i would like to set the default value for a column to current time + 6hrs
- oracle: using ctes (common table expressions) with pl/sql
- select a post that does not have a particular tag
- how can select random data from database and display in textview?
- mysql: limiting rows per wherein()
- batch orientdb sql in php
- error with dynamically created sql insert statement
- teradata: how to add range partition to non empty table?
- check which ids from a set do not exists in a table
- how to append points to linestring sql
- mysql like issue on partial match
- what percentage of users participated on each day (sql query)
- why synapse is not working with my query?
- sql server csv exports using sql server agent & powershell?
- preventing double bookings in sql
- checking if a number is greater then or less then using slt and branching using mars
- list number of duplicate values
- how to find specific links between two tables
- updating 1 million records in oracle db as batch of 10k;
- how to store date in unix millisecond in mysql?
- replace null varchar fields with empty string for whole db
- sql - message schema - need to find an existing message thread given a set of users
- web api entity-framework parent child posting to sql database
- error: duplicate key value violates unique constraint in postgres
- max pool size was reached error for parallel connections
- sas proc sql --- how to do listagg function in sas
- how to retrieve column values separately through sql data adapter class?
- speeding up postgresql queries (check if entry exists in another table)
- how to insert records based on the previous insert?
- split date range to year-month rows on sql server 2005
- sql child relation query help
- json_encode returning the next rows values - php pdo sql highcharts
- update and select in a single query(continued)
- redirect output of one recursive query into another recursive query
- setting mysql unique key or checking for duplicate in application part?
- c# databases for wp7, pc and xbox
- executing ssis task from c# application
- is it possible to import data from sql to marklogic
- custom errors in mysql trigger
- group by date month multiple tables
- how to join 3 rdd's using spark scala
- parsing/processing xml and inserting into sql tables
- conversion error from date time to string format
- insert into two sql tables from xml maintaining relationship
- symfony and doctrine 1.2.2: how can i get the sql clause of a doctrine_query object?
- scala - how to substring column names after the last dot?
- sql query for insert into with update on duplicate key is error
- how to using for loop using xquery to delete xml nodes
- sql bcp with column name
- equivalent of excel’s networkdays function with jet ado
- ordering date (dd-mm-yyyy) in sql using google bigquery
- 'percent_rank' is not a recognized built-in function name in sql server
- hibernate-4 show sql code that is generated
- how to pivot table for year in sql?
- pl/sql update values using dup_val_on_index
- convert empty array to null pyspark
- mysql workbench cannot connect to local mysql service on mac osx
- sql server: how to do 3 months' partition?
- formatting data for spark ml
- avoiding 'sort order by' in query plan
- quicker way to export sql tables into separate pipe-delimited files?
- get first record in group by result base on condition
- how to sum of particular column with month and year wise
- build an sql query for all enabled products in magento database [closed]
- select into #temp table got an error
- get comma separated values from xml data
- exporting pdf's from sql server db and writing a map to a text file
- ubuntu under ad domain controller: unsatisfiedlinkerror: no mssql-jdbc_auth-8.4.1.x64 in java.library.path
- select max value of each group including other column
- how to recover service broker after restoring database?
- why is my t-sql query returning inconsistent output?
- asp.net impersonation and sql server trusted connection calls
- codeigniter and odbc connections
- vba - sql server 2014 - how to access localhost - windows authentication
- how to do regex html tag replace in sql server?
- compound primary key table with subtypes
- databaseerror : “not all arguments converted during string formatting” when i use pandas.io.sql.to_sql()
- linq to sql: data from two unrelated tables, sorting on date
- sql querying a customer id who ordered both product a and b
- date time conversion problem when inserting data into sql database
- vb.net sql statement to query 1 yr old timestamp
- entity framework and differences between contains between sql and objects using tolower
- how to pass value between user control in asp.net c#
- how do i execute a sql statement with parameters in servicestack.ormlite?
- stored procedure performance issue
- is there a way to visually display a database view in a database diagram?
- t-sql a problem while passing csv string into a stored procedure
- how to partitioning a table using a like criteria in mysql
- generalized pivot table with deep sort in google bigquery
- is it possible to cast a sqlquery results from ebean to a model (bean)?
- displaying image from sql server in crystal reports
- how to calculate opening and closing quantity balances sql server
- is a table-valued function updatable
- creating my custom unique key
- oledbconnection source variable in c#
- sql query on a time series to calculate the average
- varchar(max) datatype odbc mapping to ms-access2003
- how to get the nearest date match in php from a sql database
- transposing rows into columns based on a condition sql
- how to trap an error and save error detail in database and redirect to custom error page in classic asp?
- what could be the cause of "java.lang.illegalstateexception: get field slot from row 0 col 0 failed"
- defaults using getdate and dateadd are not working
- php/mysql:rank users by clicks
- create dynamic where in sql sp
- dynamically "pivot" rows into columns - sql server
- extract blob data from access via vbscript
- handling quotation marks in sqldf
- oracle. preventing merge subquery and main query conditions
- is there a way to load multiple text files into a single dataframe using databricks?
- recursive cte in h2: no data returned
- insert/update on single button
- how to change from sql server windows mode to mixed mode *using sql* (sql server 2008)
- database row lock during multiple transactions
- how to count same field twice based on a boolean?
- case statement with datediff and datepart
- sql turning values returned in 11 rows into 89 total columns
- detect and delete gaps in time series
- mysql combine view of two table having different number of entry records
- getting unknown characters from azure sql server databases when storing arabic language text
- include rows with 0s or nulls in the sql query output
- execute sql from python: format the result set
- sql calculation for finding time difference
- how to form a sql query dynamically based on the input field values
- sum hours from timestamp
- get tabular as well as json column in a t-sql query
- cumulative include records in stored procedure output based on a number of bit parameters
- trying to use table aliases in sql
- sql script to drop old versions of stored procedures and functions
- create a date from credit card expire in mmyy format
- entity framework on different database
- mysql: default value of column from another table column
- how many constraints can be given to a column of a table in sql server
- how to return a redundant row for duplicate id in single row in oracle
- use email address that is stored in sql table to use in difference aspx pages
- insert time with timezone daylight savings
- connecting to amazon rds using mysql workbench
- entity framework dynamic lambda to perform search
- how do i use java to read a .csv file and insert its data into sql server?
- how to write a bat file to execute the .sql file
- using sql rank() for overall rank and rank within a group
- how to best retrieve the most recent previous record for each record
- how to monitor all the executed sql statements as a result of single transaction
- reference stored procedures for all databases in server
- how can i identify which rows in a table have met a certain condition, but the condition is based on data in previous rows? example provided
- how to set a database integrity check on foreign keys referenced fields
- logically impossible to fetch this particular string.?
- how can i connect to local sql server if mssqlserver service is missing?
- spark: access rdd inside another rdd
- subselect sql query doesn't work on mysql 4
- application crashes with assertion failure message while updating sqlite database
- how can i update all empty string fields in a table to be null?
- how do we get last inserted record in msaccess query
- insert file into access table
- inserting node in xml using sql
- mysql select query for getting current user post and followed friend post
- picking dynamic values from html form and store in php varibles
- date format and sql query clarification
- mysql: split varchar value and insert parts
- remove quotation marks on all rows in a column
- how do i find a gap in a sequence in postgresql?
- sum multiple row date difference mysql
- appending rows returned from different queries into one
- using @declare in mysql 5.1
- how can i query table within table?
- extract a specific json structure from a json string in a spark rdd - scala
- merging data from 2 tables
- what is exactly "some / any" and "in"
- sql index - difference between char and int
- sql extract substring
- sql server dynamic pivot with dynamic fields type
- mysql auto-increment a column with one specific primary key
- convert decimal <--> binary with t-sql
- how use "like" and "%" to check similarity to variable in android(java code)
- display recurring dates from sql database using php
- how to get type of a column using dacfx api?
- sqlite- normalizing a concatenated field and joining with it?
- sql join statement with where clause
- sql query select from table and group on other column
- fortify flagging query as sqlinjection when passing in parameters to a method
- geolocating a large number of posts based on ip addresses. (880,000 rows)
- validate datetime string in sql server 2005
- oracle sql - create string by concatenating rows but does not exceed x number of characters
- dumping sql queries to the screen in laravel
- determine the hierarchy of records in a sql database
- how to save the path of the sqlite image and then retrieve it?
- ora-00936 when using date function in the oracle select statement
- pl/sql function return custom type exception
- sql server reporting service url asking for credentials but not responding after that
- org.postgresql.util.psqlexception: error: syntax error at or near "("
- pass multiple values in one parameter in sql server
- group by and exclude minimum and maximum from results
- sql count grouping by a sequence of numbers
- oracle how to load a picture into a blob column using sqlldr
- how to query microsoft access database fields from vba in excel
- get user posts and/or comments in a sharing blog using sql
- how to update multiple duplicates with different values on the same table?
- how to split the comma separated string with out using loop in stored procedure
- convert lines of json in rdd to dataframe in apache spark
- how can i connect to a database on a remote server in a background thread?
- how to display multiple rows, as one row, without using a max aggregation
- using web.xml to get jstl sql datasource?
- create a stored procedure to find out employees who has overtime from timesheet table
- how to get the name of a document in alfresco with sql?
- insert data using powershell
- how to include the groupby() elements in select() in linq to sql query
- refused my local machine sql connection for 1433 port
- replace duplicate values only in consecutive records with null
- linq: dynamic where with generic property and value
- can i figure out a list of databases and the space used by sql server instances without writing sql queries?
- phpmyadmin sql error unrecognized keyword near fields
- spark dataframe - replace tokens of a common string with column values for each row using scala
- populate sas macro-variable using a sql statement within another sql statement?
- how to transpose rows to columns based on time intervals in mysql
- how can we parse a tilde delimited column in sql to create several columns?
- xml parsing in stored procedure
- t-sql select query to return combined result of multiple tables
- writing a single query for mutliple queries with same where condition same table
- aws lambda - unable to connect to sql server rds in vpc
- left join with empty rows from right table mysql
- sql syntax problem and or code problem? "index was outside the bounds of the array."
- comparing values between 2 tables across month field sql server
- django models - select distinct(foo) from table is too slow
- how to use ssis api to read a package and determine task sequence from code (precedenceconstraints)
- display varbinary as a downloadable link
- how to pivot rows in a table with condition?
- open xml insert in temp table - sql 2005
- checking if table exists keeping connection open in sqlite
- reversed query sql
- get distinct values from each table and each column with sql server
- how to design a sql recursive query?
- data should get replace as per lookup table
- spark sql doesnt let me create a table, complains about default metastore directory
- how to join 2 tables in sql server 2008
- google calendar with sql server db
- generic suggestions for sql 2005 framework\design and implementation
- postgis extension not installing
- update multiple rows mysql
- how to get column value which define in another table
- function syntax error
- bulk insert multiple xml files with ssis 2008
- rxjava alternative of group by in sql
- azure logic app with condition
- sql: join with an equal key and nearest key (similar to pandas's merge as of)
- how do i pivot this in t-sql?
- sql max/min query and data transformation
- efficiently joining/merging based on matching part of a string
- sql server -- improve speed of cursor
- querying based on a set of named attributes/values
- incorporating custom select clause in activerecord query
- mysql having clause return empty set?
- rewrite t-sql from using in to using join/where
- azure data factory get metadata to get blob filenames and transfer them to azure sql database table
- sql query doing strange thing
- some part of your sql statement is nested too deeply
- what is the best way to run sql agent job using c#?
- mapping relationship -- foreign key or mapping table
- new column to calculate overtime
- how to process an integer list row by row sent to a procedure in sql server 2008 r2?
- pyspark how to iterate over dataframe columns and change data type?
- return single column with linq
- exception: system.invalidoperationexception trying to validate a login information
- mssql 2008: get last updated record by specific field
- how to assign current date with specific time to column?
- traverse through loop to find repeated names
- adding column-name dynamically in alter table
- how can i continue execution of the current block after an insert failure?
- how to solve concurrency insert issue in sql server stored procedure
- error while inserting data having single quotes between it
- very slow connection to sql server 2005 only if using ado.net with sqlclient
- getting min and max value of a column and other column values
- google apps script get textbox value insert into database
- deterministic scalar functions
- postgresql table same data last adjacent occurance and first in one row
- tsql union in while loop
- sql: add a new column based on case expression and looking up values from another table
- update a password if user name and old password match
- using qsqltablemodel to display an sql view
- sql-server primary key (id) does not increment correctly
- sql order address by house number
- how to improve performance of updating data using jpa
- sql picking same entry multiple times
- sqlite field with a list of foreign keys
- how to join several tables?
- data grouping according to relevant values in sql server
- delphi - tupdateobject versus onupdaterecord for a join sql statement
- why did my visual studio 10 stop using app.config for my sql connection string?
- fill observablecollection directly from sql server
- pass list of strings to a stored procedure
- how to find rows>columns combinations with cross join? [sql]
- sql developer 4.0.2 install on windows 7 64 bit
- android spinners, say i pull spinner selections from sql, can i also add their sql _id's to the spinner values?
- sqlite (android) : update query with order by
- writing sql statement update query fmdb
- concatenating a column within the same column in sql server
- sql server transactions: insert causes locks?
- how can i match employee ids from 2 columns and group them into an array?
- how to update row data fetched using atl ole database in c++ from simple sql server table
- how to split a column into multiple columns in mysql
- how can i run grocery with sql server?
- create a multicolumn index to enforce uniqueness
- in clause versus or clause performance wise
- sql changes disappear after vs restart
- migrating to azure sql (bcp)
- multi line chart
- how to join two tables to get the following result?
- this type of clause was previously parsed
- report showing no data when uploaded to crm online
- convert comma separated string to sql table in sp
- select between two date
- how do i get id of a record without submitting and re-querying?
- how to have database name as variable in an sp?
- sql server dynamic columns creation
- how to insert subtract of each two subsequent rows and inserting it into a new column
- sql error with "turkish_ci_as" and "sql_latin1_general_cp1_ci_as"
- inserting values into a table based on column values of another table
- connecting python 3.3 to microsoft sql server 2008
- connecting to cloudsql from app engine (second generation cloudsql) go
- how do we check if an element in the array exists and if it has a value of "true" in presto
- azure mobile app using existing database
- select latest timestamp record after a window operation for every group in the data with spark scala
- unnest arrays of different dimensions
- sp_msforeachtable - parsing of dynamic sql
- iterate though columns of a spark dataframe and update specified values
- pass a column as parameter to dateadd in sql server
- how do i select a row based on a priority value in another row?
- mysql update timestamp on row update, even when all other row data remains the same?
- plsql block to get the dynamic sql query result
- pl sql output in hackerrank
- how to list all pairs of location with same area from the table in oracle?
- how to use backup with triggers in sql server 2008?
- select id from table where it does not match id in another table
- linq to sql many to many int id array criteria query
- select two columns from same table with different where conditions
- why is this mysql query so slow?
- sql server generate data using regex pattern
- convert char field to date field and remove time from the field name
- prevent sql injection in oracle
- display all data in a table from sql in asp.net using c#
- list of date + hours between two dates
- how enable all constraint?
- how to compare multiple values in one column against a delimited string in a stored procedure
- mysql searching for id in array from db
- left outer join with date range cte not working as i expect
- link all ids from associative entity that have common id
- restore a database from multiple .bak files sql server 2012 [closed]
- how to set security on login page in asp.net
- passing object[] to sql query
- bigquery-flatten the table using standard sql
- mysql - search for formatted conbinations of column values
- mysql limit collapse, which result in data interaction
- varchar date time comparison issue
- flask / sql alchemy raw query instead of class method
- ora-00927: missing equal sign
- mysql : select records with conditions that applies to multiple rows
- avg() not accurate in sql server
- when i am trying to save the data to mysql, an exception is being thrown( java.sql.sqlexception)
- error code 13 in mysql on unix. can anyone help me?
- error: invalid attempt to call read when reader is closed after the while loop?
- postgresql with function wrap sql so slow?
- oracle: how to find date of last friday of the month
- sql sysdatetime and sysutcdatetime
- how to set a column alias as the result of a sql query?
- pivot the date column in sql server 2012
- sql query to transpose column counts to row counts
- sql query to fetch output using table variables & join
- how to take column backup for a table in mysql [closed]
- select values between start date and end date
- fetch history of records
- the database cannot be opened because it is version 904. this server supports version 852 and earlier. a downgrade path is not supported [closed]
- sql complex dynamic pivoting
- return select statement as formatted html (sql 2005)
- how to add a primary key to all tables in sql server?
- i need to join 2 databases, with 2 tables each
- converting the results of a column into a single row [closed]
- sql oop problem : too many actual parameters on output
- filter the output of a query with row from another table
- query to show stock based on previous transactions
- why is this sqlcecommand executereader call failing?
- inserting a multiple records in a table with while loop [closed]
- selecting distinct values from multiple column of a table with their count
- how do i join on multiple columns in sql server and include columns in one table that aren't present in other tables?
- variable value assignment using returning clause
- how do you drop a default value from a column in a table?
- control flow in t-sql sp using if..else if - are there other ways?
- sql string value spanning multiple lines in query
- "not supported for dml operations" with simple update query
- linq take() question
- how to convert blank into null in ssis
- why doesn't vfp .net oledb provider work in 64 bit windows?
- select value if condition in sql server
- check if a column contains text using sql
- sql select distinct top 2
- why does sql server 2000 treat select test.* and select t.est.* the same?
- linq-to-sql error: 'int[]' does not contain a definition for 'contains'
- execute a stored procedure as another user permission
- arithmetic overflow on column sum in sql server
- mysql: update field of most latest record
- naming database tables and views
- what's the best way to determine if a temporary table exists in sql server?
- try and raiserror in t-sql
- select distinct values with count in postgresql
- t-sql to trim a datetime to the nearest date?
- error: er_wrong_value_count_on_row: column count doesn't match value count at row 1
- sql server return rows that are not equal <> to a value and null
- truncate or drop and create table
- insert timestamp into a database + 7 days
- any benefit to explicitly dropping local temporary tables at the end of a stored procedure?
- how to count the number of times two values appear in two columns in any order
- sql stored procedure if exists update else insert
- how do i find out if a sqlite index is unique? (with sql)
- ado.net data services with linq-to-sql
- sql injection hacks and django
- visual studio thinks correct sql syntax is incorrect
- maximum length of an sql query
- how to change the column length of a primary key in sql server?
- query cost relative to batch is 100%
- what is the escape character for ssis expression builder?
- how to use the create login sql statement?
- how to pass parameters to dbmigration.sql() method
- mysql replace all whitespaces with -
- filter based on an aliased column name
- postgres append or set each elements(if not exists) of an array to an array column
- why would i want .union over .unionall in spark for schemardds?
- insert into h2 table if not exists
- creating a table using explicit create table statement versus select into
- multi part identifier could not be bound sql
- subquery with entity framework
- should a table connecting two tables have its own id?
- what is the second argument in array_length() function?
- mysql where not in extremely slow
- where does sql server store the ssis packages?
- insert permission was denied on the object 'employee_info', database 'payroll' schema dbo
- sql server 2008 backup compression standard edition
- how can i select rows in reverse order in mysql?
- ssis converting a char to a boolean/bit
- how to populate a timestamp field with current timestamp using oracle sql loader
- what is the maximum length of a string parameter to stored procedure?
- rsconfig generates a dsn connection string doesn't work
- set max column value as sequence start value with liquibase tags
- system.data.sqlite not supporting multiple transactions
- differentiating between 2 sql column names with the same name in a c# sqlconnection
- sql inline if statement type question
- how to use `sqlcmd` command without username and password in sql server 2008?
- convert varchar to float if isnumeric
- inserting variable into sql query from java
- symfony2 doctrine run sql from a file in cli
- mysql update query to remove spaces
- sql server 2008 r2 add column into a specific location
- <table-valued function> is not a recognized built-in function name
- dynamic sql parameters with anorm and scala play framework
- amazon athena - converting timestamp to date?
- why does linq-2-sql create extra unnecessary objects?
- sql - joining two tables and counting items
- in sql what is the default max transaction timeout
- change column data type in mysql without losing other metadata (default, notnull...)
- incrementing a number in a loop in plpgsql
- simple select query in linq
- how to have group by and count include zero sums?
- freebcp: "unicode data is odd byte size for column. should be even byte size"
- sql query optimization to avoid temporary table
- how to convert datetime to a number with a precision greater than days in t-sql?
- sqlcommand.dispose() before sqltransaction.commit()?
- c#: is it possible to declare a local variable in an anonymous method?
- how to replace empty spaces with null
- loading sql dump before running django tests
- sql server error after update: the token supplied to the function is invalid
- how can i generate an insert script for a table with a varbinary(max) field?
- dapper multi insert returning inserted objects
- mysql: multiply all the values in a row by 2
- is there a neat way of doing a tolist within a linq query using query syntax?
- unexpected query success
- pl/pgsql select into an array
- date_sub ok with mysql, ko with postgresql
- "login timeout expired" error when accessing ms sql db via sqlalchemy and pyodbc
- problem using sql agent to run ssis packages - fails with "dtser_failure(1)"
- distinct() function (not select qualifier) in postgres
- sanity check: floats as primary keys?
- set null value in a foreign key column?
- changing identity seed in sql server (permanently!)
- c# smo backup of remote database to local machine
- pyspark dataframe orderby list of columns
- a cursor with the name ... already exists - sql server 2008
- varchar columns: nullable or not
- sql datetime insert from excel?
- ssms 2012 intellisense behavior
- avoid returning result set from stored procedure
- sql server 2005 for xml explicit - need help formatting
- sql loop insert based on list of id's
- what happens with returning ienumerable if used with async/await (streaming data from sql server with dapper)?
- return order of mysql show columns
- how can i select the longest text field when using group by in mysql, a la max()?
- sql server query erroring with 'an object or column name is missing or empty'
- encrypt in sql server / decrypt in .net 4
- how can i add leading zeros to dates in oracle?
- sql server - how to hint an index on an update command?
- sql nomenclature: "query" or "command" for insert/update/delete?
- how to drop user in postgres if it has depending objects
- why working directory is changing when executing invoke-sqlcmd?
- how to escape special sql characters in regular expression in mysql
- calculating percentage in postgresql
- how to order by an arbitrary condition in sql
- hibernate @formula doesn't include schema
- how to set identity_insert on in sql server 2008 for multiple tables at once
- how to make pandas.read_sql() not convert all headers to lower case
- is it possible to use subquery in join condition in access?
- linq-to-sql failing on insert and update when this is a trigger attached
- delete from two tables with circular foreign keys
- sqlite bracket "don't work"
- how do you handle nullable type with sqldatarecord
- insert string which includes quotes in oracle
- pyspark: randomize rows in dataframe
- mysql select on two values one column
- ssis file system task error while copying files between servers
- sql injection in firebase
- how to select n random rows using pure sql?
- sql query to convert new line character to a html <br>
- sql server 2000: is there a way to tell when a record was last modified?
- how do i query column names that contain square brackets?
- mysql nested select in update of same table
- power bi slow with ssas multidimensional cube
- is using cfsqltype good practice?
- incorrect syntax near format in bulk insert?
- get last monday in spark
- datetime.minvalue vs new datetime() in c#
- difference between end transaction and commit transaction
- catastrophic failure trying to select from linked server
- can a locked row [in postgres] still be read from?
- entity framework and sql server synonyms
- how to select all columns in dplyr/sql?
- sql server 2005: order with null values at the end
- using system environment variables in a sql script
- getting and ordering rows with value greater than zero then rows with value zero
- find mean of pyspark array<double>
- how to execute an .sql file in pymssql
- sql null set to zero for adding
- how do i convert numpy nan objects to sql nulls?
- avoid starting hivethriftserver2 with created context programmatically
- how can i protect amazon simpledb from sql injection?
- doctrine query to find total number of result in mysql with limit
- rounding up in sql server?
- creating function using newid()
- mysql - sequalize - cannot add foreign key constraint
- sql server: arbitrary auto-increment of primary key
- reference to uninitialized collection pl/sql
- how connect to sql server compact 4.0 in asp.net?
- asp.net core - application not connecting to database after publishing
- how to get the xml-safe version of an sql server xml column
- mysql 1443: what does it mean?
- how can i access the last inserted row id within a sql script?
- data normalization and writing queries
- appropriate values for -infinity & infinity in postgres
- problems creating a full text index on a view
- unknown column in mysql subquery
- sql error "the order by clause is invalid in views..."
- sum results from two select statements
- sql server - pull x random records per state
- could not find stored procedure, however can execute it
- how to pass sql as file with parameters to airflow operator
- ms sql ruby gem
- sql server deadlock on the same table
- how to do a sum across two unrelated tables?
- google bigquery: how to create a new column with sql
- how to stop ms access from changing my sql code?
- msdn about stored procedure default return value
- is it possible and how create a trigger with entity framework core
- do you only update the changed fields or all the fields?
- adding milliseconds to a datetime in tsql insert into
- restoring sql server database - master key not opening
- shift operators in pl/sql
- is a long in clause a code smell?
- sql decimal equivalent in .net
- how to have analysis service up and running in sql server express edition
- can you change the connectionstring configuration value at runtime?
- how do i do `group by` partial match
- mysql: averaging with nulls
- install oracle attunity drivers in visual studio 2017
- sql: update table from a text file
- how to compare strings in mybatis 3 with if statement - dynamic sql
- sql server - merge two xml using only .modify()
- t-sql union on 3 tables?
- mongodb equivalent of sql "top" [closed]
- is there a good way to perform sql dump of mysql database in datagrip?
- can i use a cast inside a linq to entities query?
- simple syntax: multiple constraints in alter table statement
- sqlcmd - how to get around column length limit without empty spaces?
- sql in clause with zero to many parameters
- ssis oledb destination with sql command
- ms access vba data type mismatch error in sql query
- is count(*) constant time in sqlite, and if not what are alternatives?
- how to choose collation of sql server database
- sql server: compare columns in two tables
- select query | select entires that don't start with a number - mysql
- sql server 2008 get datetimeoffset according to machine settings
- sql server trigger execution in batch updating
- i'm unsure what's wrong when i declare these variables in sql
- how to determine if a column of a view is derived or constant?
- stored procedure using sp_send_dbmail sending duplicate emails to all recipients
- how do database servers decide which order to return rows without any "order by" statements?
- linq: get table details
- mysql max() function to compare numeric values in an update?
- case statement to determine if i should union
- spring boot mssql kerberos authentication
- update statement using a where clause that contains columns with null values
- performing an update with union in sql
- opposite of in operator in sql
- sql sum with sub query?
- qsqlquery size() always returns -1
- invoke-sqlcmd with different credential
- touch mysql record to update timestamp field
- rails postgres functional indexes
- ansi sql question - how to insert or update a record if it already exists?
- mysql alter table add column with primary key syntax error
- t-sql syntax issue - using or in case statement
- aliasing a for xml path result
- convert nan values to null, or nan to 0 in sql
- how to change/set collation in ef code first
- is it possible to use sql%rowcount for select?
- rails: load just one attribute not a whole model
- select all columns except for some postgresql
- mysqldb stored procedure out parameter not working
- max value represented by bigint
- join query result to a single line of values separated by comma
- select all if parameter is null in stored procedure
- redshift : defining composite primary key
- how to make a websql query synchronous?
- phpmyadmin file too large error when trying to import sql
- sql server decimal variable assignment?
- strange behaviour of full outer join in oracle - how it could be explained?
- incorrect syntax near offset command
- pyspark dataframe how to drop rows with nulls in all columns?
- inserting a child node in an xmltype column
- can i "join" across datasources in ssrs?
- how to join result of two sql statements into one table and different columns
- mysql order by using date data row
- how to join jsonb array elements in postgres?
- cannot serialize the datatable. datatable name is not set
- using sqlquery<dictionary<string, string>> in entity framework 6
- query processor could not produce a query plan because of the hints defined in this query. resubmit the query and without using set forceplan
- handling blobs in entity framework 4.0 in a stream-fashion
- mysql: smallest datatype for one bit
- sql server alter computed column
- convert rows to columns after counting
- sql text before the nth match?
- the sql server instance returned an invalid or unsupported protocol version during login negotiation
- add multiple record using linq-to-sql
- connecting to microsoft sql server through pyodbc on ubuntu
- sql server: where is connection pool: on .net side or server side
- how to convert timestamp to date in presto?
- sql: scan row(s) with unknown number of columns (select * from ...)
- odbc unable to connect to mssql data source on os x lion
- does entity framework/linq to sql data binding use reflection?
- mysql update, max, join query
- ms sql server 2005 - stored procedure "spontaneously breaks"
- activerecord - select first record from each group
- mysql auto-add prefixes to fields
- procedure expects parameter '@params' of type 'ntext/nchar/nvarchar'
- using executenonqueryasync and reporting progress
- in memory oledbconnection to excel file
- how to drop columns in a compressed table?
- can i use hibernate query language for entities not mapped to a table?
- how to insert custom values with insert into + select from?
- how to get the distinct records based on maximum date?
- is inserting a new database entry faster than checking if the entry exists first?
- sql server : pivot functionality, need to pivot a table
- connect to sql server using windows authentication and specific account
- mysql: remove table rows depending on column duplicate values?
- list of distinct years between two dates
- select null and false but not true in sql
- merge the two xml fragments into one?
- zf2 zend\db insert/update using mysql expression (zend\db\sql\expression?)
- improve the performance of dacpac deployment using c#
- can i use jooq as an sql parser?
- how to select on table and count occurrences some values
- query to count number of different values?
- strange linq to sql .union() error
- merge syntax used to upsert or insert on duplicate update
- combine multiple results as columns, not rows
- converting all upper case to lower case in sql server?
- ssrs calculating counts across row and column groups
- cast integer column to varchar and compare with string
- query: find rows that do not belong to a list of values
- #1411 - incorrect datetime value for function str_to_date on insert into...select
- aggregate functions are not allowed in a recursive query. is there an alternative way to write this query?
- master table node missing
- add xml comments to class properties generated by the linq to sql designer
- how do i create a sql function to return a bit?
- azure sql high wait time on "vdi_client_other"
- comparing sql table to itself (self-join)
- sqlalchemy: applying an sql-like date() function on a datetime column
- getting index of inserted rows from a mysql database
- is there a function like isdate() for datetime2?
- can i execute multiple statements in sql server compact 4?
- oracle blob vs varchar
- database index not used if the where criteria is !=?
- pl/sql function called how many times?
- is it possible to write a sqlite query which recursively gets all items that are child items of a root node
- r: read.csv.sql from sqldf is able to successfully read one csv but not another
- azure: login failed for user
- t-sql recursive query - how to do it?
- is sql server's isnull() function lazy/short-circuited?
- is number after datetime2 is for nanosecond purpose?
- alias parameters in ssis
- postgres sql state: 22p02
- update column with value from another table using sqlite?
- is it possible to create a temp table on a linked server?
- how to decode xml blob field in d7
- sql distinct comma delimited list
- is there any straightforward way to output text files (or csv) from sql server?
- how can i "merge", "flatten" or "pivot" results from a query which returns multiple rows into a single result?
- how can i update multiple columns with a replace in sql server?
- what is the best way to query deleted records with sql server 2016 temporal tables?
- why does cross apply *not* get an invalid column error in this query?
- performance of delete with not in (select ...)
- how do i find indexes that have statistics_norecompute = on
- mysql return more than one row
- how to write a for loop in oracle sqlplus?
- why does primary key order matter?
- overloading mysql stored functions
- sqlalchemy load_only on parent model
- best practice for foreign key column position in table
- slow or statement in postgresql
- "oops" error while installing sql server 2017 developer edition on windows 10
- converting nvarchar(4000) to nvarchar(max)
- how to order by custom rule, e.g. how to order like 4,2,1,3
- why is "0d0" considered numeric in sql server 2008?
- merging databases how to handle duplicate pk's
- sql server compact 'data directory' macro in connection string - more info needed
- why do you have 'where' when there is 'having'
- android check when table was last updated
- how to insert php array values using an stored procedure sql server 2008 r2(mssql)
- why can't i update more than one column at the same time using with keyword?
- sql server - create single trigger that runs for all tables in the database
- how to add sql user-defined function to entity framework?
- sql server select where datetimeoffset older than 1 hour
- compiled queries and "parameters cannot be sequences"
- coldfusion: multiple sql statements in a query?
- "the connection string specifies a local sql server express instance", except it doesn't
- smo assemblies in .net framework 4.0
- sql query to solve the following
- how to transfer sql encrypted data between sql server 2005 databases?
- how to check if a variable has a value in a sql server 2008 stored procedure
- sql 'float' data type, when output as xml, causes undesired float result
- trying to run sqlcmd fails, unable to establish connection?
- i/o error while reading input message; nested exception is java.io.ioexception: stream closed
- generic sql builder .net
- tsql - make a literal float value
- how do i count the number of characters in sql server ntext (i.e. memo) field in an access query?
- sqlite syntax for operator “any”
- mysql: how to calculate weeks out from a specific date?
- query where foreign key column can be null
- how do i escape a '@' in a dapper query?
- what is the oracle equivalent of sql server's set nocount on?
- mysql error "there can be only one timestamp column with current_timestamp in default clause" even though i'm doing nothing wrong
- alter table with programmatically determined constant default value
- deadlocks - will this really help?
- sql server: the total size of an index or primary key cannot exceed 900 bytes
- rails3 sql logging output in a separate file
- in how many languages is null not equal to anything not even null?
- using join statement with contains function
- sql statement which returns id and splits comma separated values
- why does using left() on getdate() change it to a different data type?
- sql error: ora-12899: value too large for column
- sql server 2012 - insert into linked server table using openquery
- why am i seeing "collation 'xxx' is not valid for character set 'yyy'"
- files with .sql extension identified as binary in mercurial
- ssis date in derived column as yyyy-mm-dd format
- putting comma separated values into separate or different columns
- cannot access google cloud sql from google container engine
- which dbms's allow an order by of an attribute, that is not present in the select clause?
- select the field as distinct having data type as text. sql server
- cross join behaviour (sqlserver 2008)
- is 'length() is null' equivalent and faster than 'is null' for blobs?
- sql server full text search using contains, formsof, near for multiple search words
- cascade delete query
- the data types date and datetime are incompatible in the add operator
- .net: sqldatareader.close or .dispose results in timeout expired exception
- possible to create sql query with table wildcards?
- create a recursive view that has a "with recursive" statement in teradata
- why do square bracket appear with the table name?
- limit / offset in oracle 11g
- error: "multiple columns are specified in an aggregated expression containing an outer reference."
- why can i not find a foreign key using the object_id() function?
- linq to sql - best way to switch between test & dev db
- is a replace into query good practice?
- difference between dates in two consecutive rows
- why can integer be subtracted from datetime but not date type
- executeupdate sql statement in java not working
- why sql returns an array instead of an object?
- should a sql view always be in 1nf?
- functions from custom module not working in pyspark, but they work when inputted in interactive mode
- a database schema for tags (eg. each post has some optional tags)
- sorting data according to current date
- laravel orderby with column value
- is there a easy way to get the "sp_executesql" query .net generates for a parametrized query?
- why cannot use compiled insert statement in slick
- how do i use if/else or case in datacolumn.expression?
- why would the exact same sql query result with a different execution plan when executed via the sp_executesql procedure?
- consecutive days in sql
- how to connect sql server express database to vs 2017
- sql server: if exists massively slowing down a query
- converting joda localtime to sql time
- show row count in sql profiler
- regex in sql to detect one or more digit
- is bigint large enough for an event log table?
- django - filter a queryset by max(date) year
- subtracting values in mysql table
- comparing two t-sql tables for diffs
- update statement- geography column - sql server
- how to get identity of new records inserted into table with instead of trigger
- oracle sql -- remove partial duplicate from string
- cursorwindowallocationexception in standard ormlite method
- can't kill spid "transaction rollback in progress"
- sql server primary key on datetime field
- compose dynamic sql string with psycopg2
- delete from table if the id doesn't exists in another table
- calling cte multiple times in same query
- database project to drop database before deploy?
- reportviewer 11 (2012) visual studio 2010
- multiple invoke-sqlcmd and sql server transaction
- t-sql query that returns lower case results only
- sql server and date + 1 result
- what is the equivalent of timestamp/rowversion (sql server) with postgresql
- get parameter names from sql query
- select count() in doctrine dql with left join manytomany unidirectional relation where user does not have relation specific group
- visual studio 2008: don't deploy sql server compact 3.5 when debugging
- sql code smells
- mysql duplicate column error only when query wrapped as subquery
- linq query on birth date to get age
- case statement in where clause in tsql query
- how to speed up reading large amounts of data in sql server and c#
- execution time slower with each iteration of the same sproc
- why does "select distinct a, b from..." return fewer records than "select distinct a + '|' + b from..."?
- get only date from datetime sql without converting to varchar so that i can sort it in excel
- how can i pass a null value for date in vb.net to sql stored procedure?
- how to optimize delete .. not in .. subquery in firebird
- convert a flat database resultset into hierarchical object collection in c#
- unable to connect to sql server database
- ssis 2012 date formats dmy vs mdy
- ruby nomethoderror - undefined method `blah_url' for blahcontroller
- why is scala's symbol not accepted as a column reference?
- database is locked when inside a foreach with linq without tolist()
- is there a better way to extract the time of day?
- how do i properly use linq with mysql?
- sql where clause with like and in
- sql constraint to prevent updating a column based on its prior value
- google-cloud-sql - max_allowed_packet
- recursive cte sql with for hierarchy level
- mysql select where in many to many
- ignoring errors in trigger
- what's the simplest way to compare an enum to a integer value return from a db
- sql server convert iso 8601 not working as documented
- access violation exception in sqlceconnection dispose
- should control permission be given on a stored procedure in sql server 2005?
- how to call a udf in a linq to sql query?
- spark sql 1.5 build failure
- sql server - user cte in subquery
- join on data from xml in t-sql
- how to remove always encrypted from a column in sql server 2016
- entityframework: retrieve data with a condition on two different context
- why do we have to make a select after an 'insert all'?
- sql: convert an integer into a hex string?
- runtimebinderinternalcompilerexception when using microsoft.sqlserver.types with dapper
- is there a limit to what sql fiddle can handle? sql fiddle doesn't compile anything and returns no error messages
- fill in gaps in data, using a value proportional to the gap distance to data from the surrounding rows?
- withcolumn not allowing me to use max() function to generate a new column
- sql query on h2 database table throws arrayindexoutofboundsexception
- what is difference between ntext and varchar in sql server 2008 r2
- play framework jpa: how to implement one-to-many relationship?
- union causes "conversion failed when converting the varchar value to int"
- selecting most recent record
- system.collections.generic.keynotfoundexception: the given key was not present in the dictionary
- ssrs hiding the textbox in a table cell causes the borders to disappear
- sql server jobs / schedules - us vs. uk daylight savings adjustment
- sql join: how to select when value not in a set of values
- how to pass a list of values for an `in` sql clause in django
- multi-threading with linq to sql
- calculate the angle of exterior rings postgis (polygons & multipolygons)
- sql intersect conditional
- unique constraint with efcodefirst and sqlce4
- the column name "firstname" specified in the pivot operator conflicts with the existing column name in the pivot argument
- mysql yearweek() vs week() returning different result
- groupby sqlfunction on queryover
- exception handling in pl/sql
- mdx performance vs. t-sql
- guarantee random inserting
- first and last value aggregate functions in postgresql that work correctly with null values
- linq many-to-many relationships: solution?
- how does management studio know to save my t-sql comments?
- error when trying to use room library. [sqlite_error] sql error or missing database
- sql server conditional foreign key constraints
- jooq aggregate functions
- use a variable or parameter to specify restart value for alter sequence
- how to change a table id from serial to identity?
- sql select query help required
- arithmetic overflow error converting expression to data type datetime
- divide rows with date in sql server 2014
- how can i apply aggregate functions to data extracted from json in google bigquery?
- sql select * from xxx where columnname in array
- codepage error while importing data from oracle to sql server using ssis
- "using" keyword doesn't close an open sql connection
- firebird multiple statements
- executereader returns no results, when inspected query does
- count and group by on text fields seems slow
- best way of logging in ssis
- java & sql comparing dates
- help for solving drop column default value of a table error
- a cursor with the name 'cursor_name' does not exist
- converting json to table in sql server 2016
- why is using a parameterized query to insert data into a table faster than appending the values to the query string?
- trigger alternatives for two tables that have to mutually update each other
- testing custom orm solution performance overhead - how to?
- how to specify data type when using native sql query?
- sql n-to-n matching multiple values
- is it possible to create a table with a variable name in postgresql?
- oracle 11g create view using connect by and multiple tables
- identity column in sql server
- sql server trigger - need to alter
- sql delete row error
- how to fix "java.sql.sqlsyntaxerrorexception: unknown column 'product0_.return_policy' in 'field list' " exception?
- what is the hibernate equivalent of "select 1 from dual"?
- java.sql.sqlexception: no suitable driver found
- how does postgresql's cluster differ from a clustered index in sql server?
- sql server machine learning services r version 3.5
- sqlite how to remove all duplicated rows except one?
- inserting/updating data on table from a stored procedure result set
- ssas cube processing error about column binding
- how to monitor sql server network traffic
- difference between mysql is not null and != ''
- how do i search for names starting wih a in mysql?
- migrate sqlite database to microsoft sql server
- oracle to_char format number with fill mode (fm0000)
- sql query for asp.net grid pagination
- sql server: retrieve auto-incremented id inside a stored procedure?
- standard alternative to connect by?
- tsql select min & max row when grouping
- composite primary keys and influence on natural/surrogate keys usage [closed]
- rounding-up tsql
- how to show hierarchy row like parent child using sql query
- dapper.simplecrud insert / update / get fails with message "entity must have at least one [key] property"
- entity framework 4.0 entity sql passing null objectparameter parameters
- upserting a row into an hsqldb table using the merge sql statement
- make function call wait for web sql query
- pandas + pyodbc odbc sql type -150 is not yet supported
- combine command line and t-sql - sql server
- sequelize upsert() never updates and only inserts
- rails - see generated sql queries in log files
- are common table expression's (cte) available in sql server 2000
- how to remove the square brackets in child rows of a json from sql server 2016?
- spark-sqlserver connection
- msg 203, level 16, state 2, is not a valid identifier
- sql - difference between these joins?
- select xml from varchar(max) column
- how to run sql in shell script
- how can i do and bit operator between two varbinary fields in sql
- where i can check user-define table type in sql server 2008 in ssms? and how can i insert new column into it?
- oracle 11g "bind variable does not exist"
- microsoft ole db provider for sql server error '80040e14' incorrect syntax near '='
- how can i use windows authentication in mvc but use the newer identity database tables for role storage?
- syntax for default value for user defined type as table
- freetds bash: executing sql queries in microsoft sql server
- retrieve output parameter of sql statement
- custom sort order in sql server mixed datatypes stored in a varchar
- localsqlserver was not found in the applications configuration or the connection string is empty
- how to show only the time in oracle?
- microsoft sql server paging
- order by descending based on condition
- string comparison fails with varchar variable
- why sql functions are faster than udf
- having trouble setting a computed column as not null
- value >= all(select v2 ...) produces different results from value = (select max(v2) ...)
- mysql.connector, multi=true, sql variable assignment not working
- two foreign keys of the same table. how do i write this select statement?
- jdbc: get table names involved in a sql query
- how to select two columns, where one column must be distinct?
- is it a good security practice to have separated read and write users for a database?
- sql server ports 445 and 1433
- getting first row in postgres query
- sql format function error
- return rows where first character is non-alpha
- how can i see data in mdf file
- postgresql 'select distinct on' in hibernate
- postgres creating a table with an array of foreign keys
- boolean shortcircuit evaluation in linq lambda expression
- linq sort direction from string
- add() method adding duplicate rows for linked models in code-first entity framework
- linq to sql and immutability
- string or binary data would be truncated error message
- access sql query missing more required parameters
- sql server: deleting rows with foreign key constraints: can transactions override the constraints?
- recursive calculation to form a tree using sql
- is this the correct way to create sql assertion?
- table-valued function refresh
- what indices should be created to optimize sql query with multiple or conditions
- how to write a mysql case when statement with multiple search conditions?
- quoting integers
- do all parts of a sql server expression using 'or' get evaluated?
- trim not working on null characters
- ssis steps to load csv from azure blob to azure sql
- h2 sql date comparison
- linq join query get single record from second table
- nullreferenceexception when selecting from left join
- sql: cancel 'where' on null parameter
- what is the difference between not and != operators in sql?
- updating year in datetime variable
- how to order by datetime in doctrine 2?
- complex sql query, many to many
- insert utf8 data into a sql server 2008
- sql network interfaces error 26 - error locating server/instance specified
- shouldn't this postgresql function return zero rows?
- converting the name of a day to its integer representation
- sql server object explorer not showing a database
- mysql group by intervals in a date range
- efficiency of using case when ... is not null vs isnull/coalesce
- update query not working in mysql workbench
- how to implement a more efficient search feature?
- what version of .net framework ships with sql server 2008?
- dynamic insert into variable table statement sql server
- sql server performance with key/pair table vs xml field and xpath
- how to check are there json functions by sql query?
- update a column based on a field from another table
- case statement in join clause
- deploy ssis project using tfs command line
- tricky group by issue on oracle
- does linq orderby not sort original collection?
- using cte and update in redshift
- sql developer doesn't display xml
- snapshotid parameter type mismatch when calling render method on reportexecution2005.asmx ssrs service
- how do i run an ssis package in sqlserver 2012 using vs2010?
- missing reporting server templates in visual studio 2013 + business intelligence ssdt
- parameters vs string interpolation
- how can i find all columns that are filled with 100% nulls in my sql server database schema?
- sql server trigger isolation / scope documentation
- creating a dynamic query using iqueryable
- sql query: list all items in one table that do not appear in another table
- sql error #1071 - specified key was too long; max key length is 767 bytes
- update without where clause
- two triggers on insert of same table
- postgresql how to get average of sum of certain rows
- how to count group by rows in t-sql
- missing diagram folder in database explorer at visual studio 2012
- escaping question mark (?) in sql where clause
- will having multiple filegroups help speed up my database?
- how to set-up sql server / iis 7.0 to allow asp.net mvc website to access to database?
- how can i detect if a postgres temporary table already exists?
- updating 4 million records in sql server using list of record-ids as input
- jdbc - select where column is null
- getting the second occurrence from charindex function in sql server
- ms access sql, changing data type
- how to continue sql script on error?
- why "select count(distinct <column>) from <table>" return 0?
- early (or re-ordered) re-use of derived columns in a query - is this valid ansi sql?
- calculate average time difference between two datetime fields per day
- parse.com equivalent to sql joins
- prevent sql injection in dynamic column names
- linq to entities join on datetime.dayofweek
- incorrect sum when i join a second table
- how to search the string in query with case insensitive on clickhouse database?
- datatype conversion in ibm db2: bigint to varchar
- what are the benefits of using the row constructor syntax in a t-sql insert statement?
- sql server convert(numeric(18,0), '') fails but convert(int, '') succeeds?
- comparing current month and previous month's rows on a column, sql server 2012
- run multiple commands in one executescalar in oracle
- how to sort a column with date and time values in spark?
- converting from integer to binary and back in sql server
- sql select to find cyclic references in father-id-organized tree?
- swapping column values in postgresql
- loop through databases on server, and update data
- select then update those records and then return them in stored procedure
- how to join mysql tables
- update sql server database schema with software update
- pyspark transform method that's equivalent to the scala dataset#transform method
- intellij idea 11.1.2 does not copy sql files to the out folder
- why does sql server use a non-clustered index over the clustered pk in a "select *" operation?
- is this implementation sql-92 conformant?
- if the first condition is false then the second condition is checked in sql server?
- how to utilize doctrine2 type conversion on native query columns
- case sensitivity goes crazy
- oracle (pl/sql): is update returning concurrent?
- adding a join to an sql alchemy expression that already has a select_from()
- getschema("columns") + return datatype;
- how to share data between stored procedures [closed]
- sql azure doesn't support 'select into' - is there another way?
- the member [class] has no supported translation to sql
- ora-01873: the leading precision
- mysql groupby and shows it horizontally
- sql clr function based on .net computehash is not working with cyrrilic
- standard sql query to get matching record field with another table (google bigquery)
- bulk insert file path as stored procedure parameter
- missing microsoft excel as option in sql server data import tool
- sql: how to return an non-existing row?
- how can you find the rows with equal columns?
- how to deduplicate in presto
- how to rollback changes to wpf datagrid control using linq-to-sql?
- use sql to display count of min and count of max within group
- case sensitive join tsql
- how to use same list twice in where clause?
- mysql left join for right table max value
- typo3 extbase: how to get disabled related object, without raw sql-query?
- passing dynamic key in json_value() in oracle
- when the computed column will update?
- oracle hierarchical sum (distance from leaf to root)
- mysql case when then empty case values
- how do i access sql server from windows 8 apps?
- saving a list of rows to a hive table in pyspark
- count if a user has reached the borrwing limit
- execute db statements from file
- syntax error: unexpected string literal '93868086.ga_sessions_' at [1:244] - bigquery
- how to deny delete on a table for all users
- granting execute permission on all stored procedures in a certain database
- mysql query to average time
- spark: select with key in map
- how to combine two tables into own this the same columns?
- mysql query equivalent of "and", whereas "in" is "or"?
- sql server - round time values to the next minute
- ora-00998: must name this expression with a column alias
- how to use lookup tables in oracle?
- how can i select top 500 rows from table1 and insert them to table2?
- objective-c sqlite adding query parameter inside of like clause
- insert rows with unicode characters using bcp
- import multiple excel files into sql server 2008 r2 using ssis packages?
- select max from each subset
- sql server stored procedure with optional parameters updates wrong columns
- what will happen if i kill a huge mysql innodb delete query?
- using nhibernate mapping by code: cannot insert explicit value for identity column in table 'dietuser' when identity_insert is set to off
- must declare the scalar variable "@username"
- how to group time column into 5 minute intervals and max/min value respectively sql?
- sqlserver 2005: deadlock problem with no shared records
- spark window function with condition on current row
- linq to sql peculiarities
- exclude matched array elements
- execute stored procedure from wpf
- incorrect syntax near the keyword 'table' c# sql [closed]
- how to use a table variable in an "update from select" query?
- mssql linked server error: the ole db provider "oraoledb.oracle" for linked server supplied inconsistent metadata for a column
- sql server + composite key or unique id
- sp_ddopen - what is this doing?
- using case to create new column based on specific text in a string column
- "grant all to role" in sql server
- vs 2013 database project: post-deployment scripts to run based off of build configuration
- select * from tbl where id>=5 /* then add the result from id<5 to query */
- how to check sql script compatibility agains sql 2008
- postgres 8.4.4 (x32 on win7 x64) very slow update on small table
- how to determine if a parameter value was passed to a stored procedure
- are there generic options for version control within a database?
- using mysql user-defined variable in stored procedure for 'in' clause
- how to encrypt data in sql server and decrypt it in .net apps
- how to solve 1753 year issue in sqlserver?
- using a temp table in a view
- java.sql.sqlexception: database connection closed
- how do you reference a field in the embedded code of an ssrs report
- vb.net insert multiple records
- database design issue when adding new columns to table from application
- select distinct on inner join query filtering by multiple values on a single column?
- validate for a valid sql string
- operator used tempdb to spill.... with variables but not literals
- sql if no rows are returned do this
- sql server : consecutive rows issue
- "where x > all select max" vs "where x > select max"
- simultaneous connections to sql server using the same name and password. is there any problem with that?
- any way to export/import sql server reporting services subscriptions?
- getting id of record just inserted?
- sql server - trying to de-normalize my table
- outer join using in list?
- how to use conditional columns values in the same select statement?
- pyspark reversing stringindexer in nested array
- hibernate insert failing when embedded key contains identity column on sql server
- how do i work around the "the process cannot access the file .ispac because it is being used by another process" error?
- why use is distinct from - postgres
- does `sp_executesql` really accepts the `nvarchar(max)` argument?
- sql statement for a 13 character long timestamp
- versioning each field vs history date field?
- how could a inner/right/left join be 14x slower than a full join?
- need sql optimization (maybe distinct on is the reason?)
- linq to sql - delete some related records
- how to iterate through an sql table which "parent" and child" rows are in same table
- how can see the sql statements that spark sends to my database?
- is there a standard for sql aggregate function calculation?
- substituting value in empty field after using split_part
- how to find stored procedures by name?
- select aggregate function and all other columns
- oracle pl/sql, how to calculate age from date birth using simple substitution variable and months_between
- why is "or operation" or or condition non-sargable?
- why create view must be first statement in a batch? [closed]
- how can i convert a string to a string encoded in utf-8 and vice-versa?
- data driven business rules.
- how to update a column fetched by a cursor in tsql
- asp.net login failed for user 'nt authority\network service'
- linq to sql datacontext not updating for foreign key relationships
- linq: sort by date when its stored as text
- postgresql ansi,python sql, utf-8' codec can't decode byte 0xa0
- xml parsing: well formed check: undeclared entity
- sql server 2008 "identity_insert is on" error on insert
- compare date java to datetime column in database table using sql
- sql server merge statement and order by clause
- django orm - percent sign for like
- mysql selecting count of rows as extra column?
- excel (xls) to csv with utf-8
- why does sql sum of multiple columns containing nulls return incorrect result?
- linqtosql precompiling queries benefit?
- what are in and out parameter in sql server
- is it possible to have a function without a parameter in t-sql?
- ssis flat file source text qualifier being ignored
- can a linq query retrieve blobs from a sql database?
- how to resolve collation conflicts with the entity framework?
- mysql: should i make all columns in my table indexed?
- sql: error when creating a foreign table that has an enum column
- how can i delete data with specific row number (sqlite)
- mssql select top 10 winning scores, including ties and at least one from each category
- sql single column split over multiple columns
- sqlcmd with output file and screen output
- how to perform multiple linq to entities orderings dynamically
- is join insert/update on mysql an atomic operation?
- why is postgres scanning a huge table instead of using my index?
- are sql execution plans based on schema or data or both?
- redshift: add column if not exists
- sql server - simultaneous inserts to the table from multiple clients - check limit and block
- update a table field to its value plus a constant on mysql w/o php
- generate id based on multiple columns
- gcloud beta run deploy fails after sucessfully uploading image, fails to enable api
- sql subquery questions, "error: invalid reference to from-clause entry ..."
- how to ignore 'where' and 'order by' condition if the column is null in linq
- how to get average of the 'middle' values in a group?
- is "version" a reserved word in transact-sql? (shows blue but not in reserved word list)
- return all the columns in a mysql table in a string format
- reference class library in sql server clr project
- oracle alter table insufficient privileges
- getting values relating to the max and min rows in oracle
- sql server 2008 limit on exec statement
- convert number of minutes to hh:mm
- pyodbc does not like %, "the sql contains 2 parameter markers, but 1 parameters were supplied."
- 3d spatial objects in sql server
- impersonation on remote service says login failed for user 'nt authority\anonymous logon'
- django programmingerror [42s02] [microsoft][odbc driver 13 for sql server][sql server] invalid object name
- create a table based on a type
- sql server: how to abort a series of batches in query analyzer?
- most efficient way of getting the next unused id
- unkillable oracle session waiting on "sql*net message from client" event
- row size overhead
- querying sql server with index for range
- ensure that one and only one default is defined for a set
- empty string results in "errors were detected in the command line arguments, please make sure all arguments are set correctly"
- jooq pojos with one-to-many and many-to-many relations
- extract substring with a specific pattern in mysql
- subtracting 30 years from current date in oracle sql
- database tables, one table referencing multiple unrelated tables
- sql server equivalent of mysql's using
- inserting superscript numbers in ms sql
- is linq generally slower than a equal sql statement
- best ansi options when creating a new database
- clr: multi param aggregate, argument not in final output?
- cte vs. t-sql loop for determining depth of object hierarchy
- unable to pass a variable value to a stored procedure in ssis
- how to speed up max() query
- dmf sys.dm_exec_sql_text not showing dbid
- what's faster? struct array or datatable
- why is datareader giving "enumeration yielded no results"?
- get random number of rows from sql server table
- memory consumption of having a column longtext in mysql database
- dateadd column caused an overflow
- how to execute a procedure with jdbc
- "string data, right truncation" warning on a select statement
- mysql like to match complete word or beginning of word on string
- sql / doctrine : left join problem
- sql server nvarchar and java prepared statement
- sqlalchemy: check if a given value is in a list
- get time difference between group of records
- is performing a count() calculation slowing down my mysql query?
- how can i update rows returned by a select in a loop?
- how to achieve default value if column value is null?
- pyspark.sql.utils.illegalargumentexception: "error while instantiating 'org.apache.spark.sql.hive.hivesessionstatebuild in windows 10
- using offset-fetch, how to default number of rows to "all rows"?
- compute string length in spark sql dsl
- for xml path and xsi:nil attributes
- what is the proper way to manually sequence a column in postgres?
- ms access rounding precision with group by
- is there a way to get the full sql text back from sqlcommand after param substitution?
- sql server 2008 filestream vs normal files
- guid with extra characters issue
- mysql - inserting row in table 1 when specific row deleted on table 2
- postgres creating a local temp table (on commit drop) from a dynamic sql string
- sql query to select all columns in a table except two columns
- on db2 for i, search for column, return table names in list form
- how do you join two tables using django without using raw sql?
- how to extract number from string column?
- sql custom order by
- composite key, in comparison
- huge performance differences between sum(column_name), sum(1) and count(*) on a large dataset
- oracle sql inserting multiple rows and returning something
- how to append data to a sql server table with identity primary key using function sqlsave() in r?
- datetime2 and providermanifesttoken in entity framework
- sql query with limit on rows from one table, not the result set
- how to add datetime field with a time field
- how to set sql datetime to null from linq
- sql server jdbc exception
- reuse a parameter in a preparedstatement?
- error: the conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value
- sql server create date
- sql sum mtd & ytd
- spid of a sqlconnection (sql-server) in ado.net
- error : this feature is not available for the database you are using
- transforming one column into multiple ones in a spark dataframe
- what does the n in varchar(n) refer to
- where clause rejecting rows if null occurred
- oracle cte merge
- django-pyodbc vs django-mssql
- this driver is not configured for integrated authentication
- microsoft odbc driver 13 for sql server : login failed for user 'sa'
- vba run-time error 3134
- how to add a table name in execute immediate query?
- syntax error "near from" when using update with join in mysql?
- distinguish between null's when using "group by ... with rollup"
- how to get unique set of rows from sql where uniqueness is defined by 2 columns?
- right trimming binary data in sql server
- mysql to sql server transferring data
- how to insert using a select in hibernate
- how can i set identity_insert on a tablename passed as a variable
- sql: normalization of database while retaining constraints
- active directory(ad) authentication in azure sql not working
- how to get time (hh:mm:ss) from sql query?
- reporting services expression using switch
- using stored procedure as ole db source in bids
- getting account 'locked' status in sql server
- can i have 2 different entityframework contexts share a single sqlserver compact database?
- udf performance in mysql
- executing an oracle stored procedure within entityframework
- error in your sql syntax; check the manual that corresponds to your mysql server version
- portable sql to determine if a table exists or not?
- sql cursor throws out of memory while calling getstring
- get date of every second tuesday of a month
- ef linq to entities calling tolist() on entity set generates sql command containing multiple left outer join
- using fread() to select rows and columns, the way read.csv.sql() does
- return rows affected from a stored procedure on each insert to display in asp.net page
- why does a t-sql block give an error even if it shouldn't even be executed?
- call aspnet_regsql.exe from sql script
- problem with sql, resultset in java
- index on join and where
- performance of sashelp views versus sql dictionary tables
- hex characters in varchar() is actually ascii. need to decode it
- what will append if the maximum value of an identity column is reached?
- flat file connection manager carriage return/line feed discrepancy
- sql a numbering column - mysql
- wrong dates values in ssis
- can sql server bcp in a file with unix line endings?
- why am i getting "the magic number in gzip header is not correct." error using owin auth against azure sql
- how to solve microsoft sql server. error 233. provider: ssl provider
- issue with inserts and updates
- oracle error: not enough values
- can i have a constraint on count of distinct values in a column in sql?
- select only first letters of words from a varchar field
- java.sql.sqlexception: ora-01005: null password given; logon denied
- how does linq-to-sql prevent sql-injections?
- count events in sql server?
- pivot not working incorrect syntax near ')'
- returning set of rows from plpgsql function.
- where should i put sql queries in rails?
- pdo auto-aliasing when fetching?
- error in my sqlite syntax
- converting sql case when statement into c#
- how can i list duplicate values out of a table?
- is there a way to get the first and last weekday of a month?
- how to set and index on two columns of t-sql declared table variable?
- is there a way around the 8k row length limit in sql server?
- oracle procedure error (pls-00428)
- sql: limit on case (number of when, then conditions)
- how to fix native client error 'connection is busy with results for another command'?
- linq with optional where options
- understanding ilike any element of an array - postgresql
- when to use single quotes in an sql statement?
- magento -- "sqlstate[23000]: integrity constraint violation.." on customer update
- calculate most users ever online with mysql
- oracle sql: selecting from all_tab_columns does not find existing column
- sql and multiple statements in stored procedure
- display records from two tables side by side matching only some of the fields
- mysql: access denied for user to database
- sql query- update if exists, insert otherwise
- what is a row constructor used for?
- export custom event dimensions to sql from application insights using stream analytics
- how to connect to windows sql server from ubuntu
- mysql using spatial index
- service broker or sqldependency in sqllocaldb?
- how to configure jooq-sbt-plugin
- method x has no supported translation to sql
- in memory database h2 how long keep connection open?
- tempdb has reached its size quota: how to increase size quota for tempdb on azure sql
- sql grouping interescting/overlapping rows
- rails 4 join group by and select
- return empty or null fields as <element /> from sql server 2008 r2 with for xml
- joining 3 tables oracle sql
- architectural design for data consistency on distributed analytic system
- literal does not match format string for oracle sql to_date on a string column
- detecting disconnection of the client in sql server
- how to use index in sql query
- strange results using order by and limit
- foreign key on myisam table alternative?
- sqlbulkcopy with identity insert in destination table
- sum of datetime difference in sql (hh.mm)
- sqlite natural join broken?
- search by substring in documentdb
- t-sql how to select rows without duplicate values from one column?
- caused by: java.sql.sqlexception: jdbc4 connection.isvalid() method not supported
- difference between database level trigger and server level trigger in sql server
- either an aggregate function or the group by clause
- sql alias gives invalid column name
- error unable to convert data type nvarchar to float
- should i have fks pointing to data that rarely changes, or just stick the data in directly?
- sql query help: selecting rows that appear a certain number of times
- how to execute like query in sqlalchemy?
- long running entity framework transaction
- what's the scoping rule for temporary tables within exec within stored procedures?
- sql select including data type and data values
- sql server - cte recursive sum value from different table
- python: pyodbc execute stored procedure with parameters
- get select column names from dynamic query in sql server
- cosmosdb sql query that matches multiple values in an array
- mysql - how to modify complex inner join and concat query?
- using variables to call on [database].[schema]
- query to merge multiple rows into into distinct rows with multiple columns
- how mysql does the math calculation of floating point addition?
- reference .net assembly from a sql server stored procedure or function
- tool to visualize sql cascade tree
- why does random() in a sqlite cte join behave differently to other rdbmss?
- want to execute sp_send_dbmail and send results in excel format
- check if a record field contains a value using standard sql (google bigquery)
- raw sql in .net core
- why is null not in(1,2,3) false
- insert rows (parent and children) programmatically
- why is [date] + ([time] - [offset]) non-deterministic in sql server 2008?
- getting first 10 unused manual_sequence numbers
- insert .. select with some default values in mysql with jooq
- entity attribute value (eav) frameworks?
- can linq to sql/linq to entities generate a merge statement?
- most efficient way to join two time series
- force inner join for django query
- error executing sql script; the process cannot access the file because it is being used by another process:'c:\\users\\......\....cnf'
- what is the difference between these two queries?
- summarizing two conditions on the same sql table
- delete empty xml nodes using t-sql for xml path
- selecting distinct value order by desc
- sql server : splitting the results of group by into a separate columns
- how to store the result of query on the current table without changing the table schema?
- creating table in firebird script causes "unsuccessful metadata update" with deadlock
- problem with sql subquery using top() on linked server
- set ms sql result in variable and reuse it
- how to perform a case-insensitive attribute selector in xquery
- stored procedure to insert values into dynamic table
- dynamic 'like' statement in sql (oracle)
- postgres aggregrate function for calculating vector average of wind speed (vector magnitude) and wind direction (vector direction)
- database missing ! finding the root cause
- updating a table with a column from another table in sql
- pandas: function equivalent to sql's datediff()?
- parameterize insert of multiple rows
- sql - getting the id from a row based on a group by
- ef4 two models one database, possible?
- does using non-sql databases obviate the need for guarding against "sql injection"?
- max() in oracle sql
- oracle views and network traffic
- jpa criteriabuilder for join in subquery
- storing data in xml or sql?
- is there a way to query json column in sql server ignoring capitalization of keys?
- delete all records in table which have no reference in another table
- sql unpivot with row numbers
- how to avoid overlapping date ranges when using a grouping clause?
- fetch only n rows at a time (mysql)
- create n new rows from raw data such as (1000....1000+n)
- understanding the use of curly braces and "oj" in a sql query
- sql query takes about 10 - 20 minutes
- rank by groups sql server
- handle multiple inputs of a form in php
- retrieve number of columns in sql table - c#
- insert into table.. exec at linked server does not work
- logback shows debug output with root at level info when org.hibernate.sql logger configured
- checking if all the items in list occur in another list using linq
- parsing select statement with regex (for custom sql parser)
- hierarchyid: get all descendants for a list of parents — not working
- protection level changed mid project - now project won't build
- postgresql - deleting data that are older than an hour, and then inserting new data to the same table
- having trouble creating a view in microsoft sql server management studio
- update statement for multiple ids
- how do i convert utf-8 data from classic asp form post to ucs-2 for inserting into sql server 2008 r2?
- getting the min() of a count(*) column
- why doesn't mysql use the primary key on join plus order?
- how to extract hashtags from a string in t-sql
- sql server 05, which is optimal, like %<term>% or contains() for searching large column
- find all strings that share at least x characters, order by likeness
- "invalid reference to from-clause entry for table" in postgres query
- tsql pseudo random text generator
- database insert mechanism
- select based on matching columns
- air sqlite: sqlevent.result not firing, but statement is executing properly
- group by x or y?
- inserting 1000s of rows to sql table using ssms
- incorrect return value when using executenonquery()
- creating relationships between tables
- ssis exporting data to flat file renders double quotes as hexadecimal characters
- catch/raise event on table data update c#
- oracle sql - generate and update a column with different random number in every row
- how to pass parameter to formsof function in sql server
- sql server performance with large query
- sql server error: maximum number of prefixes. the maximum is 3. with join syntax
- sql like query slow if using declare parameter but fast if not
- how can i resolve error when trying to launch instance on amazon rds?
- an error occured during the pre-login handshake
- how to extract a value from a json string by key
- 8078 bytes in 8060 b datapage (sql server)?
- how to select from more columns but group by 1 column?
- convert scientific notation in string format to numeric in spark dataframe
- running sql files scripts from a java program
- how to cache a large amount of data from database for asp.net mvc
- why do you hate sequences on oracle? [closed]
- issue with linq and reference list
- choosing sql server data types for maximum speed
- sql server view with a 'select where x is not null' takes ages to complete
- practical limitations of expression indexes in postgresql
- get common rows within the same table
- runtime exception mocking groovy.sql in spock
- the identity column must be of data type int, bigint, smallint, tinyint, decimal, or numeric
- find movies with highest number of awards in certain year - code duplication
- clean up sql data before unique constraint
- sql server login failure in middle of application run
- how to select the utc offset from a datetimeoffset object?
- how to grant references permission to all tables
- varchar invalid for sum operator
- how to use calculated field in another field of the same query
- how to calculate percentage of each row in sql server 2012?
- sql server 2k - insert explicit value for timestamp column?
- update records that satisfies a condition with incrementing number
- "in" condition at case when on where clause?
- change default template in sql server management studio
- how do i save the result of an sql count query with vba in access 2007?
- are subqueries evil?
- backup and restore of azure sql database using c#
- how can i use two different data contexts in one linq request?
- db design: should i use constraints within a table or a new table
- could not load file or assembly 'microsoft.sqlserver.management.sdk.sfc version=11.0.0.0
- return the names of the categories which are of n’th level in the hierarchy (categories with parentid -1 are at 1st level)
- 4000 character limit in like statement
- show sql errors of spring-security in tomcat
- how to get only date from datetime column using linq
- how to select lines in mysql while a condition lasts
- auto number and reset count for each different column value
- what is the sql server equivalent to a linked table in ms access?
- is it possible to copy all data from one table to another table, plus an extra column?
- simple persistence framework compatible with macruby?
- asp mvc 3 noobie: why is the code-first method not building my db on sql server?
- how to achieve try_convert functionality in ssis?
- sqlite order by numeric and not alphabetic
- conditional where statement in t-sql
- how to generate a list of number in sql as it was a list of comprehension?
- how to bind datagridview with sqldatareader
- django aggregation count
- how can i use an external python module with sql 2017 sp_execute_external_script?
- why my entity framework creates several queries instead of a single union query?
- delphi ems firedac: how to pass parameter from client to server using ems?
- how can i set column type when using sqlbulkcopy to insert into a sql_variant column
- mocking idocumentquery in unit test that uses sql queries
- sqlexception during executebatch() when i'm handling batchupdateexception
- execute as user failed for the requested user dbo in the database
- postgresql: error: column of relation does not exist
- trigger to capture schema changes in the server
- what are the first tasks for implementing unit testing in brownfield applications?
- entity framework order by issue
- single line go(batch) statement giving error in sql server?
- linq to sql - decimal datatype truncated instead of rounded
- determine if file is empty (ssis)
- sql server: multiple queries or union
- java.lang.classnotfoundexception: org.jooq.util.javagenerator
- pagination on fast changing database content
- how to calculate the likely size of an olap cube
- confusing sql error in select null, *, null, null
- fluent nhibernate mapping to a sql server char(10) id column
- sql id from table posts same id to all other coldfusion entries per transaction
- how can i achieve sql case statement from linq
- sql server - add default constraints to all tables
- see list of all sql queries run on server
- what is a good way to provide a range of unique numbers (c# vs sql)?
- query optimization - order of expressions in where clause
- safe datetime in a t-sql insert statement
- nhibernate sorting (sql as a second option)
- create new table with subquery select
- sql: how to keep track rows already matched in a correlated subquery?
- sql server: delete from opendatasource
- get a count based on the row order
- tsql update statement with join
- oracle get id of inserted row with identity always
- handing executescalar returning null when no results are found
- limit result set in sql window function
- how to re-use sqlcommand object for a commandtext after executing a query based on stored procedure in c#?
- do indexes work in not in or <> clause?
- how to join on when both tables contain null
- how do i get the identity field that results from an insert?
- using left join to only selection one joined row
- how to restore using restore class of microsoft.sqlserver.management.smo namespace
- visual studio code vs sql formatting
- is it possible to map basic jdbc sql types to a java class?
- multiple oracle queries problem
- the model already has an element that has the same name - asp.net
- error 1452: cannot add or update a child row
- is it possible to connect to sql server without specifying a database?
- oracle sql: export to csv avoiding newlines
- why does a query generated by entity framework take twice as long to run as the same query run directly?
- ms sql float decimal comparison problems
- entity framework iqueryable extension methods do not work as a sub query
- c# object obj's value is {}. what is "{}"?
- handling large sql queries with linq
- how to select from variable that is a table name n postgre >=9.2
- can i create view in my database server from another database server
- how to insert list<t> into database
- sql query to store text data in a varbinary(max)
- get default sql value from entity framework class
- query to get "most recent" joining on other table with date
- sql server t-sql n prefix on string literal
- how to cast computed column with correct decimal/$ result
- is there any way to make this udf deterministic?
- sql raiserror specify parameter
- linq - where inside include
- issue when trying to read multiplte entity resultsets from a stored procedure
- am i closing this sql connection in a c# function appropriately?
- how do i select the max score from each distinct user in this table?
- transact-sql insert in two tables at once?
- sql parse delimited string
- share a data context across various model repositories in asp.net mvc using linq2sql
- how to concatenate multiple columns in pyspark with a separator?
- is there a "for xml path" equivalent in linq to sql?
- utility to create "data dictionary" for mysql database
- what is the advantage of using a date dimension table over directly storing a date?
- how to encrypt data in sql azure?
- visual studio 2015 update 2 and sql server 2016 schema compare
- faster to query one binary(1) field or 8 bit fields?
- sql combining several select results
- have mysql select statement return fully qualified column names like table.field
- mysql subquery order
- sql: count of rows before and after given row
- select the first element in a json array in microsoft stream analytics query
- in sql server, replace a char(0), the null character, embedded in a string with its hex code
- sql union of two queries, duplicate column name error
- sql-statement to use predefined values list as an sql-table
- t-sql substring
- open existing db in mysql workbench
- what can i do to improve performance of my pure user defined function in sql server?
- possible to analyse sql queries in sonar?
- finding the spanning forest (with recursive, postgresql 9.5)
- if-else statement in db2/400
- sql how to split one column into multiple variable columns
- cast into a decimal with a specified amount of decimal places
- sql word root matching
- how to create udf from scala methods (to compute md5)?
- what is the fastest way to copy data from one table to another
- server explorer unavailable (vs2008pro)
- sqlcommand return value parameter
- selecting multiple maximum rows
- optimize difficult query (possibly with squeel)
- why is linq to sql tricked by an extension method? what now?
- incrementing datetime field with an update statement
- how to output a file using tab delimiter in netezza nzsql
- sql: join on two tables where on column is null
- independent format for a string representation of date/time value, for ms sql server?
- insert into table with multiple values in subquery
- duplicated results when performing inner join
- how to detect all empty columns in a dataset and delete\drop them?
- an iterator adaptor implementing an sql-like right outer join using a hashmap
- saving bytearray to varbinary column in sql server inserts only one byte
- old-school sql db access versus orm (nhibernate, ef, et al). who wins?
- what version of sql server do i need to move database to production server?
- sql server rows to columns
- is it ok to check @@rowcount function to determine existence of a row?
- sparklyr can i pass format and path options into spark_write_table? or use saveastable with spark_write_orc?
- updating local sql server databases with clickonce deployment
- how to get count of two-way combinations from two columns?
- in an output clause in an instead of insert trigger, is it possible to reference both inserted tables?
- using ms access how to perform an update with multiple joins and where clauses?
- efficient use of sql group by, sum, count
- is there a list of exception error class values and what they mean? specifically sqlexception
- (recursive) sql query instead of loops
- entity framework mvc slow page loads
- how to kill a process/query in db2
- merging @sql from superclass with @sql in subclass
- are ad-hoc read-only queries stored in sql server transaction log?
- sqlite case sensitive search with collate nocase field
- how do i handle the timezones for every chat message
- strange behaviour of parameterized sqlite query
- using case statements with isdate in a sql where clause
- sql select values of each selected columns on separate rows
- how to remove duplicate columns from join in sql
- creating a date range table
- is there a sql query that will always return zero results? [closed]
- sql server date format user dependent?
- query with a union sub-query takes a very long time
- select from ... - based on a value in json format
- remove leading zeros
- sql server isdate in indexed view
- mysql and utf-8
- jdbc preparedstatements for multiple value inside in
- query for exact match of users in a conversation in sql server
- sql: how to get random number of rows from one table for each row in another
- sql server 2005 puts square brackets around column name
- how can i prevent/detect an underflow in a postgresql calculation that uses exp()
- is it possible to copy a filegroup from one database to another?
- sql server 2008 cannot drop constraint
- sqlsave in r to create and save a dataframe to an sql table
- why is sql server not using index for very similar datetime query?
- "set transaction isolation level read uncommitted" and views
- what is the proper way to refer to the sql dialect used by microsoft access?
- best way to store uint32 in sql server
- spring boot and database initialization not working properly
- update + with (rowlock) + cte
- recursive query with cte - sum of child columns for a given parent
- best way to store a list of numbers in an sql database?
- create one json per one table row
- db2 cascade delete command?
- in mysql, does putting select foo increase in performance if foo is indexed?
- insert into a temp table from a stored procedure on sql server 2000
- sql multiple where clause
- sql server order by syntax with case when and a constant
- how does database engine handle concurrent inserts?
- insert/select with linq - getting around the entity construction in a query
- ssrs 2008 export to microsoft word does not include headers and footers
- using select within select in mysql query
- mysql column = 0 returns true
- sql server: how to list changed columns with change tracking?
- how can i query the database culture (sql server 2005)?
- sql count/sum the number of calls until a specific date in another column
- prepared statements in libdbi
- importing data from access to sql server (with minor table changes)
- how to loop thru a table to find data set?
- deleting from two h2 tables with a foreign key
- n-grams from text in postgresql
- sql server database projects - missing template in vs 2013
- sql nested replace
- get latest date before date value in row
- sql - return limited number of rows, but full row count
- mysql string to date with given format containing a timezone specifier
- decimal number in mssql table gets rounded although precision is set
- alter auto_increment value by select result
- sql server generating random spatial geography around point?
- lag() function error within bigquery sql; unable to return lagged hits.page.pagepath
- need to validate usa zip code in a sql server stored procedure
- why does my sql server upsert code sometimes not block?
- why is my jdbc prepared statement update not updating the database?
- rows with null value for group_concat not returned
- check if opened window has been closed
- is it possible to tell ssms not to check if a column exists in a t-sql script?
- can you create a linked server in sql server and then refer to it with an alias
- why is this (non-correlated) subquery causing such problems?
- count(distinct) in multiple columns in sql server 2008
- does sql standard allows whitespace between function names and parenthesis
- how to make a nested query?
- loop through all tables and rename a column
- create a user defined function like sql server 2017 string_agg on earlier versions
- read value from a complex xml structure using sql server
- ambiguity in left joins (oracle only?)
- sql: need to remove duplicate rows in query containing multiple joins
- how the schema migration tools work?
- spring batch: could not increment identity; nested exception is com.microsoft.sqlserver.jdbc.sqlserverexception: invalid object name 'batch_job_seq'?
- hebrew and other languages in sql
- sql: comparing dates with only month and year columns
- how secure is azure sql connection?
- executing merge statement via c# sqlcommand not working
- cannot insert character '≤' in sql server 2008
- using alias from coalesce from select in where clause
- coerce result row into object
- performance difference between global database connection and opening connection everytime on golang
- select data grouped by time over midnight
- convert rows to columns in ms sql
- all the reasons i can't access an instance of sql 2005
- mysql how to get avg of values into specific range
- better performance for sqlite select statement
- why might sql server 2008 ole db udl require port 1433 explicitly specified?
- printdocument adds blank page
- column alias not recognized in where-statement
- postgresql: st_geomfromtext(unknown) does not exist
- hibernate exception: missing column (column exists)
- cannot launch ssms (sql server 2014 express) - invalid license data. reinstall is required
- how to emulate a before delete trigger in sql server 2005
- lu.[tablename] instead of dbo.[tablename]?
- rdd to dataframe in pyspark (columns from rdd's first element)
- t-sql convert xml field to multi-column dataset
- sql inner join query returns two identical columns
- oracle update multiple spaces in a column with a single space
- track changes in microsoft sql server database
- sql server trigger to delete one record from multiple tables
- postgresql fastest way of getting the set of unique values in one column or a large table
- xquery to get list of attributes
- filter duplicate nodes before inserting into xml field
- sql join only if all records have a match
- sql oracle rownum on multiple where clauses?
- stored procedure to return a specific interval of records
- how to access csv file within war using h2's csvread() function/query?
- update multiple attributes on sql server xml data field at once
- the given value of type string from the data source cannot be converted to type bigint of the specified target column
- sql query: which one should i use? count("columnname") or count(1)
- anydac aka firedac cannot generate update query
- sql server arithmetic overflow error converting expression to data type datetime
- how to convert a datetime string to a datetime in sql server
- using posgresql array_agg with join alias in jooq dsl
- microsoft t-sql counting consecutive records
- sql self-join to return specific rows
- connect a c# mvc application to a remote sql server database
- how to select from a datetime column using only a date?
- hibernate native query optional parameter throws 'operator does not exist: bigint = bytea'
- different execution plan for the same stored procedure
- convert string list to binary list in pyspark
- partial/full-match value in one rdd to values in another rdd
- concatenate the result of an ordered string_split in a variable
- odbc: how to bind a empty string?
- mysql - can we order by column position instead of name?
- linq-to-sql left join on left join/multiple left joins in one linq-to-sql statement
- locking table in postgresql
- querying sql server geospatial data from r
- sql query that returns aggregate and non aggregate results
- java: sqlite throws exception after writing a few records?
- spark throws error when reading hive table
- sql statement help -- select customers who ordered today
- selecting employees with birthdays in given range using oracle sql
- handle multiple db updates from c# in sql server 2008
- sql server stored procedures: do they queue up?
- whats the exact meaning of having a condition like where 0=0?
- postgres, update and lock ordering
- how do i get 5 records before and after a record with a specific id?
- in sql, how can i generate every possible unique combination of 5!56?
- getting values from xml type field using in sql server
- is it good practice to trim whitespace (leading and trailing) when selecting/inserting/updating table field data?
- sql server slow select query from type varbinary(max)
- how to find the assembly registered in sql server?
- exception handling around the rollback of a sqltransaction
- sql - consolidate overlapping data
- is it possible to reuse aggregate functions results in the same select?
- how to connect visual studio 2010 express c# to sql server express
- top 1 query from each id with multiple instances
- get wrappedarray row valule and convert it into string in scala
- strange datetime behavior in sql server
- ssrs excel export adds total rows for groups, not other formats
- how to pass parameters in a native query jpa
- real time sync from sharepoint to sql server
- creating and selecting table variables dynamically in sql server stored procedure?
- how to select distinct row based on multiple fields
- how do i reference an alias in a where clause?
- find missing pairs in sql
- ms access set cascade-to-null constraint to existing table
- how to use order by in alphanumeric column in oracle
- how to solve msg 8115, level 16, state 2, line 2 arithmetic overflow error converting expression to data type int.?
- t-sql: parsing string with multiple delimiters
- delete from 3 tables with one query
- downloading xml file from sql reporting server
- select distinct in dataview's rowfilter
- dot product in an sql table with many columns
- select row which contains exact number in column with set of numbers separated by comma
- installing ssis
- how to limit number of rows returned from oracle at the jdbc data source level?
- knitr sql chunk not saving data into variable
- mysql group by returning incorrect result
- how do i make a sql job step quit reporting failure
- findasync is slow, but lazy loading is fast
- ssis package upgraded by deployment
- expression in ssrs not working as expected
- instead of trigger to update view with multiple tables
- sql query for splitting the strings into rows and columns
- using sum on nvarchar field
- npgsql parameterized query output incompatible with postgis
- sql server: cast bool as integer
- ms access to sql query issue
- how to add rank column?
- why newly created functions can not be found by sql server?
- sql server describing first result set fails when temp table is used (sp_describe_first_result_set)
- sql server job dynamic schedule
- order by items must appear in the select list if select distinct is specified error
- how can i display tree structure in html from closure table
- insert a empty string on sql server with bulk insert
- jdbc dates deprecated in java (java.sql package)
- union and order by
- convert image datatype to string in sql server
- sql server 2008 nvarchar(max) concatenation - truncation issue
- failed to login as 'domain\computername' pyodbc with py2exe
- sql syntax for "if exists"
- sql-query takes a lot longer time in code than query db direct
- sort by most recent but keep together by another id column
- how to change the decimal separator from a comma to a dot in sql server
- mysql show null results in query - with inner join
- conversion of integer to datetime differs to vb6
- when does a query/subquery return a null and when no value at all?
- sp_msforeachtable to execute procedure on each table
- automatically remove gaps in primary key sequence
- c# sql connection driver
- ordering select clause result in specific way
- getting the 'date' out of a datetime field in sql server
- azure, mvc web app architecture - how to split data between sql azure and azure table storage?
- how do i get linqtosql to pass “index hints” to sql server?
- sql server - before insert trigger
- sql: speed improvement - left join on cond1 or cond2
- postgres settings for django on google app engine flexi
- multiple use of left join brings only 1 row
- how do i prevent linq from adding a guid so that sql server can do it?
- sql server count on a grouped by
- joining two hierarchical queries to form larger hierarchy
- adding a new empty column to sql select query
- daily/weekly/monthly record count search via storedprocedure
- how to escape single quotes in doctrine
- sql select... in result order
- how to get the latest message in each conversation of a certain user in sql?
- in sql server how can i use row_number() with a subquery column?
- does update change the order of records in a table in postgresql?
- limit number of rows per group from join (not to 1 row)
- oracle: pivot (coalesce) some counts onto a single row?
- unable to convert sql query to linq query for left outer join
- checking rule violations before deleting a record
- sql server + select top 1 record of all the distinct records
- how to use curdate() in check clause?
- cloud sql proxy and insufficient permission
- sql server import wizard doesn't support importing from excel sheet with more than 255 columns
- check and map ip address to subnet lookup table with sql
- convert sql columns to rows
- understanding transactionscope timeouts
- stored procedure maximum pattern match
- how did i wrong my datacontext?
- how to define a regular expression with multiple or operators where each term includes a space prefix and suffix?
- web.config authentication error
- is it possible to return ienumerable of anonymous objects from datacontext.executequery?
- timestamp discrepancies between sql server and java
- dynamic expressions in "where" clause - linq to sql
- using a column alias in sqlite3 where clause
- extracting multiple similar rows for each distinct type of a column
- what's the difference between filtering in the where clause compared to the on clause?
- how to load huge (but simple) hierarchical xml file into an sql table
- select where count = 1
- mysql: finding repeated names in my user table
- sql - convert time series events into on/off pairs (handling potential missing on's or off's)
- select range (limit) of results in oracle sql / pagination
- svg viewbox reversing y-coordinates
- sql server : ddl trigger, controlling table creation
- sql server: execute as clause of stored procedure not granting sysadmin permissions
- generate a sql clause using a linq-to-sql expression
- how do i update selective fields in sql (leaving some unchanged)?
- global temporary tables - locking rows + concurrency question
- does jooq support joda-time?
- merge rows based on date in sql server
- can't find table "cdc.lsn_time_mapping"
- t-sql updating current row to next row's value issue
- how to eliminate duplicate calculation in sql?
- sql server: insert a new row for every unique value in column 1
- convert datetime in sql server
- optional where clause / parameter in a sql 2008 stored proc?
- reduce the amount of data scanned by athena when using aggregate functions
- sql trigger - which table does it belong to?
- convert tables with "id,attribute,value" columns to "id,attribute1,attribute2,..."
- right to left string in crystal report
- how to join two tables without any condition
- mysql: select max() from sub-query with count()
- "model already has an element" errors (tsd04105) when using visual studio 2008 database project gdr2
- sql server stored procedure case sensitive?
- how to perform a bitwise operator on result in postegres?
- why aren't my sql placeholders being replaced (using go pq)?
- sql max of column including its primary key
- does sql server optimize like ('%%') query?
- sql performance, using option (fast n)
- in sql, how do i get the row with the maximum value for a particular column?
- sql server between
- mysql query - inner join using only the latest version of an entry
- value todf is not a member of org.apache.spark.rdd.rdd
- how do i correctly dispose a linq to sql datacontext in a repository?
- cumulative summing values in sqlite
- running async js functions on bigquery with #standardsql
- how to tackle not null constraints in ole db destination in ssis package?
- comparing the dates logic in linq
- rename column in db2
- sql group by modulo of row count
- what are the pros and cons of one master base table which all entities inherit from?
- unicode characters causing issues in sql server 2005 string comparison
- mysql faster insert
- lock whole database?
- select rows that appear more than once
- efficiently select random rows from large resultset with linq (ala tablesample)
- sql not in possibly performance issues
- conditionally summing the same column multiple times in a single select statement?
- what applications are there for nullif()?
- are sql strings null terminated?
- in sql server how do i order table rows by insertion order if primary key is guid?
- how can i make three columns my primary key
- unable to transfer sql server varchar(max) to mysql text using ssis
- sql query and datetime parameter takes long time to execute
- multiple join statements not returning the expected result
- converting play! framework evolution from mysql to postgresql
- ddl commands are autocommit in sql server, what does it mean?
- wp_query same request, different syntax - one of which does not work
- query optimization with case statement
- insert values into table after splitting the string
- sql server: how to query data all rows as json object into next to other columns?
- sql server related question
- executing t-sql view from ado.net
- porting "sql" export to t-sql
- getting a mysql error code: 1265. data truncated for column when doing a load data local infile
- how do i create a dynamic sql query at runtime using jdbi's sql object api?
- sqlite: bad performance with on delete cascade
- inserting dates before year 1950 in oracle
- mysql query to search for items with certain tags
- sql regex get phone number
- sql - how to select a row having a column with max value (+ group by)
- mysql consolodating table rows with overlapping date spans
- dealing with "hypernormalized" data
- how can i find consecutive active weeks in sql?
- asp.net update table on click of a button
- caching sql queries
- how do i get the "next available number" from an sql server? (not an identity column)
- spark sql's where clause excludes null values
- i want to exchange the value of a column in two different rows in microsoft sql server
- mysql modify unsigned attribute to specific column
- sql server - is there a collation that provides natural order for numbers?
- sql pivot to flatten rows into columns
- how can i read a string column as a list in mysql?
- sql, get the average on a group while escaping the where condition
- sql - find all instances where two columns are the same
- sql server 2014 code snippets missing
- how to get sql server datetime field in odbc native client
- why does from_json fail with "not found : value from_json"?
- how to move data between multiple database's table while maintaining foreign-key relationships/referential integrity?
- cannot cumulatively sum `count(*)`
- postgresql function returns composite - how do i access composite values as separate columns?
- mybatis doesn't return all the results from the query
- qsqldatabase::open() always returns true
- sql server filestream how to populate the filestream column
- how to search for "%" in sql table-column
- more efficient way to find employees with coverage between two dates
- what is the preferred merge method for sql server 2005?
- import first 1000 records into sql server from a csv file
- select rows after a row with a certain value
- how to extract numbers from a string using tsql
- on update restrict on delete cascade
- unknown column in field list when using sum(something) as a
- are cdata sections really unnecessary?
- impersonation in sql server views?
- empty blobs - sql server
- sql server management studio 2014: unable to view stored procedures on azure sql database v12
- sql calculate days between two dates in one table
- does sql server expand a view's sql inline during execution?
- ssis script task - vb - date is extracting as int instead of date string
- is bit field faster than int field in sql server?
- sql get top 10 records by date
- sql clause vs expression terms
- sql server: select distinct mon-yyyy format output sorty by descending order
- order by in view returns different results sql
- sql server 2000 jdbc driver
- sqlite exists keyword : how to query the highest average?
- how to make row numbering with ordering, partitioning and grouping
- convert month and year combination to date in sql
- how can i 'walk' the relationships between tables in linq?
- how to "average" two or more geography linestrings using c#/sql server 2008 spatial
- run db migrations on cloud build connecting to cloud sql using private ip
- get the missing value in a sequence of numbers
- how to select lowest level in hierarchy from table
- selecting a column with period in the column name sql server
- pyqt - load sql in qabstracttablemodel (qtableview) using pandas dataframe - editing datas in a gui
- is there a single query that can update a "sequence number" across multiple groups?
- mysql: all parts of primary key must be not null; if you need null in a key, use unique instead
- inserting data into multiple tables through an sql view
- multiple conditions with case statements
- extjs dateformat issue
- creating a function in postgresql that does not return composite values
- how to write dataset to a excel file using hadoop office library in apache spark java
- postgresql order by column position (and not by column name)
- select top 1 * from table fails in sybase procedure
- get identity value in the same t-sql statement it is created in?
- regular expression in mysql query
- full outer join or union?
- storing video duration time in sql server
- how to return multiple classes as iqueryable<t>
- postgresql error: set-returning functions must appear at top level of from
- basic linqtosql question: why won't this compile?
- how to get results of this particular "query"
- how to create a stored procedure with schemabinding?
- sql converting string mmm.yy to date
- oracle ora-00902 invalid datatype error
- how to run multiple sql scripts, in ssms, against sql azure?
- sqlite selecting two columns as one with null
- sql server parallels to oracle dbms_metadata.get_ddl?
- unique constraint only over non-null columns
- spark dataframe grouping, sorting, and selecting top rows for a set of columns
- localsystem vs. system vs. local system windows system accounts [closed]
- powershell returns negative exit code while script results are correct
- replace comma between quotes with space
- what is the way to populate a dropdownlist from a database in asp.net by using classes?
- sql: can i insert some fields from variables other from another table
- oracle sql: how can i output a table from procedure
- searching encrypted field in postgres
- complex sorting based on next and previous records in sql
- sql server with different database of different time zone. how to get getdatetime for all database
- charindex() counts white chars in the end, len() doesn't in t-sql
- oracle performance using functions in where clause
- how convert a byte[] to a data to insert a value in a varbinary(max) column in sql server?
- how to find data table column reference in stored procedures
- prevent sql injection without using cfqueryparam
- sql foreign key constraint error 1025 (152)
- oracle : dynamic column name
- java hibernate org.hibernate.exception.sqlgrammarexception: could not extract resultset on createsqlquery
- linq query having group by
- what's wrong with my sql? (find a "previous" record)
- improving speed of sql query with max, where, and group by on three different columns
- how long should a primary key delete take?
- pyspark: custom function in aggregation on grouped data
- search matching prefix of every word in field in sqlite
- org.apache.spark.sql.analysisexception: 'write' can not be called on streaming dataset/dataframe
- new object in entity framework - problems with primary key
- union all performance in sql server 2005
- unit testing practice with linq to sql
- how to use a recursive query as a subquery?
- t-sql join table only when the table is not empty
- sending a datatable as a parameter to stored procedure
- ms access alternative to sql function row_number()
- postgresql various clean up of string \ varchar
- problem reading out parameter from stored procedure using c#
- is it possible to use linq to alter a database table?
- increase validity of always encrypted certificate
- how to join tables from two different contexts with linq2sql?
- speeding up queries with linq
- scala string variable substitution
- why does sqlclient use unnecessary xml conversion while passing sqlxml?
- determining index of last uppercase letter in column value (sql)?
- t-sql to "merge" two rows, or "rekey" all fk relationships
- ms sql 2008 join - select one from many results
- sql server function to add working days to a date
- getting sourcecontrol on stored procedures
- calculate sum of spent time
- sort datetime in html5 web sql database
- oracle sql: is order by non unique field deterministic?
- mysql convert row_number() over partition
- c# obeying the newline character in a string pulled from sql server
- sql refusing connection in load test
- "inverse" limit?
- sql server "network-related or instance-specific error" once a day or so (perplexed!)
- sqlite 3 "sql error 'out of memory' (7)" objc
- fill in missing values
- spark - exception in thread "main" java.sql.sqlexception: no suitable driver
- join tables in sqlite with many to many
- in linq to entities can you convert an iqueryable into a string of sql?
- where can i find an official grammar for the pl/sql programming language?
- how to join two jdbc tables and avoid exchange?
- sql server: arithmetic overflow error converting expression to data type bigint
- create table reverse engineering in oracle
- sql azure - maxing dtu percentage querying a 'empty table'
- sql server compact edition 4.0: error: 26 - error locating server/instance specified
- sql query to get difference between adjacent records
- how can i call a function in another cfc file from within a query of a function in one cfc file?
- sql server 20xx - "encryption not supported on the client" when compiling stored procedure with linked server query
- add a column in ms sql server table
- how to find running multiplication
- t-sql date range in a table split and add the individual date to the table
- maintaining stored procedures in source control
- insert into select strange order using union
- t-sql use satetement in condition
- sql alchemy overriding ==
- symfony2 (doctrine2) native sql insert
- java.sql.sqlexception: field 'id' doesn't have a default value
- postgresql grouping error
- poor clustered index seek performance?
- get percentiles of data-set with group by month
- sql server profiler
- bigquery error: 400 no matching signature for operator between for argument types: date, timestamp, timestamp
- cross apply in linq
- how to efficiently check if two columns in the same table is one-to-one mapping?
- mysql booking site: query/db optimization
- does using sql parameter binding mean text can be directly entered from input?
- informix memory leak
- error when sql-querying flatfiles with custom file-extension
- how do you track the time of replicated rows for subscribers in sql server 2005?
- how to replace substring in a column using lookup table in sql server
- access 2010 sql-- using where in on select top subquery field
- mysql join on like statement
- multiple days of week stored in one field
- insert blob from a file into a sql script to embed h2 database
- race conditions between insert on conflict do nothing and select
- what's wrong with this first_value query?
- violated - parent key not found 02291. 00000 - "integrity constraint
- sql cursor in dynamic content
- include sql server database in application
- my sql table is set to allow null for this column, but when i run it, it says it cannot be null. what/why/how?
- shuffle column values per row
- parent_id a foreign key(self reference) and null?
- linq to sql specified cast is not valid error with union
- what other dependencies do i need to install in visual studio 2019 express / community to open a dtsx siss file in the gui?
- oracle sql or pl/sql: compute based on previous row values and on date column
- rails 3 activerecord & postgres: order by count on association
- adding inner join and where clause to insert into on duplicate key update
- linq: how to dynamically use an order by in linq but only if a variable is not string.empty or null
- issue on trying to query geojson multipolygons in sql server 2016
- max over multiply columns
- what would prevent code running in a docker container from connecting to a database on a separate server?
- sql group_concat and subquery
- calculate year from date difference in oracle
- mysql: how to associate a column alias with a specific join clause
- sql server "for xml" output from queries joining two tables
- magento module sql does not run
- doesn't quotename work inside of exec?
- sql - how do i delete two entities referencing each other
- dynamic query to union multiple databases
- getting records of one and only one type
- detecting if sql server 2008 is installed
- sql server pivots: displaying row values to column headers
- dynamically adding zero-valued records for subsequent aps for analytical function to work
- ssis lookup transformation advanced editor(modify the sql statement)
- oracle script problem - create trigger not terminating
- sql most recent order? ms sql
- appending messages in a variable using coalesce function
- why can't isnull be called inside a contains statement?
- automatically sync sql databases across two computers
- what sql returns duplicates in first column where values in 2nd column differ?
- best pratice to send asp.net webform to jquery autocomplete
- tsql how do you iterate through rows while parsing them?
- sql server varbinary(max) to c# byte[]
- error: "bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (date)."
- select only rowwith highest id value if there are identical column values
- how to get all ssrs subscription data using stored procedure?
- get random object from sql database via hibernate
- orientdb sql vs gremlin
- why does a sqlexception thrown by sqlcommand.executenonquery contain all the prints as errors?
- datagrid doesn't refresh on changed data
- sqlite column aliasing
- how to update a single bit of a binary number as toggle?
- how to use local database .sdf in c# wpf?
- getting error: "error converting data type nvarchar to numeric" in sql
- bulk inserts of heavily indexed child items (sql server 2008)
- how to have a primary key with null values using empty string?
- ordering street address in ms sql
- unexpected end of subtree exception after hibernate version update on delete query
- sql - selecting the first record found before a given date
- db2 convert iso 8601 timestamp string to db2 timestamp
- is sparksql rdbms or nosql?
- unable to open database when website hosted in iis
- problem convert column values from varchar(n) to decimal
- dynamic linq 2 sql using expressions trees raising exception "binary operator lessthan not defined for system.string and system.string"
- aggregate array type in spark dataframe
- validating update and insert statements against an entire table
- how can i query a value in sql server text column that contains xml (not xml column type)
- how do i do a "like" wildcard comparison in entity framework in .net 4.0?
- t sql "select case" vs "if ... else" and explaination about "begin"
- ssis - sql server datetimeoffset(0) destination column recognized as dt_wstr
- how to return t-sql query with column names as first row
- why is this cte so much slower than using temp tables?
- timestamp interval
- sql injection-proofing textboxes
- geo functions from sql server 2008 to c# (latitude and longitude points inside or outside polygon/map area)
- trouble with sql syntax
- insert into postgresql
- postgresql insert or update values given a select result after a trigger has been hit
- mysql - need search result of maximum matching letters from a string
- can i join two tables whereby the joined table is sorted by a certain column?
- how can i select the last edited version of the post?
- can i get ssms to switch to the messages tab programatically?
- reading xml that is saved as text from sql
- how do i log the frequency and last-used time for a stored procedure?
- how do i specify the database isolation level to be used, at a high level?
- convert a hexadecimal varbinary to its string representation?
- sql join - summing count of different values
- delete recursive children
- dynamic month year columns per date range
- mysql - using count and limit functions together
- llblgen: select distinct?
- add column to pyspark dataframe based on a condition
- selecting with two references to same table
- why does my relational tables throw outofmemoryerror?
- entity framework 4.1 - code first: many-to-many relationship
- finding overlapping intervals using sql
- cross apply does not work with sql server 2000?
- how can i set sql_mode to a list of values
- t-sql with if logic not working with temp table
- sql for xml path list and count
- how to create a join across two foxpro databases using the ms ole db provider?
- rails 2.3: how to turn this sql statement into a named_scope
- dynamic queries with hibernate
- use jooq to do a delete specifying multiple columns in a "not in" clause
- how to compare a string as an integer
- how to execute a stored procedure after it is created?
- should an sql dictionary table have an identity column
- how would i perform math within a sql query to calculate percent difference?
- sorting null-data last in database query
- need to use row_number without over in sqlserver 2005
- how to know which linq statement produced the sql on hand during runtime?
- list distinct tuples in a table(sql query)(10 ways)
- why is my query returning far to many results?
- sql query adding column values
- how to rename items by assigning sequential number?
- change data capture for updates and deletes only
- checkbox bind even if null (datatable control)
- why is my mvc 5 application trying to access local db
- how to make live changes to sql server express
- sql: show average and min/max within standard deviations
- error "sqlserver_ado isn't an available database backend" (pyisapie on iis)
- access gcp cloud sql from ai notebook?
- how to store 'fully qualified' and 'name only' file name in ssis variable
- classic asp - sql server does not exist or access denied
- oracle query to calculate current age
- sql oracle : how to find records maching a particular id in the column
- for a writeless transaction which is cheaper/quicker: commit or rollback?
- mysql select only percentage of rows
- group by column alias
- powershell sql query to csv to excel workbook
- how to limit an sql result set to not too common items
- how would be the right way to use exists clause
- how to add new columns based on conditions (without facing janinoruntimeexception or outofmemoryerror)?
- c# and sql server 2008 clr serialization problem
- sql statement not selecting
- connecting to ms sqlserver from qt linux application
- portable sql : unique primary keys
- sql music playlist database design
- calculating a daily average (or: how many mondays are in a date range?)
- how to read sql server schema info in .net?
- copy rows with pk feedback loop
- sql join two tables with specific condition
- selecting same column twice from a single table but with different conditions
- how to compare two tables in ssis? (sql server)
- implement recursive cte for hierarchical query to mariadb
- an aggregate may not appear in the where clause unless it is in a subquery
- postgres update with join
- selecting sum of the count from tables in a db
- install an sql dump file to a docker container with mariadb
- dynamically select and update a column value in linq resultset
- how to get results of stored procedure #1 into a temporary table in stored procedure #2
- sql: extract date from string
- many to many table design question
- sql query runs faster than stored procedure
- how to insert row in sql database in ado.net connection oriented mode
- how to select sequential duplicates in sql server
- asp.net core 2.1 serilog sql server sink using azure sql is working locally but not from azure app service
- can osql.exe run as a standalone?
- loading ssis package programmatically in c#
- reset sum when condition is met in oracle
- mysql limit x, y equivalent for sql server l?
- what gets disposed when sqlcommand.dispose is called?
- sql left outer join's unexpected output
- inserting to a local table from a linked stored procedure
- how do i pass a string parameter greater than varchar(8000) in sql server 2000?
- webmatrix csv import to sql server compact
- pyspark sqlcontext read postgres 9.6 nullpointerexception
- sql server 2008: rename an element using xml dml?
- asp.net mvc linq sql problem
- aggregate boolean values to true if any of the source columns is true
- mysql select query using count (*)
- oracle 10g pl/sql connect by prior returning child and parent on same row
- sending parameters to stored procedures vb.net
- delete from database all selected rows except first two
- inserts with sequential guid key on clustered index not significantly faster
- how to lowercase the whole string keeping the first in uppercase in mysql
- normalised database - one to many - search through all joined data sets
- usql - how to select all rows between two string rows in usql
- sql; only count the values specified in each column
- using cloud_sql_proxy behind corporate firewall - can't connect to mysql instances
- how do i drop a table column in sql server 2012? [closed]
- columns in oracle pivot
- sql-server replace empty cells with null value
- passing value to the null value column in sql
- remove duplicate entries in a mysql table
- import dbf files into sql server
- importing csv file with null values into phpmyadmin
- generic way to find or create an object in linq to sql?
- hresult: 0x8004d00e using transactionscope - c#
- why does invoking my update query in an access database via oledb not work?
- what format should the start and end lsn parameters be to sys.fn_dblog?
- how to measure query duration without showing results of query?
- sql ce inconsistent with multiple statements
- spark 2.1 cannot write vector field on csv
- sql: aggregate function and group by
- quickest method for matching nested xml data against database table structure
- how to exec a stored procedure from ssis to get its output to text file
- index on every foreign key?
- recursive/hierarchical query using postgres
- how do i write a sql concat in linq?
- updating record in ef 4.1
- displaying rows in sql server where count = 0
- syntax error when the column name contains underscore
- dynamic/conditional sql join?
- get all overlapping date ranges when all overlap at the same time
- order by is currently only supported on the clustered columns of the primary key
- postgres get first and last version for individual vendor
- what sqlcommand.parameters.addwithvalue really does?
- split column into two columns based on type code in third column
- "data connections" in azure
- spring isolation support? msql snapshot isolation
- sql server table audit trigger
- got error, "some part of your sql statement is nested too deeply" only on some servers
- db2 sql script: how to start a transaction and rollback on error
- postgres - how to create an alphanumeric sequence like aaaa0000 and so on
- jpa mapping a java double to a sql number column
- how to have a child group span across three columns?
- sql full outer join
- pivot query to return multiple repeating groups?
- how can i compare rows from 2 tables that have composite primary keys?
- xml export via bcp bulk export
- what should be the strategy to handle the sql exceptions?
- count(*) with and without group by, no matching rows
- t-sql stored procedure - dynamic and/or operator
- insert data into sql server with best performance
- pl/sql trigger issues
- coldfusion sql insert loop
- entity framework core one to one relationship generate one to many in sql server
- dbdatareader, nextresult() and filling more than one table
- org.dbunit.dataset.nosuchtableexception, but table exists
- how to list all columns of a given sql query
- postgres simple 'pivot' table
- reference is ambiguous with sparksql csv
- sql join to get the cartesian product of 2 columns out of 3 columns
- how does a "schema changed after the target table was created" error occur?
- how to get server os local time in all postgres versions
- mysql query using 'in' operator: why different results w/ quotes?
- how do not scan all records to query top rows by complex condition
- postgresql where with age() function
- get sql query from nhibernate criteria, before the criteria executes
- sql query to select percentage of total
- sql server 2008 - find which tables contain specific text
- how can delete be both a ddl and a dml statement
- sql server - evaluation period has expired error
- how to get particular object from jsonb in postgresql?
- grouped aggregations with yii stat?
- sql server: why xp_cmdshell is disabled by default?
- postgresql group by: select column on max of another where a third column = x
- coldfusion: sql select in from a query
- how to use [charlist] wildcard in android sql search
- providing a limit param in django query without taking a slice of a queryset
- rails active record: how to reduce number of trips to database?
- sql except performance
- select statement on non-existing columns not being caught by exception block
- how to specify primary key when using vba to create tables
- ms-access 2003 sql modification for resetting sum values based on a date
- how to improve limit clause in mysql
- add a column to a table with check constraint sql
- oracle get all dates in a month
- display rownum issue mysql
- how to execute statement for each row and return entire result
- java regex to remove sql comments from a string
- an invalid floating point operation occurred
- java.lang.classnotfoundexception: org.apache.spark.sql.dataframe error when running scala mongodb connector
- confusion between service based database and local database
- t-sql different datatype possible in a case?
- get row with max(column)
- why does visual c# express 2010, becomes slow and choppy, and the handles in task manager become excessively high?
- is it possible to insert data into the mid section of a table using the insert command?
- how to transform dataset[(string, seq[string])] to dataset[(string, string)]?
- can i treat the results of a stored procedure like a table?
- efficient sql 2000 query for selecting preferred candy
- the best way to extract data from xml with xquery
- windows ce 6.0 - installing sql server ce 3.5 into the run-time image
- copy one database to another database
- pivot function on multiple tables and dynamic columns in sql
- int pk inner join vs guid pk inner join on sql server. execution plan
- @@error in sql server 2005
- mysql: execute the second query only if the first query doesn't return result
- mysql nested query running very slow?
- apache beam - org.apache.beam.sdk.util.usercodeexception: java.sql.sqlexception: cannot create poolableconnectionfactory (method not supported)
- how does a sql statement containing mutiple joins work?
- linq 2 sql , insert objects with associated child objects list into database , silverlight ria
- how can i use a variable for a ole db connection in ssis
- copy the encrypted column to another database sql server 2012
- sql: split comma separated string list with a query?
- how can i set default values in entity framework
- azure sql sync between subscriptions
- how to insert into remote table using linked server withint transaction?
- gorm and sql server: auto-incrementation does not work
- ampersand (&) character is being ignored in oracle order by
- ssis - dynamically moving files to folder with matching substring name
- sql/sql-lite - counting records after filtering
- connect to sql server from powerpoint
- join a table with previous record of same table
- sql join tables on time between start and end
- postgresql: count query takes too much time
- mysql advanced order by query
- how to insert a new record which has a auto increment number as primary key?
- linq to sql database row not updating
- sql: select one record for each day nearest to a specific time
- create id column based on activity data
- mysql many-to-many condition which combine and/or
- penultimate date for each record
- order by function not working in oracle
- month increment query
- why do functions on columns prevent the use of indexes?
- how to select data that is older than 12 months?
- why is endexecutenonquery() needed?
- accessing cloud sql from cloud run on google cloud
- how can i get rid of dynamic sql
- azure sql: invalid object name using powershell's "invoke-sqlcmd" on adventureworks
- improving query performance by using views
- how to split data into groups in pyspark
- sql logic problem & cross apply query
- column is invalid in the select list because it is not contained in either an aggregate function or the group by clause
- sql. how to reference a composite primary key oracle?
- hive - create map columns type by aggregating values across groups
- select and count distinct active users by platform and compare if they exist in other tables
- sql server 2016 developer version can not connect to (localdb)\mssqllocaldb
- t-sql - compare strings char by char
- sql to parse a key-value string
- create index on partial char column
- how to store time duration values in mysql as the time datatype?
- what are in sql server user instances that make them impossible in non-express editions?
- why won't connection string work for ef migration?
- decryptbypassphrase is not working after creating them with encryptbypassphrase
- mssql table multi foreign key cascade
- bulletproof way to drop and create a database under continuous integration
- t-sql - minutes per hour between two datetimes
- how do i structure an oledbcommand query so that i can take tables from one .mdb, and replace them in another .mdb
- sql having sum group by
- create view on h2 database
- add the not null constraint to a column
- sql - add sequential counter column starting at condition, with group by and non incrementing ids
- oracle 11g - for loop that inserts only weekdays into a table?
- how to get average values for time intervals in postgres
- linq stored procedure issue- returning an int
- how do i use different version of java
- how to execute a sql statement in java with variables
- what are the ramifications of granting a db user with limited access execute permission?
- how to loop through different schemas and execute some sql on each?
- sql server: "could not find the database engine startup handle" [closed]
- best practice to keep rss feeds unique in sql database
- how to traverse through a table which has relation to itself?
- how to compare a datetime type in sql server
- timeout error - sending mail through sql mail - service broker queue
- can sqlexpress 2005 and 2008 be installed on same machine without issue?
- get resultset from stored procedure
- conditional operator in c# and return types
- bulk load xml referring to auto-increment parent-id
- why does my query break when it is parameterized?
- how do i add an attribute to xml contained within a clob in an oracle database?
- set one row fields as a multiplication of 2 others
- creating static datacontext() or creating whenever its needed. which is better, and why?
- convert mysql query to sql server (mssql / sqlsrv) (with distinct)
- how to refresh a test instance of sql server with production data without using full backups
- can multiple compiled linq queries be chained together?
- what is the best way to cache a table from a (sql) linked server view?
- more efficient query than not in (nested select)
- simply tick a checkbox in a fuzzy lookup transformation object using ssis biml
- executing an oracle stored procedure from sql server 2005
- how to script a stored procedure from tsql
- datetime conversion error for 1 sql server, but not another
- incorrect syntax near '=' sp_executesql
- mysql query for month year
- mysql update rows with double left join, limiting first match
- custom sql group by clause
- sql primary key exception
- how to make a wrapper to return something other than ref cursor
- sqlite database in android and java
- how do you make the python msqldb module use ? in stead of %s for query parameters?
- assign css class to html tags generated with sql 'for xml'
- ssrs - how to make iif statement ignore invalid values
- getting last 6 records for each team in a mysql database
- insert all rows from table into other table, single query
- 'invalid column name' while using the having
- stored procedure gets dropped randomly
- linq to sql transaction and read id of inserted record
- sp_executesql with n arguments is causing slow performance
- adding parameters to a stored procedure in sql server
- cannot insert the value null into column ... when the value is not null
- entity sqlce can't find connection string in app.config file
- how to group by week specifying end of week day?
- ef core 3.0 - convert sql to linq
- get non-overlapping dates ranges for prices history data
- postgresql select value and increment at once
- sql query across multiple sql servers
- isnumeric in sql server join
- convert update into insert into on duplicate key update statement
- gather stats on an index or drop create?
- unable to drop a mysql table
- java.sql.sqlexception: ora-06550: line 1, column 13: after granting user permission to execute package
- sql agent command line not saved
- setting where condition to use ids.contains() in executesqlcommand()
- database design for multiple room reservation: one to many
- joining multiple unrelated tables in mysql
- handling insert and delete with multiple users in sql
- dts vs. ssis vs. informatica vs. pl/sql scripting
- using sql sum with case statement containing inner select
- sql - counting a column twice
- upsert in sqlite
- return array of years as year ranges
- ssis expression previous date without dateadd()
- sql trigger to update another table
- sql server change data capture - capture user who made the change
- calling oracle pl/sql stored procedure from java middle tier using jdbc on linux?
- sql: find top-rated article in each category
- java - mysql - select query outfile - where is file getting saved
- near matches not found in containstable
- (how) can i number query result groups by row/result order in a single query?
- adding a further group into a recursive cte
- concatenate fields in order - sql server
- error while querying data on redshift - error fetching stripe data
- sql server 2000 stored procedure prevent parallelism or something?
- mysql insert order number by varchar field
- how should i be saving .doc documents to a sql server database
- catching sql exception in entity framework4?what is the best practice?
- working with ado.net and special characters in sql
- sybase sql select distinct based on multiple columns with an id
- t-sql query group in date order (gaps and islands)
- combining two sql select statements on the same table
- hibernate criteria - how to limit join results to a single entity type?
- dynamic linq & icompare
- does with statement execute once per query or once per row?
- hibernate result transformer cannot instantiate resultclass
- perform an or of two linq iqueryables
- is a mysql primary key already in some sort of default order
- hibernate sql audit logging
- sql select multiple conditions many to many relationship
- convert go-pg query into plain sql
- sql server - how to change table column only having some specific values?
- sql - select most 'active' time from db
- "missing columns in relationship" when creating table
- ef6 stored procedure with no results
- need some serious help with self join issue
- how to find substrings in sql (postgres)
- using sql credential to open a file with openrowset
- setting a default date format on postgresql
- how to filter keys in maptype in pyspark?
- what is the equivalent of sql not in in cascading pipes?
- how do i control the datatype of a computed column?
- inner joining two tables based on all "key/value" pairs matching exactly
- sql view: join tables without causing the data to duplicate on every row?
- bulk update sql server c#
- linq puts unwanted trailing spaces on strings
- n prefix and parameter
- when to use the table operator apply
- sql server : output inserted.id join with inserted temporary user defined table
- mysql select with statements
- unique constraint on one column with excluding row with same values in other
- how to determine if an ssis package (.dtsx) was created by bids 2005 or 2008?
- find polygon overlaps
- postgresql cursor with "order by" clause
- unable to quote table name in pdo with mssql
- how to increase perfromance of sql query for selecting from 2 tables
- query to merge continuous temporal records
- mysql: join many tables on one statement
- how to calculate sum time with data type char in oracle
- what is considered slow with respect to sql queries?
- sql query works in workbench but get 'could not convert variant type' error with the exact same query in delphi
- sql server : decimal precision/scale are yielding strange results
- how to optimize retrieval of most occurring values (hundreds of millions of rows)
- how to insert into sql server decimal column?
- why is my azure sql database table permanently locked?
- spark sql to transfer data between cassandra tables
- how to write a transaction using jdbc driver?
- get path of node in tree
- are there any advantages to using the vb.net like operator vs a regex?
- fulltext search over data with underscore
- sql: sum after group by
- what is the most performant way to rewrite a large in clause?
- how to specify a "like" on an integer column?
- sql server bcp export binary to file: extra data at the begining of the file
- if using linq to sql is there any good reason to learn sql queries/syntax anymore?
- apache spark - udf doesn't seem to work with spark-submit
- how to get child nodes without grandchildren and great-grandchildren? closure table pattern
- order by relationship properties neo4j
- mysql replace .html links of given domain
- msmq on azure website
- sql server express folder permissions
- time series querying in postgres
- how to rename sql table column name(s) and not break stuff
- getting timeout expired. the timeout period elapsed prior to obtaining a connection from the pool. .exception
- select all columns except those with only null values
- check if date is overlapping in sql
- poor performance using hibernate criteria api
- generating scripts based on condition
- how to write dataframe into mssql using pymssql?
- inheriting a linq to sql class and cast the result of a linq query
- jcr-sql - contains function doesn't escape special characters?
- is there a way to detect a cycle in hierarchical queries in sql server?
- sql query to fill column with combination of other columns
- fnd consecutive dates withing a defined span where a trainer is available to schedule
- what could be causing the primary key exception?
- how are the table data stored when it has a clustered index
- return 0 in group by when count(*) is null
- synchronize dataset
- python spark dataframe: replace null with sparsevector
- how to return a table variable from a function (udf)?
- how to get desired output in ssis by grouping by and count?
- parent child sql recursion
- ssis the percentage column from excel -> sql server
- linq to sql - problem with 1-to-1 association
- generate xml in proper syntax from sql server table
- a conditional select/join from a single sql server table in a single query?
- caching joined tables in sql server
- parenthesis() and sql query performance
- where clause if there are multiple of the same id
- how to insert data into a pl/sql table type rather than pl/sql table?
- sql connection.open() exception
- are the 'inserted' and 'deleted' tables guaranteed to return their records in the same order in an after update trigger?
- sql server : split multiple strings into one row each
- usage rollback to savepoint with condition
- which c# data types are not wcf serializable?
- distinct row values as columns sql server
- add column value to an xml field as an attribute
- database design 1 to 1 relationship
- how to execute multi batch delete in jdbctemplate?
- replace last two characters in column
- html escape in t-sql sql server 2014
- unable to create a constant value - only primitive types or enumeration types allowed
- joining two datatables in c# with non matching data
- execution time of alter column
- sql query working fine in sql server 2012, but failed to execute in sql server 2008 r2
- stored procedure is taking time in execution
- why use prepared statements instead of query / exec with go sql package?
- postgresql - unique rows, independent of order
- intermittent sql connectivity issue with aws rds
- entity framework database update first multiplicity conflicts
- how to set arithabort on for connections in linq to sql
- sql hashing a password
- query xml field with t-sql
- prefix every column name with a specific string?
- variant use of the group by clause in tsql
- how to get latest results by date when selecting from two table?
- mysql .csv load failing due to "cannot add or update a child row: foreign key constraint fails"
- kafka connect jdbc sink quote.sql.identifiers not working
- how to automatically drop constant columns in pyspark?
- ionic 2 - get token from storage value and set header before http request
- how to dump generated java code to stdout?
- oracle regex replace multiple occurrences of a string surrounded by commas
- load collection except another collection using linq
- use coalesce (or something like it) with group by in sql server
- how to concatenate all results from table row?
- converting pascalcase string to "friendly name" in tsql
- microsoft.reportingservices.interfaces.dll missing for ssrs 2005
- maxrecursion value from local variable
- in apache spark, how to make an rdd/dataframe operation lazy?
- using linq to sql in asp.net 5 mvc 6
- how to use string functions in the on clause of a left join with standard sql in bigquery?
- sql server 2008 t-sql features do not respect compatibility levels
- arithmetic operators against dynamic column in sql server 2008
- viewing oracle's metadata about primary/foreign key constraints
- undetermined sort order when using row_number() over decimal column with ties
- copy access database to sql server periodically
- choose first non-null cell from two columns in postgresql
- last 4 whitespaces of sql would hurt sql server performance?
- rails/postgresql - query to update all dates adding 1 day
- #1005 - can't create table 'table_name' (errno: 150)
- list temporary table columns in mysql
- why is my inline table udf so much slower when i use variable parameters rather than constant parameters?
- variable "in" expression in sql
- is there an easy implementation to use a predicate function in a generic f# query
- how to combine two sql queries?
- keeping one connection to db or opening closing per need
- creating a temporary table name with a randomly generated number
- coalesce function is not working when i pass null values but it works when declare variables as null
- oracle sql columns to rows without unpivot
- pagination sql query syntax
- need to find the type of the column of db
- update every row with a random datetime between two dates
- count number of nulls in a row
- sql server performance - subselect or inner join?
- update table with select from another but with a field being sum(somefield)
- c# insert data from datatable to sql server database
- using cast in sql with multiple column selections
- wrong calculation in sql-server
- stemming words in mysql
- how to divide a time type variable by 2 in sql server
- sorting union queries in mysql
- correlated query: select where condition not max(condition in inner query)
- how to store output of sql query in variable in batch script?
- trigger - is it necessary begin / commit tran
- binding multiple fields to listbox in asp.net
- dealing with huge amount of data when inserting into sql database
- sql update statement to update a column based on another existing row
- wrong object_name and definition relationship in sys.sql_modules and sys.objects
- ssis file system task error: the type of the value being assigned to variable ... differs from the current variable type
- a complex sql query string inner join common denominator
- filter a managedquery by file extension (or, alternatively, file type) for an android cursor
- how to search date in sql?
- turning on multiple result sets in an odbc connection to sql server
- spark-sql: unable to instantiate org.apache.hadoop.hive.metastore.hivemetastoreclient
- read subject and body of email using webdav and c#
- insert / update data using dbnull or null?
- not able to create database using stored procedure pyodbc sql server
- tricky select statement
- lightswitch beta 1 looking for sql express instead of full sql instance
- ssis import excel document using column position, not name
- does it delete partially if execute a delete statement without transaction?
- optimizing mysql table indexing for substring queries
- pad 0's to returned query and insert into temp table
- do mvcc databases see inserted rows in mid-transaction?
- using subquery instead of the tablename
- sql alter table then modify values
- converting varchar to decimal in sql server 2008
- semantic difference between join queries
- creating a foreign key in java db (netbeans)
- 'sparksession' object has no attribute 'serializer' when evaluating a classifier in pyspark
- how can i manage sql permissions between development and production?
- sql isset and not showing blank 'cells'
- modifiy connection manager information from ssis catalog from sql
- how to query integration services catalog
- perl, dbi with sql statement with a like condition
- oracle analytics - partitions and ordering of sql queries
- insert into temporary table query
- employee id automatic generate with prefix
- best primary key format for large table
- how to store arrays in a database?
- writing large amounts of records to access using vb
- check if an element is contained in the values (array) of a json column in mysql
- update column with another value from the same table?
- compare dates between 2 different rows and columns
- sql server asp.net - "login failed"
- sqlite: select multiple ids with manual order
- how can we profile jooq statements for speed
- sqldependency only fires on subscribe
- how to update foreign key
- when to use stored procedures instead of using any orm with programming logic?
- "catching" errors from within a user defined function in sql server 2005
- permissions denied on sql query
- sql insert data to other table after split string
- ordering parent rows by date descending with child rows ordered independently beneath each
- ssrs 2014 url access always generates xls instead of xlsx when format is excel
- sql server 2005 - how to compare field value, and return a count if different, for every occurance
- convert unicode string to ascii in sql server
- are good security practices and auto identity range mgmt mutually exclusive?
- how to update all rows except one row out of many satisfying the given condition?
- c# how to check if database is not busy?
- select a record just if the one before it has a lower value takes too long and fail
- find id of parent where all children exactly match
- default logged in user to sql server column
- 1064: sql syntax error executing pymysql query
- how to get the record details which has been changed in access database
- retrieving data from sql server and turning it into a json format?
- start position for a reused t- sql cursor?
- applying or condition on sum function in sql server
- what is the syntax for a multi-table delete on a mysql database using doctrine?
- how can i get an even distribution using where id in(1,2,3,4)
- binary tree get bottom extreme left or right
- sql advancedquery
- create view based on hierarchy / used of cte
- sql - insert if the number of rows is greater than
- orient-db regex modifiers
- oracle group by only one column
- ? like (column || '%')
- postgres crosstab, error: the provided sql must return 3 columns
- passing a datatable into a stored procedure. is there a better way?
- sql server management studio: backup and restore database without data
- how to obtain the most recent row per type and perform calculations, depending on the row type?
- how to restore table from dump to database?
- automate turning named-pipes and tcp\ip on
- how can i exclude left joined tables from top in sql server?
- inserting data into sql server returns error code 00q
- sql -- assigning a bit variable in select statement
- table with multiple foreign keys linking to the same primary (2)
- how to show order fulfilment in a sql server 2008 query
- linq union vs sql union
- returning 1 or 0 in specific sql query
- find time spent in a day along with work break taken
- advanced mysql alphabetical sort with prefix?
- directed graph sql
- date_format conversion is adding 1 year to the border dates
- like in linq to sql
- dbd::odbc vs win32::odbc
- append sql table name with today's date
- null in query values resulting in 0.00 in mysql
- sql: select sum of all children records recursively
- how do identify the first character of a string as numeric or character in sql
- counting total per day with my result in sql
- sql connection in spring servicemix camel
- sql like statement. end of string
- select count of ip and count of distinct ip in same query
- super slow query... what have i done wrong?
- partition columns for a unique index must be a subset of the index key error
- calculating the 95th percentile value?
- insert data into sqlite3 database with api
- sql max() only returns 1 row if column has several max values
- which values are making the conversion from varchar to date fail?
- sqlite select statement optimisation advice
- create a mysql primary key without a clustered index?
- how to merge two columns with a condition in pyspark?
- ssis removing single quote within double quotes
- good methods or tutorials for understanding joins in sql [closed]
- one insert with multiple select
- exception in thread "main" java.lang.noclassdeffounderror: org/apache/spark/sql/catalyst/analysis/overridefunctionregistry
- unique constraint on two fields, and their opposite
- how to get the latest records of the multiple values of same column in postgresql?
- override alphabetical default order by with a union of 2+ tables?
- cascading diamond shaped deletes in sql
- t-sql query between a table of events and a date range
- sql server data to kafka in real time
- connecting to on-prem sql server through azure databricks
- error during loading of ssis package
- is there are reason i select by a string columns which contains sha1 hexdigests?
- app script bigquery standard sql insert or update statement
- how to fix microsoft sql server, error: 262?
- are both queries the same?
- mysql "insert ... on duplicate key" with more than one unique key
- sql injection capturing on classic asp - reposting form puts in lots of ticks
- runtime validation of jooq generated classes after schema update?
- can i use ms sql syntax in sybase?
- which sql query is more secure in terms of sql injection
- most efficient way to read xml in ado.net from xml type column in sql server?
- does sql server acquire locks even without an explicit transaction?
- slow update after truncate
- python mysqldb programming error: 1064 when inserting data
- i want to return new column using recursive in sql?
- sumproduct in sql
- why can't t-sql find my function in my assembly?
- when to use separate sql database tables for two slightly different types of information?
- when selected into an object; does linq to sql still perform the logic in a sql query?
- multiple databases tables or combined into one
- get last insert id from access
- ora-00932: inconsistent datatypes: expected char got number while adding 1 to a date
- operand data type time is invalid for add operator
- showing all rows with sql pivot including those with record counts of zero
- mysql searching for value across multiple databases
- mysql 'after insert' trigger to calculate a field based on other fields
- select a random entry from a group after grouping by a value (not column)?
- fast table indexing for range lookup
- sql server 2008 guid column is all 0's
- subqueries vs inner joins - which one executes faster?
- ignore dependency when creating view in sql server
- getting error: a network-related or instance-specific error occurred while establishing a connection to sql server
- user created using dacpac cannot log on
- pl/sql array to clob
- how to deal with "maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."
- distinct on multiple columns in mysql
- avoiding null pointer on failed join
- how to fetch data from two tables in sql
- # ifdef type conditional compilation in t-sql sql server 2008 2005
- sql update same row multiple times
- sql to return seconds difference between two rows
- sql server script generator cast datetime values from hex
- ora-01839 "date not valid for month specified" for to_date in where clause
- pyspark converting an array of struct into string
- what exactly does 'bytes per row' mean in sql server max. capacity specifications
- sql server 2008 row to column
- why does my sqlconnection remain in the ssms processes list after closing it?
- is it possible to exec a t-sql stored procedure that has an ouput parameter while ignoring select statement?
- closure table insert statement including the level/distance column
- is it possible to stop django adding quotes around raw sql params?
- using .net framework 3.5 in a sql server 2005 stored procedure
- how to include only rows where the following row is within 12 hours and rank accordingly
- can clickonce or installshield setup sql server or sql server express?
- row_number() cte performance when using order by case
- how do i query a database field but ignore the html markup?
- check if a stored proc is running?
- parse datetime to java date
- how to update struct field spark/scala
- how to load a sql file (stored in the source folder of my java project) into mysql from a java application?
- mysql order by field with %
- row_number() over 2 billion records (teradata)
- sql server scripts 2012 project into team foundation server 2012
- how do i persist mysql configuration variables in cloudsql?
- sql server cte "multi- part identifier could not be bound."
- unpivot multiple columns in mysql
- sql update query and 'subquery returned more than one value'
- import large sql file
- how to sort by distance from now() (future first) in postgresql
- datetime import using pandas/sqlalchemy
- add 30 days for date in db
- an insert exec statement cannot be nested. dealing with error
- escape character in sql
- move records which are older than 3 years from one database (production db) to another db (archive db) using ssis
- sql server execute procedure as user
- how do i extract just the date from a sql datetime value in ssis?
- joining two subqueries or a query with a subquery sql server 2008
- how can i know which values are numeric in oracle 9i
- problem of sqlite3::sqlexception: sql logic error or missing database
- postgresql, mixed food and recipes
- execute a stored procedure using vb.net
- how to store dt_r8 in a variable in ssis
- mysql where-condition in procedure ignored
- future of "user instance" in sql server
- execute @var character limit sql server 2008 r2
- interpret deadlock and fix it
- specified cast is not valid error using c#
- evaluate sequential pairs of rows in sqlite
- how to fix sql syntax error using liquibase and mysql to create trigger
- hibernate one-to-many could not initialise collection
- how to make a computed column nullable in sql server
- add sql server data connection in visual studio
- how to print record that caused ora-01843 error?
- golang sql server query via go-mssqldb
- how to get highest record of every 10 minute data sql query
- org.hibernate.engine.jdbc.spi.sqlexceptionhelper - function "within" not found; sql statement
- identifier too long in oracle
- declare and return a custom type in postgresql function
- building ssis solution using visual studio online build definition... .dtproj is not supported by msbuild and cannot be built
- tsql split xml nodes
- php sql server mssql_select_db error