code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
IGT,
2258PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
APX,
6 15060please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
10 12375can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
15 17483i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
3 7994
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How column data types are determined in a view?
What is recompile sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the indexes in sql server?
What are the lambda triggers?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How to create stored procedures with parameters in ms sql server?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are user-defined functions (udfs) in sql server?
What are statistics?
Explain what is row_number function?
What does asynchronous call backs means?
What is the difference between count and distinct count?
Explain what is sql server english query?