If a column is an image value type, how you can compare column values? How can you use this column in join clause?
1002You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
1068You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
969The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
997What are the three basic rules which are to be followed for the relational model of the database?
1015Post New DB Development Questions
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is an application role and explain a scenario when you would use one?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Why does this query return 0?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How to replace not in with not exist?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain about the hierarchical model of the database?
How you can make a parameterized view?
What is DB Development software?
Which data type cannot be used as a parameter in a udf?
How long can an error message be in raiseerror function?
What are the three basic rules which are to be followed for the relational model of the database?