What is difference between rownum and rowid?
No Answer is Posted For this Question
Be the First to Post Answer
What is the default schema of your login session in ms sql server?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
What is statement level trigger?
What is the difference between getdate and sysdatetime?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
What should we do to copy the tables, schema and views from one SQL Server to another?
What is the importance of a recovery model?
What are the advantages of partitioning?
what is DTS what are tasks available
How to provide column names in insert statements in ms sql server?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
How to truncate a table first before running a package?