Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
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 741     Previous     Next
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?
Discover Long-Running Queries
by Srinath MS
Let SQL Server tell you which queries take the longest to run.
Find All User-Defined Functions in a SQL Server Database
by Jaya Nehru
This query returns all the user-defined functions in the specified database.
Table Variables Are More Efficient than Temporary Tables In Some Cases
by Srinath MS
Using @TABLE rather than temporary tables improves performance for small tables that don't require indexes.
1-20 of 741     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date