MsSQL - Tutorials

Tutorials Shared by the Internet Community
Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 30 Tutorials

gap line

Most Recent Tutorials


  • How to Grant or Revoke Object Permissions

    Code below presents the GRANT and REVOKE statements you use to grant or revoke permissions to use an object in the current database
    http://www.w3computing.com/sqlserver/grant-revoke-object-permissions/
  • How to work with Schemas

    One advantage of using schemas is that you can grant permissions to all the objects in a schema by granting permissions to the schema
    http://www.w3computing.com/sqlserver/work-with-schemas/
  • How to work with Database Users

    Each database maintains a list of the users that are authorized to access that database.
    http://www.w3computing.com/sqlserver/database-users/
  • How to Create Login IDs

    When you install SQL Server it is configured with some built-in IDs. Then, to add additional login IDs you can use the CREATE LOGIN statement
    http://www.w3computing.com/sqlserver/create-login-ids/
  • An Introduction to SQL Server Security

    Before a user can work with the data in a database, he must have a valid login ID so that he can log on to SQL Server.
    http://www.w3computing.com/sqlserver/introduction-sql-server-security/
  • An Introduction to Cursors in SQL Server

    A cursor lets you retrieve data from a result set one row at a time. In the topics that follow you will learn about the different types of cursors
    http://www.w3computing.com/sqlserver/introduction-cursors/
    • 18851 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • SQL Coding Guidelines

    SQL is a freeform language. That means that you can include line breaks, spaces, and indentation
    http://www.w3computing.com/sqlserver/sql-coding-guidelines/
  • A Comparison of Oracle, DB2, MySQL, and SQL Server

    Although this tutorial is about SQL Server, you may want to know about some of the other SQL-based relational database management systems.
    http://www.w3computing.com/sqlserver/comparison-oracle-db2-mysql-sql-server/
    • 13505 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • Stored Procedure to Split String in SQL

    Unfortunately there is no split() function in Sybase or SQL Server to split string based upon any delimiter. You need to use methods like PATINDEX ,CH
    http://javarevisited.blogspot.com/2012/12/charindex-padindex-sybase-sqlserver-eample-split...
  • How to manage transaction in Database and MySQL

    This article explains what is transaction in database, What is ACID properties of database transaction,
    http://javarevisited.blogspot.com/2011/11/database-transaction-tutorial-example.html
    • 16286 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • Overview of Conversations in SQL Server 2005

    The core concept in Service Broker is the conversation. Conversations introduce a new messaging paradigm.
    http://www.codebeach.com/tutorials/sql-server-service-broker-conversations.asp
    • 16132 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

« Previous 1 2 Next »


Advertisements
Advertisements