Transact-SQL
Learn how to save time and prevent permission configuration problems when you move a SQL Server database from one computer to another.
- James H. Byrd
- Tagged With: ALTER USER, Mapping Logins, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
Use SQL Paging to make your grids so fast that you'll wonder if you really clicked the mouse button.
- James H. Byrd
- Tagged With: GridView Performance, Microsoft C#.NET, Microsoft SQL Server, Programming Example, ROW_NUMBER SQL Function, SQL Paging, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.
- James H. Byrd
- Tagged With: Microsoft SQL Server, Programming Example, Stored Procedures, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
The next time you are designing a new application database or adding new tables to an existing database, take a few moments to think about how you can leverage the DRI features of SQL Server to make your development life a little easier.
- James H. Byrd
- Tagged With: Database Design, Foreign Key Constraints, Microsoft SQL Server, Relational Integrity, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.
- James H. Byrd
- Tagged With: Database Transactions, Microsoft SQL Server, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
James H. Byrd
Book Publisher
Fiction Author
Software Developer
Technical Writer
Speaker
Vegetarian Cook