where myColumn = @value or
(myColumn is null and @value is null)
I am experiencing a very weird behaviour from the management studio GO.
I am following the full-Text Search tutorial and I run the following query over adventure works
SELECT FT_TBL.ProductDescriptionID,
FT_TBL.Description,
KEY_TBL.RANK
FROM Production.ProductDescription AS FT_TBL INNER JOI...
First: I really haven't got any idea how to google for this. If you got one, leave a comment.
If I want to store arbitrarily large tables in a database, how should I set up my database tables?
Requirements:
A table has an arbitrary number of columns and rows (columns about 1-10k, rows about 0...
After detaching and reattaching a database to do a copy operation, all of the user objects are now missing from the database (I should add that the copy failed; according to the logs, there was an issue with a number of views. I didn't get a chance to really look it over before I discovered my m...
Trying to refer to accesstype from custplan but keep getting the error:
Foreign key 'custPlan_accessType_fk' references invalid column 'AcccessType#' in referencing table 'PlanType
PRINT 'Creating AccessType table...'
CREATE TABLE AccessType
( AccessType# INT NOT NULL,
AccessName VAR...
LOL, This is not possible. You can't modify the way Management Studio shows a table!
Usually, you don't store passwords in DDBB, but the hash.
MySQL query returns up to 65535 rows (max). How can retrieve all the rows of a table over the limit? (totally 120k)
query_string1 = "SELECT DISTINCT ID FROM table1"
print query_string1
try:
self.cursor.execute(query_string1)
...
GIVEN A TABLE AS :
CONFH CONFHNAME CONFHCAPACITY RENTPERDAY
CH001 Michael Dell 100 1000
CH002 Steve Jobs 150 2000
CH003 Henry Ford 50 750
DECLARE
v_maxval NUMBER:=100;
v_max number;
BEGIN
SELEC...
I have a .bup file which is supposed to be Progress database file. My question is, how can I open/restore it and look at the data?
I have a PostgreSQL database and my data-set include time-series of temperature for two stations. I would like to look their pattern's similarity in similar time sequences.
For station number 1:
+------------+------------------+
|temperature |dt |
+------------+------------------...After detaching and reattaching a database to do a copy operation, all of the user objects are now missing from the database (I should add that the copy failed; according to the logs, there was an issue with a number of views. I didn't get a chance to really look it over before I discovered my m...
If you want to return the players on a team with only one member you can use:
select p.id, p.name
from players p
where p.Team_ID in (select Team_ID
from players p
group by Team_ID
having count(Team_ID) = 1);
See SQL Fiddle with Demo
Database Administrators' third moderator election has come to a close, the votes have been tallied, and the new moderator is:
He'll be joining the existing crew shortly — please thank him for volunteering, and share your assistance and advice as he learns the ropes!
For details on how the vo...
This answer might be a good start. It shows how to use regular expression like syntax to determine if certain characters are in a field
EDIT
select * from [TABLE] where [FIELD] LIKE '%[^a-zA-Z0-9öçşğüıÖÇŞİĞÜ-\& \.]%'
