skip to main | skip to sidebar

Me & My Little Techie.......

A place to learn from Little Techie... Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year..........

Pages

  • Home
  • About Me

Sunday, May 3, 2009

SQL Server Scripts

This section contains all the use ful scripts that we need in our day-to-day life
Find out all the Identity Key columns in SQL Server
List all the Primary Keys in SQL Server Database
List all the Foreign Keys in a SQL Server
Foreign Key and Primary Key in SQL Server
Finf out all the child tables of a parent table

Posted by Vijaya Kadiyala at 3:12 PM
Labels: DotNetVJ, Vijaya Kadiyala

0 comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Channel 6 Study Circle

  • .Net Interview Questions
  • PowerShell Articles
  • How To: SQL Server Management Studio
  • SQL Server Scripts
  • .NET Tutorials
  • SQL Server Interview Questions
  • SQL Server Tutorials

60 Second Interviews

MVP Lead Mr.Abhishek Kant
MVP Tony John
MVP Pinal Dave
MVP Suprotim Agarwal
MVP Jacob Sebastian
MVP Sugesh Kumar
MVP Michael Coles (New)

Tech Round-Up

Where can I use Windows PowerShell
Windows Mobile 6.5 Developer Tool Kit
Filtering Sensitive Text in SQL Server

Tech Mechanic

TSql Unit Test Generator
Powerful text editor - UltraEdit

Page 3 Techie Hang-Outs

In Jun-2009
Announcing the NYC Agile Firestarter
Summer 2009 MSDN “Suburban” Roadshow
SQLAuthority News – TechEd On Road Ahmedabad
An Introduction to Oslo

Subscribe 2 Get Updates

 Me & My Little Techie

Technology Top Blogs

Followers

I Am

I Am
Just Bring It

I am watching you...

HTML Hit Counters
HTML Counter

About Me

My Photo
Vijaya Kadiyala
I am fun loving and very hard working with little brain....
View my complete profile
Google

Blog Archive

  • ►  2010 (18)
    • ►  February (8)
      • Extract Just Time from DATETIME data type in SQL S...
      • sargable vs non-sargable queries
      • DATEDIFF Function in SQL Server
      • DotNetVJ News - 500th Article
      • Find the Database creation date (DATABASE AGE) in ...
      • Table Scan Vs Index Scan in SQL Server
      • Convert list of values seperated by comma stored i...
      • Split Full Name into First Name, Middle Name, Last...
    • ►  January (10)
      • Convert Number to Varchar in SQL Server using CAST...
      • Search For Columns in SQL Server
      • Is Your MONEY Safe in SQL Server
      • Order By Clause is not accepting alias Name in SQL...
      • Intellisense update/refresh on schema changes - SQ...
      • Get the records nearest to GETDATE() in SQL Server...
      • DROP INDEX - Must specify the table name and index...
      • When to use fully qualified names in SQL Server
      • Getting the Server Name in SQL Server using @@SER...
      • Get Current date and time in SQL Server using CURR...
  • ▼  2009 (183)
    • ►  December (11)
      • When you co-relate Disk Drives with Girls - Funny ...
      • Case Sensitive Search on a Case Insensitive SQL Se...
      • Get Database Traffic Report in SQL Server
      • Why Upgrade to SQL Server 2008?
      • Print from the DataGrid view
      • Convert PDF to Image Using Ghostscript API
      • Convert Rows to Columns with aggregate functions
      • Qwitter and Twitter based on Newton's Third Law
      • Select the nth best amount with simple query
      • Custom Pagging in SQL Server using ROW_NUMBER Func...
      • SQL Server Vs Oracle
    • ►  October (1)
      • Microsoft Most Valuable Professional Award - 2009 ...
    • ►  September (1)
      • Mindcracker Most Valuable Professional Award - 200...
    • ►  August (1)
      • Implementation of NOT IN operator with out using N...
    • ►  July (14)
      • Database Answers To Real Life Questions -- Creativ...
      • Parameter Sniffing & Stored Procedures Execution P...
      • Columnar Database - New Tech in BI space
      • Why We should Use EXISTS instead of DISTINCT to im...
      • Processing Order of SELECT Statement
      • Enable SQL Full-text Filter daemon Launcher Proces...
      • How to find whether Full Text is Installed or not?...
      • Why we should avoid * in SELECT Clause to improve ...
      • Could not open a connection to SQL Server
      • What to do when SELECT query is Running Slowly?
      • Find out the objects on which the view depends eit...
      • Generate DDL of a Table Using SQL Server Managemen...
      • Date Format using CONVERT function in SQL Server
      • Information Schema Views in SQL Server
    • ►  June (27)
      • What Happens When You Issue INSERT statement
      • Insert Multiple Rows with Single INSERT statement ...
      • Filtering Sensitive Text in SQL Server
      • Reading XML file in PowerShell
    • ▼  May (37)
      • TSql Unit Test Generator
      • 60 Seconds with Michael Coles
      • Disable F1 key in Excel Sheet
      • Very Common SQL Server Errors And Resolutions Part...
      • Undocumented feature to concatenate strings from a...
      • 60 Seconds with Sugeshkumar Rajendran
      • Tuning Replication for High Performance from SQL S...
      • How To: SQL Server Management Studio
      • How to Debug TSQL Programs in SQL Server
      • Convert list of values seperated by comma stored ...
      • Tree Queries in SQL Server with Common Table Expre...
      • String Functions in SQL Server -- Final Part
      • Very Common SQL Server Errors Part 1
      • Exception Handling at the Table Level
      • TOP 5 ways to delete Duplicate Records in a Table
      • Filtered indexes in SQL Server 2008
      • String Functions in SQL Server Part 1
      • Covering Index in SQL Server
      • Declaring a variable in SQL Server 2008
      • Generate and Insert the data into a table in SQL S...
      • Getting Started with Windows Azure on Thursday
      • Non Clustered Index in SQL Server
      • SQL Server Performance Tuning Training on Saturday...
      • Required Field Validation Control in ASP.NET
      • 60 seconds with Jacob Sebastian
      • Clustered Index in SQL Server
      • Useful Stored procedures in SQL Server -- Final Pa...
      • Useful Stored procedures in SQL Server Part 1
      • .NET Tutorials
      • Populating PDF from ASP.Net using iTextSharp
      • Alter Identity Column Value in SQL Server
      • SQL Server Scripts
      • SQL Server Interview Questions
      • SQL Server Interview Questions -- Constraints
      • SQL Server Tutorials
      • Most Valuable Member of DotNetSpider
      • Insert Values into IDENTITY column using IDENTITY_...
    • ►  April (34)
    • ►  March (23)
    • ►  February (20)
    • ►  January (14)
  • ►  2008 (241)
    • ►  December (27)
    • ►  November (10)
    • ►  October (10)
    • ►  September (23)
    • ►  August (11)
    • ►  July (17)
    • ►  June (30)
    • ►  May (15)
    • ►  April (28)
    • ►  March (12)
    • ►  February (29)
    • ►  January (29)
  • ►  2007 (61)
    • ►  December (35)
    • ►  November (26)
My Zimbio
Top Stories