Use JDBC MetaData classes using any RDBMS, i think that will help you with your knowledge.
Type: Posts; User: CSOOR; Keyword(s):
Use JDBC MetaData classes using any RDBMS, i think that will help you with your knowledge.
Try SAS's Data integration tool
You will have to do some programming in unix using the date format.
e.g to find the date you can try ,date '+%d' to get the date ,then check for day ( Sun ) using date '+%a' and build the...
Please go thro' all replies and add this into that, delete keeps the log while truncate does not.
You can consider entire set of attributes of relation as the primary key of the relation since this is uniquely identify the row,but same time if you think about the whole system design , there...
This is very simple problem, i think you should solve yourself. You should know the
System Design Life Cycle ( SDLC) .
Use "banner" command in your login shell.
eg. If your login shell is K shell. Then in the .profile file add this command
like banner "Welcome to My World"
Suppose you have file name my_script.sql which has all the code then you can run from
command line by calling this file.
eg.
c:\>sqlplus username/password@databasename @"c:\my_script.sql"
Do practise as much as you can .
- Note : First alter the employee table with identity col then go with the logic below, after you finish the migration just remove that identity column from employee table
Declare...
select concat( upper(substring(Col_Name,1,1)),lower(substring(Col_Name,2)) )
from Table_Name
-- Note : Replace the Table_Name and Col_Name with your actual tablename and column.
Please take the idea from one of my answer for "One row to Multiple Rows" in the same sql server thread.
The member name is "kkknnn" .
You are loosing the CR/LF characters when you are bringing the data thro' spool , you will have to preserve the CR/LF characters. Then you can see the
data in multiple lines.
Try this query in SQL server 2005
Internally , rowid take care of the order in which you insert the row.
select sno,name,marks from t_name order by 3 desc;
Put this result into some other table call t_name2 in the same order the way you want.
Now delete all the rows from t_name.
Again insert the...
CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))
returns @temptable TABLE (items varchar(8000))
as
begin
declare @idx int
...
select max(rownum) from TableName
You can do whatever you like within the Cursor; But question is like that .
Insert is Odd, which is not a part of CURSOR syntax.
Please send your questions in proper thread, this thread is only for sql server .
The class defination is divided into multiple classes . Each class will represent the small model. This is good for modeling the business logic. Code will be clean and easy to maintain.
use NEWID() function as default, while creating the table with unique Identifier
eg.
col_name UNIQUEIDENTIFIER DEFAULT NEWID()
There are two ways :
1. CASE
2. Subquery
#include <stdlib.h>
Try atoi function