questions/database
I have a SQL Server database, and ...READ MORE
We can build temp tables in SQL ...READ MORE
I'm not sure what sequence this query ...READ MORE
Is there a method to choose data ...READ MORE
This category discusses everything related to SQL/ ...READ MORE
With the Cricket World Cup going on, ...READ MORE
I have formula that checks if the ...READ MORE
Let's say you have a file named input.json which ...READ MORE
need the row/column combinations marked with an ...READ MORE
Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE
Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE
Following can be a solution to your ...READ MORE
Using convert() and style 106, you can ...READ MORE
Upload html-file(s) Select files from Computer, Google ...READ MORE
Suppose a customer gets a 10 percent ...READ MORE
You need to re-think this… the while ...READ MORE
Drag down the column to select the ...READ MORE
Try: INSERT INTO tableA ( column_1 ) SELECT ...READ MORE
With Microsoft Sql Server: -- -- Create test case -- DECLARE ...READ MORE
The answer is in the material you ...READ MORE
A Candidate Key is any column or ...READ MORE
Can someone explain the ramifications of using ...READ MORE
To calculate the date difference, we can ...READ MORE
If you are familiar with using formulas ...READ MORE
Select the row or column that you ...READ MORE
There are certain direct formulas to convert ...READ MORE
Use this query to include any of words: SELECT * ...READ MORE
A fast way of doing this would ...READ MORE
The easiest way to work this out ...READ MORE
Using READ UNCOMMITED as a transaction isolation ...READ MORE
So the key parts are to grab ...READ MORE
Select a non-empty cell. Do Data -> Text ...READ MORE
Basically for this, you need to create ...READ MORE
It is very easy and you can ...READ MORE
You can use the query as: SELECT COUNT(*) ...READ MORE
A primary key is unique and it ...READ MORE
My book definition of Database Systems does ...READ MORE
You have to convert the literal to ...READ MORE
HAVING: It is used to check after the aggregation ...READ MORE
Functions are calculated values that cannot make ...READ MORE
Oracle introduced the SQL WITH clause in ...READ MORE
Always use ANSI default string literal format for date i.e. YYYY-MM-DD like below. INSERT ...READ MORE
SQL SQL is the standard language for relational ...READ MORE
Timestamp is a synonym for rowversion, according ...READ MORE
The CASE statement is the closest to IF in ...READ MORE
The SQL keywords (SELECT, FROM, WHERE, etc.) ...READ MORE
TSQL has no for-loop, we have only ...READ MORE
Not only can you compare objects at ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.