SQL Script : Adventure works database setup and Select query, list of tables #100daysofsql

Hi all,

Welcome to 100 days of SQL script code

In this blog post, will start with AdventureWorks sample database in Microsoft SQL server

Install MS SQL server and SSMS latest version

Download bak file from https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

Follow the restore steps in the same above link

after restoring below adventure work database below

Run the below query in SQL server

-- showing list of tables

select * from INFORMATION_SCHEMA.TABLES

output

customer and product table select query

-- customer and product table

select * from SalesLT.Customer

select * from SalesLT.Product

Outputs are

Comments

Java Swing MySql JDBC: insert data into database

Program import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; public class insertswing implements ActionListener { JFrame fr;JPanel po; JLabel l1,l2,main; JTextField tf1,tf2; GridBagConstraints gbc; GridBagLayout go; JButton ok,exit; public insertswing(){ fr=new JFrame("New User Data "); Font f=new Font("Verdana",Font.BOLD,24); po=new JPanel(); fr.getContentPane().add(po); fr.setVisible(true); fr.setSize(1024,768); fr.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); po.setBackground(Color.WHITE); go=new GridBagLayout(); gbc=new GridBagConstraints(); po.setLayout(go); main=new JLabel("Enter User Details "); main.setFont(f); l1=new JLabel("Name :");tf1=new JTextField(20); l2=new JLabel("User Name :");tf2=new JTextField(20); ok=new JButton("Accept"); exit=new JButton("Exit"); gbc.anchor=GridBagConstraints.NORTH;gbc.gridx=5;gbc.gridy=0; go.s...

Guidewire Policy - Spin Up Spin Off Transactions

Guidewire PolicyCenter - Spin Up and Spin Off Policy Job Transactions In Guidewire PolicyCenter, "spin up" and "spin off" refer to specific actions you can take with policy job transactions. These terms are related to how new policy transactions (such as renewals, endorsements, or cancellations) are created or modified. Here's an explanation of each: 1. Spin Up: "Spin up" refers to the process of creating a new policy job from an existing policy or transaction. When you "spin up" a policy job, you're essentially initiating a new transaction based on an existing policy. This new transaction could be a renewal, an endorsement, or any other type of policy change. For example: - Renewal : When a policy's term is about to expire, you might "spin up" a renewal job to create a new policy term based on the existing one. The new job will carry forward much of the existing policy's data but may allow for updates or cha...

Guidewire Reinstatement and Rewrite

Guidewire Reinstatement, Rewrite Mid Term, Rewrite Full Term, and Rewrite New Term In Guidewire PolicyCenter, different types of policy transactions allow users to modify, renew, reinstate, or rewrite policies under various circumstances. Hereâ€™s an explanation of Reinstatement, Rewrite Mid Term, Rewrite Full Term, and Rewrite New Term, along with their similarities, differences, and example scenarios. 1. Reinstatement Definition: - Reinstatement is a process that brings a canceled policy back into force. This is typically done after a policy has been canceled due to non-payment or other reasons, and the insurer agrees to reinstate the policy, often after the insured has met certain conditions (e.g., paying outstanding premiums). Scenario Example: - A policyholder misses their premium payment, and the policy is canceled. After paying the overdue amount, the insurer reinstates the policy without any changes to the original policy terms and conditions. Key Points: - The poli...

Kumaran1987

Search This Blog