Updating values in sql
Let’s see an example where you want to pass a number to a SQL Server function and get consecutive date values Create the following function Here’s the same query to try out: Running the query will list out 10 consecutive dates starting from today, as shown below: As you can see, the return type of the function test_function is a table.
A SQL Server function can return a single value or multiple values.
To return multiple values, the return type of the the function should be a table.
He is also one of the leading posters at a moderator at
by MAK [Muthusamy Anantha Kumar] In a typical development, QA or production environment, it can be very hectic to change all of the connection parameters, such as source file path, destination server name, table name, user ID, password etc.
As years went by, he started working more on writing queries in SQL Server.
He now has good level of knowledge in SQLServer, Oracle, My SQL and Postgre SQL as well.