Section provides some SQL Server scripts examples. To start with SQL Server development, learn by the example with practical scripts and cases is effective.
It includes SQL scripts, T-SQL examples and object creation like tables, views, stored procedures, and functions.
How to write an insert or update SQL Server query? Here are two different, quick and easy solutions to write an “UPDATE OR INSERT” query. In other words, avoid the SQL Server error …
How to execute a stored procedure with parameters? Depending on the implementation of the SQL Server code, call the procedure with all parameters or only one. First you have to set the value …
How to completely empty a SQL Server table? The TRUNCATE TABLE command empties all the data in the table. How to completely delete data in a SQL Server table with TRUNCATE TABLE? The …
How to split a text after a particular character with SQL Server… like for example a file name: “file.txt” to separate the file name from its extension. Indeed, it is obvious that splitting …
How to write an Insert into query from a Select with SQL Server? There are three solutions for running an INSERT INTO query with a SELECT in SQL Server. The first solution is …
Microsoft SQL Server database is slow, or the available disk space is getting abnormally small? To solve this problem, it is sometimes enough to empty the SQL Server transaction log and reduce the …
To display the list of SQL Server tables of a specific database, several solutions are possible. Indeed, to audit a database and its tables, it is common to want the list of tables …
In order to create a new SQL Server database with one script, just follow this article and especially the code snippet. To create a Microsoft database with a Transact-SQL script, use the CREATE …
How to create a new SQL Server database with SQL Server Management Studio – SSMS ? In this tutorial, let us see how to add a new SQL Server database. Indeed, to start, …
How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL DROP …
2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.
