developmentpool.blogspot.com

Knowledge Transfer.........

Wednesday, August 29, 2012. Get list of tables used in a stored procedure. WITH stored procedures AS (. Oname AS proc name, oo.name AS table name,. ROW NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row. INNER JOIN sysobjects o ON o.id=d.id. INNER JOIN sysobjects oo ON oo.id=d.depid. WHERE o.xtype = 'P'). SELECT proc name, table name FROM stored procedures. WHERE row = 1. ORDER BY proc name,table name. Wednesday, August 15, 2012. Drop all the Tables,Stored Procedure,Views. SELECT @...

http://developmentpool.blogspot.com/

OVERVIEW OF developmentpool.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

17

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR DEVELOPMENTPOOL.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

February

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Monday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.1 out of 5 with 10 reviews

5 star

0

4 star

5

3 star

3

2 star

0

1 star

2

Hey there! Start your review of developmentpool.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.1 seconds

CONTACTS AT DEVELOPMENTPOOL.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

17

SSL

EXTERNAL LINKS

0

SITE IP

172.217.6.65

LOAD TIME

0.147 sec

SCORE

6.2

PAGE TITLE

Knowledge Transfer......... | developmentpool.blogspot.com Reviews

<META> DESCRIPTION

Wednesday, August 29, 2012. Get list of tables used in a stored procedure. WITH stored procedures AS (. Oname AS proc name, oo.name AS table name,. ROW NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row. INNER JOIN sysobjects o ON o.id=d.id. INNER JOIN sysobjects oo ON oo.id=d.depid. WHERE o.xtype = 'P'). SELECT proc name, table name FROM stored procedures. WHERE row = 1. ORDER BY proc name,table name. Wednesday, August 15, 2012. Drop all the Tables,Stored Procedure,Views. SELECT @...

<META> KEYWORDS

1 knowledge transfer

2 select

3 from sysdepends d

4 and proc name='xyz

5 posted by

6 kapil dalke

7 no comments

8 email this

9 blogthis

10 share to twitter

CONTENT

Page content here

KEYWORDS ON PAGE

knowledge transfer,select,from sysdepends d,and proc name='xyz,posted by,kapil dalke,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,declare @name varchar 128,declare @sql varchar 254,begin,exec @sql,update tablename

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Knowledge Transfer......... | developmentpool.blogspot.com Reviews

https://developmentpool.blogspot.com

Wednesday, August 29, 2012. Get list of tables used in a stored procedure. WITH stored procedures AS (. Oname AS proc name, oo.name AS table name,. ROW NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row. INNER JOIN sysobjects o ON o.id=d.id. INNER JOIN sysobjects oo ON oo.id=d.depid. WHERE o.xtype = 'P'). SELECT proc name, table name FROM stored procedures. WHERE row = 1. ORDER BY proc name,table name. Wednesday, August 15, 2012. Drop all the Tables,Stored Procedure,Views. SELECT @...

INTERNAL PAGES

developmentpool.blogspot.com

1

Knowledge Transfer.........: September 2011

http://developmentpool.blogspot.com/2011_09_01_archive.html

Friday, September 30, 2011. Rollback in SSIS Package Level. If you are using SSIS package for transaferring data from one database to other database.In case of any failure or any exception on any data flow task or component level .We have to rollback our old transactional in other tables where data is already inserted. You can set the transaction option to 'required' at package level.and 'supported' for the the components(Data) that you want to rollback in case of failure. Subscribe to: Posts (Atom).

2

Knowledge Transfer.........: Drop all the Tables,Stored Procedure,Views...

http://developmentpool.blogspot.com/2012/08/drop-all-tablesstored-procedureviews.html

Wednesday, August 15, 2012. Drop all the Tables,Stored Procedure,Views. Drop all non-system stored procs */. SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name]). WHILE @name is not null. SELECT @SQL = 'DROP PROCEDURE [dbo].[' RTRIM(@name) ']'. PRINT 'Dropped Procedure: ' @name. SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] @name ORDER BY [name]). Drop all views */. WHILE @name IS NOT NULL. SELECT @co...

3

Knowledge Transfer.........: How to update column value with auto increment number or unique number

http://developmentpool.blogspot.com/2012/03/how-to-update-column-value-with-auto.html

Friday, March 16, 2012. How to update column value with auto increment number or unique number. Using this query we can update any column value with any unique number with n number of digit. SET @counter = 1000000000. SET @counter = ColumnName = @counter 1. Using this query you can update with string character to any of the column value. Put table name , column name and give a identity column value. SET ColumnName = 'Test User ' convert(varchar,IdentityColumnName). SELECT * FROM TableName.

4

Knowledge Transfer.........: Finding Duplicates data in one Table with SQLsql server

http://developmentpool.blogspot.com/2011/11/finding-duplicates-data-in-one-table.html

Wednesday, November 30, 2011. Finding Duplicates data in one Table with SQLsql server. Duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once:. HAVING ( COUNT(email) 1 ). You could also use this technique to find rows that occur exactly once:. HAVING ( COUNT(email) = 1 ). Subscribe to: Post Comments (Atom). Email : kapildalke@gmail.com. View my complete profile. Finding Duplicates data in one Table with SQLsql s. Follow this link for more information.

5

Knowledge Transfer.........: December 2011

http://developmentpool.blogspot.com/2011_12_01_archive.html

Monday, December 19, 2011. Remove SQL Server database from single-user mode to Multi-User Mode. This query should be executed in Master Database(System Database). Select d.name, d.dbid, spid, login time, nt domain, nt username, loginame. From sysprocesses p inner join sysdatabases d on p.dbid = d.dbid. Where d.name = 'db Name'. Exec sp dboption 'db Name', 'single user', 'FALSE'. Subscribe to: Posts (Atom). Email : kapildalke@gmail.com. View my complete profile. Follow this link for more information.

UPGRADE TO PREMIUM TO VIEW 12 MORE

TOTAL PAGES IN THIS WEBSITE

17

OTHER SITES

developmentpolicy.net

easyDNS Parked Page for: developmentpolicy.net

Developmentpolicy.net is a parked domain. 10 Things you must. Know before you register your domain name with anybody. For a concise 1-page explanation as told by a domain industry insider, click here. We provide responsive customer support to assist you with your domain account. You can email our support staff anytime, day or night, or call our toll-free support line. During regular business hours. Services and Pricing - Domain Registration, DNS Hosting, Dynamic DNS, Secondary DNS.

developmentpolicyforum.de

Home - Development Policy Forum of the Society for International Cooperation. (GIZ) GmbH

Skip to navigation (Press Enter). Skip to main content (Press Enter). Img')attr('src', 'files/ media/framework/img/de high.png');" onmouseout="$j(this).find(' img').attr('src', 'files/ media/framework/img/de.png');". GIZ and Development Policy Forum. We shape dialogue processes that focus on future options of development policy.". We shape multi-stakeholder dialogues in the political arena.". We create unique dialogue events using a one-stop shop format.". We create spaces for the key issues.". A new fig...

developmentpolitics.com

Development Politics

Scott Andrews' blog on all things Political, Developmental and International. Tuesday, May 1, 2012. When China Met Africa by Marc and Nick Francis. Last night I sat down with my dad at watched When China Met Africa. We wanted to tell the China-Africa story in microcosm from the perspective of three characters that were living out the daily reality of this paradigm.". Unfortunately I am not qualified to comment on the relative merits of Chinese involvement/investment in sub-Saharan African countries like ...

developmentpolitics.wordpress.com

Protected Blog › Log in

Https:/ developmentpolitics.wordpress.com/. Is marked private by its owner. If you were invited to view this site, please log in. Below Read more about privacy settings. Larr; Back to WordPress.com.

developmentpool-knowledgeblog.blogspot.com

Development Pool Knowledge-Blog

Wednesday, July 29, 2009. Welcome to World of Knowledge. Welcome to world of Knowledge and Research. This blog is being maintained by Development Pool (Lahore, Pakistan), a consultancy firm engaged in economic, social and marketing research activities. This Blog site pools ideas, insights and experiences in knowledge management by our staff members, fellows and visitors. We encourage your contribution. Let’s create knowledge which brings value! Subscribe to: Posts (Atom). Welcome to World of Knowledge.

developmentpool.blogspot.com

Knowledge Transfer.........

Wednesday, August 29, 2012. Get list of tables used in a stored procedure. WITH stored procedures AS (. Oname AS proc name, oo.name AS table name,. ROW NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row. INNER JOIN sysobjects o ON o.id=d.id. INNER JOIN sysobjects oo ON oo.id=d.depid. WHERE o.xtype = 'P'). SELECT proc name, table name FROM stored procedures. WHERE row = 1. ORDER BY proc name,table name. Wednesday, August 15, 2012. Drop all the Tables,Stored Procedure,Views. SELECT @...

developmentportal.com

developmentportal.com -

developmentportal.eu

developmentportal.eu - This website is for sale! - developmentportal Resources and Information.

This domain is FOR SALE - Diese Domain steht ZUM VERKAUF.

developmentpost.com

Development Post – News, Development, Advocacy

Kano Judge Frees 20 Inmates from Prison. The acting Chief Judge of Kano State, Justice Nura Sagir, has set free 20 inmates from Central Prison located in Kurmawa. The judge freed the . UTME: Sokoto establishes school of remedial studies. Governor Aminu Waziri Tambuwal has approved the establishment of School of Basic and Remedial Studies to address continuous decline in the number and . Agency Vaccinates 1149 Bauchi Prison Inmates Against Meningitis. Nigeria under Buhari has made steady progress- Oyegun.

developmentposters.com

Developmentposters.com