Browse by Tags
Sorry, but there are no more tags available to filter with.
-
-
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...
-
-
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...
-
-
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...
-
-
StrAll - Helps to construct SQL Statement... Ultimately save the times StrAll <TableName> CREATE Procedure StrAll (@obj varchar(255)) as declare @fldname varchar(255), @len int, @datatype varchar(50), @nullable bit declare @sqlUpdate varchar(4000...
-
-
DROP procedure InsertProc GO CREATE procedure InsertProc ( @tablename varchar(100)) as declare @cname varchar(100),@First int, @strAllColumns varchar(5000),@strAllColumnsVal varchar(5000), @strParam varchar(5000), @strAllParams varchar(1000), @length...
-
-
Use Northwind Go create procedure des(@tablename varchar(100)) as select name,(select max(name) from systypes where xtype=sc.xtype) datatype, length,prec,scale,case isnullable when 1 then 'Y' when 0 then 'N' else 'X' end nullable...