dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

Sql Server

1-20 of 746     Previous     Next
Compress and Decompress SQL Functions
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to use compress and decompress in SQL Server 2016.
SET ARITHABORT ON
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.
DateDiff_BIG Function
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to obtain date differences between larger date ranges in SQL Server 2016.
Using the STRING_SPLIT Function in SQL Server
by Srinath M S
Language: SQL, Expertise: Intermediate - Explore a way to split a string that is concatenated with a separator.
Enable SQL Server to Run Stored Procedures at Server Startup
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn the two-step process required to run stored procedures at startup.
Allow SQL Server to Silently Truncate Data
by Hannes du Preez
Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.
Secure Your Data in SQL 2016 with Row Level Security (RLS)
by Srinath M S
Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.
The sp rename SQL Stored Procedure
by Hannes du Preez
Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.
Identify All the Foreign Keys in Your Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.
Get All Tables Referenced by at Least One View
by Hannes du Preez
Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.
Enumerating all SQL Servers
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how easy it is to enumerate (list) all the possible SQL servers to which you want to connect.
The sp_MSforeachdb Stored Procedure
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Renaming an SQL Server Database
by Hannes du Preez
The SQL Intersect Operator
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Using the @@rowcount Global Variable in SQL
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Find out Whether a Value Exists in a List of Values
by Hannes du Preez
You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious. Language: SQL||Expertise: Beginner
Backup and Restore an SQL Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Importing Data from Excel into SQL Server
by Hannes du Preez
A very quick way to import data from Excel into SQL Server.
How to Read Environment Variables in SQL Server Using T-SQL
by Deepak Choudhari
The xp_cmdshell extended stored procedure in SQL Server enables you to read environment variables in T-SQL.
Displaying the Row Number in a SELECT Query with SQL Server 2005
by Deepak Choudhari
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
1-20 of 746     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date