sql-server Archives - Page 34 of 39

How do you clear the SQL Server transaction log?

I’m not a SQL expert, and I’m reminded of the fact every time I need to do something beyond the basics. I have ...

April 29, 2022
0 Comments

What is “with (nolock)” in SQL Server?

Can someone explain the implications of using with (nolock) on queries, when you should/shouldn’t use it? For example, if you have a banking ...

April 28, 2022
0 Comments

What is the difference between char, nchar, varchar, and nvarchar in SQL Server?

What is meant by nvarchar? What is the difference between char, nchar, varchar, and nvarchar in SQL Server? 12 s 12 Just to ...

April 28, 2022
0 Comments

Get top 1 row of each group

I have a table which I want to get the latest entry for each group. Here’s the table: DocumentStatusLogs Table |ID| DocumentID | ...

April 28, 2022
0 Comments

Solutions for INSERT OR UPDATE on SQL Server

Assume a table structure of MyTable(KEY, datafield1, datafield2...). Often I want to either update an existing record, or insert a new record if ...

April 27, 2022
0 Comments

C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int ...

April 27, 2022
0 Comments

What is the best way to auto-generate INSERT statements for a SQL Server table?

We are writing a new application, and while testing, we will need a bunch of dummy data. I’ve added that data by using ...

April 27, 2022
0 Comments

How do I create a unique constraint that also allows nulls?

I want to have a unique constraint on a column which I am going to populate with GUIDs. However, my data contains null ...

April 26, 2022
0 Comments

Check if a temporary table exists and delete if it exists before creating a temporary table

I am using the following code to check if the temporary table exists and drop the table if it exists before creating again. ...

April 25, 2022
0 Comments

Rename column SQL Server 2008

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL. ALTER TABLE table_name RENAME ...

April 25, 2022
0 Comments