SQL Schema samples and examples



You can make money from this site by posting original and quality articles that comply with Google AdSense policies.. Also, we offer several other reward programs including monthly profit sharing, cash rewards per post, contests & prizes etc to contributing members.

Submit Your Article

Articles

Few Global Variables,Functions And Queries In SQL.

This article explains few global variables and functions like @@ROWCOUNT, SCOPE_IDENTITY, DBCC CHECKIDENT, IDENTITY_INSERT and few queries to retrieve any keywords, all the tables or stored proc used in a database.

Few SQL Server Concepts And Queries

This Article describes about few Few Sql Server Concepts like SQL Transaction like COMMIT TRANSACTION,ROLLBACK,SAVEPOINT,@@TRANCOUNT,etc. AS well as Exception And Error Handling in SQL Transactions, CHUNK in SQL Server.

Information Schema regarding a Database table and Database Using sql querys

In this Article i will discuss how to get structure(Schema) of a table through sql query that Schema Information includes Columns,Datatypes,size/Precision relationships and structure of a Database includes size ,owner ,status , compatibility level , constraints and Views that exists in the Database with code snippets and real time images.

How to set Identity Increment ON/OFF in SQL

In this artical i'm trying to explain how to fix identity value how to change the identity value and how to update that value with proper order using Identity column on / off. Here i provide one simple example go through that example and check how it's working.

Compare two database schema in two different server

This article explains about comparison between two database schema in two different server. While updates in live server, we are able to get all the scripts of stored procedures and execute directly to the server. At the same it will not possible to execute the table scripts because it may have lot of real time data. So confusions occur while updating our table structure changes to live server. I have found a good and easiest solution to upgrade our table structures to live server.



Submit Your Article