Use NVARCHAR(size) datatype and prefix string literal with N: CREATE TABLE #tab(col NVARCHAR(100)); INSERT INTO #tab(col) VALUES (N’👍 🖒 🖓 🖕 🗑 🛦 ⁉ 😎 😔 😇 😥 😴 😭’); SELECT * FROM #tab; db<>fiddle demo Output: ╔═════════════════════════════════╗ ║ col ║ ╠═════════════════════════════════╣ ║ 👍 🖒 🖓 🖕 🗑 🛦 ⁉ 😎 😔 😇 😥 😴😭 … Read more
The ideal way would be to normalize your design and split the two components of the column into two separate columns. One of type integer, one text. With the current table, you could: SELECT col FROM tbl ORDER BY (substring(col, ‘^[0-9]+’))::int — cast to integer , substring(col, ‘[^0-9_].*$’); — works as text The same substring() … Read more
You can use information from the catalog tables like so: Create a table with id as the primary key create table test1 (id int primary key, name text); Create the SQL to drop the key select concat(‘alter table public.test1 drop constraint ‘, constraint_name) as my_query from information_schema.table_constraints where table_schema=”public” and table_name=”test1″ and constraint_type=”PRIMARY KEY”; The … Read more
DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS
I’m a fan of SQL DBDiff, which is an open source tool you can use to compare tables, views, functions, users, etc. of two instances of SQL Server databases and generate a change script between the source and destination databases.
Use the DATEADD function: SELECT DATEADD(ss, 1291388960, ‘19700101’) …specifying a date of January 1st, 1970. In this example, it was provided in the YYYYMMDD format. DATEADD will return a DATETIME data type, so if you have a table & column established — you can use the function to INSERT/UPDATE depending on your needs. Provide details, … Read more
I had the same question and the answer, which I found, is: if not engine.dialect.has_schema(engine, schema_name): engine.execute(sqlalchemy.schema.CreateSchema(schema_name)) We can also check schema without engine instance, but using connection conn = engine.connect() if conn.dialect.has_schema(conn, schema_name): …
use CURRENT_TIMESTAMP select * from tableName where date_column > CURRENT_TIMESTAMP() CURRENT_TIMESTAMP
In SQL Server: SELECT col1 AS [text()] FROM foo FOR XML PATH (”) In MySQL: SELECT GROUP_CONCAT(col1 SEPARATOR ”) FROM foo In PostgreSQL: SELECT array_to_string ( ARRAY ( SELECT col1 FROM foo ), ” ) In Oracle: SELECT * FROM ( SELECT col1, ROW_NUMBER() OVER(ORDER BY 1) AS rn FROM foo MODEL DIMENSION BY (rn) … Read more