questions/database
I've used C# and SQL Server 2008 ...READ MORE
The SQL keywords (SELECT, FROM, WHERE, etc.) ...READ MORE
The AutoSum button or formula can be ...READ MORE
Suppose a customer gets a 10 percent ...READ MORE
down voteaccepted Expand the SQL Server Agent node ...READ MORE
Create a formula with the name THIS ...READ MORE
VDL(View Definition Language): Represents user views and ...READ MORE
I recently came upon a Python package ...READ MORE
To understand phantom deadlock, you need an ...READ MORE
It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE
Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE
1. Enter the following formula in cell ...READ MORE
There are three types of index namely: Unique ...READ MORE
In Excel, you can use a feature ...READ MORE
Convert CSV to SQL http://www.convertcsv.com/csv-to-sql.htm This programme may be ...READ MORE
The maximum number of characters per cell ...READ MORE
Use the following calculation since Indian Standard ...READ MORE
Hi@akhtar, You have to change the permissions or ...READ MORE
Use the following SQL Server 2000 query: select ...READ MORE
Your table dbo.Sup Item Cat refers to ...READ MORE
Use this: SELECT *FROM ...READ MORE
For the software to run, you'll need ...READ MORE
Download a sample Excel file using Node. ...READ MORE
Create ReactJS project import React, { Component } ...READ MORE
Use this code and check <?php /** ...READ MORE
This is my Stored procedure : CREATE PROCEDURE ...READ MORE
This is the process of partitioning tables, ...READ MORE
When Cassandra write: 1. memtable (in memory) 2. commit ...READ MORE
The unique key in your database that ...READ MORE
Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE
Merging Excel Sheets: A Step-by-Step Guide Make sure ...READ MORE
ColumnPrefixFilter: takes a single argument, a column ...READ MORE
Projection means choosing which columns (or expressions) the query shall ...READ MORE
Hii @kartik, I was also facing the same ...READ MORE
Use this: =MATCH(A1,{0,35,60,85,110}) READ MORE
The Macro-containing workbook was always open in ...READ MORE
Hello @netwell, You need to have at least 3.25 ...READ MORE
Generate table creation statement for an existing ...READ MORE
Simple SQL queries can be used to ...READ MORE
I was wondering if there was a ...READ MORE
Given date: DECLARE @Date1 VARCHAR(50) = '30-01-2015' I want ...READ MORE
Percentage formula in Excel In cell D2, type ...READ MORE
Using OJDBC 6, I created some Java ...READ MORE
There are a lot of ways to ...READ MORE
I experimented with the following code in ...READ MORE
Try this: SELECT ... FROM ( SELECT ...READ MORE
There are mainly 5 types of Keys, ...READ MORE
Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...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
Data Independence refers to the ability to ...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.