Query with sys.sysprocesses SELECT * FROM sys.sysprocesses WHERE open_tran = 1 DBCC OPENTRAN : helps to identify active transactions that may be preventing log truncation. DBCC OPENTRAN displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the transaction log of the specified database. Results are displayed … Read more
Semicolon at the end of the statement. INSERT INTO myTable (ID) values (5);
Right, the a = NULL and b = NULL bit was the issue as @a_horse_with_no_name indicated. You might also consider this derivative, which doesn’t require the OR operator: create table test ( id integer primary key, a integer, b integer, check ((a IS NULL) != (b IS NULL)) ); Of course that works exclusively with … Read more
This should do it: UPDATE TheTable SET PhoneNumber = SUBSTRING(PhoneNumber, 1, 3) + ‘-‘ + SUBSTRING(PhoneNumber, 4, 3) + ‘-‘ + SUBSTRING(PhoneNumber, 7, 4) Incorporated Kane’s suggestion, you can compute the phone number’s formatting at runtime. One possible approach would be to use scalar functions for this purpose (works in SQL Server): CREATE FUNCTION FormatPhoneNumber(@phoneNumber … Read more
You can concatenate the CR and LF: chr(13)||chr(10) (on windows) or just: chr(10) (otherwise) dbms_output.put_line(‘Hi,’||chr(13)||chr(10) ||’good’ || chr(13)||chr(10)|| ‘morning’ ||chr(13)||chr(10) || ‘friends’);
You can pass a cursor object to the DataFrame constructor. For postgres: import psycopg2 conn = psycopg2.connect(“dbname=”db” user=”user” host=”host” password=’pass'”) cur = conn.cursor() cur.execute(“select instrument, price, date from my_prices”) df = DataFrame(cur.fetchall(), columns=[‘instrument’, ‘price’, ‘date’]) then set index like df.set_index(‘date’, drop=False) or directly: df.index = df[‘date’]
Do you have lots of tables which do not have a seed and increment of 1 ?? If not (by default, all tables have that), use this code: exec sp_MSforeachtable @command1 = ‘DBCC CHECKIDENT(”?”, RESEED, 1)’ MSforeachtable is an undocumented, but extremely handy stored proc which executes a given command against all tables in your … Read more
Create the database ‘Documents’ and give file properties through an alter. USE [master] GO CREATE DATABASE [Documents] GO ALTER DATABASE [Documents] MODIFY FILE ( NAME = N’Documents’, SIZE = 512MB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) GO ALTER DATABASE [Documents] MODIFY FILE ( NAME = N’Documents_log’, SIZE = 256MB, MAXSIZE = UNLIMITED, FILEGROWTH = … Read more