我是sql的新手，刚开始编写sp，触发器和函数 [英] I am new to sql just now i've started writing sp,triggers and functions

问题描述

我觉得我很难写任何人都可以建议我一个解决方案或一本书

我并不擅长开发人员需要的逻辑思维。是否有任何练习在线获取触发器和sp为初学者

i feel it is difficult for me to write can any one suggest me a solution or a book
and i am not good at logical thinking which is needed for a developer.Is there any exercises in online for triggers and sp for beginners

推荐答案

如果有疑问，请从Google开始：存储过程教程 [< a href =https://www.google.co.uk/search?q=stored+procedure+tutorial&oq=stored+procedure+tutorial&aqs=chrome..69i57j0l5.12771j1j7&sourceid=chrome&es_sm=93&& ; ie = UTF-8target =_ blanktitle =New Window> ^ ]并为触发器执行类似操作 - 您将获得大约相同数量的资源。



如果你需要首先开发逻辑思维，那么我建议你不要尝试使用SQL来学习：尝试C＃（甚至是VB（如果必须）首先：使用.NET程序中的调试器比在SQL查询中查看更容易。

If in doubt, start with Google: stored procedure tutorial[^] and do a similar thing for triggers - you will get about the same number of resources.

If you need to develop "logical thinking" first, then I'd suggest that you don't try to learn that using SQL: try C# (or even VB if you must) first: it's a lot easier to see what is goign on with a debugger in a .NET program than it is in an SQL query.

首先要学习的内容是数据类型然后 DDL 然后 DML 然后 DCL 然后 DQL 然后转到 SP ，< b>触发器和功能。



专注于 if-else块和循环。



制定学习计划然后开始。它会有所帮助。

Contents to be learn first is Datatypes then DDL then DML then DCL then DQL then go for SP, Triggers and functions.

Concentrate on if-else blocks and Loops.

Make a study plan and then start. It will help.

这篇关于我是sql的新手，刚开始编写sp，触发器和函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！