August 2008 - Posts

T-SQL : Auto generating data retrieval SP
Published Wed, Aug 27 2008 18:52 | abu
Auto generating data retrieval SP will be done by just a second... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go CREATE procedure [dbo].[SelectSP] ( @tablename varchar(100)) as declare @cname varchar(100), @strAllColumns varchar(5000) declare crsColumn...
Filed under:
Generating Auto generated SELECT SQL from Oracle Database
Published Wed, Aug 27 2008 13:03 | abu
set pagesize 2000 set linesize 2000 set long 4000 --create table gensql(line number(4) not null primary key,txt varchar2(4000)) delete gensql / commit / declare cursor cl is select 'CREATE TABLE '||TABLE_NAME||' ( ' tbl, column_name clmn...
Filed under:
Auto generated stored procedure by SP [T-SQL]
Published Wed, Aug 27 2008 6:18 | abu
In a project if we have 50 tables, and average 10-15 columns then to write stored procedure for insert and update we have to take average 30 minutes each, then more than 25 hours will be required for only data insert/update operaion. This will be very...
Filed under:
Splitting comma separated IDs into one by one using T-SQL
Published Tue, Aug 26 2008 13:05 | abu
declare @str varchar ( 200 ) declare @chr char ( 1 ) declare @val numeric declare @cnt numeric set @cnt = 0 set @str = '1,22,11,0,5' if right( @str , 1 )<> ',' begin set @str = @str + ',' end set @val = ( len ( @str ) - len...
Filed under:
IPhone, at what price?
Published Wed, Aug 13 2008 16:06 | abu
I am planning to buy iPhone. Today I am googling to know the best selling price in India in terms of INR. After reading the article, I am totally confused about the possible price.... IPhone, at what price? http://computing.in.msn.com/gadgets/article...