Universe Guide Blog Archive 5

How to create an Updateable View in SQL Server / 23rd August 2021 10:10 PM

Updateable Views allows users to access and edit certain parts of a recordset. The recordset can contain fields from multiple tables but can only update fields from one table.

Read More...

Beginners Guide to Nested SQL Server Transactions / 22nd August 2021 6:28 PM

Guide to using nested transactions in SQL Server. Nested transactions are when you have one transaction inside another, hence the term. Read More...

Beginners Guide to SQL Server Transactions / 22nd August 2021 4:50 PM

Transactions are a valuable way to ensure that all commands are either commited or rollback according to the actions of the procedure or code running. Read More...

How to notify Google your sitemap has changed using C# (.NET) / 21st August 2021 6:54 PM

Updating Google that your sitemap has been changed is easy if you have your own home made CMS, its quicker than having to go into Webmaster Tools every time. Read More...

How to find a string in a procedure in SQL Server / 21st August 2021 6:43 PM

When updating a table, you will normally need to know what tables are referencing it and if you have 100+ tables, it can take time. The enclosed is a technique to identify which procedures reference the country table. Read More...

How to call one stored procedure from another and use the selected records returned / 21st August 2021 6:18 PM

A calling procedure can use the results of a stored procedure without creating a permanent table in which to store the results temporarily. Read More...

How you make a SQL Server database Read-Only / 21st August 2021 5:42 PM

SQL Server database are by default read/write but there are times when you need the database to be read only. Making the database read only is just a simple case of using SQL. Read More...

How to detach or attach a database to SQL Server / 21st August 2021 4:40 PM

Attaching and Detaching a database in SQL Server is easy, it can be completed by either using the SQL Management Studio or by using SQL Server's very own SQL commands. Read More...

How to change the colour of text in a C# Console Application / 21st August 2021 4:13 PM

Code to show you how to change the foreground and background colour of .NET Console applications rather than just black and white screens. Read More...

How to use Cursors in SQL Server / 21st August 2021 1:12 PM

Example of how to use Cursors in SQL Server. Cursors are a useful way in viewing individual records in a selected recordset in SQL Server but they do have drawbacks such as efficiency. Read More...

Newer Articles | Older Articles

About... / Contact.. / Cookie...