since you are using SQL Server, why not change the data type to VARCHAR(100)? To work around this error without changing the datatype, the TEXT or NTEXT column needs to be converted to VARCHAR or NVARCHAR when used in either the ORDER BY clause or the GROUP BY clause of a SELECT statement. eg, which … Read more
Enable SQLBLANKLINES to allow blank lines in SQL statements. For example: SET SQLBLANKLINES ON insert into table(id, string) values (1, ‘Line1goesHere Line2GoesHere blablablabla ‘); The premise of this question is slightly wrong. SQL*Plus does allow multi-line strings by default. It is only blank lines that cause problems.
Yes, it’s remarkably easy in fact: WHERE YEAR(A.[reimbursementDate]) = YEAR(GETDATE())
select a.ip, a.os, a.hostname, a.port, a.protocol, b.state from a left join b on a.ip = b.ip and a.port = b.port
SELECT unnest(array[‘Sl.no’, ‘username’, ‘Designation’,’salary’]) AS “Columns”, unnest(array[Sl.no, username, value3Count,salary]) AS “Values” FROM view_name ORDER BY “Columns” Reference : convertingColumnsToRows
You can also use Dapper’s SqlBuilder. Note that you’ll have to install the Dapper.SqlBuilder NuGet package since it doesn’t come with Dapper’s main distribution. Here is an example: [Test] public void Test() { var model = new PersonModel {FirstName = “Bar”, City = “New York”}; var builder = new SqlBuilder(); //note the ‘where’ in-line comment … Read more
SELECT rowid, * FROM tbl1 WHERE letter=”B”
The main reason for primary and foreign keys is to enforce data consistency. A primary key enforces the consistency of uniqueness of values over one or more columns. If an ID column has a primary key then it is impossible to have two rows with the same ID value. Without that primary key, many rows … Read more
postgres=# UPDATE pg_database SET datistemplate=”false” WHERE datname=”template_postgis”; UPDATE 1 postgres=# DROP DATABASE template_postgis; DROP DATABASE postgres=#
If your dates are no more than 2047 days apart: declare @dt datetime, @dtEnd datetime set @dt = getdate() set @dtEnd = dateadd(day, 100, @dt) select dateadd(day, number, @dt) from (select number from master.dbo.spt_values where [type] = ‘P’ ) n where dateadd(day, number, @dt) < @dtEnd I updated my answer after several requests to do … Read more