SQL Server database engine service account must have permissions to read/write in the new folder. Check out this To fix, I did the following: Added the Administrators Group to the file security permissions with full control for the Data file (S:) and the Log File (T:). Attached the database and it works fine.
If possible you should change the data type of the column to a number if you only store numbers anyway. If you can’t do that then cast your column value to an integer explicitly with select col from yourtable order by cast(col as unsigned) or implicitly for instance with a mathematical operation which forces a … Read more
I assume you want to know the performance difference between the following: WHERE foo IN (‘a’, ‘b’, ‘c’) WHERE foo = ‘a’ OR foo = ‘b’ OR foo = ‘c’ According to the manual for MySQL if the values are constant IN sorts the list and then uses a binary search. I would imagine that … Read more
As Henrik wrote you can use dblink to connect remote database and fetch result. For example: psql dbtest CREATE TABLE tblB (id serial, time integer); INSERT INTO tblB (time) VALUES (5000), (2000); psql postgres CREATE TABLE tblA (id serial, time integer); INSERT INTO tblA SELECT id, time FROM dblink(‘dbname=dbtest’, ‘SELECT id, time FROM tblB’) AS … Read more
Let us assume the database character set is UTF-8, which is the recommended setting in recent versions of Oracle. In this case, some characters take more than 1 byte to store in the database. If you define the field as VARCHAR2(11 BYTE), Oracle can use up to 11 bytes for storage, but you may not … Read more
A CASE expression returns a value from the THEN portion of the clause. You could use it thusly: SELECT * FROM sys.indexes i JOIN sys.partitions p ON i.index_id = p.index_id JOIN sys.allocation_units a ON CASE WHEN a.type IN (1, 3) AND a.container_id = p.hobt_id THEN 1 WHEN a.type IN (2) AND a.container_id = p.partition_id THEN … Read more
Update, if you are running SQL Server 2012 see: https://stackoverflow.com/a/10309947 The problem is that the SQL Server implementation of the Over clause is somewhat limited. Oracle (and ANSI-SQL) allow you to do things like: SELECT somedate, somevalue, SUM(somevalue) OVER(ORDER BY somedate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Table SQL Server gives … Read more
For SQL Server 2005+, if there is no insert trigger, then change the insert statement (all one line, split for clarity here) to this INSERT INTO aspnet_GameProfiles(UserId,GameId) OUTPUT INSERTED.ID VALUES(@UserId, @GameId) For SQL Server 2000, or if there is an insert trigger: INSERT INTO aspnet_GameProfiles(UserId,GameId) VALUES(@UserId, @GameId); SELECT SCOPE_IDENTITY() And then Int32 newId = (Int32) … Read more
Using prepared statements, there is no “SQL query” : You have a statement, containing placeholders it is sent to the DB server and prepared there which means the SQL statement is “analysed”, parsed, some data-structure representing it is prepared in memory And, then, you have bound variables which are sent to the server and the … Read more
Simple script (question asked) Building on @a_horse_with_no_name’s answer and improved with @Gregory’s comment: DO $do$ BEGIN IF EXISTS ( SELECT FROM pg_catalog.pg_roles WHERE rolname=”my_user”) THEN RAISE NOTICE ‘Role “my_user” already exists. Skipping.’; ELSE CREATE ROLE my_user LOGIN PASSWORD ‘my_password’; END IF; END $do$; Unlike, for instance, with CREATE TABLE there is no IF NOT EXISTS … Read more