dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
Search the Tips

Sql Server

1-20 of 744     Previous     Next
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.
Retrieving Table Size in SQL Server
by Deepak Choudhari
Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.
Choosing a Large-Text Data Type for SQL Server Table Columns
by Deepak Choudhari
SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?
1-20 of 744     Previous     Next
Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date